Rebasely Beta: data may be purged

examples/storefront Public

SQL · 13 lines · 628 B · at b748afa

-- The search index, in its own D1 database (storefront-search). One row per active product with-- the text shoppers search: its name and description. Everything else about a product is read-- from the storefront database, which stays the source of truth. The index can be emptied and-- rebuilt from the catalog at any time with POST /admin/search/rebuild.---- porter stems English words (aprons matches apron); unicode61 with remove_diacritics 2 lets-- creme match Crème.CREATE VIRTUAL TABLE products_fts USING fts5(  product_id UNINDEXED,  name,  description,  tokenize = 'porter unicode61 remove_diacritics 2');