News for hackers. Stuff that matters.

A comment on Against SQL. Parent comment

Re:Against SQL by ahartmetz on Saturday July 10, 2021 @06:07AM (#27792378)
I don't think that NoSQL ever was about better query languages for relational databases. It was about making databases faster and easier to use by using simpler data models with fewer guarantees.
[ Parent | on HN ]
Re:Against SQL by 1337shadow on Saturday July 10, 2021 @06:14AM (#27792405)
And now that we can query JSON fields in PG we get the best of both world.
[ Parent | on HN ]
Re:Against SQL by jjgreen on Saturday July 10, 2021 @07:55AM (#27792758)
I like this (and use it) but it has to be said, the syntax is grim.
[ Parent | on HN ]
Re:Against SQL by LAC-Tech on Saturday July 10, 2021 @09:00AM (#27793077)
Still, I'd rather query JSON in postgres than do joins in mongo.
[ Parent | on HN ]
Re:Against SQL by Izkata on Saturday July 10, 2021 @03:23PM (#27795774)
For now. Next version (currently in beta) will support the usual [] syntax in queries: https://blog.crunchydata.com/blog/better-json-in-postgres-wi...
[ Parent | on HN ]
Re:Against SQL by Semaphor on Saturday July 10, 2021 @08:59AM (#27793069)
Same for MSSQL, all XML or JSON Syntax is very… unfun.
[ Parent | on HN ]