News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by mumblemumble on Thursday April 15, 2021 @09:30AM (#26820211)
Even when systems don't share a database, if operational concerns - disaster recovery, failover migrations, metrics and monitoring, anything like that - matter to me, I'm reaching for PostgreSQL or MS SQL Server. I hear I also need to get over my 20 year old grudge against MySQL.

SQLite is really only my first choice for hobby projects and desktop apps that aren't running on the JVM.

Re:SQLite the only database you will ever need in most cases by eric_h on Thursday April 15, 2021 @11:02AM (#26821320)
> I hear I also need to get over my 20 year old grudge against MySQL.

I hear this too - but silently truncating my data (causing a great deal of data loss and grief for me) is likely going to continue to bias me against MySQL for the foreseeable future.

Re:SQLite the only database you will ever need in most cases by johannes1234321 on Thursday April 15, 2021 @01:51PM (#26823858)
That was configurable for ages and default is on strict for a long time now ...

Compatibility with old decisions vs. doing the right thing™ is always a pain ...

Re:SQLite the only database you will ever need in most cases by eric_h on Thursday April 15, 2021 @07:04PM (#26827293)
> That was configurable for ages and default is on strict for a long time now

I'm not saying I'm being rational in holding my grudge. I got bit by that "bug" _bad_ early in my career and the scar tissue lingers.