TypeError: Cannot read properties of undefined (reading 'columns')
Hi, is there any way to fix this error?
I get it after going through the
drizzle-kit generate wizard.
```
TypeError: Cannot read properties of undefined (reading 'columns')...Best approach for data migration: moving data from two columns to JSONB
Hi Drizzle community! š
I'm working on a schema migration where I need to:
1. Move data from two existing string columns (
old_col1, old_col2) into a new JSONB column (new_jsonb_col)
2. Drop the old columns...Error please install required packages: 'drizzle-orm'
I'm getting this error when trying to run drizzle-kit push in my monorepo workspaces (npm & turborepo)
I setup everything correctly as it can run on another project but failed on this.
drizzle-kit 0.31.4...
Quick question about your Docs āAsk AIā (Inkeep) implementation
Hi Drizzle team,
I tried the āAsk AIā feature in your docs and found it genuinely usefulāgreat work.
Weāre currently evaluating Drizzle ORM (migrating from SQLA) and are interested in how you integrated the Ask AI experience (I understand itās powered by Inkeep). Would you be open to sharing a high-level overview or any public resources? In particular, Iām curious about:
How you index docs and keep them fresh
Any custom prompts/guardrails you use...
Deleted entries in __drizzle_migrations table.
Hey. I am atm migrating away from supabase js to drizzle. I am playing locally. I had to reset the database and it kept the migrations table somehow but deleted the entries (probably some seed file).
Now the migration push tries to reapply the initial migration, which includes all the table creations etc.
Is there a way to insert this single migration? ...
How to use drizzle orm with Cloudflare agents integrated sqlite db?
I was trying to use drizzle for agents, but I couldn't find a way to make it work.
Open-telemetry
is there some open-telemetry instrumentation for drizzle? which gives the traces for Postgres calls, etc, and possibly metrics for query processing time etc?
drizzle-zod returning BuildSchema instaed of zod schema
Im trying to create zod schema from drizzle schema, but this is returning an buildschema, that dosenĀ“t seam right. What im doing wrong?
how to properly auto migrate db in prod
so i have set up some automations to auto deploy my application that uses drizzle but i dont know what is the correct way to make it migrate. Like when i should do it
Non-interactive abort on data loss push
Hello, I am huge fan of
drizzle-kit push but I struggle to find the best way to integrate it to into CI.
I was first thinking of using --strict and --verbose to sort of get what I want, but now if any dev forgets to push on their own machine, the CI machine just hangs at the interactive prompts.
I am essentially wanting a non-interactive drizzle-kit push that will abort on data loss....Parameterization from string and array of values
I have a sql string with placeholders and an array of values for those placeholders. How can I have drizzle parameterize and execute it?
for context I'm trying to have pg-boss use the same session as my drizzle transaction. pg-boss generates strings and arrays of values, but I can't find anything to render the sql in the api.
I am using node-postgres.
...
json column returning as string
Hello, i'm having some trouble querying from a table that has a text column with mode set to JSON. The data is returning as a stringified json, is this the expected behavior?
I'm using the better-sqlite3 driver btw....
Drizzle ORM HTTP SQlite proxy does not work with JSON mode text
Hey, another issue: The drizzle http proxy for sqlite always throws a tantrum when it encounters any column with json text. Here is the error:
```log
iscord API Error: SyntaxError: "undefined" is not valid JSON
at JSON.parse (<anonymous>)...
returning insert values undefined with drizzle http sqlite proxy
Hey, I just ran into an issue while using
drizzle-orm/sqlite-proxy when used with the returning() statement.
This is what my db client looks like: `
```ts...How to add self-signed certificate for studio gateway?
AWS RDS uses self-signed certificate, currently there is no way on studio gateway to disable the check or add custom certificate.
TypeScript and Runtime Error when using string constants in relations references array
Hello!
I'm trying to define a relation where one table can reference multiple different tables based on a type (literal) field, but I'm encountering both TypeScript and runtime errors when trying to use string constants in the references array....
Chat am I cooked?
```log
dog@dog MINGW64 ~/Documents/GitHub/www.airnode.nl (main)
$ bun run db:studio
$ drizzle-kit studio
No config path provided, using default 'drizzle.config.ts'...
Reset migrations for production
Hello!
During development I have been using migrations to sync changes to our staging environment. Before going live on production I messed up and forgot to reset all migrations and start from scratch. What we have now is a mess with 38 migration files. I have manually made edits in some of the migrations files (I know..) and staging won't accept migrations due to conflicts. I have been forcing changes with push for some time.
Now we have our prod live since a week with not much, but some data that I want to keep. Before it goes too far I want a clean slate on migrations with the current state as a baseline.
...
query array
Hi everyone, can I query an array of strings (inserting, removing, searching) for elements?