designs 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

June 27, 2026

Ticketmaster’s ‘customizable pass’ collab with Google Wallet sounds great for gameday

Ticketmaster has partnered with Google Wallet to introduce "customizable passes" for Android users, allowing event clients to personalize digital passes with designs and up to 12 links for venue details. These passes can provide information on parking, food, drinks, merchandise, and VIP access. The collaboration also includes an update to Google Wallet that uses "context-aware" technology to display relevant passes automatically as users approach specific locations, enhancing user convenience.

Winsage

June 27, 2026

Windows 11’s built-in apps are getting quiet but welcome improvements

Microsoft has released a preview version of its upcoming Windows update for members of the Windows Insider Program, enhancing several pre-installed applications including Calculator, Camera, Clock, Media Player, Notepad, Paint, Photos, and Sound Recorder. Key updates include: - Calculator: Improved accuracy in square root calculations, high-contrast readability for settings, right-to-left language support, and a fix for startup issues. - Sound Recorder: Added Bluetooth microphone support, a streamlined interface, immediate access to features, disabled WAV file tags, a smoother deletion process, and a resolved memory leak issue. - Additional features: AI-generated image watermarks in Photos, a zoom slider in Camera, customizable subtitles in Media Player, and a new option to delay alarms by 15 minutes in Clock.

Winsage

June 26, 2026

Windows 11’s built-in apps are getting quiet but welcome improvements

Microsoft has released a preview version of an upcoming Windows update for members of the Windows Insider Program, enhancing several pre-installed applications including Calculator, Camera, Clock, Media Player, Notepad, Paint, Photos, and Sound Recorder. The Calculator update includes improved accuracy for square root calculations, better readability in high-contrast designs, right-to-left language support for Arabic and Hebrew, and a fix for startup issues. The Sound Recorder enhancements feature an accurate live waveform display for Bluetooth recordings, a streamlined interface, immediate access to the "Highlight" button, disabled tags for WAV recordings, a smoother deletion process for multiple recordings, and a fix for a memory leak issue. Additional features include watermarks for AI-generated images in the Photos app, a zoom slider in the Camera app, customizable subtitles in Media Player, and a 15-minute delay option for alarms in the Clock app.

AppWizard

June 26, 2026

You can put Minecraft’s gorgeous new biome and building blocks to the test right now

Mojang has introduced the Dappled Forest biome in Minecraft, featuring Poplar Trees with off-gray wood and autumn-colored leaves. The biome includes Shelf Mushrooms that grow on these trees, providing culinary uses and reducing fall damage. Players can collect Red Shrubs that retain their color and propagate with Bone Meal. The update also adds Wool Stairs and Wool Slabs in sixteen colors, and introduces abandoned camps with unique designs and loot. The Dappled Forest hosts various wildlife, including sheep, chickens, cows, pigs, rabbits, and foxes. The update is available for testing in Minecraft Bedrock preview 26.40.27 and Minecraft Java snapshot 26.3.

AppWizard

June 26, 2026

Meccha Chameleon review

Meccha Chameleon is a game developed and published by lemorion_1224, priced at £5.29, that offers a unique twist on the hide-and-seek format through a camouflage mechanic using hand-painted designs. Players transform featureless marble figures into parts of the environment using a brush and eyedropper tool during the hiding phase. The game emphasizes creativity and strategy, challenging players to manipulate visual perception to remain undetected. It was created by a small team of two developers, which has led to some production limitations, such as collision issues and a simplistic user interface. Despite these challenges, the game's handmade quality adds charm and encourages players to embrace its imperfections.

AppWizard

June 26, 2026

Down with tactical rocks

The evolution of miniature design in tabletop gaming has shifted from simple character representation to exaggerated poses and precarious placements. Miniatures like the ork, once depicted in dynamic stances, now feature characters such as a dwarf leaping off a statue for dramatic effect. Maugan Ra, the Phoenix Lord, is shown straddling two tactical rocks, resembling a politician rather than a harbinger of doom. Games Workshop has popularized the trend of "tactical rocks," which are intended to elevate characters for visual impact but have become excessive. Originally, key figures were distinguished by size or mounting, but now even imposing figures like Kragnos awkwardly perch on these rocks. There is a growing sentiment among enthusiasts that this trend detracts from the artistry of miniatures, with many preferring to use color schemes and banners for distinction rather than relying on exaggerated poses. The balance between creativity and practicality in miniature design continues to be a topic of discussion.

AppWizard

June 25, 2026

From Idea to Launch: Essential Steps for Building a Successful Android App

Building a successful app requires transforming a strong idea into a useful, reliable, and discoverable product. Key steps include addressing a genuine problem, developing an effective initial version, conducting thorough testing, and launching with a strategic plan. Many apps fail by neglecting essential steps, leading to confusion or lack of real need. It is important to identify specific problems the app aims to solve rather than starting with an extensive feature list. Understanding the target audience and their pain points is crucial for making informed decisions. Validation can be achieved by examining reviews of competing apps and engaging with potential users to assess interest in the solution. The initial app version should be the smallest iteration that delivers tangible results, focusing on the primary user journey. Outlining the user flow is important for a smooth experience, ensuring that permission requests are logical and intuitive. Early-stage apps should exhibit stability, integrating analytics and crash reporting from the beginning to understand user behavior. A gradual launch is recommended, starting with internal tests and moving to closed tests with target audience members. This phased approach allows for learning and adaptation, ensuring that the initial version effectively addresses a real problem and engages users.

AppWizard

June 25, 2026

It’s wild of Rockstar to ask us for $80, minimum, without showing a GTA 6 gameplay trailer

Rockstar has announced the commencement of preorders for Grand Theft Auto VI, despite the absence of any actual gameplay footage. The minimum preorder price is set at an unspecified amount, with an "Ultimate Edition" available for an additional , which locks certain gameplay features. To date, there have been two trailers for the game, focusing on narrative elements rather than gameplay, and recent promotional images have not provided gameplay content. Many fans feel frustrated by the lack of evidence to justify their investment, especially those without current-generation consoles who are considering waiting for a PC release.