News for hackers. Stuff that matters.
Re:ORMs Are Backwards by deathanatos on Tuesday September 03, 2019 @10:57PM (#20873601)
I don't think there is enough information from the database schema to feed an ORM reliably. E.g., take a "boolean" in MySQL: MySQL doesn't have proper booleans, it just represents them as a `tinyint`. But you'd really like your ORM to convert those to your language's `bool`!

There is certainly a lot of information in a schema, and you definitely want your ORM's idea of the database and the database's idea of it to be in close alignment, but I feel like any serious attempt would find all sorts of holes like the above when it actually came to doing it.

Re:ORMs Are Backwards by setr on Wednesday September 04, 2019 @12:19AM (#20873969)
Wouldn’t you just offer user-modifiable translators for such cases (presumably with some sane default)? It seems more preferable than writing the domain model in code first, resulting in N copies of the schema definition for N applications utilizing the db..
Re:ORMs Are Backwards by skissane on Wednesday September 04, 2019 @01:21AM (#20874228)
> N copies of the schema definition for N applications utilizing the db..

Is multiple applications talking to a shared DB schema a common practice, especially nowadays?

In my mind, each app/service should have a DB schema which only it talks to, and other apps/services needing data in that DB go through services exposed by that app/service (REST, RPC, GraphQL, whatever) rather than talking to its DB directly. That means you can rearchitect the DB schema, change which DB you use completely, etc., and only the app/service which owns that DB needs to be modified.

Re:ORMs Are Backwards by jacobush on Wednesday September 04, 2019 @02:22AM (#20874519)
Yes, it is common practice just about in every organically grown system, ever. Also anything corporate.