libSQL SQLite fork adds embedded replicas, remote access, and WebAssembly UDFs

libSQL is an open-source fork of SQLite developed by Turso that preserves the embedded database model while adding infrastructure for distributed applications. The project maintains SQLite's file format and C API compatibility, allowing existing databases and applications to migrate without structural changes.

New capabilities include embedded replicas for local access to remote databases, a standalone server component for network-based SQL access, extended ALTER TABLE operations, randomized ROWID support, and WebAssembly-based user-defined functions. Client bindings are available for Rust, JavaScript, Go, and other languages. The project is distinct from Turso's separate commercial database engine and is released under the MIT License.

What libSQL adds beyond SQLite

• Embedded replicas: Applications can maintain locally accessible copies of remotely hosted databases, enabling offline-capable distributed architectures without abandoning SQLite's embedded model.
• Remote server component: libSQL server provides network-based SQL database access, extending SQLite beyond single-process local use cases.
• WebAssembly UDFs: User-defined functions can be implemented in WebAssembly, allowing sandboxed custom database operations in portable bytecode rather than native C extensions.
• Extended schema operations: Additional ALTER TABLE functionality supports more column and constraint modifications than stock SQLite permits.
• Virtual WAL interfaces: The engine exposes virtualized write-ahead logging interfaces for applications requiring custom control over replication, durability, or logging behavior.

Why it matters

libSQL addresses a long-standing gap in the SQLite ecosystem: the inability to operate SQLite as a distributed or client-server database without abandoning its simplicity. For Linux application developers and embedded systems builders, this provides a migration path toward replication and remote access without adopting heavier databases like PostgreSQL or MySQL. The WebAssembly UDF support also aligns with growing cross-language and sandboxed extension strategies seen in modern database projects.