behind the scenes Archives

AppWizard

July 27, 2025

Steam’s mechanical new puzzle game has taken over my brain

The author played the game "Kaizen: A Factory Story" during a 45-minute subway ride, which involves optimizing product assembly lines set in 1980s Japan. The gameplay includes solving puzzles to create items like binoculars and camcorders by connecting various components using gadgets and automating their functions. The author faced challenges in assembling a camcorder, particularly in integrating a tape deck, and found inspiration for a solution while walking to a bar. The game emphasizes the decline of handcrafted goods in mass production and celebrates the creativity of engineers behind the scenes.

AppWizard

July 19, 2025

Prince of Persia: The Sands of Time Remake will launch ‘very soon,’ Ubisoft exec says, but he also namedropped Splinter Cell for no apparent reason so maybe he’s still just messing with us

Five years have passed since the initial leak of the Prince of Persia: The Sands of Time Remake. Ubisoft has not provided concrete updates on the remake or Splinter Cell during its recent Annual General Meeting. Chief Financial Officer Frederick Duguet indicated that the Sands of Time Remake is slated for release in Ubisoft's 2026 fiscal year, which ends on March 31, 2026, with speculation suggesting a potential holiday 2025 release.

AppWizard

July 12, 2025

‘A Minecraft Movie’ Remains No. 1 on Disc Sales Chart

The Minecraft Movie is in development and aims to capture the essence of the game while introducing a narrative for both gamers and newcomers. The film will explore themes of adventure, friendship, and imagination, featuring familiar elements such as crafting, building, and exploring. A talented team of writers and directors is working on the project, which includes a mix of seasoned actors and rising stars in the cast. The film will utilize cutting-edge visual effects, feature a lineup of voice actors, and include an original music score. Anticipation is building within the gaming community as the release date approaches.

Tech Optimizer

July 8, 2025

How TimescaleDB helped us scale analytics and reporting

At Cloudflare, PostgreSQL and ClickHouse are used as primary databases for transactional and analytical workloads. PostgreSQL is preferred for product development due to its speed, versatility, and reliability, with hundreds of instances running in various configurations. ClickHouse, introduced in 2017, allows ingestion of tens of millions of rows per second with millisecond-level query performance but comes with trade-offs. The Digital Experience Monitoring (DEX) product was developed with a focus on simplicity and rapid shipping, utilizing a team of three engineers and collaboration with other teams. DEX's initial launch included fleet status logs uploaded every two minutes and synthetic tests with usage caps, leading to a successful MVP launch ahead of schedule. The architecture included an HTTP API, PostgreSQL for storing configurations, and a React UI in the Cloudflare Dashboard. PostgreSQL was chosen for analytics due to its ability to handle structured logs, with a table created for device state logs lacking a primary key but optimized with unique and standard indexes for common queries. The UPSERT query was used for data insertion, and the order of columns in multicolumn indexes was optimized for performance. After launching DEX, the system scaled to 1,000 inserts per second, leading to performance degradation. Precomputed aggregates were implemented to improve query performance, resulting in up to a 1000x improvement. Table partitioning was considered but ultimately not pursued due to its manual management requirements. TimescaleDB was explored as an alternative to enhance query performance, offering features like automatic partition management, continuous aggregates, and compression. A side-by-side comparison with PostgreSQL showed significant performance improvements, particularly for longer time windows. TimescaleDB's integration allowed for efficient data retention and aggregation, simplifying the infrastructure. Following the success of DEX, other teams at Cloudflare began using TimescaleDB for analytics and reporting, consolidating data from various sources and managing high ingestion rates effectively by optimizing data handling techniques such as switching to COPY for bulk inserts and adjusting replication settings.

AppWizard

June 27, 2025

Deus Ex lead Warren Spector pops up to remind everyone he didn’t make the game alone in a cave, wish you a happy 25th anniversary, and get me wondering if something Deus Ex-related is happening behind the scenes

