Index products from standard grocery categories into Bonsai
How it works:
Each staple fetches a fixed batch size (Coffee=60, Milk=40, Bread=40, others=30) ordered by product_id ASC. Page 0 = rows 1–60. Page 1 = rows 61–120. And so on — new products always get higher IDs so they're never skipped.
Seeding is sequential (coffee → banana → milk…). Re-seeding the same page upserts — no duplicates.
Set From = To to seed a single page. Set To higher to auto-loop through multiple pages (e.g. 0 → 24 indexes all 1,482 coffee products). The numbers in brackets are products per page per category.
Search & Index by Name
🔎
Index by Product Name
Search CockroachDB by product name keywords and index matching products
Full Product Index
🗄️
Full Index (All Products)
Index every product in the database in batches of 100. Resumes from the last processed ID.
Starting…
Test Search
🔍
Search Bonsai Index
Query the Bonsai index to test relevance and ranking