LiveStore: SQLite-based data layer for local-first apps

livestorejs/livestore

LiveStore is a next-generation state management framework based on reactive SQLite and built-in sync engine.

Johannes Schickling on Twitter / X

After 4 years of work, I'm incredibly excited to introduce LiveStore, the next-gen data layer I'm building for Overtone.It's based on reactive SQLite and has a built-in sync engine. Give it a try - would love your feedback! https://t.co/DB0cEXY9MD— Johannes Schickling (@schickling) May 27, 2025

LiveStore

LiveStore is a next-generation state management framework based on reactive SQLite and git-inspired syncing (via event-sourcing). - LiveStore

PowerSync: Backend DB - SQLite sync engine | For Postgres, MongoDB, MySQL, SQL Server

Automatically sync your backend database with in-app SQLite and avoid the complexities of using APIs to move app state over the network.

SQLSync

SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

Litestream

Litestream is an open-source, real-time streaming replication tool that lets you safely run SQLite applications on a single node.

Local-First Software

Experience apps that work offline, keep your data private, and sync seamlessly across your devices. Your data stays with you, not locked in the cloud.

Honker

Durable queues, streams, pub/sub, and time-trigger scheduling on SQLite. One file, zero servers.

tursodatabase/turso

Turso is an in-process SQL database, compatible with SQLite.

haileyok/cocoon

An ATProtocol PDS (Personal Data Server) written in Go with a SQLite block and blob store

Persistent Storage Options

This API provides database persistence via localStorage/sessionStorage and, in compatible browsers, the Origin-Private FileSystem.

How We Built an Offline-First Data Pipeline for Rural Cooperatives | HackerNoon

Learn how an offline-first data pipeline using edge computing and SQLite enabled reliable synchronization in low-connectivity regions.

Lifestreams: a storage model for personal data

Conventional software systems, such as those based on the “desktop metaphor,” are ill-equipped to manage the electronic information and events of the typical computer user. We introduce a new metaphor, Lifestreams, for dynamically organizing a user's personal workspace. Lifestreams uses a simple organizational metaphor, a time-ordered stream of documents, as an underlying storage system. Stream filters are used to organize, monitor and summarize information for the user. Combined, they provide a system that subsumes many separate desktop applications. This paper describes the Lifestreams model and our prototype system.