Re:What ORMs have taught me: just learn SQL (2014)
by rickycook on Monday December 18, 2017 @02:22AM
(#15950044)
it might be theoretical in hibernate, but sqlalchemy does a TON of this stuff
as an example: https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalch...
heaps of this kind of thing are nicely dotted around the code so you don’t have to deal with weird driver quirks, maps “Text” column type to whatever it needs to be in your given database to have an unbounded text blob
id say that’s far more than theoretical
EDIT: typo
EDIT 2: also, on DB specific features, SQLA supports a bunch (not all). eg: https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalch...
Re:What ORMs have taught me: just learn SQL (2014)
by needusername on Monday December 18, 2017 @03:36PM
(#15955253)
In Java land the JDBC driver is supposed to do that. If it doesn't then that's a bug in the driver. If it's a bug in the JDBC driver then the fix needs to go into the JDBC driver, especially if the driver is on GitHub.
The presence of an ORM relying on these bugs should not prevent a bug in the driver from being fixed.
That is quite theoretical. My PRs for fixing non-spec compliant behavior in pgjdbc get rejected because they might break some ORMs (mostly Play). My PRs for adding MariaDB sequence support to Hibernate get rejected because there are additional MariaDB features that Hibernate doesn't support as well.