4 ms·

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