Turso SQLite Database

Turso is an edge-hosted distributed SQLite database platform created by Glauber Costa and Piotr Sarna in 2023, built on top of libSQL, an open-source fork of SQLite that adds replication, native vector operations, and server capabilities, providing per-tenant databases, multi-region replication, and embedded client libraries, designed to bring SQLite to the edge computing era with databases deployed close to users for minimal latency, backed by investors including Andreessen Horowitz and positioned as an alternative to traditional client-server databases for read-heavy and edge-native applications. The libSQL fork extends SQLite with server capabilities through a native server mode that accepts connections over HTTP and WebSocket, streaming replication that asynchronously replicates writes from a primary database to read replicas across multiple regions, native vector data types and operations for AI similarity search applications including approximate nearest neighbor search through vector embeddings, and JavaScript user-defined functions for extending SQL with custom logic. The multi-tenant architecture enables creating hundreds of thousands of individual SQLite databases, one per user, tenant, or application instance, with each database being independently branched, replicated, and managed, enabling architectural patterns where each customer gets their own isolated database rather than sharing a multi-tenant database with row-level isolation. The embedded client provides a JavaScript and TypeScript SDK that can run queries against a local replica of the database in the browser or edge function, with automatic synchronization to the remote primary, enabling offline-capable applications with instant reads from local data and eventual consistency for writes. The fly.io integration for global deployment. The schema management. The point-in-time recovery. Designed for edge and serverless developers.