If you’re looking to enable vector extensions, you should instead consider
using the native libSQL vector datatype.
Preloaded Extensions
The following extensions are always-on and available:| Extension | Version | Description |
|---|---|---|
| JSON | Built-in | Work with JSON data in SQLite. |
| FTS5 | Built-in | Full-text search and indexing. |
| R*Tree | Built-in | Indexing and querying spatial data. |
| SQLean Crypto | 0.24.1 | Hashing, message digest, encoding, and decoding. |
| SQLean Fuzzy | 0.24.1 | Fuzzy string matching and phonetics. A fork of Spellfix1 with improvements. |
| SQLean Math | 0.24.1 | Advanced mathematical calculations. |
| SQLean Stats | 0.24.1 | Common statistical functions with SQLite. |
| SQLean Text | 0.24.1 | String manipulation (reverse, split) with SQLite. |
| SQLean UUID | 0.24.1 | Limited support for RFC 4122 compliant UUIDs. |
Optional Extensions
The following extensions are also enabled in addition to the preloaded extensions on databases using the Fly Cloud Provider (Pro & Enterprise).| Extension | Version | Description |
|---|---|---|
| SQLean Regexp | 0.24.1 | Regular expressions with SQLite. |
| sqlite-vec | 0.1.3 | The Vector Search successor to sqlite-vss. |