Module db 

SQLite database connection management.

Provides a connection pool to the SQLite database with WAL mode enabled for concurrent read/write performance. The database file and its parent directories are created automatically if they don’t exist.

Write-Ahead Logging (WAL)

WAL mode is enabled for all connections, which allows concurrent readers and a single writer without blocking. This is important for the MCP server, where search queries and sync operations may overlap.

Connection Pool

Uses sqlx::SqlitePool with up to 5 concurrent connections. Connections are reused across requests for efficiency.

Functions

connect

Create a connection pool to the configured SQLite database.