SQLite Extensions

The default SqliteDatabase already includes many SQLite-specific features:

• General notes on using SQLite.
• Configuring SQLite using PRAGMA statements.
• User-defined functions, aggregate and collations.
• Locking modes for transactions.

The playhouse.sqlite_ext includes even more SQLite features, including:

• Full-text search
• JSON extension integration
• Closure table extension support
• LSM1 extension support
• User-defined table functions
• Support for online backups using backup API: backup_to_file()
• BLOB API support, for efficient binary data storage.
• Additional helpers, including bloom filter, more.