News for hackers. Stuff that matters.
Re:"We ran out of columns" – The best, worst codebase by Vampiero on Saturday August 03, 2024 @11:20AM (#41147090)
> Well, you move the type checks from the database to the app, effectively, which is not a new idea by any means (and a bad idea in many cases), but with JSON, it can actually work out nicely-ish, as long as there are no significant relationships between tables.

That way you're throwing away 50% of the reason you use a relational database in the first place. Has it occurred to you that MongoDB exists?

Also I don't understand why you're afraid of migrations, especially since you're the only developer on your own SMTP server.

Re:"We ran out of columns" – The best, worst codebase by PreInternet01 on Saturday August 03, 2024 @11:44AM (#41147248)
> Has it occurred to you that MongoDB exists?

My original comment started with "but it feels "prior to the MongoDB-is-webscale memes""

So, care to take another guess? And, while we're here, does MongoDB run fully in-process these days? And/or allow easy pagination by ROWID?

Re:"We ran out of columns" – The best, worst codebase by CRConrad on Saturday August 17, 2024 @10:55AM (#41274999)
> My original comment started with "but it feels "prior to the MongoDB-is-webscale memes""

Which feels off by six generations or so of memes. It feels prior to "memes" existing in the first place (at least this modern iteration, pics with captions in them; not Dawkins' original verion). I'd guess it is, ironically, chronologically closer to, well, your username here.

Re:"We ran out of columns" – The best, worst codebase by throwup238 on Saturday August 03, 2024 @11:43AM (#41147244)
> That way you're throwing away 50% of the reason you use a relational database in the first place. Has it occurred to you that MongoDB exists?

Did you miss that he’s using sqlite? The dev experience with a sqlitedb is way better than running yet another service, especially for personal projects.

Sqlite is used just as much as an application file format as it is a relational database.

Re:"We ran out of columns" – The best, worst codebase by throwaway173738 on Saturday August 03, 2024 @01:06PM (#41147784)
How does MongoDB handle someone pulling the power cord out of the server? Because that’s another reason to use something like SQLite, and it often gets used in embedded systems.
Re:"We ran out of columns" – The best, worst codebase by fooster on Saturday August 03, 2024 @05:28PM (#41149380)
Same way as SQLite.
Re:"We ran out of columns" – The best, worst codebase by beembeem on Monday August 05, 2024 @12:37PM (#41162901)
This is a joke right? It journals updates to disk and has a well-defined recovery procedure.
Re:"We ran out of columns" – The best, worst codebase by randomdata on Saturday August 03, 2024 @01:25PM (#41147900)
> Has it occurred to you that MongoDB exists?

What gain would MongoDB offer here?

You certainly would lose a lot of things, like a well supported path to linking with to the database engine, and a straightforward way to start to introduce relational tables as the project matures. Nothing completely insurmountable, of course, but carry a lot of extra effort for what benefit?