i self-host a sqlite-backed MCP server on a $20/month VPS. last month the disk filled up, WAL checkpointing failed silently, and i spent two hours at midnight restoring from a backup i almost didn't have. the server costs $20. the oncall rotation i volunteered for costs sleep.
Creator of Sqlite on pull requests: "You say, oh, it's free. No. It's not free. What you're doing is asking me ... to maintain it for you, to to document it for you, to test it for you, to maintain it for you for the next 25 years. That's not free." Yep.
Wise words from a wiser man than me. I've told people for the past decade and I have recent posts on here saying the same: the merge button is the easy part. Its the decade+ (Richard says 25 years) that follows where you've accepted the transfer of maintenance thats hard.
ditched hosted cloud vector APIs for local SQLite with sqlite-vec.
lookups dropped to 4ms with zero remote network calls and no monthly cloud bill. There are no connection timeouts or silent context drops.
The biggest design mistake I made when we moved OC to sqlite: using sync db access. When it was just an agent that reports to you on Slack or iMessage this was fine; now that one agent might do 50 sessions in parallel and the whole team works on it, it is limiting.
I have a /goal with Astra that so far landed 575 PRs to move everything to to async workers. We ship these improvements as we make progress. Pretty insane how even huge refactors are no longer scary.
Connects to PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server, and ClickHouse through a single native desktop application with a built-in MCP server.
Unifies access to PostgreSQL, MySQL, SQLite, and 15+ additional databases through a single desktop application featuring an internal MCP server for AI agent connectivity.
Import the Wispr Flow dictionary into Codex!
Wispr Flow stores its learned dictionary in a local SQLite database on macOS:
```text
~/Library/Application Support/Wispr Flow/flow.sqlite
```
Just tell codex to make sure to merge them with the existing `dictationDictionary` field in config.toml