Hacker News new | ask | show | jobs
by scoom 2849 days ago
Great, so force SQL to 'join' things that aren't tables and 'select' things that aren't rows.

SQL wasn't built for querying every possible data store.
2 comments
kevsim 2849 days ago
Yeah, that was my reaction as well. I fully understand his point regarding ORMs that are meant to be an abstraction over a relational database, but imposing the relational model over non-relational datastores sounds like a disaster.
link
threeseed 2849 days ago
If only there was a popular example of this. Wait there is: PostgreSQL.

They bastardised SQL to support JSON data types just like every other vendor has to do because SQL is for relational and only relational data stores. Is this the utopia that the author is after ?

https://www.postgresql.org/docs/9.0/static/hstore.html

link
oulu2006 2849 days ago
I thought they were, for the most part, fairly logical extensions to SQL.

You don't have to use the JSON/JSONB column types, they are optional.

We use them extensively in production and haven't had much difficulty learning them.

link