DT
Drizzle Team•6d ago
Newt

Type Error when Generating Typebox

I'm encountering a type compatibility issue with Drizzle ORM and TypeBox. When using createSchemaFactory from drizzle-typebox with PostgreSQL tables, I'm getting type errors when trying to create schemas. But in Runtime it Works without any Problems, i also Tried to edit my tsconfig to: 
{
  "compilerOptions": {
    "lib": ["ESNext"],
    "module": "ESNext",
    "target": "ESNext",
    "moduleResolution": "bundler",
    "esModuleInterop": true,
    "strict": true,
    "skipLibCheck": true,
    "allowSyntheticDefaultImports": true,
    "noEmit": true,
    "allowImportingTsExtensions": true,
    "noUncheckedIndexedAccess": true,
    "baseUrl": ".",
    "paths": {
      "$server": ["./src/server.ts"],
      "$lib/*": ["./src/lib/*"]
    }
  },
  "include": ["src"]
}
{
  "compilerOptions": {
    "lib": ["ESNext"],
    "module": "ESNext",
    "target": "ESNext",
    "moduleResolution": "bundler",
    "esModuleInterop": true,
    "strict": true,
    "skipLibCheck": true,
    "allowSyntheticDefaultImports": true,
    "noEmit": true,
    "allowImportingTsExtensions": true,
    "noUncheckedIndexedAccess": true,
    "baseUrl": ".",
    "paths": {
      "$server": ["./src/server.ts"],
      "$lib/*": ["./src/lib/*"]
    }
  },
  "include": ["src"]
}
Versions: 
"drizzle-orm": "^0.41.0",
"drizzle-typebox": "^0.3.1",
"drizzle-orm": "^0.41.0",
"drizzle-typebox": "^0.3.1",
The error suggests that the PostgreSQL-specific column types (PgColumn) from my table definition aren't compatible with the generic Column type expected by the schema factory functions: 
Argument of type 'PgTableWithColumns<...>' is not assignable to parameter 
of type 'Table<...>'. The types of '_.config.columns' are incompatible...
Argument of type 'PgTableWithColumns<...>' is not assignable to parameter 
of type 'Table<...>'. The types of '_.config.columns' are incompatible...
Has anyone encountered similar type mismatches when using PostgreSQL-specific types with the schema factory? Is there a proper way to handle this without type assertions?
7 Replies
Newt
NewtOP•6d ago
My Code: Code: 
import { table } from "$lib/db/schema.ts";
import { createSchemaFactory } from "drizzle-typebox";
import { t } from "elysia";

const { createInsertSchema, createSelectSchema, createUpdateSchema } = createSchemaFactory({ typeboxInstance: t });

const Content = t.Object({
  text: t.String(),
  data: t.String(),
});

const MessageExample = t.Object({
  user: t.String(),
  content: Content,
});

