Docs
Docs/Database Connections/SQLite

SQLite

Connect to local SQLite database files

SQLite databases are stored as single files on your computer. QuackDB uses native C++ bindings (better-sqlite3) for maximum performance.

Supported File Extensions

.db.sqlite.sqlite3

Connection Options

OptionDescription
PathPath to your database file
Read-onlyOpen in read-only mode (optional)

Supported Features

WAL mode for concurrent access
In-memory databases
FTS (Full-Text Search)
JSON1 extension
Attached databases
R-Tree indexes

Note: SQLite supports only one write operation at a time. QuackDB uses WAL mode to improve concurrent read performance.

Need help?

Join our Discord community for support and discussions.

Join Discord