How can I make the user ID an auto-incrementing integer?

I have already seen the github issue related to this topic, but no information on how to actually do this and still get type safety is explained. I have already disabled generating ids in my config, but how can I get it to show up as a number and not a string? Here's my config (using nextjs):

export const auth = betterAuth({
  database: drizzleAdapter(db, { provider: "pg" }),
  emailAndPassword: {
    enabled: true,
  },
  plugins: [nextCookies()],
  advanced: {
    generateId: false,
  },
});

export const auth = betterAuth({
  database: drizzleAdapter(db, { provider: "pg" }),
  emailAndPassword: {
    enabled: true,
  },
  plugins: [nextCookies()],
  advanced: {
    generateId: false,
  },
});

export const auth = betterAuth({
  database: drizzleAdapter(db, { provider: "pg" }),
  emailAndPassword: {
    enabled: true,
  },
  plugins: [nextCookies()],
  advanced: {
    generateId: false,
  },
});

export const auth = betterAuth({
  database: drizzleAdapter(db, { provider: "pg" }),
  emailAndPassword: {
    enabled: true,
  },
  plugins: [nextCookies()],
  advanced: {
    generateId: false,
  },
});

marcusOP•12/22/24, 8:26 PM

Update: i ended up doing this at the moment, works for passing the User as props to a function, but the main functions aren't typed correctley still

type DefaultUser = typeof auth.$Infer.Session.user;
export interface User extends Omit<DefaultUser, "id"> {
  id: number;
}

type DefaultUser = typeof auth.$Infer.Session.user;
export interface User extends Omit<DefaultUser, "id"> {
  id: number;
}

Mmarcus Update: i ended up doing this at the moment, works for passing the User as props...

bekacru•12/23/24, 6:14 AM

feel free to open an issue on gh

Bbekacru feel free to open an issue on gh

marcusOP•12/23/24, 11:02 AM

Ok i will thank you

marcusOP•2/24/25, 1:07 PM

Still having this issue, no solution on github

marcusOP•2/24/25, 1:11 PM

https://github.com/better-auth/better-auth/issues/998

GitHub

How can I make the user ID an auto-incrementing integer? · Issue #9...

Is this suited for github? Yes, this is suited for github To Reproduce Create a new nextjs app (create-next-app) Install drizzle-orm Install and setup better-auth using email & password, but ch...