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