I am testing Drizzle as an alternative to Prisma (which is our current implementation). Thanks to Drizzle's query composability it fits with some of the stuff we want to do much better.
During the process of setting up Drizzle, something is going wrong.
Looking through the docs (https://orm.drizzle.team/docs/rqb) and trying to replicate the setup is failing with a typescript error (which prevents me from accessing the
query
query
interface.
This is my current initialization:
export const db = drizzle(connection, {schema});
export const db = drizzle(connection, {schema});
schema
schema
is imported as per the documentation:
import { drizzle } from "drizzle-orm/mysql2";import mysql from "mysql2/promise";import * as schema from "./schema";
import { drizzle } from "drizzle-orm/mysql2";import mysql from "mysql2/promise";import * as schema from "./schema";
And the schema file being referenced is generated via introspection from
drizzle-kit
drizzle-kit
.
The typescript error that comes out of it is odd:
Type 'typeof import(".../db/schema")' is not assignable to type 'Record<string, never>'.
Type 'typeof import(".../db/schema")' is not assignable to type 'Record<string, never>'.
I've looked through the types, I'm not 100% sure how to correct it. As far as I can tell it's matching the documentation for