webrobots.io
PostgreSQL 9.4 JSON Queries
Intro Querying JSON with SQL is extremely powerful and convenient. Some great things about: Use SQL to query unstructured data Join relational and JSON tables Convert between JSON and relational schema But query writing can be difficult and non obvious at first. Official documentation doesn't have many samples. Many useful queries need other great but not widely known