Failed to find required executable \"crontab\" in paths: /sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin" Honestly, people. One of these days you're going to make me install cd aren't ya!? * I'm quite aware cd is a shell built-in thanks #linuxdistro

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

Fosstodon

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