5 ms·

>Experiments have been unable to find a binary encoding that is significantly smaller or faster than a plain text encoding. (The present implementation parses J

>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?

haldean 10y ago
Looks like you can't index based on JSON in SQLite, so they might be optimizing for different metrics?
- dunham 10y ago
  It's possible this is just the first step in that direction.
- lsaferite 10y ago
  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 http://sqlite.org/expridx.html