throwawaygehehe
throwawaygehehe on Hacker News
Re:SQLITE: JSON1 Extension
on Friday February 03, 2017 @09:13AM (#13559875)
I'm pretty sure one can create indices based on JSON expressions
(see, for example, http://sqlite.1065341.n5.nabble.com/Partial-indexes-on-JSON-...). I don't know how it compares to Postgres' JSON support.