Programmer Humor

32716 readers

459 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

Posts must be relevant to programming, programmers, or computer science.
No NSFW content.
Jokes must be in good taste. No hate speech, bigotry, etc.

founded 5 years ago

MODERATORS

[email protected]

403

MySQL moment (lemmy.world)

submitted 9 months ago by [email protected] to c/[email protected]

34 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] lowleveldata 10 points 9 months ago (2 children)

Is this a MySQL specific problem? I have witnessed a few dead queries on Sybase / Oracle / etc

[–] [email protected] 8 points 9 months ago* (last edited 9 months ago) (3 children)

I don’t think its mysql specifically, but for some reason the worst systems I have used, all have mysql/mariadb as a database.

It seems shitty applications gravitate to mysql, use it poorly, then bring a bad name to mysql.

But given all my years of experience with it, MSSQL > Posgresql > Mysql > Oracle

[–] [email protected] 4 points 9 months ago* (last edited 9 months ago)

I feel like the popularity of the LAMP stack (or WAMP if you were just starting out your interest in software and hadn't yet moved to Linux) in the 00s and early 10s is to blame here. MySQL ended up being the default choice for people who didn't know much about databases.

Now that I know more than I did at the age of 14 when I first started learning programming... I'll be honest, I'm still likely to choose MySQL just because it's familiar. But at least I know what indices are now, and I try to avoid dependent subqueries :)

To be fair, I feel like I should use Postgresql more, I just haven't actually ever worked on anything that needed the cool data types it has extensions for.

[–] [email protected] 2 points 9 months ago

I was a DBA for over 10 years. Postgresql is superior to mssql in most ways. Especially replication.

But that does not mean that mssql is bad. MySQL is, oracle is.

[–] [email protected] 2 points 9 months ago

Databases need tuning for your workload, and most people just think it’s a big box where you can dump anything you want and it will work. And then when it chokes on a terrible query they blame the DBA.

This makes DBAs very cranky.

[–] [email protected] 3 points 9 months ago

Usually DBMSs have some small capacity to handle requests in parallel so everything slows down, but work is still getting done.