outcome 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 and was advised to focus on analytics rather than OLTP databases, which were considered solved. This led to the creation of Apache Spark and Databricks. However, during the development of Databricks, it was found that OLTP databases were not solved problems; they were difficult to scale and fragile. This realization led to the development of Lakebase, a serverless Postgres database designed with modern technology. Lakebase architecture separates the write-ahead log (WAL) and data files into independent, scalable services. The WAL is externalized to a service called SafeKeeper, which uses Paxos-based replication for durability, while data files are managed by PageServer, which stores them in cloud object storage. This design addresses challenges such as data loss, scaling, and performance interference between transactional and analytical workloads. Lakebase maintains compatibility with Postgres, offers unlimited storage, serverless compute, durable writes, and simpler high availability. It also introduces LTAP (Lake Transactional/Analytical Processing), which allows both transactional and analytical processing to operate on a single data copy in real time, eliminating the need for separate data copies and reducing costs. LTAP utilizes a unified storage layer that allows data to be materialized in both row and columnar formats, optimizing it for both transactional and analytical workloads. The system ensures that analytics can access the most current data without affecting transactional performance by using a log sequence number (LSN) to retrieve the latest changes. Unlike traditional CDC approaches, LTAP requires no explicit table replication, as all data is stored in a single governed copy. This architecture circumvents common issues faced by hybrid transactional/analytical processing (HTAP) systems, such as incomplete feature sets, lack of ecosystem support, and performance contention. The Lakebase architecture has unlocked capabilities like unlimited storage, elastic compute, durable writes, and instant branching, with ongoing developments anticipated in the future.

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

July 2, 2026

Dragon Age setting creator says AI push is a delusion of the executive class that’s a ‘virulent plague’ on games

David Gaider, a veteran of BioWare and creator of the Dragon Age universe, expressed concerns about generative AI in gaming, calling it a "virulent plague" that negatively impacts creativity and job opportunities. He criticized the current use of AI for producing subpar results and diminishing entry-level opportunities for writers. Gaider suggested that AI should be used as a supportive tool for mundane tasks, allowing human writers to focus on creative work, but noted that AI is currently taking on critical roles instead. He emphasized the importance of nurturing new talent and cautioned against eliminating tasks essential for training junior developers. Gaider also raised ethical concerns about AI's reliance on datasets that may lack consent from original creators, warning of potential legal issues. He expressed skepticism about AI's readiness for widespread application in the industry, advocating for caution until proper regulation and ethical data training are established.

AppWizard

July 1, 2026

Kalshi Challenges Illinois Sports Betting Tax as Prediction Market Jurisdiction Fight Escalates

Kalshi has filed a federal lawsuit against the state of Illinois, challenging a law that imposes taxes and licensing requirements on sports-related trades in prediction markets. The lawsuit questions whether contracts traded on Kalshi's federally regulated exchange are classified as sports bets under state laws or as financial derivatives overseen by the Commodity Futures Trading Commission (CFTC). Illinois law categorizes prediction market operators as sports wagering businesses, imposing a 1.75% tax on the first five million sports wagers annually, increasing to 3.5% for wagers above that threshold, along with a costly licensing requirement. Kalshi argues that these state requirements are preempted by federal law and contends that its offerings are financial instruments, not traditional wagers. The dispute reflects a broader conflict between federal and state regulators regarding jurisdiction over prediction markets, with the CFTC previously filing a lawsuit against Illinois over similar regulatory issues. The outcome of this legal battle could have implications for the regulation of prediction contracts related to various events beyond sports.

Winsage

July 1, 2026

Do you still need third-party antivirus on your Windows PC?

In April, a statement on the Windows Learning Center claimed that Microsoft Defender Antivirus is sufficient for many Windows 11 users, leading to brief attention before the article was removed a month later without explanation. The link now redirects to the homepage, but the content is still accessible via the Internet Archive. Microsoft has not clarified the removal, and speculation suggests backlash from the third-party security industry may have influenced this decision. Research indicates that the infection rate for consumer PCs in 2023-2024 was 3.07%, lower than the 2.39% for business PCs, suggesting that risks may not be as widespread as often claimed. The 2025 Cybersecurity Threat Report noted that 56% of consumer endpoints that faced an infection in 2024 experienced subsequent infections, with user behavior playing a significant role. A survey found that 54% of Americans rely on default device protection, while 46% use third-party antivirus solutions. Modern antivirus solutions, including Microsoft Defender, achieve protection rates of 99% or higher, with Defender specifically reaching a 99.0% protection rate without false positives. This performance indicates that Defender is adequate for most consumers. Default security measures on platforms are generally effective, with modern antivirus applications blocking 99.2% of threats that bypass other protections. Consequently, 97% of PCs remain free from malware infections, suggesting that improving user training may be more beneficial than investing in superior software. In contrast, businesses face different challenges, as attacks are often executed by sophisticated criminal organizations targeting vulnerabilities in third-party software. Enterprise administrators typically use specialized endpoint security products for centralized management and continuous monitoring, which are essential for protecting business environments.

