libSQL

What libSQL is

libSQL is an open-source, open-contribution relational database fork of SQLite maintained by Turso. It aims to retain SQLite file-format support and API compatibility while adding APIs and extensions, and can run embedded in an application without a network connection. Embedded replicas let applications keep replicated database copies locally. For remote access, the libSQL server accepts SQL from clients over HTTP; Docker instructions cover primary and replica server instances. The repository lists official TypeScript/JavaScript, Rust, and Go drivers, experimental Python and C drivers, and community drivers for PHP, D, and Ring. Listed extensions include ALTER TABLE changes to column types and constraints, randomized ROWID, WebAssembly user-defined functions, and a virtual write-ahead-log interface. GUI options include Beekeeper Studio, Outerbase, TablePlus, Dataflare, and libSQL Studio. The project retains SQLite’s single-writer limitation. Its documentation recommends Turso Database for new projects, where new features are being developed, while libSQL remains actively maintained. The repository identifies the license as MIT.