Documentation Index
Fetch the complete documentation index at: https://docs.turso.tech/llms.txt
Use this file to discover all available pages before exploring further.
SQLite Compatibility
The authoritative compatibility reference is maintained atCOMPAT.md in the repository root. It tracks the support status for every SQL statement, expression, function, PRAGMA, C API function, VDBE opcode, and extension.
Refer to that document for the current state of compatibility. It is updated alongside code changes to stay accurate.
Turso-Specific Extensions
These features extend Turso beyond SQLite compatibility:| Feature | Description |
|---|---|
| CREATE TYPE | User-defined types for STRICT tables |
| CREATE MATERIALIZED VIEW | Live materialized views with incremental maintenance |
| BEGIN CONCURRENT | Optimistic concurrent write transactions (MVCC) |
| Vector functions | Vector storage, distance calculations, similarity search |
| Full-text search | Tantivy-powered FTS with BM25 scoring |
| CDC | Change Data Capture via PRAGMA |
| Encryption | At-rest database encryption |
| Custom index methods | CREATE INDEX … USING for FTS and custom access methods |
| stddev() | Standard deviation aggregate function |
See Also
- Experimental Features for how to enable experimental features
- COMPAT.md for the full compatibility matrix
