SQLite or PostgreSQL? It's Complicated

Re:SQLite or PostgreSQL? It's Complicated by BeefWellington on Tuesday June 28, 2022 @12:33PM (#31909873)

Sure, you can start there. Once you scale though you're going to have lots of fun.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by neverartful on Tuesday June 28, 2022 @12:45PM (#31910031)

For many applications you're right. However, in the case of a dashboard for blog articles I don't think it could ever come to that.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by ed25519FUUU on Wednesday June 29, 2022 @01:55AM (#31916928)

I’ve never worked on a project that was scaled out that didn’t require at least moderate DB maintenance, such as a large migration or sharding.

A migration is all but expected. Might as well make things easy on yourself for the first year and start with SQLite.

[ Parent | on HN ]

Re:SQLite or PostgreSQL? It's Complicated by marginalia_nu on Wednesday June 29, 2022 @06:45AM (#31918454)

We're talking about data from a blog, though. It's not like it's going to scale to have terabytes of entries anytime soon.

[ Parent | on HN ]