Re:ORMs Are Backwards
by bayesian_horse on Thursday September 05, 2019 @01:19AM
(#20884039)
Still, I think accessing a single database in RDBMs like Postgres or MySQL from multiple codebases or even languages means asking for trouble.
Providing some kind of API as a library, REST, RPC or whatever would almost always be preferable, if only to centralize permissions and validation.
the problem is that these days you need a lot of application code to check for permissions and that kind of stuff.
In principle permissions can go in the DB.
Re:ORMs Are Backwards
by bayesian_horse on Thursday September 05, 2019 @01:15AM
(#20884026)
In practice this is rarely ever done (right).
Row-level permissions are possible, but it can get more complicated when certain users are only allowed to change a certain row in a certain kind of way but not in another.
A motivation for relational algebra was different applications accessing data in different ways. This integration remains a selling point. Further, data often outlasts applications... even languages.