4 ms·

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

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.

1337shadow 5y ago
And now that we can query JSON fields in PG we get the best of both world.
- jjgreen 5y ago
  I like this (and use it) but it has to be said, the syntax is grim.
  - Semaphor 5y ago
    Same for MSSQL, all XML or JSON Syntax is very… unfun.
  - LAC-Tech 5y ago
    Still, I'd rather query JSON in postgres than do joins in mongo.
  - Izkata 5y ago
    For now. Next version (currently in beta) will support the usual [] syntax in queries: https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14 https://blog.crunchydata.com/blog/better-json-in-postgres-wi...