Turso - Databases Everywhere

# Turso > Turso is a SQLite-compatible database for every application — local, embedded, cloud-synced, or remote. ## Overview Turso is a ground-up rewrite of SQLite with concurrent writes (MVCC), async I/O, and built-in cloud sync. It runs embedded in your application, as a remote cloud database, or both. Turso is a drop-in replacement for SQLite — your existing SQL, schema, and queries work unchanged. - GitHub: https://github.com/tursodatabase/turso - Documentation: https://docs.turso.tech Features: - **Concurrent writes** (MVCC) — multiple writers without "database is locked" errors - **Full-text search** — Tantivy-powered FTS with BM25 ranking, highlighting, and boolean queries - **Vector search** — native embedding storage and cosine similarity search - **Turso Sync** — true local-first sync with explicit push/pull to Turso Cloud - **Encryption at rest** — AES-256 per-database encryption - **Change Data Capture (CDC)** — built-in audit logging of every mutation - **Triggers and materialized views** — database-level automation - **Multi-tenancy** — designed for thousands of lightweight databases (database-per-tenant) ## Which package should I use? | Use case | TypeScript | Python | | --- | --- | --- | | **Local database** (embedded, on-device, offline) | `@tursodatabase/database` | `pyturso` | | **Local database + cloud sync** (push/pull) | `@tursodatabase/sync` | `pyturso` (with sync) | | **Remote access** (servers, Docker, serverless, edge — any over-the-wire) | `@tursodatabase/serverless` | `libsql` | | **Legacy (libSQL)** — battle-tested, ORM support | `@libsql/client` | `libsql` | **Starting a new project?** Use `@tursodatabase/database` (TypeScript) or `pyturso` (Python) for local/embedded use. Use `@tursodatabase/serverless` for any application that connects to a remote Turso Cloud database over the network — including Node.js servers, Docker containers, serverless functions, and edge runtimes. Use `@libsql/client` only i