3 ms·
In PostgreSQL, you can just select against JSON and query away to your hearts content. They have JSON data types and functions to work on it.
by zie 2y ago
In PostgreSQL, you can just select against JSON and query away to your hearts content. They have JSON data types and functions to work on it.
- masklinn 2y agoThat’s pretty much just jq though, you have bespoke json querying capabilities in sql but you’re not sql-querying your json. At least not before postgres 17, in the latter json_table does provide this capability.
- zie 2y agoThankfully PG17 is released and ready for production querying needs!