22
submitted 10 months ago by cwagner@beehaw.org to c/programming@beehaw.org

I’m an accidental DBA, but I still never quite got the hate for ORMs. I thought this article does a good job explaining the issue, and why they aren’t so bad.

you are viewing a single comment's thread
view the rest of the comments
[-] abhibeckert@beehaw.org 1 points 10 months ago* (last edited 10 months ago)

I wouldn't call that "near" SQL, I'd basically just call it SQL. Nothing wrong with that... SQL is great, and using proper language constructs instead of strings makes it even better... but it's not solving the some problem as an ORM.

[-] Paradox@lemdro.id 1 points 10 months ago

True, however it occupies the same niche an ORM occupies, without the foot guns. Updating a slew of different db tables from rather clean and straightforward models is relatively simple. It tries to live somewhere between just doing everything as SQL and abstracting everything away like AR does, giving you conveniences from both approaches. You don't get mired in scoping hell, but you don't have big ugly messes of nearly-identical SQL statements either.

i'd recommend trying it out https://hexdocs.pm/ecto/Ecto.html

this post was submitted on 24 Oct 2023
22 points (100.0% liked)

Programming

13097 readers
1 users here now

All things programming and coding related. Subcommunity of Technology.


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 1 year ago
MODERATORS