libSQL is SQLite

for modern applications

Build on the most deployed database in the world

SQLite is the most deployed database in the world because it's the simplest to write, test and deploy. libSQL, the open contribution fork of SQLite, builds on that foundation while preserving all the benefits developers love.

Affordable to run, replicate & scale

SQLite runs anywhere, from the smallest device to the most powerful server. With native replication, libSQL makes that into a database that can massively replicate and scale, with low resource usage.

Develop, test and deploy with the same database

Unlike Postgres and MySQL, a SQLite database is just a file. That means local testing is fast and doesn’t depend on spawning containers or services. libSQL adds an HTTP mode that lets you take the code you just tested straight into production.

Allows for massive Database Per Tenant

libSQL lets you easily spin up one database per user, regardless of scale, using multitenant database groups. That means support for per user data isolation and convenient geographical placement for minimized latency and local compliance.

Run locally or over the network

libSQL comes with a server mode, libsql-server, and because of other powerful native features like replication, embedded replicas, multi tenancy and edge nodes in every major geo in the world, that means you can write locally and deploy wherever you like.

It’s open source & open contribution

We love SQLite, and we believe the Open Source community can help us continue to build it into a modern application powerhouse, while continuing to integrate it into modern workflows. That's why we made the libSQL fork open contribution.

Why We Created libSQL

Postgres and MySQL are locked in a decades long struggle for SQL supremacy.

Meanwhile, SQLite exists as a popular alternative solution, because developers love its simplicity, reliability and zero conf nature. That’s why it is considered the “hello world” of databases: every tutorial starts with SQLite.

Usually SQLite is thought of for alternative use cases where all of your data fits locally within your application, but we strongly believe that SQLite can also play an important role in modern distributed internet workloads, especially where latency and performance are important. To get there it needs to evolve, however SQLite is open source, but not open contribution.

That’s why we created libSQL.

Learn more about libSQL

Get started with Turso for free

scarf