2 ms·
I'm increasingly finding myself using SQLite's JSON features for array stuff - they're surprisingly convenient once you get into the habit of using them. A coup
by simonw 4y ago
I'm increasingly finding myself using SQLite's JSON features for array stuff - they're surprisingly convenient once you get into the habit of using them. A couple of recent examples:
- https://til.simonwillison.net/sqlite/sort-by-number-of-json-intersections https://til.simonwillison.net/sqlite/sort-by-number-of-json-...
- https://til.simonwillison.net/sqlite/function-list#user-content-a-better-solution-using-json_group_array-and-json_each https://til.simonwillison.net/sqlite/function-list#user-cont...