SQLite or PostgreSQL? It's Complicated

Re:SQLite or PostgreSQL? It's Complicated by riku_iki on Wednesday June 29, 2022 @12:24PM (#31922333)

There is config change in steps above (pgsql defaults suck), and having docker now, changing them becomes harder.

Also, I usually change hba.conf file too, to disallow outside connections.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by jayd16 on Wednesday June 29, 2022 @02:31PM (#31923984)

Keep in mind the suggestion was a managed product in production but if you really need to customize your local image, you can mount in arbitrary initialization scripts as well.

If you need all this customization then did SQLite really fit the bill in the first place?

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by riku_iki on Wednesday June 29, 2022 @03:11PM (#31924458)

> if you really need to customize your local image

I need to change config for prod pgsql instance, because default config performance wise is not necessary suitable for serious prod machines.

> If you need all this customization then did SQLite really fit the bill in the first place?

I am not familiar with SQLite, but somehow familiar with Java H2 DB, which has similar idea. You can embed it and all configs into self contained java jar file together with your app and no moves in host OS is needed.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by physicsguy on Wednesday June 29, 2022 @05:09PM (#31925738)

I only use this for local development personally, we use RDS in Prod

[ Parent | on HN ]