Drizzle Team

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

Join

Drizzle Team

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

Join

jsingleton37

12/12/2024

Column of relation already exists

I have a couple of tables ```tsx export const schoolReferences = pgTable( 'school_references',...

SKUZZIE

12/11/2024

Select without from?

Is there currently a way to use a select without from, or a raw sql query as a subquery? Basically, I need to do the example from this issue: https://github.com/drizzle-team/drizzle-orm/issues/372...

Didine

12/11/2024

How to add schemas to the DB object when using URL for DB connection

I'm using a URL to connect to my database and I cannot figure out the syntax for adding schemas to the DB instance This is how my config looks ``` import { drizzle, } from "drizzle-orm/mysql2"; import * as schmea from "../drizzle/schema.ts";...

Fedox

12/11/2024

_meta Directory purpose

I'm having trouble with understanding what is _meta directory and how I should approach it. What is it's purpose? Should I check it into the repository? What is the purpose of snapshots? Is there any way to rollback a migration?...

Guilherme Fialho

12/11/2024

Drizzle Graphql with graphql codegen for apollo in the frontend

Is there any wait to get all the ".graphql" queries and mutations auto generated for inputing on graphql codegen for frontend typescript? I mean, i want to get all queries and mutations already generated by drizzle graphql schema, in the graphql codegen for react/next. There is anyone can help with it please?...

Melihsub

12/10/2024

d1-http explanation

I stumbled accross the https://orm.drizzle.team/docs/guides/d1-http-with-drizzle-kit driver. I could not figure out how to use it, in terms of how to retrieve data. After setting it up how can i access the client?

bimsina

12/10/2024

Reconstruct Queries from toSQL() data

Hey everyone, I have an interesting use case. I'm trying to figure out if there's a way to reconstruct/run a query from a Query object obtained via query.toSQL(). Something like: ``` ts const query = db.select().from(usersTable).limit(1); const sql: Query = query.toSQL();...

SanquiAlt

12/10/2024

[Solved] Running drizzle-kit push in CI to set up a database

Hello, I'm trying to run drizzle-kit push in a CI pipeline to prop up a database for testing. However, the process gets stuck on "Warning You are about to execute current statements". Obviously there is no tty and no user to answer yes. I checked drizzle-kit push --help and didn't find any --yes or --ci arguments to skip this check. What's the recommended way to proceed here?

Нарбек

12/10/2024

Not getting a typescript error for insert

```typescript import { db } from "./db"; import {users} from "./schema"; // gives no error, but it should ??...

roze789

12/10/2024

How to apply "where OR condition" and "lt or gt condition" on timestamp fields

Hello, i woud like to apply 2 conditions: - OR condition - if basketItem invoicedOn is newer than basketItem InvoicedOn with 1 hour added to it...

Jam

12/10/2024

SQLITE deprecation warning

Anyone knows why am I getting this warning ? "drizzle-orm": "^0.38.0" "drizzle-kit": "^0.30.0",...

Tim

12/9/2024

pgEnums error in studio drizzle runner

Anyone have any ideas why my enums are like this in studio? It technically sends and works just fine just gives an error about the enum value being wrong. Only in studio not orm

browntiger

12/9/2024

Drizzle ORM issues

Running into weird issue with ORM where Query: select "id", "name", "email", "emailVerified", "image", "password", "role", "isNewUser", "invalidlogin_attempts", "lockedAt", "isTwoFactorEnabled", "created_at", "updated_at" from "dds_users" "users" where "users"."email" = $1 limit $2 -- params: ["[email protected]", 1] ⨯ TypeError: value.toISOString is not a function at PgTimestamp.mapToDriverValue (C:\MyFiles\Saas\next-progress-saas.next\server\chunks\ssr\5f296_drizzle-orm_pg-core_f7448a..js:1958:22)...

Eduard Dyckman

12/9/2024

Primary key is not applied

Drizzle doesn't generate a primary key statement in the migration. Here is the schema: ``` export const usersTable = pgTable( "users", {...

Kevin Wolf

12/9/2024

Challenges with Drizzle Kit Workflow Using a Single Database for Development and Production

I'm currently employing a single database for both development and production environments, as my project hasn't gone live yet. My workflow is as follows: 1. Develop locally, modifying the schema and executing drizzle-kit push to apply changes directly. 2. Once satisfied with the database structure, run drizzle-kit generate to create migration files. 3. On the remote environment, execute drizzle-kit migrate to apply pending migrations....

yehtet804

12/9/2024

How to run drizzle studio in a docker container?

Hi,is there any way to run drizzle studio in an container or change the url from https://local.drizzle.studio?port=3333&host=localhost to something like localhost:3333?

cosbgn

12/9/2024

D1 Remote in localhost?

Has anyone figured out how to connect to the production d1 DB in localhost? in wrangler is enough to add --remote

WGW ☂ calldata.space

12/8/2024

Drizzle GraphQL bug with SQLite JSON (Turso)

Hey, just found that it doesn't "decode/extract" the JSON when we have text({ mode: 'json' }).$type<{ [key: 0x${string}]: number }>().default({}) I'm using GraphQL Yoga to check the seeded data, and it shows that column as plain string, not extracted json. Probably bug in your graphql resolvers. Or this is intentional? I don't see why would it tho....

Olshansky

12/7/2024

onedollarstats not showing any stats (olshansky.info)

I added support for onedollarstats in the hugo theme I use [1]. I confirmed that the deployment has the script (see screenshot). I waited a week (just in case aggregation took time) and it's still showing 0 stats....

Kenedy Olisi

12/7/2024

Urgent help with drizzle-kit commands

Hello Devs! I have a project using pnpm. I have added drizzle-orm v^0.37.0 as dep and drizzle-kit v^0.29.1 as devDep. and a drizzle.config.ts at the root folder but when I run pnpm drizzle-kit generate or other commands like push or migrate, it exits with code 1 with message: "This version of drizzle-kit requires newer version of drizzle-orm Please update drizzle-orm package to the latest version 👍". I don't understand what seems to be the issue here yet both drizzle packages are latest versions....

Previous Next

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!