DT
Drizzle TeamA. Perkamentus

Broken typescript in select

Whatever I put inside the select function. it will generate this typescript error: I am using the lastest ts- and drizzle versions.
A. Perkamentus
A. Perkamentus•320d ago
I fixed it, it was because I used a dynamic db connection: 
import { connect } from "@planetscale/database";
import { type DrizzleConfig } from "drizzle-orm";
import { drizzle as mysqlDrizzle } from "drizzle-orm/mysql2";
import { drizzle as planetscaleDrizzle } from "drizzle-orm/planetscale-serverless";
import mysql from "mysql2/promise";

import * as schema from "~/lib/drizzle/schema";
import { env } from "~/env.mjs";

const isDev = env.NODE_ENV === "development";

const mysqlConnection = await mysql.createConnection({
  uri: env.DATABASE_URL,
});

const planetscaleConnection = connect({
  url: env.DATABASE_URL,
});

const config: DrizzleConfig<typeof schema> = {
  schema,
  logger: env.NODE_ENV === "development",
};

export const db = isDev
  ? mysqlDrizzle(mysqlConnection, config)
  : planetscaleDrizzle(planetscaleConnection, config);
import { connect } from "@planetscale/database";
import { type DrizzleConfig } from "drizzle-orm";
import { drizzle as mysqlDrizzle } from "drizzle-orm/mysql2";
import { drizzle as planetscaleDrizzle } from "drizzle-orm/planetscale-serverless";
import mysql from "mysql2/promise";

import * as schema from "~/lib/drizzle/schema";
import { env } from "~/env.mjs";

const isDev = env.NODE_ENV === "development";

const mysqlConnection = await mysql.createConnection({
  uri: env.DATABASE_URL,
});

const planetscaleConnection = connect({
  url: env.DATABASE_URL,
});

const config: DrizzleConfig<typeof schema> = {
  schema,
  logger: env.NODE_ENV === "development",
};

export const db = isDev
  ? mysqlDrizzle(mysqlConnection, config)
  : planetscaleDrizzle(planetscaleConnection, config);
Want results from more Discord servers?
Add your server
More Posts
Why is introspecting creating tables that didn't previously existMore context here: https://github.com/drizzle-team/drizzle-orm/issues/847Passing SQL functions to insertIs there any way to pass a SQL function like `gen_random_uuid()` to the `insert` function, for a speDrizzle-kit database push connection errorWhen trying to run `drizzle-kit push:mysql` to push my schema to Planetscale, I get the following erTypescript error when importing the planetscale-drizzle db instance.my db is hosted on planetscale and im trying to do the setup as explained in the drizzle docs but whMapped column name and relation with the original nameHi, I am taking over an old project and have found an issue, I'm not sure if I should file it as a bHow to properly do foreign keys in schema with PlanetScale?I'm aware that foreign key *constrains* aren't supported, but foreign keys themselves are. push: ``