Drizzle Team Community - Answer Overflow

5/7/2023

Migration failure on fresh DB

I'm currently experiencing a migration failure on a fresh Postgres DB with both postgres.js and node-postgres. It's complaining that an enum I have defined in my schema (which should have created already as it's in the generated migration) does not exist. ⌛ Running Migrations ❌ Migration Failed...

joostschuur

5/6/2023

Using Vercel Postgres and developing locally

To confirm, if I want to use Vercel Postgres in production and a local Postgres DB for development, is the best way to just conditionally import


                      drizzle

(and other platform specific stuff like

sql

) from


                      drizzle-orm/vercel-postgres

or


                      drizzle-orm/node-postgres

based on


                      NODE_ENV

? I see the sample Next.js project has been updated for Vercel Postgres: https://github.com/vercel/examples/blob/main/storage/postgres-drizzle/lib/drizzle.ts ...

volks

5/6/2023

Custom Type interpreted as String

Hello everyone, I am having some issues with getting Drizzle to work with PostGIS, I am trying to have support for PostGIS's Point geometry. This is what I have setup ```typescript export type Point = { longitude: number;...

andreterron

5/5/2023

Can I use queryBuilder for inserts?

My scenario is that I want to read some rows from a database (prod), and generate a SQL file that we'd use to populate a local DB. I wanted to use


                      queryBuilder

( https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/pg-core/README.md#query-builder ) since I wouldn't need to connect to a DB to generate the SQL queries, but seems like


                      queryBuilder

only supports


                      select()

at the moment. Do I need to connect to a local DB if I want to generate


                      insert()

queries?

tmcw

5/5/2023

I ran introspect:pg to initialize my schema, then created a new migration. How should I deploy this?

The remote database, right now, doesn't have the


                      drizzle.__drizzle_migrations

table. It'd be nice to have a way to know that the old migrations - the ones that were generated by introspect:pg and just reflect the existing state of the database - won't run. Is this the right way to look at it? Thanks!

Alex.dev

5/5/2023

Transaction rollback

Hello guys. Kind of dumb question but should I cover body of transaction in try/catch and call rollback explicitly? Here is an example. What will happen some query throws an error in transaction callback? ```sessionId = await db.transaction(async (tx) => { const [{insertedSessionId}] = await tx .insert(session)...

ben-san

5/5/2023

error creating relationship

I'm having trouble creating a relationship in MySQL using drizzle-orm, I'm running


                      npx drizzle-kit push:mysql

but the I'm trying running the code inside my MySQL database but I'm getting this error


                      Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'anime_user_id_users_id_fk' are incompatible.

here is the schema and the generated SQL migration code. ```javascript export const users = mysqlTable( "users",...

tomspoint

5/5/2023

define default value for array

I work with a PostgreSQL database. Here is my Schema: export const user = pgTable( 'auth_user',...

warflash

5/5/2023

TS query types dont match + no return types

I'm trying to query data from my db after importing the Item table from my schema.


                      const data = await db.select().from(Item)

As you can see in the screenshot and the error message below typescript seems to have trouble with that.


                      Item

table definition is being imported from another typescript project within the repo which might have to do with it? ...

naethan

5/4/2023

Can't generate migrations because of top level await

This only recently started happening.Here is my


                      drizzle.config.json

:
```{ "out": "./migrations", "schema": "./src/* / .sql.ts" }...

GabrielC

5/4/2023

Error types with custom schema

Hi, I'm trying to do a general function to paginate my querys, but I'm having some problems with the types. I'm trying to use the types of the library, but I'm not sure if I'm doing it right. All my tables have the same columns, so I created a function to create the base table, and I'm trying to use it to create the pagination function, and definitly i'm doing it wrong but I'm not shure how to do it, could you point me in the right direction? to know if it's possible to do it. ...

anthonyshew

5/4/2023

Trying to write next-auth adapter

blahblahblahrober AKA @Dan Kochetov helped me get most of the way to having a next-auth adapter done but, in the couple weeks I waited for a review, I came back and now the SQLite migration is betraying me. See video. Starting from a clean slate, it's saying


                      nothing to migrate

and, when I run tests against my


                      db.sqlite

, I get back errors for


                      no tables, kiddo

. Pretty confused; seems like I'm not pushing any schema somehow? Pull request if you want to look at code: https://github.com/nextauthjs/next-auth/pull/7165 ...

backo

5/3/2023

Been getting this error while using the libsql client. The code works though. Any ideas. Thanks! 🙂

I get the error from the screenshot every time I access my db client, but the code works fine though. How can I get rid of the error? 🙂

McLean 25

5/3/2023

Select wildcard

I'm sure someone's asked this before but I can't find it. Is there not a way to do a


                      .select()

wildcard so that I can do something like: ```ts db.select((defaultFields) => ({...

macvim

5/3/2023

RangeError: Maximum call stack size exceeded - When I try to INSERT

Hi, I am getting


                      RangeError: Maximum call stack size exceeded

when I try to INSERT something in the DB, SELECT queries works with no issues. I am using


                      "drizzle-orm": "^0.25.3"

and


                      "@remix-run/react": "^1.15.0"

....

warflash

5/3/2023

Tables are not being generated

Hey 👋 I'm probably missing something obvious but with the setup I have (shown in the image) drizzle doesnt seem to apply the things inside the migration folder. It does generate the drizzle schema in the db + the __drizzle_migrations table so something is running for sure, but it doesnt seem to pick up on the migrations I did. Appreciate the help!...

Tharaka

5/1/2023

Inserting records into related tables

I have a few of tables that are related. I just need to know if there's a better approach when inserting records into these. I'm using PlanetScale so no FK constraints. Here's my approach. export const product = mysqlTable('product', {

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Gaming

Programming

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!