mikeyseeM
Convex Community3y ago
3 replies
mikeysee

More complex indexes

It would be awesome if at some point Convex could support PostgresJSON-like index's so we could index deeply within objects.

Im thinking something like the following:

defineSchema({
  users: defineTable({
    name: v.string(),
    email: v.string(),
    status: v.union(
      v.object({
        kind: v.literal("not_verified"),
        createdAt: v.number(),
      }),
      v.object({
        kind: v.literal("verified"),
        createdAt: v.number(),
      }),
    ),
  })
    .index("by_status_kind", o => o.status.kind)
});
Was this page helpful?