← Graph

In-memory filtering without a database

question 3 connections

Audience asked whether products had to be pulled into memory to run filters, or if the work could happen as SQL. Answer: all in-memory. Because the Cometeer store runs on Shopify, there is no local database to query. Building a sync layer to mirror products into a database would introduce a new class of failure modes, so the team instead queries Shopify's slow GraphQL endpoints and runs the filter-and-score pipeline in memory.

answer_summary
All in-memory; no local DB because the store is on Shopify, and a sync layer would add new failure modes. Queries hit slow Shopify GraphQL endpoints.
question In-memory filtering without a database
about
Shopify company
Answer explains why there is no local database — the store runs on Shopify.
question In-memory filtering without a database
about
GraphQL tool
Answer notes the in-memory approach uses Shopify's GraphQL endpoints.
question In-memory filtering without a database
asked_at
Asked during the post-talk Q&A.

Provenance