tanstack-db

Expert guidance for TanStack DB - the reactive client store for building local-first apps with sub-millisecond queries, optimistic mutations, and real-time sync.

| Collection | Typed set of objects (like a DB table) | | Live Query | Reactive query that updates incrementally | | Optimistic Mutation | Instant local write, synced in background | | Sync Engine | Real-time data sync (Electric, RxDB, PowerSync) |

| eq(a, b) | Equal | | gt(a, b) | Greater than | | gte(a, b) | Greater than or equal | | lt(a, b) | Less than | | lte(a, b) | Less than or equal | | like(a, pattern) | Case-sensitive match | | ilike(a, pattern) | Case-insensitive match | | inArray(a, arr) | Value in array | | isNull(a) | Is null | | isUndefined(a) | Is undefined |