Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
number[]
, bigint[]
, string[]
) that contains only one element into sql``
, it will be transformed into their non-list type (ex. number
, bigint
, string
respectively).
When I put two elements in, it then turns into a Postgres record, which is not what I want. What I expect is that the array stays an array.
...TypeError: client.unsafe is not a function

error when trying to run drizzle-kit push:pg
What is the purpose of the _meta directory?
_meta
directory does. Currently this part of the migration workflow is undocumented leaving several questions unanswered. Initially I tried to inspect the code myself and find out what it is used alas the source code of drizzle-kit is still not available (https://github.com/drizzle-team/drizzle-orm/issues/580).
Currently I wonder if it has to be checked in to git, and under what circumstances it is required to read from as well as write to this directory. This would influence how drizzle migrations can/will be deployed on production: Does it have to be part of the deployed code, can it be non-existent, is it only needed for ephemeral data or does it have to persist data (i.e. in docker this would have to be a mounted volume), is it sufficient to only read from there (i.e. in docker this would allow increased security by marking the filesystem as readonly) etc...
https://github.com/drizzle-team/drizzle-kit-mirror/issues/196...`tablesFilter` cli arg "unknown option"
--tablesFilter Table name filters
--tablesFilter Table name filters
[BUG] Multi schema tables with same name
many-to-may relation
Responses are coming back with Capitalized table names
TypeError: Seems like the schema generic is missing - did you forget to add it to your DB type?
db.query.users
in my code below?
```bash
Property 'users' does not exist on type 'DrizzleTypeError<"Seems like the schema generic is missing - did you forget to add it to your DB type?"> | { [x: string]:RelationalQueryBuilder<ExtractTablesWithRelations<any>, { ...; }>; }'.
Property 'users' does not exist on type 'DrizzleTypeError<"Seems like the schema generic is missing - did you forget to add it to your DB type?">'.ts(2339)...Can I create tables at runtime?
Execute is not exist on a type LibSQLDatabase
Transactions, PgBouncer/Supavisor, prepared statements
prepared statement 'name' does not exist
which was very hard to debug.
still don't fully understand why transaction won't work i've tried everything i could find setting params binary_parameters=yes
(not even sure what this does, resetting database server (supabase). using a direct connection worked but wasn't something i could do forever.
so my fix was.... just remove transactions from my endpoints (which sucks but it is what it is) ...Simple ForeignKey With statement not working
totalCount from relational query
undefined
values)
I thought maybe I could utilize CTEs here but then how would I get the benefit of relational queries?...Cannot read properties of undefined (reading \'columns\')
Findfirst and Findmany config

Trouble running JEST testing in Hono for Cloudfare Workers