News for hackers. Stuff that matters.

A comment on SQLite or PostgreSQL? It's Complicated. Parent comment

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 ]