It might have been a very relaxing weekend if [@bert_hubert](

bert hubert 🇺🇦🇪🇺🇺🇦 (@bert_hubert@fosstodon.org)

8.05K Posts, 1.12K Following, 941 Followers · Software developer, entrepreneur, former government regulator, current government advisor, amateur s...

) hadn’t said ‘sqlite’ earlier today… ;) I’ve had a bee in my bonnet for a week, and this might be a solution. SQLite3 really is very fast. Here a query of a JSON element on 290k records in a table of 1.2 million records. Edit: of course: SELECT DISTINCT(js->>'desc') AS place FROM rec WHERE user = 'jpm' AND place LIKE 'r%'; — I added place later and forgot to adapt