1 reply

Set up drizzle config db url

Dependencies:
"drizzle-orm": "^0.31.2"
"drizzle-kit": "^0.22.7"
"@planetscale/database": "^1.18.0"

Setting up the configuration for this database has not been as straight forward as expected.

I have a new db called findasetter_v2 under findasetter planet scale organisation. Drizzle config looks like:

import { type Config } from 'drizzle-kit'

import { env } from '~/env'

export default {
  schema: './src/server/db/schema.ts',
  dialect: 'mysql',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  tablesFilter: ['findasetter_v2_*'],
} satisfies Config`

import { type Config } from 'drizzle-kit'

import { env } from '~/env'

export default {
  schema: './src/server/db/schema.ts',
  dialect: 'mysql',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  tablesFilter: ['findasetter_v2_*'],
} satisfies Config`

db set up - I've tried two approaches:

import { Client } from '@planetscale/database'
import { drizzle } from 'drizzle-orm/planetscale-serverless'

const client = new Client({
  host: process.env['DATABASE_HOST'],
  username: process.env['DATABASE_USERNAME'],
  password: process.env['DATABASE_PASSWORD'],
})

export const db = drizzle(client)

import { Client } from '@planetscale/database'
import { drizzle } from 'drizzle-orm/planetscale-serverless'

const client = new Client({
  host: process.env['DATABASE_HOST'],
  username: process.env['DATABASE_USERNAME'],
  password: process.env['DATABASE_PASSWORD'],
})

export const db = drizzle(client)

DB url looks like

DATABASE_URL='mysql://USERNAME:PASSWORD@aws.connect.psdb.cloud/findasetter?ssl={"rejectUnauthorized":true}'

DATABASE_URL='mysql://USERNAME:PASSWORD@aws.connect.psdb.cloud/findasetter?ssl={"rejectUnauthorized":true}'

Now when I run any drizzle command i.e. studio or push, there is an error:

Error: VT05003: unknown database 'findasetter' in vschema

Error: VT05003: unknown database 'findasetter' in vschema

Any ideas on how to fix this?

Set up drizzle config db url

import { type Config } from 'drizzle-kit'

import { env } from '~/env'

export default {
  schema: './src/server/db/schema.ts',
  dialect: 'mysql',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  tablesFilter: ['findasetter_v2_*'],
} satisfies Config`

import { type Config } from 'drizzle-kit'

import { env } from '~/env'

export default {
  schema: './src/server/db/schema.ts',
  dialect: 'mysql',
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  tablesFilter: ['findasetter_v2_*'],
} satisfies Config`

db set up - I've tried two approaches:

import { Client } from '@planetscale/database'
import { drizzle } from 'drizzle-orm/planetscale-serverless'

const client = new Client({
  host: process.env['DATABASE_HOST'],
  username: process.env['DATABASE_USERNAME'],
  password: process.env['DATABASE_PASSWORD'],
})

export const db = drizzle(client)

import { Client } from '@planetscale/database'
import { drizzle } from 'drizzle-orm/planetscale-serverless'

const client = new Client({
  host: process.env['DATABASE_HOST'],
  username: process.env['DATABASE_USERNAME'],
  password: process.env['DATABASE_PASSWORD'],
})

export const db = drizzle(client)

DB url looks like

DATABASE_URL='mysql://USERNAME:PASSWORD@aws.connect.psdb.cloud/findasetter?ssl={"rejectUnauthorized":true}'

DATABASE_URL='mysql://USERNAME:PASSWORD@aws.connect.psdb.cloud/findasetter?ssl={"rejectUnauthorized":true}'

Now when I run any drizzle command i.e. studio or push, there is an error:

Error: VT05003: unknown database 'findasetter' in vschema

Error: VT05003: unknown database 'findasetter' in vschema

Any ideas on how to fix this?

Set up drizzle config db url

Similar Threads

Set up drizzle config db url

Similar Threads

Similar Threads

Similar Threads