Operation Archives

Tech Optimizer

July 2, 2026

From monolith to Lakebase to LTAP: rethinking the database from storage up

Sixteen years ago, the author began their PhD at UC Berkeley, where they were advised to focus on analytics rather than OLTP databases, which were considered a solved problem. However, upon developing Databricks, they found that OLTP databases were cumbersome, challenging to scale, and fragile. This led to the creation of Lakebase, a serverless Postgres database designed to address these issues by externalizing the write-ahead log (WAL) and data files into independent services. Lakebase architecture separates the WAL into a distributed service called SafeKeeper and data files into another service called PageServer, allowing for improved durability, scalability, and performance. This architecture eliminates data loss risks associated with disk failures and misconfigurations, simplifies high availability, and allows for elastic compute resources. Lakebase also introduces LTAP (Lake Transactional/Analytical Processing), which enables transactions and analytics to operate on a single data copy in real-time, avoiding the need for separate data copies and reducing costs. The system retains Postgres's ACID semantics while storing data in open columnar formats, making it accessible to both transactional and analytical engines without the delays and complexities of traditional replication methods. The architecture allows for unlimited storage, serverless compute, and instant branching, while ensuring that analytics can read the most current transactional data without affecting transactional workloads. LTAP aims to unify transactional and analytical processing by leveraging distinct compute engines for each workload while integrating at the storage layer.

AppWizard

June 29, 2026

Steam Week in Review: Steam sales are the best time to hoard dozens of forgotten ’90s PC gaming oddities

In 2026, Valve's Steam Summer Sale features significant discounts on popular games, such as Red Dead Redemption 2 at a 75% discount for the 14th time since January 2025, and The Witcher 3 with its fifth 95% discount since July 2024. Cyberpunk 2077 has reached a 75% discount after eight previous markdowns of 65% since June 2025. The sale includes major publishers like Ubisoft and indie titles such as Terraria and Satisfactory. Notable retro games available include I Have No Mouth And I Must Scream, Operation Body Count, Interphase, Corpse Killer, and The Dame Was Loaded. Steam's weekly sales charts show top sellers, with Meccha Chameleon achieving 10 million sales, aided by the PUBG PNC 2026 tournament.

AppWizard

June 27, 2026

The game formerly known as Operation Flashpoint is getting a remaster, while developer Bohemia Interactive has released its engine source code

Operation Flashpoint debuted in June 2001 as a significant military simulator with an expansive open-world design, allowing players to engage in combined-arms warfare across large islands. Players could control various military assets and command squads, offering a level of realism and complexity ahead of its time. Bohemia Interactive announced plans to celebrate ArmA: Cold War Assault with a remastered edition featuring a reengineered Poseidon engine, widescreen support, and modern hardware compatibility. A demo is available, serving as a "self-contained slice" and a "sanctioned asset pack" for fans to create new content. Bohemia has released the complete engine source code on GitHub, upgraded to C++20 with cross-platform support, while ensuring that the license does not extend to the ArmA or Operation Flashpoint trademarks. Bohemia is also developing ArmA Reforger, which recreates iconic islands and serves as a testbed for the anticipated ArmA 4, set for release in 2027.

AppWizard

June 25, 2026

You can finally turn Riot’s Vanguard anti-cheat off when you’re not playing a game

Riot Games is updating its Vanguard anti-cheat system to an "on-demand" model, which will only activate during gameplay and stop once the game ends. This change addresses concerns over Vanguard's previous persistent background operation and kernel mode access. Players must meet specific security criteria to use the new feature, including enabling pre-boot security mechanisms and Windows' native protection features. Approximately 35% of players already meet these conditions, while 3% using older hardware will not have access to the on-demand option until they upgrade. Vanguard will continue its current operation for those unable to meet the requirements. The update is influenced by advancements in Windows and PC hardware security and aims to enhance anti-cheat measures while keeping the process optional for most players.

Tech Optimizer

June 23, 2026

Millisecond Latency at Scale: Why Our ML Feature Store Runs on Snowflake Postgres

Organizations are consolidating their fragmented database environments with Snowflake Postgres, phasing out outdated systems and simplifying multivendor setups without extensive code rewrites. Ericsson migrated four legacy databases to Snowflake Postgres, achieving a 99% reduction in data processing time. SimCorp's transition to Snowflake Postgres resulted in a tenfold increase in disk operation speeds. Sigma Computing provides real-time analytics using Snowflake Postgres, eliminating the need for external systems. BlueCloud supports low-latency transactional workloads and analytics on a single platform. Superblocks enables developers to create full-stack applications using Snowflake CoCo, leveraging SQL tools against live data. Snowflake Postgres is approximately four times faster than Databricks Lakebase and has a 99.95% published uptime SLA. It operates on Postgres 18 and accommodates up to 64 TB of storage, surpassing Lakebase's 16 TB limit. Snowflake Postgres simplifies management with in-place major version upgrades and supports standard logical replication, enhancing flexibility for data movement and integration.

