Ask HN: Have you used SQLite as a primary database?

Re:Ask HN: Have you used SQLite as a primary database? by jll29 on Monday April 25, 2022 @07:13AM (#31152935)

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).

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by barryhennessy on Monday April 25, 2022 @07:35AM (#31153104)

I'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.

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by asymmetric on Monday April 25, 2022 @10:13AM (#31155080)

For 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

[ Parent | on HN ]