this post was submitted on 09 Aug 2024
593 points (98.1% liked)

Programmer Humor

32479 readers
222 users here now

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

Rules:

founded 5 years ago
MODERATORS
 

Those who know, know.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 26 points 3 months ago (7 children)

The consultancy I used to work for in the late 90s would have crucified any developer that didn't write "a data abstraction layer that allows you to pop off the original db and substitute a different one later".

How many times in my 25 year career have I swapped out the database (and been thankful for such an abstraction layer)? 0 times.

[–] [email protected] 4 points 3 months ago (4 children)

I am literally in the middle of swapping DynamoDB for a RDBMS.

The idea that you can abstract away such fundamentally different data stores is silly. While I hate doing it now, reworking the code to use relational models properly makes for a better product later.

[–] [email protected] 2 points 3 months ago (2 children)

It's literally what an orm does, and it's good enough for 80% of apps out there. Using it for the wrong purpose is what's silly.

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

I see. It seems like you may be one of the people that try to coerce relational models into nosql stores like Dynamo.

Or course it's possible. They even trick you into thinking it's a good pattern by naming things "tables".

But if you're using Dynamo to its fullest an ORM is not going to be able to replicate that into a relational store without some fundamental changes.

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

Hence 80%.

Most apps out there are a CRUD with a thin layer of logic.

If you are in the 20% that needs real performance, an ORM is not gonna cut it, no matter what DB you have.

load more comments (1 replies)
load more comments (3 replies)