AppWizard

June 22, 2026

The Steam Machine is the most ambitious game console I’ve ever played

The Steam Machine retails starting at ,049 without a gamepad and ,128 bundled with one. Its performance does not significantly exceed that of the 5.5-year-old PS5, which offers sharper visuals in certain games. The Steam Machine operates more like a console than previous iterations, featuring a compact design and compatibility with modern gamepads. Valve claims to sell its components at cost, having negotiated with suppliers during a memory supply crisis. Users have reported technical issues, such as problems with the Steam Controller, sound output, and game downloads. The device requires manual adjustments for settings, lacks user-friendly configurations, and has questionable reliability with its sleep function. Valve plans to support AMD’s FSR 4 upscaling and is working on graphics driver updates. The Steam Machine is positioned as a versatile gaming and computing solution, but its limitations highlight the need for further refinement.

AppWizard

June 22, 2026

The arcade meets the hex grid in R-Type Tactics—an unlikely fusion that shines like a star on PC

The R-Type series is transitioning from its traditional shmup format to a strategy format, introducing complexity with statistics and material costs. Originally released on the PSP with two Tactics games in the late 2010s, the series now offers over 100 missions across three unlockable campaigns on PC, including the new English debut of Operation Bitter Chocolate and additional content in the "Cosmos" missions. This shift aims to provide a unique experience for players amidst a competitive landscape of strategy games.

Winsage

June 22, 2026

I forced Windows 11’s CPU boost on a 10-year-old PC, and it feels surprisingly new

Windows 11 has introduced the Low Latency Profile to enhance the responsiveness of the Start menu, Search, and Action Center by rapidly increasing CPU frequency during user interactions. Testing on a Lenovo ThinkCentre M700 Mini Desktop with a 6th Generation Intel Core i3-6100 processor showed that the Low Latency Profile could be activated via the June 2026 Patch Tuesday update (KB5094126) and the third-party tool ViVeTool. Initially, no significant CPU frequency spike was observed, but after enabling the feature, the CPU frequency increased from approximately 800MHz to 3.0GHz and then to 3.7GHz almost instantaneously during interactions. This resulted in a marked improvement in the responsiveness of the Start menu and Action Center, with the latter showing the most significant enhancement. The Low Latency Profile effectively improved performance on older systems without adverse effects on battery life or thermal output.

Tech Optimizer

June 22, 2026

I Turned Off All Antivirus Protection for a Week. Here’s What I Learned

The author conducted an experiment by disabling both Bitdefender and Windows Security for a week to rely solely on personal cybersecurity instincts. They took precautions by using a secondary device and backing up important data. Throughout the week, the author experienced heightened awareness while navigating online tasks, encountered a phishing email, and adapted to a more deliberate browsing rhythm. Key takeaways included exercising caution, verifying sources, being aware of URLs, and keeping software updated. The experiment highlighted the importance of both good habits and antivirus software in maintaining cybersecurity. The author concluded that while personal vigilance is crucial, antivirus software is essential for those lacking strong instincts.

AppWizard

June 21, 2026

Steam Gets 11 New Free Games You Can Check Out Now

Steam has released a new collection of free games, including: - The Unrealtor: A couch co-op puzzle adventure for two players involving perspective-based puzzles. - Operation P.L.U.S.H: A horde defender game for 1-4 players where dream-powered plushies protect a child's nightlight. - Cave Of Treats: A Halloween-themed arcade game where players control a skeleton disguised as a mummy to battle creatures. - Dragon Kisser: A third-person soulslike game where players charm a dragon to save their village. - Moon River: A short RPG adventure focused on music and exploration. - Tarot Spell: A typing survival game that involves learning about Tarot cards to cast spells. - Once Upon A Card: A card-based game where players help a royal child navigate dreams and face challenges. - Bloxzer: A puzzle game that involves rolling blocks into holes and activating bridges, with the first 15 levels free. - Without Sanctuary: An underground fighting game set in a nightclub, featuring brutal combat. - Tumble Type: A word puzzle game where players spell quickly to rescue keys and climb leaderboards. - eXSert: A Dieselpunk 3D beat 'em up game where players confront a genocidal AI. Players should check their PC hardware specifications for optimal performance.