4 ms·
Generated columns · Cloudflare D1 docs
- NicoJuicy 3y agoThought the following was interesting to know: > Generated columns are virtual columns based on properties within raw json objects. > Indexes over these properties (dramatically) increases performance of queries. From their dev pages about querying json on https://developers.cloudflare.com/d1/learning/querying-json https://developers.cloudflare.com/d1/learning/querying-json > D1’s support for generated columns allows you to create dynamic columns that are generated based on the values of other columns, including extracted or calculated values of JSON data. > These columns can be queried like any other column, and can have indexes defined on them. If you have JSON data that you frequently query and filter over, creating a generated column and an index can dramatically improve query performance.