3 ms·
Are there any examples of ORMs that have been used for over 10 years that people don't hate?
by keithalewis 4y ago
Are there any examples of ORMs that have been used for over 10 years that people don't hate?
- mo_po2 4y agoDjangoORM
- graypegg 4y agoRails activerecord? It’s got it’s quirks, but I feel like it’s pretty boring and predictable to use, in a good way!
- alkonaut 4y agoDapper https://github.com/DapperLib/Dapper/ https://github.com/DapperLib/Dapper/ Granted, it doesn't do everything (it just does what it needs to not be hated). I used it because it does the boring error-prone bits of manual SQL but not much else.
- thom 4y agoI never hated Hibernate. It gave me huge amounts of power and flexibility, outs to use raw SQL or even stored procedures when necessary, and was extensible enough that I could even map to legacy schemas that were basically insane.
- thunderbong 4y agoRuby's Sequel ORM - https://sequel.jeremyevans.net/ https://sequel.jeremyevans.net/
- plant-ian 4y agoSQLAlchemy: "SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL." - connection pooling, multiple drivers - core layer (can use to build sql without orm, describe table metadata, output ddl, etc.) - orm layer (automatic class to table mapping, relationships, configurable relationship loading strategies, easy ad-hoc optimization of loading objects, write custom SQL to load objects, load relationships from subqueries, etc.) - db reflection - db inspection - migrations (via alembic) - now supports async drivers - 2.0 coming out soon with more consistent interfaces Pretty much does almost everything or provides a compatible way for you to do it yourself. I think most people complaining about ORMs just haven't used this one. You still have to know SQL. edited: formatting