platform 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.

AppWizard

July 2, 2026

15 indie games we saw during the Big Indie Pitch at NAGIS that you’ve got to check out

The Big Indie Pitch event recently took place in Canada, showcasing indie developers and their PC and console games. Sponsored by Xsolla, the event featured a speed-dating format where developers presented their games to a panel of industry experts for five minutes. This format allowed for feedback and insights from professionals in publishing, scouting, and media. The event attracted developers at various project stages and served as a networking opportunity. The pitching sessions are a staple of Pocket Gamer Connects conferences and other gaming events worldwide. Interested participants can visit the Big Indie Pitch website for information on future events.

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.

Tech Optimizer

July 2, 2026

MTAR T3D Sessions: Scaling PostgreSQL Without Replacing It

Google's sign-in mechanism for YouTube uses a passive sign-in method that employs an iframe element called passive_signin. This iframe directs users to the Google accounts login interface without leaving the current page. The URL includes parameters such as service (YouTube), uilel (user interface language set to Dutch), passive (indicating a passive sign-in), and continue (a redirect URL back to YouTube after authentication). This design simplifies the sign-in process and enhances security by reducing the exposure of sensitive information.

Tech Optimizer

July 2, 2026

EDB Named a Leader in Multimodel Data Platforms Evaluation

EDB has been recognized as a Leader in The Forrester Wave: Multimodel Data Platforms, Q2 2026, with EDB Postgres AI (EDB PG AI) achieving the highest scores in Vision, Innovation, Roadmap, and Partner Ecosystem criteria. EDB PG AI integrates transactional, analytical, and AI workloads into a unified platform, supporting open-source frameworks and enabling various deployment options. The platform features governance at the data layer and is designed for operational efficiency, allowing organizations to implement sovereign AI quickly. EDB PG AI can be deployed on-premises, in hybrid environments, or across cloud infrastructures, backed by partnerships with companies like Dell, IBM, and NVIDIA.

Tech Optimizer

July 2, 2026

EDB named Forrester Leader in multimodel data platforms

EDB has been recognized as a Leader in Forrester's Multimodel Data Platforms evaluation for Q2 2026 for its EDB Postgres AI platform, receiving the highest scores in Vision, Innovation, Roadmap, and Partner Ecosystem. The platform is designed to manage mixed translytical and AI workload demands, offering flexibility in deployment across on-premises, hybrid, and multi-cloud environments. EDB's recent product update introduced agentic database and converged analytics functionalities, reportedly accelerating database tuning by up to tenfold and reducing analytics ownership costs by as much as 58%. The platform is supported by a partner ecosystem that includes Dell, IBM, NVIDIA, Red Hat, and Supermicro, which plays a crucial role in influencing database purchasing decisions. EDB's roadmap focuses on advancements in GPU-accelerated workloads, semantic intelligence, governance, and knowledge graph functionalities. The emphasis on sovereign deployment aligns with organizations' needs for control over sensitive data amidst stricter regulations.

AppWizard

July 2, 2026

This PC gaming launcher for Windows handhelds lets you browse stores and compare the best prices

Winhanced has introduced achievement support for popular gaming consoles like Steam, Xbox, and PlayStation. The latest update features a built-in store browser that allows users to navigate digital storefronts within the Winhanced interface. This feature is currently available for testing among supporters. The store browser offers personalized game recommendations based on user preferences and allows for searching specific titles or browsing categories. Winhanced encourages community feedback on the new feature and has a presence on Reddit for discussions.

AppWizard

July 2, 2026

Fanmade VR Port Of Nintendo 64 Classic Perfect Dark Out Now On Quest & PC

Modder Alex Le Tux has released the first public build of Perfect Dark VR, a fan-made adaptation for Quest headsets and PC VR, following a preview video in February. The VR port is based on the Perfect Dark decompilation project started in 2022. The latest release allows players to explore iconic locations from Perfect Dark with features like head tracking and motion control aiming. A trailer showcasing these features has been shared by YouTube user Graslu00. The trend of creating VR ports for classic games has grown, with contributions from fans and indie developers, including Team Beef, which has ported classic PC titles to VR. Additionally, Virtual Boy Go is an open-source emulator that enables players to experience Nintendo's virtual reality games on Quest headsets without the original console.

AppWizard

July 2, 2026

‘They refuse to offer a meaningful alternative’: Game preservation leader agrees that piracy is the only preservation option for a discless future

Sony plans to discontinue the production of physical game discs for the PlayStation 5 by 2028, shifting towards a fully digital licensing model. Frank Cifaldi from the Video Game History Foundation has raised concerns about the preservation of video game history, stating that piracy may become the only means of safeguarding digital works. He criticized the Entertainment Software Association for resisting efforts to create a legal framework for preserving digital content. Cifaldi highlighted that museums and archives are preparing for this digital future, questioning the industry's expectations for cultural institutions as physical media is phased out. The transition to digital ownership has sparked discussions in the gaming community, particularly regarding the lack of backward compatibility in the PlayStation ecosystem and the challenges posed by the closure of digital stores for older consoles. The urgency for solutions to protect video game history is increasing as the industry moves towards a digital-only future.

Winsage

July 1, 2026

I thought Windows 11 broke GIFs, but the real reason was Google quietly pulling the plug on this service

Users of Windows 11 versions 24H2, 25H2, and 26H1 have reported an issue with the emoji panel where a message states that the "GIF service is not available" due to the discontinuation of the Tenor service on June 30, 2026. Microsoft confirmed that this issue occurs for users who have not installed the latest optional update that transitions from Tenor to GIPHY. To continue using GIFs in the emoji panel, users must install the latest Windows update; otherwise, they will encounter the error message. The transition to GIPHY was included in the June 23 preview update for the relevant versions.