Oracle databases also break their spirit. I've used the Oracle DB MCP server with an agent based ChatGPT 4o and it got stuck in a ever more desperate loop because the MCP Server listed the table names but in SQL you had to quote them if they are not all uppercase. Empty strings are also "special" in Oracle... It was funny and sad to read what the model tried to do to solve the problem.

[–] luciferofastora@feddit.org 5 points 1 day ago (1 children)

Fuck Oracle DB.

(Though I can't say I'm particularly happy with the MS SQL Servers we're using at work either)

[–] msage@programming.dev 13 points 1 day ago (2 children)

Fuck every database other than Postgres.

SQLite can be ok at times, too.

[–] expr@programming.dev 7 points 1 day ago

Yep. Postgres rocks. No idea why anyone would bother with anything else. They all suck in comparison.

[–] CosmicTurtle0@lemmy.dbzer0.com 2 points 1 day ago (1 children)

Wait what's wrong with MariaDB?

It's FOSS, it's compatible with MySQL libraries.

[–] msage@programming.dev 3 points 1 day ago

MySQL is absolute shit.

I don't follow MariaDB to know if they made it much better.