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

CDCloudflare Developers

•Created by kelbs on 3/10/2024 in #general-help

block malicious probing requests

is the ends_with functionality also only available on paid plans? Doesn't seem to be an option for me

7 replies

CDCloudflare Developers

•Created by kelbs on 3/10/2024 in #general-help

block malicious probing requests

I'm currently on the free plan so I could upgrade to pro to enable more managed rules, but its unclear to me if that'll solve the issue.

yeah, not on paid plan but have been considering it. Only reason I haven't pulled trigger is I wasn't sure if it would help or not. Thank you for the ideas! I'll use these and see if there are more commonalities across the requests for easy blocking

7 replies

CDCloudflare Developers

•Created by kelbs on 3/9/2024 in #workers-help

Cloudflare workers vs pages

Briefly looking through the pages functions docs and it mentions a /functions folder. I'm guessing sveltekit's build output creates this? Otherwise it would break the framework's model (file-based routing where each page has its own load function for db/api calls/etc)

8 replies

CDCloudflare Developers

•Created by kelbs on 3/9/2024 in #workers-help

Cloudflare workers vs pages

If I have a full stack sveltekit site and host it on pages, do the backend things automatically get run in workers/functions?

8 replies

CDCloudflare Developers

•Created by Pierre 🪴 on 9/15/2023 in #workers-help

Cloudflare pages vs workers

@Cyb3r-Jok3 so it sounds like if you're building an API only, you can use workers. But if you're building a full stack app (that'll serve static assets like the js bundle and css), you need to use pages? Are there any sources I can read about this distinction? Because this was also confusing to me

6 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

•Created by kelbs on 4/2/2023 in #help

drizzle bug won't let me update mysql table

will be a bit before I can try

12 replies

Gaming

Programming