Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: