Hacker News Reader

>Experiments have been unable to find a binary encoding that is significantly smaller or faster than a plain text encoding. (The present implementation parses JSON text at over 300 MB/s.)

I understand that JSONB in Postgres is useful primarily for sorts and indexes. Does SQLite work around this somehow, or is that just not included in their experiments?

View on HN

Looks like you can't index based on JSON in SQLite, so they might be optimizing for different metrics?

My understanding is that yes you can create an index using this JSON data. You just have to create an index from an expression. http://sqlite.org/expridx.html

It's possible this is just the first step in that direction.

Reply on news.ycombinator.com