[adamckay]

> It feels like you're asking people to only create Postgres, but SQLite has a perfectly valid use case as well.

I don't mean this to be a "well actually" comment, but because I found it interesting when I learnt this a few weeks ago - some limits for SQLite [1] are actually higher than the limits for Postgres [2] (specifically the number of columns in a table and the maximum size of a single field).

1 - https://www.sqlite.org/limits.html

2 - https://www.postgresql.org/docs/current/limits.html

[lordgrenville]

I've been working with some SQLite databases that are >100GB lately, and wondering if this is a bad idea. The theoretical max size is 140TB, but there's a big gap between can and should.