undefined | Better HN

0 points1337shadow4y ago0 comments

And now that we can query JSON fields in PG we get the best of both world.

0 comments

I like this (and use it) but it has to be said, the syntax is grim.

Still, I'd rather query JSON in postgres than do joins in mongo.

For now. Next version (currently in beta) will support the usual [] syntax in queries: https://blog.crunchydata.com/blog/better-json-in-postgres-wi...

Same for MSSQL, all XML or JSON Syntax is very… unfun.

j / k navigate · click thread line to collapse

I like this (and use it) but it has to be said, the syntax is grim.

Still, I'd rather query JSON in postgres than do joins in mongo.

For now. Next version (currently in beta) will support the usual [] syntax in queries: https://blog.crunchydata.com/blog/better-json-in-postgres-wi...

Same for MSSQL, all XML or JSON Syntax is very… unfun.

j / k navigate · click thread line to collapse