sqlite-utils
Fewer than 5 people recommend it so far, so there's no written verdict. Here is what commenters said.
Why people recommend it
“I'm a big fan of sqlite-utils”
“sqlite-utils does SQLite FTS full text search config.”
Show 1 more
“"make it easy to replcate" Litestream and "make it easy to use" sqlite-utils, it just becomes easier.”
Caveats and dissent
No one in these comments warned against it.
Often compared with
From the makers not counted in the ranking
“but Datasette, sqlite-utils and LLM are not that.”
“I have similar charts across my three main open source projects”
“My sqlite-utils CLI tool and Python library offers solutions to both the alter table limitations and the need for schema migrations.”
“I just added a new test explicitly covering this”
“This inspired me to add a feature to my sqlite-utils Python library and CLI tool”
“The test coverage of sqlite-utils is solid”
Threads where it came up
- Prefer Strict Tables in SQLite 3 mentions
- Eight Myths on Software Engineering and GenAI 2 mentions
- sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) 2 mentions
- Small Kafka: Tansu and SQLite on a free t3.micro 2 mentions
- SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers 1 mention
- SQLite is all you need for durable workflows 1 mention
Data: sqlite-utils.json. Quotes are verbatim; the verdict and theme labels are written by a model from these comments, and every clause links to its sources.
All comments 5
“It uses "PRAGMA foreign_keys=0"”
“I'm a big fan of sqlite-utils”
“sqlite-utils does SQLite FTS full text search config.”
I love the idea of SQLite, but I actually really dislike using it. I think part of my issue is that a lot of uses of it end up having a big global lock on the database file (see: older versions of Emby/Jellyfin) so you can't use it with multiple threads or processes, but I also haven't really ever find a case to use it over other options. I've never really felt the need to do anything like a JOIN or a UNION when doin
“"make it easy to replcate" Litestream and "make it easy to use" sqlite-utils, it just becomes easier.”