ORMs are stupid. Get rid of them. (hexbear.net)

submitted 7 months ago* (last edited 7 months ago) by PorkrollPosadist@hexbear.net to c/technology@hexbear.net

13 comments fedilink hide all child comments

SQL is good actually. Using your database system to define your data model along with all of its constraints is much better than just scribbling out some Rust/TypeScript/Go datatypes and shitting them out into a schema with a new database migration every fucking commit.

Your SQL application does not need to be portable. You don't need an over-engineered rube-goldberg solution where you can slot out OracleDB for SQLite for fucking CSV documents. Your code SHOULD be ANSI/ISO standard, but it just needs to run on PostgreSQL. PostgeSQL is portable.

Thanks for coming to my TED talk.

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

[-] makotech222@hexbear.net 8 points 7 months ago

use a good ORM, like Efcore

Having strict typing and references for accessing your db is essential for refactoring jobs. Having to fucking query where a property is used in stored procedures is pure hell. Deploying new versions of your code with migrations is also so much easier than orchestrating sql execution alongside code execution.

Being able to write

dbcontext.Users.Where(x => x.IsAdmin).Select(x => x.UserName).ToListAsync() and execute exactly the sql you would write is awesome, and not have to fuck around with sql is great.

[-] mr_satan@lemmy.zip 3 points 7 months ago

Yeah, this. I recently tried TypeORM for a personal project and, well, it works. But, god, I wish it was way more mature like EFCore.

this post was submitted on 26 Sep 2025

39 points (88.2% liked)

technology

24356 readers

164 users here now

On the road to fully automated luxury gay space communism.

Spreading Linux propaganda since 2020

Rules:

1. Obviously abide by the sitewide code of conduct. Bigotry will be met with an immediate ban
2. This community is about technology. Offtopic is permitted as long as it is kept in the comment sections
3. Although this is not /c/libre, FOSS related posting is tolerated, and even welcome in the case of effort posts
4. We believe technology should be liberating. As such, avoid promoting proprietary and/or bourgeois technology
5. Explanatory posts to correct the potential mistakes a comrade made in a post of their own are allowed, as long as they remain respectful
6. No crypto (Bitcoin, NFT, etc.) speculation, unless it is purely informative and not too cringe
7. Absolutely no tech bro shit. If you have a good opinion of Silicon Valley billionaires please manifest yourself so we can ban you.

founded 5 years ago

MODERATORS

context@hexbear.net

SexUnderSocialism@hexbear.net

gaycomputeruser@hexbear.net

Wakmrow@hexbear.net

SwitchyandWitchy@hexbear.net

JustSo@hexbear.net