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

Kawthar

9/10/2024

Type mismatch between tables from schema and drizzle-orm functions

I am getting an error for type mismatch while trying a simple db.delete(table) query:

Argument of type 'PgTableWithColumns<{...columns}, {}, {}>; title: PgColumn<...>; desiredWeeklyFrequency...' is not assignable to parameter of type 'PgTable<TableConfig>'

Argument of type 'PgTableWithColumns<{...columns}, {}, {}>; title: PgColumn<...>; desiredWeeklyFrequency...' is not assignable to parameter of type 'PgTable<TableConfig>'

.How can I fix this? These are the related files:```ts // schema.ts import { createId } from '@paralleldrive/cuid2';...

minhtringuyennn

9/10/2024

Get stuck when setting up Drizzle Kit from existing Supabase project

I have setup some basic config but Drizzle Studio have work for 1 time and now I can't connect it, just loading indefinitely Also when I was using instropect it stuck on fetching columns, enum. Appreciate if someone can assist me on setting up the project...

cosbgn

9/10/2024

Any way to use D1 remote DB (production one) while locally?

On wrangler is enough to add --remote but not sure how it works on drizzle

Grokksmak

9/10/2024

__old_push references

Hi could anyone help me with this annoying problem ive been having for some time, and i havent been able to find a solution for it. I have a sqllite database with turso and im using drizzle-orm for the queries. If i have a empty database, and do the normal drizzle-kit generate -> drizzle-kit migrate -> drizzle-kit push , all my tables are there in turso But whenever i for example add a new field in a table, and run the same flow drizzle-kit generate -> drizzle-kit migrate -> drizzle-kit push , i always get the error no such table: main.__old_push_playlist and i end up having to drop all of my tables. I have done a drizzle-kit pull and there i can see alot of these old_push references, any way i can fix this or remove all references to the old tables?...

bur

9/9/2024

is there any way to get linting for foreign keys?

when i convert a primary key for a table from one type to another, typescript doesn't complain if a foreign key that references it has not changed e.g. converting a column type from an integer id to a uuid...

icomad

9/9/2024

Correct typings for factory table

Hey all, I'm back again with a problem with typings on a factory function for creating tables. I already asked about this months ago but the solution that another user came up with, which was something similar to what I was doing, is not correct and presents some problems. The goal is to make a factory function that creates a table with some default columns, like timestamps, author columns etc... This is the "solution" we found at the time: ```typescript const baseTableSchema = { id: [...],...

AndréLB

9/9/2024

Getting total sales by service

I have the tables orderListing and orders: ```ts const orderListing = = pgTable( 'orderListing',...

CMarker

9/9/2024

Subquery in select, and referencing value from outer query

Hello! I am trying to convert this postgres query from SQL til drizzle syntax. ``` SELECT...

Bholmesdev

9/9/2024

`ilike` in sqlite

We received an issue on the Astro repo recently about ilike support for our SQLite driver. We decided not to expose ilike as a utility, since we noticed it was incompatible with sqlite on the Drizzle docs: https://orm.drizzle.team/docs/operators#ilike That said, it seems strange that ilike is incompatible but notIlike is. Can someone confirm the documentation badge is correct?...

Marcel Overdijk

9/9/2024

creating a join for re-use

Drizzle support creating re-usable where and order by expressions like: gt(customerTable.salary, 5000); desc(customerTable.salary) ...

patryk

9/8/2024

Error: The edge runtime does not support Node.js 'crypto' module.

I dont know what i'm doing wrong during the setup of next auth ```tsx import type { NextAuthConfig } from "next-auth" import Credentials from "next-auth/providers/credentials";...

uzelac

9/8/2024

drizzle.team website down?

Is the site down?

max

9/8/2024

missing columns in typings?

second time ive had this issue now in a different project than the last, no answer on my last post

BaNuni

9/8/2024

Typing `varchar` with a type reference instead of `enum` value

using varchar and enum in the docs: ```ts import { varchar, pgTable } from "drizzle-orm/pg-core"; export const table = pgTable('table', { varchar1: varchar('varchar1'),...

Abdulramon Jemil

9/8/2024

How does Drizzle ORM map PostgreSQL dates with regard to timezones?

Sorry for reposting this as I initially posted it in discussions. So how does Drizzle actually handle dates and timestamps for Postgres. It is mentioned here that drizzle provides string or "mapped dates": https://orm.drizzle.team/learn/latest-releases/drizzle-orm-v0300 What exactly does "mapped dates" mean? When using a timestamp without timezone in postres with drizzle, based on the statements on that page, I assume it converts the passed date object to utc format using .toISOString() and then passes it to postgres. Since it is without timezone, Postgres does no offset adjustment. So what happens when retrieving such fields inside of drizzle when using mode: "date" ? Does drizzle pass the date string retrieved from postgres to new Date() directly? In this case, the date (since it has no timezone information) will be assumed to be in the timezone of the call to new Date(). On the other hand, does Drizzle parse the date string and append the UTC timezone info before passing to new Date() so that new Date() treats the date as UTC?...

megamindat

9/8/2024

Reference Error: Cannot access "..." before initialization

Please help. I'm getting this error: ReferenceError: Cannot access 'defaultAddressSchema' before initialization at Object.defaultAddressSchema (/home/megamindat/Desktop/learning/CCH_backend/src/db/schema/address.ts:1:1) at Object.get [as defaultAddressSchema] (/home/megamindat/Desktop/learning/CCH_backend/src/db/schema/address.ts:14:45)...

Fyzz

9/7/2024

Vector types/querys - Turso/LibSQL Support

Is there support for the vector features of libSQL in drizzle-orm? I can't seem to find it anywhere

ShiNxz

9/7/2024

Migrations wont support my dialect

Hey, for some reason generating migration files create them with just "CREATE TABLE" instead of "CREATE TABLE IF NOT EXISTS". and also it uses words like serial (postgress) instead of int (mysql), any idea?

Kelvin

9/7/2024

Creating migrations while using ES Modules fails with error `Cannot find module '<filename>.js`

Recently I upgraded our CommonJS project to use the modern standard of ES Modules. However, it appears that Drizzle kit either straight up does not support the use of ES Modules, or I have forgotton to add some new configuration after the move. Either way, migrations stopped working after adding the required .js file extension when using ESM explicitly when importing Typescript source files. Any help would be much appreciated as this is a huge show stopper for us. Pretty much this exact issue....

Sun

9/6/2024

How to start with drizzle?

I'm reading docs and there doesn't seem to be any form of "how to get started" section or any installation area. It says a lot why to use it, but not how to use it. And the learn tab also didn't have any project starter. Is there no ways to do something like prisma init, that just starts a simple drizzle configuration or some documentation that gives that information?...

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!