← Latest papers
🤖 AI

Zeta-Lite: A Concurrent, Branchable In-Browser SQL Database for Agentic Memory

Zeta-lite is a compact, concurrent, and branchable in-browser SQL database engine built on WebAssembly that enables overlapping snapshot-isolated transactions and copy-on-write database branching, offering a feature-complete PostgreSQL interface optimized for agentic memory and local-first applications.

Original authors: Gene Zhang

Published 2026-09-03✓ Author reviewed
📖 7 min read🧠 Deep dive

Original authors: Gene Zhang

Original paper licensed under CC BY 4.0 (http://creativecommons.org/licenses/by/4.0/). This is an AI-generated explanation of the paper below. It is not written by the authors. For technical accuracy, refer to the original paper. Read full disclaimer

For decades, the internet operated on a simple rule: your data lived on a server somewhere else, and your computer was just a window to look at it. If you wanted to search, sort, or analyze that data, you had to send a request across the network and wait for the answer to come back. This model changed as applications began to demand more privacy and the ability to work without an internet connection. The idea of keeping data right on the user's device, rather than in a distant cloud, became a priority. This shift led to a new challenge for software engineers: how do you build a powerful, structured data system that runs entirely inside a web browser? Browsers are designed to be safe and isolated, which makes them difficult places to run complex software that usually requires deep access to a computer's operating system.

The solution has traditionally been to shrink down existing database systems or to use very simple tools that lack advanced features. One popular approach involves taking a massive database engine, stripping it down, and translating it into a format browsers can understand, but this often forces the software to run slowly or in a single line of work, unable to handle multiple tasks at once. Another approach uses tiny, lightweight engines that are fast but cannot perform complex searches or manage intricate relationships between different pieces of information. The question remained whether it was possible to have a database that was small enough to fit in a browser, fast enough to feel instant, and smart enough to handle complex, overlapping tasks all at the same time.

A researcher has now built a system called Zeta-lite that answers this question with a definitive yes. They created a database engine that lives entirely inside a web browser, weighing in at just 2.87 megabytes when compressed. Despite its small size, it can perform complex searches, manage multiple users working at the same time, and even create copies of itself to test new ideas without risking the original data. This system is designed specifically for a new kind of software: artificial intelligence agents that run in the browser and need a place to store their thoughts, memories, and discoveries. The researcher found that by changing how the database remembers its history, they could achieve a level of performance and flexibility that was previously thought impossible for such a small program.

The core of their discovery lies in how the database handles time. Most traditional databases work like a single-lane road where cars must wait for the one in front to finish before moving forward. If two people try to update the same piece of information at once, one has to wait. Zeta-lite works differently. Instead of a single lane, it treats every piece of data as having a history of versions. When a task starts, it takes a snapshot of the data at that exact moment. It can then work on its own version of the truth while other tasks are happening at the same time. If two tasks try to change the same thing, the system detects the conflict and stops one of them, but it does not force them to wait in line. This allows multiple tasks to run simultaneously on a single thread of execution, a feat that usually requires complex, heavy-duty hardware or special browser settings that most websites cannot use.

This ability to handle overlapping tasks is paired with a unique feature called branching. In the world of software development, creating a branch means making a copy of a project to work on a new idea without breaking the original. Zeta-lite brings this concept directly to the data itself. An application can fork its entire database into a new branch, make changes, test them, and then decide to either merge those changes back into the main database or discard them entirely. This happens almost instantly and without using extra storage space, because the system only saves the differences between the branches. For an artificial intelligence agent, this is a powerful tool. It allows the agent to explore a hypothesis, try out a new plan, or simulate a conversation, and then simply erase the experiment if it fails, leaving the original memory perfectly intact.

The researcher tested this system rigorously to ensure it was not just a theoretical concept but a working reality. They ran the database in two of the most popular web browsers, Chrome and Firefox, and compared its speed against a native version running on a standard computer. They found that the browser version was nearly as fast as the native one, handling hundreds of thousands of data lookups per second. In tests where multiple tasks tried to update the same data at the same time, the system successfully managed the conflicts without crashing or slowing down. They also verified that the system could run for long periods without losing data or leaking memory, even as it grew to handle millions of operations. The database persisted its state by saving a complete snapshot of itself to the browser's private storage, a process that took less than a second even for large amounts of data.

What makes this achievement particularly significant is that it does not rely on the complex, heavy infrastructure that usually powers such systems. Most browser-based databases that offer similar features require special security headers that force websites to isolate themselves from the rest of the internet, which limits where they can be used. Zeta-lite avoids this entirely. It runs on the main thread of the browser, the same place where the rest of the website lives, without needing extra security measures or background workers. This means it can be dropped into any web application without changing how the site is built or hosted. The system is built from the same codebase as a much larger server database, proving that the complex logic required for advanced data management can be compressed down to a tiny package without losing its power.

The implications of this work extend beyond just speed or size. It opens the door for a new generation of applications that can remember and reason over their own data locally. Imagine an AI assistant that lives in your browser, capable of storing your personal history, learning from your interactions, and organizing your information without ever sending that data to a remote server. With the ability to branch its memory, this assistant could try out different ways of organizing your notes or planning your day, keeping only the results that work. The researcher has already begun building a companion system called Zengram-lite that uses these exact capabilities to create a memory system for such agents.

The paper concludes that the old assumption—that you must choose between a small, simple database and a large, powerful one—is no longer true. By rethinking how data is versioned and how tasks are managed, it is possible to have both. The Zeta-lite engine demonstrates that a fully featured, concurrent, and branching database can fit into a web browser and perform at a level that rivals native software. This is not a simulation or a promise of future technology; it is a working system available today, ready to be used by developers who want to build applications that are private, fast, and capable of complex reasoning right on the user's device.

Drowning in papers in your field?

Get daily digests of the most novel papers matching your research keywords — with technical summaries, in your language.

Try Digest →