3 ms·
I am curious on this. Why do you think SQLite is simpler than Postgres? and in what setting is that the case? Sqlite comes with the headache of managing an att
by madsbuch 3y ago
I am curious on this. Why do you think SQLite is simpler than Postgres? and in what setting is that the case?
Sqlite comes with the headache of managing an attached volume.
- J_Shelby_J 3y agoBuilding an mvp or a single container app. I’m actually trying to get Postgres to work like this right now. SQLite being embedded is simpler to use and more performant in this environment as there is no IPC overhead.
- madsbuch 3y agoWhy even use a database? Just assign a variable. All state is dead the second you destroy the container anyways.
- jimbokun 3y agoWell then single container plus one attached volume.
- madsbuch 3y agoYep, my point was that this roughly has the complexity of setting up eg. Supabase. In conclusion: I would always advice for Postgres over the approach of setting up a volume with sqlite. The second you need to move on, you need to get that pesky file out of that volume. With Postgres, you just connect to the database from any psql compliant client.