Hacker News Reader

Their JSON data type is atrocious, does anybody actually use it or is it a checkbox item?

You 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#3...

Isn't it just a string? can you do nested queries? secondary indexes? really anything beyond just querying the key-value pairs?

It's a real type. You can do nested queries, follow paths into the structure etc. I've performed quite sophisticated joins over jsonb records.

Reply on news.ycombinator.com