4 ms·
My preferred production DB is PostgreSQL. However, for small experiments, SQLite is more versatile due to fewer dependencies, single binary, zero install overh
by jll29 5y ago
My preferred production DB is PostgreSQL. However, for small experiments,
SQLite is more versatile due to fewer dependencies, single binary, zero install overhead etc., so I use it often, in particular for research experiments and systems prototyping. The only thing that ever bothered me was the lack of type enforcement, which has since been improved.
Production uses: 0 (1 if my Ph.D. thesis code is included, which had some C++ code that linked against version 2 of the SQLite library).
- barryhennessy 5y agoI'm coming from a similar direction. Postgres is my go-to, and I love it's reliability when you get your schema right. Glad to hear its type enforcement situation is improving.
- asymmetric 5y agoFor those who've missed the announcement, here are some past links on the topic: - https://www.sqlite.org/stricttables.html - https://news.ycombinator.com/item?id=28259104 - https://news.ycombinator.com/item?id=29363054