Warren Spector clarified his role in the creation of Deus Ex during a video for the game's 25th anniversary, stating that he did not create it alone and expressing pride in its lasting impact. A remastered version of the game's opening cutscene for the PlayStation 2 was recently unveiled, indicating renewed interest in the franchise. The future of Deus Ex is uncertain following the collapse of Embracer Group's deal, which halted several projects, but there are possibilities for a revival, including the potential involvement of Nightdive Studios with the original title and Invisible War.

Tech Optimizer

June 25, 2025

Meet the new features for Avast Free AV and Avast Premium Security

Avast has millions of active users and is recognized in the cybersecurity field for its effective solutions and commitment to user security. Avast Free Antivirus includes real-time behavioral analysis for proactive malware detection, enhanced Network Inspector and Firewall modules for network security, improved intelligent quarantine and cloud scanning, and the new Scam Guardian feature, which includes Web Guard for browsing protection and Avast Assistant for scam guidance. Avast Premium Security offers additional features for heightened privacy, including Sensitive Data Shield, Webcam Shield, Data Shredder, and Hack Alerts for monitoring password leaks. The Pro version introduces Email Guard, which uses AI for intelligent email filtering to detect phishing attempts. Avast's tools enhance online shopping safety, email security, public Wi-Fi connections, and protection of sensitive files and credentials.

Tech Optimizer

June 24, 2025

How We Made Our SQL Query 80% Faster by Thinking Differently

The task involved querying a table named user_events to retrieve the most recent event for every user. A conventional SQL query was used, which performed poorly in production despite returning correct results. The inner query groups the entire table by user to find the latest event time, requiring Postgres to scan 100 million rows and perform 5 million aggregations, resulting in a temporary table with 5 million rows. The outer query then checks each row against this large list, significantly degrading performance due to the repetitive evaluations across the vast dataset.

AppWizard

June 20, 2025

Godfather Android malware takes over banking apps

A new version of the Android malware Godfather creates isolated virtual environments on mobile devices to steal account details and transactions from banking apps. It targets over 500 banking, cryptocurrency, and e-commerce applications globally, utilizing a fully virtual file system, virtual process IDs, intent spoofing, and a component called StubActivity. Godfather manifests as an APK app with a virtualization framework, scanning for targeted applications and encapsulating them within its virtual environment. It intercepts permissions for accessibility services, redirecting them to a StubActivity that launches the virtual version of the banking app, allowing it to capture sensitive information. The malware can record account details, passwords, and PIN codes using Xposed for API hooking. It employs a fake lock screen overlay to trick users into entering their credentials and can manipulate user interfaces and execute transactions within the legitimate banking app. Godfather first emerged in March 2021 and has evolved significantly since then, with the latest iteration demonstrating advancements from previous versions.

AppWizard

June 19, 2025

Steam’s new in-game overlay offers some useful upgrades – and I’m particularly happy about one that exposes a controversial AI trick

Valve is enhancing Steam's in-game frame rate counter by transforming it into a comprehensive overlay that displays frames per second (FPS) and provides insights into CPU and GPU status, including utilization levels, clock speeds, and temperatures. The new beta version of the Steam app introduces this performance monitor, currently available only to beta testers on Windows PCs, with plans to extend similar capabilities to other platforms like SteamOS in the future. The overlay can be customized to show only the FPS counter and allows users to adjust its transparency and positioning on the screen. It will help players identify if frame generation technologies, such as Nvidia's DLSS, AMD's FSR, and Intel's XeSS, are active and highlight instances of micro-stutter. This update aims to simplify the process of understanding game performance metrics for gamers, reducing reliance on third-party tools.

AppWizard

June 17, 2025

Prince of Persia social media botch forces Ubisoft to promise once again that it’s still working on The Sands of Time

Ubisoft has confirmed that it is still working on the remake of The Sands of Time, but there are no new updates available at this time. The game's release was initially scheduled for January 2021 but has faced multiple delays and a complete reboot announced in mid-2023, pushing the release to 2026. The development team is actively working on the project, and fans are currently awaiting further updates.