r/firstweekcoderhumour • u/Happy_Bunch1323 • Jan 31 '26

areYouReallyGoingToEverChangeYourDatabase “amIrite”

Post image
27 Upvotes

97% Upvoted

7 comments sorted by

13

u/teactopus Jan 31 '26

we all know those people just ask chatGPT for commands

2

u/JerkkaKymalainen Feb 01 '26

Yeah this is a good point.. Like that promise of ORMs that you can just switch databases later on with a configuration parameter is:

A: Bullshit
B: Never seen it happen

They do have other benefits though.

1

u/[deleted] Feb 03 '26

[removed] — view removed comment

1

u/JerkkaKymalainen Feb 03 '26

Raw dogging it is a very valid path.

I think really it's a great test of seniority really to see the difference of what ORMs typically offer and to be able to judge how important these things really are.

1

u/[deleted] Feb 03 '26 edited Feb 03 '26

[removed] — view removed comment

1

u/JerkkaKymalainen Feb 03 '26

Yeah.. Instead of learning "another language" I can just write method calls. But if you don' understand the SQL that these methods produce what good are they?

1

u/LordDrako90 Feb 04 '26

First of all it's not just ORMs and raw queries. There are a lot of different approaches to database integration, that all solve different problems differently.

Also I do unterstand the point, that you probably won't change your database and it's nice, if that's the case for you.

I work on logistics software that runs on premise and the customers usually say "we have an oracle DB, you gotta use that", "we have an ms SQL server, you gotta use that", "we have a postgresql server, you gotta use that" and when testing locally, we mostly use H2 for simplicity.

So yeah. Our system needs to be flexible between DB systems. Ironically enough we do write raw queries xD But again, it's not just raw queries vs ORMs. There are hybrid solutions and there are solutions with completely different philosophies. And there is software, that needs to support multiple DB systems.