ethan Comments - Answer Overflow

Topics

ethan

•Created by ethan on 3/18/2024 in #help

unable to use migrations

step 4 is where im stuck at

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

https://orm.drizzle.team/learn/migrate/migrate-from-prisma

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

1s

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

im honestly just following this tutorial

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

gotcha

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

im using supabase

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

yeah but im not hosting the db locally

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

connection string should be right drizzle is working fine for CRUD

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

and my friend is also getting the error on his end

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

yep ive tried deleting the whole project and recloning

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

No description

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

No description

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

No description

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

No description

34 replies

•Created by ethan on 3/18/2024 in #help

unable to use migrations

No description

34 replies

•Created by ethan on 3/8/2024 in #help

having issues with querying db

ohh gotcha my mistake. thanks for catching that

15 replies

•Created by ethan on 3/8/2024 in #help

having issues with querying db

oh hey i think i solved the issue... im using supabase and have connection pooling enabled. if you have connection pooling enabled on supabase you have to turn prepare off so something like this will work:

import { drizzle } from "drizzle-orm/postgres-js";
import * as schema from "./schema";
import postgres from "postgres";

const client = postgres(process.env.DATABASE_URL!, { prepare: false });

export const db = drizzle(client, { schema });

import { drizzle } from "drizzle-orm/postgres-js";
import * as schema from "./schema";
import postgres from "postgres";

const client = postgres(process.env.DATABASE_URL!, { prepare: false });

export const db = drizzle(client, { schema });

figured id put the solution here in case anyone else was facing this issue 🙂 thanks for the help

15 replies

•Created by ethan on 3/8/2024 in #help

having issues with querying db

none of my other queries work either like getting a user by id so i figured it would be a bigger overarching issue with the config, schema, or the way im instantiating db or something like that

15 replies

•Created by ethan on 3/8/2024 in #help

having issues with querying db

oh no i just have redis in the function to check if theres any cached data to pull. if no redis data is found itll query the db which is where the function is halting

15 replies