- SQLite — local SQLite database file
- Turso CLI — managed libSQL server
- libSQL Server — self managed libSQL server
- Turso Database — remote Turso database
SQLite
Turso, a hosted platform for libSQL (a fork of SQLite), is ideal for local development, particularly for projects using SQLite, testing environments, and seamlessly transitioning from dev to prod by creating databases from SQLite files There are a few things to keep in mind when using SQLite for local development:- Doesn’t have all the features of libSQL
- Works with non-serverless based Turso SDKs
file: URL to connect to a SQLite database file instead of a remote Turso database:
You don’t need to provide an
authToken in development.It’s recommended to use environment variables for both
url and authToken for a seamless developer experience.Turso CLI
If you’re using libSQL specific features like extensions, you should use the Turso CLI:url option in your SDK:
If you want to persist changes, you can pass the name of the SQLite file to
turso dev:
libSQL Server
You can build and run libSQL server (sqld) yourself locally, or inside your own infrastructure using the source code:
tursodatabase/libsql
Turso Database
If you already have a database created with Turso, you can use that same one in development by passing theurl option to your SDK.