Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on PostgreSQL 9.4 Released.
http://goessner.net/articles/JsonPath/
http://blog.redfin.com/devblog/2012/03/json_in_postgres.html
That article was written before JSON/JSONB showed up, but the idea remains the same.
I didn't have plv8 installed, so I did some plumbing code in plpython. plv8 would be more suitable though.
https://github.com/jvinet/pg-jsonpath
There are no comments on this comment yet.
http://goessner.net/articles/JsonPath/
http://blog.redfin.com/devblog/2012/03/json_in_postgres.html
That article was written before JSON/JSONB showed up, but the idea remains the same.
I didn't have plv8 installed, so I did some plumbing code in plpython. plv8 would be more suitable though.
https://github.com/jvinet/pg-jsonpath