Why you should probably be using SQLite

Re:Why you should probably be using SQLite by eduction on Friday October 27, 2023 @10:39AM (#38039073)

> What I do think would be awesome would be an embeddable Postgres library/binary that could use a single state file on your local filesystem for development and use a networked database in production.

Absolutely! And also, short of that but incrementally building toward it, some sort of simplification of initial db setup and configuration, including really solid, thoughtful defaults (many of them are but I am guessing they could be substantially improved).

I feel like half of people’s attraction to SQLite is the easy setup and first deploy story. Postgres will never match that but could get closer.

[ Parent | on HN ]

Re:Why you should probably be using SQLite by jimbokun on Friday October 27, 2023 @11:07AM (#38039464)

> I feel like half of people’s attraction to SQLite is the easy setup and first deploy story.

That is an incredibly important part of the story!

Spending a lot of time on configuring and monitoring and operationalizing your database can kill a business iterating on its minimum viable project.

[ Parent | on HN ]

Re:Why you should probably be using SQLite by icedchai on Friday October 27, 2023 @12:36PM (#38040690)

In production, use a managed service (RDS, Cloud SQL, tons of others...) In dev, set up a Docker container. You won't spend a lot of time on either of these things.

[ Parent | on HN ]