3 ms·
Modern SQLite: Generated Columns
- marvel_boy 3y agoThanks for this blog "Moder SQL". I am trying to catch up with the last capabilities of sqlite, and man there are a lot of new things !
- rini17 3y agoYou can index the json expression directly, but yes it's convenient. Also the intent was probably to store JSON as BSON blob for faster access, but the example needs to insert jsonb('jsonstring') to achieve that. Rest of the example can stay unchanged. SQLite has exceptionally readable documentation, I recommend just reading whole relevant chapter before using some functions.