4 ms·
You can shorten your JSON queries using arrow notation in sqlite. SELECT settings -> '$.languages' languages FROM user_settings WHERE s
by captn3m0 6mo ago
You can shorten your JSON queries using arrow notation in sqlite.
SELECT
settings -> '$.languages' languages
FROM
user_settings
WHERE
settings ->> '$.languages' LIKE '%"en"%';
I use them heavily with my jekyll-sqlite projects. See https://github.com/blr-today/website/blob/main/_config.yml#L82-L86 https://github.com/blr-today/website/blob/main/_config.yml#L... for example.