4 ms·
Their JSON data type is atrocious, does anybody actually use it or is it a checkbox item?
by Beefin 7y ago
Their JSON data type is atrocious, does anybody actually use it or is it a checkbox item?
- jacques_chester 7y agoYou can join on arbitrary json fields, with indices. It is an extremely useful swiss army knife. I've used jsonb for performing ETL in-database from REST APIs. I know Concourse from 6.0 uses it for storing resource versions. They had an inputs selection algorithm that became stupidly faster because they can perform joins over JSON objects provided by 3rd-party extensions. Previously it was a nested loop in memory. https://github.com/concourse/concourse/releases/tag/v6.0.0#3602 https://github.com/concourse/concourse/releases/tag/v6.0.0#3...
- Beefin 7y agoIsn't it just a string? can you do nested queries? secondary indexes? really anything beyond just querying the key-value pairs?
- jacques_chester 7y agoIt's a real type. You can do nested queries, follow paths into the structure etc. I've performed quite sophisticated joins over jsonb records.