SQLite extensions
caution
SQLite extensions are an experimental feature in Turso. Your observations and feedback are welcome on our Discord.
SQLite extensions add optional features, supported by the SQLite community, that can be used in queries handled by the SQLite query engine. The instances of libSQL server managed by Turso can be configured to enable a select few extensions.
Enabling extensions
Extensions are enabled using the --enable-extensions
flag when creating a
database with the Turso CLI. For example:
$ turso db create my-db --enable-extensions
Extensions can't be enabled for existing databases.
List of extensions
The following extensions are loaded into libSQL server for databases that have extensions enabled.
Extension | Purpose |
---|---|
SQLean Crypto | Hashing, message digest, encoding, and decoding |
SQLean Fuzzy | Fuzzy string matching and phonetics |
SQLean Math | Advanced mathematical calculations |
SQLean Regexp | Regular expressions |
SQLean Stats | Common statistical functions |
SQLean Text | String manipulation (reverse, split) |
SQLean Unicode | Case-insensitive string comparison for Unicode strings |
SQLean UUID | Limited support for RFC 4122 compliant UUIDs |
Vector Similarity Search | Vector search capabilities based on Faiss. |