libSQL (Turso) — Open-Contribution Fork of SQLite

What it is

libSQL is a fork of SQLite created by Turso that is both open source and open to contributions. SQLite itself does not accept external contributions. libSQL adds features that SQLite cannot: embedded replicas, a standalone server mode, vector search columns, and ALTER TABLE extensions.

libSQL targets developers building modern applications who want SQLite simplicity with features needed for edge computing, distributed reads, and AI workloads like vector similarity search.

How it saves time or tokens

libSQL embedded replicas let your application read from a local SQLite file that automatically syncs from a remote primary. This eliminates the latency of network database queries for read-heavy workloads. The Turso CLI provides instant database creation and management without infrastructure setup.

How to use

1. Install the Turso CLI and create a database:

brew install tursodatabase/tap/turso
turso db create mydb
turso db shell mydb

1. Or run libSQL locally with Docker:

docker run -d --name libsql -p 8080:8080 ghcr.io/tursodatabase/libsql-server:latest

1. Connect from your application using a libSQL client library.

Example

-- libSQL extends SQLite with vector columns
CREATE TABLE documents (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT NOT NULL,
  embedding F32_BLOB(384)
);

-- Insert with vector data
INSERT INTO documents (title, embedding)
VALUES ('AI Guide', vector('[0.1, 0.2, ...]'));

-- Vector similarity search
SELECT title, vector_distance_cos(embedding, vector('[0.1, 0.2, ...]')) AS distance
FROM documents
ORDER BY distance
LIMIT 5;

Related on TokRepo

• Database Tools -- Database and data storage solutions
• AI Tools for RAG -- Vector search for retrieval-augmented generation

Common pitfalls

• libSQL is wire-compatible with SQLite but adds extensions. Code written for libSQL vector features will not work on stock SQLite.
• Embedded replicas are read-only. Write operations must go through the primary server.
• The Turso managed service has a free tier with limits. Self-hosting libSQL-server removes those limits but requires your own infrastructure.