export const AgentSchema = {
  //The Error Apears here:
  insert: createInsertSchema(table.agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
  //The Error Apears here:
  select: createSelectSchema(table.agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
  //The Error Apears here:
  update: createUpdateSchema(table.agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
} as const;
import { table } from "$lib/db/schema.ts";
import { createSchemaFactory } from "drizzle-typebox";
import { t } from "elysia";

const { createInsertSchema, createSelectSchema, createUpdateSchema } = createSchemaFactory({ typeboxInstance: t });

const Content = t.Object({
  text: t.String(),
  data: t.String(),
});

const MessageExample = t.Object({
  user: t.String(),
  content: Content,
});

export const AgentSchema = {
  //The Error Apears here:
  insert: createInsertSchema(table.agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
  //The Error Apears here:
  select: createSelectSchema(table.agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
  //The Error Apears here:
  update: createUpdateSchema(table.agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
} as const;
table: 
export const agent = pgTable(
  "agents",
  {
    id: uuid("id").primaryKey().defaultRandom(),
    enabled: boolean("enabled").default(true).notNull(),
    // Character
    name: text("name").notNull(),
    username: text("username"),
    system: text("system"),
    bio: jsonb("bio").$type<string | string[]>().notNull(),
    messageExamples: jsonb("message_examples")
      .$type<MessageExample[][]>()
      .default(sql`'[]'::jsonb`),
    topics: jsonb("topics")
      .$type<string[]>()
      .default(sql`'[]'::jsonb`),
    adjectives: jsonb("adjectives")
      .$type<string[]>()
      .default(sql`'[]'::jsonb`),
    settings: jsonb("settings")
      .$type<{
        secrets?: { [key: string]: string | boolean | number };
        [key: string]: unknown;
      }>()
      .default(sql`'{}'::jsonb`),
    style: jsonb("style")
      .$type<{
        all?: string[];
        chat?: string[];
      }>()
      .default(sql`'{}'::jsonb`),
    createdAt: timestamp("created_at", { withTimezone: true, mode: "date" }).defaultNow().notNull(),
  },
  (table) => [unique("name_unique").on(table.name)],
);
export const agent = pgTable(
  "agents",
  {
    id: uuid("id").primaryKey().defaultRandom(),
    enabled: boolean("enabled").default(true).notNull(),
    // Character
    name: text("name").notNull(),
    username: text("username"),
    system: text("system"),
    bio: jsonb("bio").$type<string | string[]>().notNull(),
    messageExamples: jsonb("message_examples")
      .$type<MessageExample[][]>()
      .default(sql`'[]'::jsonb`),
    topics: jsonb("topics")
      .$type<string[]>()
      .default(sql`'[]'::jsonb`),
    adjectives: jsonb("adjectives")
      .$type<string[]>()
      .default(sql`'[]'::jsonb`),
    settings: jsonb("settings")
      .$type<{
        secrets?: { [key: string]: string | boolean | number };
        [key: string]: unknown;
      }>()
      .default(sql`'{}'::jsonb`),
    style: jsonb("style")
      .$type<{
        all?: string[];
        chat?: string[];
      }>()
      .default(sql`'{}'::jsonb`),
    createdAt: timestamp("created_at", { withTimezone: true, mode: "date" }).defaultNow().notNull(),
  },
  (table) => [unique("name_unique").on(table.name)],
);
TOSL
TOSL•6d ago
What is table.agent is it returning a pgTable type? Not sure I'm reading this right but it looks like you should be importing agent and using it 
export const AgentSchema = {
  //The Error Apears here:
  insert: createInsertSchema(agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
export const AgentSchema = {
  //The Error Apears here:
  insert: createInsertSchema(agent, {
    messageExamples: t.Array(t.Array(MessageExample)),
  }),
Newt
NewtOP•6d ago
export const agent = pgTable("agents", {
  id: text("id").primaryKey().$defaultFn(ulid),
  //...other columns
});

export const table = {
  agent,
  //...other tables
} as const;
export const agent = pgTable("agents", {
  id: text("id").primaryKey().$defaultFn(ulid),
  //...other columns
});

export const table = {
  agent,
  //...other tables
} as const;
this is my export ^^
TOSL
TOSL•6d ago
Okay so it should be a pgTable. Just for the sake of elimination can you try passing the agent table directly.
Newt
NewtOP•6d ago
Nope, still, but here is the FULL error: https://pastebin.com/CFYsN01P
Pastebin
No overload matches this call. Overload 1 of 2, '(table: Table
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
TOSL
TOSL•6d ago
So do you also think it's your jsonb columns? I don't know how you'd fix this without typecasting or simplifying the type somehow
Newt
NewtOP•6d ago
the thing is, in Runtime it works without problems, i just get Runtime Errors, i also tried the Examples and i also get Compile Errors there: https://orm.drizzle.team/docs/typebox#select-schema Also Tried to Update my TS Config like described here: https://discord.com/channels/1043890932593987624/1318443104927223818
Drizzle ORM - drizzle-typebox
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Did you find this page helpful?