News for hackers. Stuff that matters.
Re:WordPress Core to start using SQLite Database by ilyt on Wednesday July 26, 2023 @06:42PM (#36886185)
> Apps and frameworks should work with the lowest-common denominator of SQL.

Pointless limitation that will make your app slower and SQL code worse.

> I get physically ill when I walk into yet another Rails shop to find that they have used every cool feature of Postgres and as a result, the CI must spin up a huge postgres instance and multiple plugins just to run a single unit test. Ugh.

shrug. We (not rails shop) just create temporary database, pass it to CI test, remove after. Picking database because your CI is done badly is like one of the worst ways to decide on architecture

Re:WordPress Core to start using SQLite Database by notjoemama on Wednesday July 26, 2023 @08:01PM (#36886904)
shrug. a lot of systems have been in place long before modern CI

Assuming they can just "do it" is a bad assumption of both the depth of their existing stack and their companies budget for migrating.

I'm gonna guess you haven't been around long enough to have FTP'd files as a deployment.

Re:WordPress Core to start using SQLite Database by phendrenad2 on Thursday July 27, 2023 @11:18PM (#36902795)
> Pointless limitation that will make your app slower and SQL code worse

That seems to be the common opinion, but I don't think that it's based on anything tangible.