AppWizard

July 1, 2026

KFTC accuses Google of abusing Android app dominance, may face $9.1bn fine

South Korea's competition regulator, the Korea Fair Trade Commission (KFTC), has accused Google of using its dominant position in the Android apps market to suppress competition, potentially leading to significant financial penalties. The KFTC estimates that Google's practices have revenue implications of 14.16 trillion won (approximately .1 billion). The investigation centers on the Games/Google Velocity Program, also known as "Project Hug," which allegedly provided financial incentives to game developers for launching titles exclusively on the Google Play store. This program reportedly discouraged developers from distributing their games through competing platforms, particularly OneStore. If the KFTC finds that Google abused its market position, the company could face fines of up to 6% of the affected revenue, around 0 million. Google will have eight weeks to respond to the evidence against it, and the KFTC plans to expedite a final decision while respecting Google's due process rights.

Winsage

June 30, 2026

Bypassed Windows 11 shows surprising stability on ancient, completely unsupported hardware

Windows 11 has elevated system requirements, necessitating four times the memory and storage for AI-driven applications. It can technically run on a minimum of 4GB of memory, but current hardware pricing is challenging due to a silicon shortage affecting various memory types. A retro hardware enthusiast named Omores installed Windows 11 on a DDR1-based system using an ASRock ConRoe865PE motherboard, Intel Core 2 Quad Q6600 processor, 3GB of DDR1 RAM, and an ATI Radeon HD 4650 AGP graphics card. He overcame the lack of AGP support in Windows 11 by using legacy drivers, achieving satisfactory performance for older applications and games. However, Windows 11 version 24H2 requires SSE4.2 CPU instructions, which are not supported by processors from the AGP era, making version 23H2 the last compatible release for such systems.

AppWizard

June 29, 2026

Steam Machine reservations are already being resold on Ebay for up to $2900

Valve's Steam Machine has faced challenges due to scalpers exploiting its limited availability. Despite measures like a randomized queue and one-unit purchase limits, resellers have listed the device at inflated prices on platforms like eBay. For example, a 2TB Steam Machine bundled with a controller is priced at ,899.99, over double its retail cost of 8. Listings for 2TB models range from ,700 to ,899.99, while a 512GB model without a controller is offered for ,800. Resale practices mirror those seen during the Steam Controller launch, where buyers could purchase multiple units for resale. The Steam Machine's higher starting price of ,049 makes reselling less feasible for many. Valve has indicated that as they process reservations, cancellations may open opportunities for others on the waiting list. Additionally, there is speculation about the demand for Valve's upcoming VR headset, the Steam Frame, amid existing competition.

BetaBeacon

June 25, 2026

Google Play Store Fees Will be Lowered Thanks to Epic Games Lawsuit, Settlement

Google Play Store fees are getting lower starting on June 30, with the service fee starting at 10% on the first million in annual earnings. Developers using Google Play's billing system will pay an additional 5% billing fee. The changes are a result of Epic Games' lawsuit against Google, which required the company to make structural changes to its Play Store operations. Apple also made changes to its App Store policies following a lawsuit from Epic.

AppWizard

June 22, 2026

Google Photos may have a new trick to make your pictures look dramatically different

Google Photos is set to introduce a new feature called Moods in version 7.81 of the app, which utilizes artificial intelligence for photo editing. Moods offers eight distinct templates: Airy Minimalist, Crisp 35mm, 2000’s Cinema, Rich Textures, Pink Digicam, Retro Contrast, Night Lights, and 2000’s Night, each designed to evoke specific visual styles. The feature aims to provide a more personalized editing experience by analyzing images individually rather than applying uniform filters. Although Moods is not yet operational, it represents a shift towards a more AI-driven editing experience in Google Photos. An APK teardown indicates potential features, but there is no guarantee they will be publicly released.