Mukund Posts - Answer Overflow

Mukund

•Created by Mukund on 3/28/2025 in #support-community

Convex Auth Cookie Token in Tanstack Start

I have a Next.js project with Convex and Convex Auth that stores token and refreshToken in cookies. I created a similar project in Tanstack Start with convex and it stores token and refreshToken in localStorage. I am not very familiar with auth and good practices. So is it OK to store token and refreshToken in localStorage. what are the benefits or drawbacks of localStorage tokens? Also is there any way to store token and refreshToken in cookies?

2 replies

CCConvex Community

•Created by Mukund on 2/15/2025 in #support-community

Autoincrement and unique fields in convex.

This is my drizzle schema:

const admins = createTable("admins", {
  id: int("id").autoincrement().primaryKey(),
  name: varchar("name", { length: 255 }).notNull().unique(),
  username: varchar("username", { length: 12 }).notNull(),
  email: varchar("email", { length: 255 }).notNull(),
  phone: varchar("phone", { length: 15 }).notNull(),
  passwordHash: varchar("password_hash", { length: 255 }).notNull(),

  ...created_updated_at,
}, (t)=>[
    uniqueIndex("username_idx").on(t.username),
    index("email_idx").on(t.email),
    index("phone_idx").on(t.phone),
  ],
);

const admins = createTable("admins", {
  id: int("id").autoincrement().primaryKey(),
  name: varchar("name", { length: 255 }).notNull().unique(),
  username: varchar("username", { length: 12 }).notNull(),
  email: varchar("email", { length: 255 }).notNull(),
  phone: varchar("phone", { length: 15 }).notNull(),
  passwordHash: varchar("password_hash", { length: 255 }).notNull(),

  ...created_updated_at,
}, (t)=>[
    uniqueIndex("username_idx").on(t.username),
    index("email_idx").on(t.email),
    index("phone_idx").on(t.phone),
  ],
);

I created a convex schema like this:

const admin = defineTable({
  name: v.string(),
  username: v.number(),
  email: v.string(),
  phone: v.string(),
  passwordHash: v.string(),
});

const admin = defineTable({
  name: v.string(),
  username: v.number(),
  email: v.string(),
  phone: v.string(),
  passwordHash: v.string(),
});

I want username to be something like this ADMIN00001, ADMIN00002, ADMIN00003, and so on. Currently I have SQL DB and I am using AUTO_INCREMENT field by creating an id field and based on value of id updating the username. How can I do that in convex. Also, I didn't find any way to create unique fields (in my sql schema username is unique) how can I do same here.

3 replies

Gaming

Programming