kelbs Comments - Answer Overflow

kelbs

Explore posts from servers

CDCloudflare Developers KKysely DTDrizzle Team

Posts Comments

DTDrizzle Team

•Created by nEEk on 8/30/2023 in #help

How can I create a virtual table with sqlite?

+1, would also like to do FTS with Turso

13 replies

DTDrizzle Team

•Created by Jumaron on 8/9/2023 in #help

Planetscale Serverless for Relational queries

Thanks! Did you look at drizzle code to figure it out? In that case I think the docs are a bit misleading

40 replies

DTDrizzle Team

•Created by Jumaron on 8/9/2023 in #help

Planetscale Serverless for Relational queries

I also get this type error when trying to add mode:

typescript: Argument of type '{ schema: typeof schema; mode: string; }' is not assignable to parameter of type 'DrizzleConfig<typeof import("<project>/src/lib/server/schema")>'.
  Object literal may only specify known properties, and 'mode' does not exist in type 'DrizzleConfig<typeof import("<project>/src/lib/server/schema")>'. [2345]

typescript: Argument of type '{ schema: typeof schema; mode: string; }' is not assignable to parameter of type 'DrizzleConfig<typeof import("<project>/src/lib/server/schema")>'.
  Object literal may only specify known properties, and 'mode' does not exist in type 'DrizzleConfig<typeof import("<project>/src/lib/server/schema")>'. [2345]

40 replies

DTDrizzle Team

•Created by Jumaron on 8/9/2023 in #help

Planetscale Serverless for Relational queries

@Angelelz what about the rest of the thread saying its not required to pass mode and works without it? Plus my own testing in local dev using relational queries without it? Seems like the following is true, but the docs don't make it super clear as evidenced by all the confusion in this thread 1. If using planetscale serverless driver, don't need to pass mode 2. If using mysql2 driver, need to pass mode

40 replies

DTDrizzle Team

•Created by Jumaron on 8/9/2023 in #help

Planetscale Serverless for Relational queries

@Angelelz is it still required to pass mode: "planetscale" to drizzle? Based on this page (https://orm.drizzle.team/docs/quick-mysql/planetscale) the planetscale setup code is this:

import { drizzle } from "drizzle-orm/planetscale-serverless";
import { connect } from "@planetscale/database";
 
// create the connection
const connection = connect({
  host: process.env["DATABASE_HOST"],
  username: process.env["DATABASE_USERNAME"],
  password: process.env["DATABASE_PASSWORD"],
});
 
const db = drizzle(connection);

import { drizzle } from "drizzle-orm/planetscale-serverless";
import { connect } from "@planetscale/database";
 
// create the connection
const connection = connect({
  host: process.env["DATABASE_HOST"],
  username: process.env["DATABASE_USERNAME"],
  password: process.env["DATABASE_PASSWORD"],
});
 
const db = drizzle(connection);

40 replies

DTDrizzle Team

•Created by thdxr on 11/10/2023 in #help

Dropping primary keys every time

@thdxr curious if you're using drizzle in prod? If so, do you have workarounds for these drizzle kit issues? I've run into similar issues now and previously that have made me hesitant to switch

70 replies

DTDrizzle Team

•Created by Ravi on 7/12/2023 in #help

Custom column type with default not working?

I think the root issue is that drizzle doesn't support unsigned ints. I'm guessing you wouldn't be creating custom types if unsigned ints were supported

4 replies

DTDrizzle Team

•Created by SneaX on 8/1/2023 in #help

How to make an unsigned bigint column in MySQL

I'm also trying to migrate to drizzle and use lucia. Looks like unsigned ints aren't yet supported which is kinda crazy... but at least its on the roadmap I guess https://github.com/orgs/drizzle-team/projects/1/views/1?pane=issue&itemId=28818707

3 replies

DTDrizzle Team