when running postgres in docker, drizzle cannot connect to it, says database doesnt exist
basically all i did is
./start-database.sh the env updated itself but it says that databse does not exist :/ i checked in docker desktop and the container is runningrecommendation on changing data type of column?
what's the recommended approach here, e.g. changed from text -> double precision and I got this expected error
error: column "time_waiting_for_builds" cannot be cast automatically to type double precision
i'm wondering how to go around these kind of things. would editing the resulting migration sql be an anti pattern? is there a recommended approach to do these things?...TypeError unless column is notNull
gave the following error.
Object literal may only specify known properties, and <column> does not exist in type:
schema.ts:
```ts...
Update returning with some relation
As the title says I am updating an object using this syntax:
```ts
const idToUpdate = "someId";
const newEvent = {...};...
reference fails with Cannot read properties of undefined (reading 'id')
I have a foreign key reference that will not resolve. It seems that the other pgTable is undefined when it tries to resolve. I used madge to check and i have no circular dependencies. Does anyone have a strategy for how to find my error?
Drizzle not creating table
Hello,
Do I need to manually create the tables? I have schema set up but its not creating the tables?...
Best way to insert thousands of records.
Hi, I've a use case where we get thousands of items from an API and I need to insert them into our DB.
Right now my stack is node with nestjs+drizzle+postgres (aurora rds).
As far I know the best option in PG for large inserts is to use
COPY command....using rqb with pgSchema
Trying to use rqb to access table within my "auth" postgres schema, but it seems that rqb hit the public schema
I can access db.query.member even if member is within auth schema, definied with auth.table("member" , ...)
Is there anything I'm missing ? difficult to find infos on how to perform query in this case on the doc...
How to specify types for raw sql statement?
How do I specify the types for a raw sql statement? I have the following code, but I have to override the types to unknown before I can get the types out.
```typescript
interface SQLResults {
numResponses: number;...
refine and createInsertSchema
createInsertSchema accepts and option to further refine the schema
I would like to validate fields against each other like ensuring a completedAt field is date after a startedAt field.
```...Changing postgres timestamp mode (string -> date) isn't reflected in migrations
Hi.
I have my migrations generated and applied from my initial schema.
Now in the schema I changed to
mode: 'date' in multiple timestamp columns (ex: time: timestamp({ withTimezone: true, mode: 'date' }).notNull(),). This was mode: 'string' by default previously.
Now when I run the drizzle-kit generate command, no migrations are generated. I made this change to multiple columns. ...Conditional queries with $dynamic
Is there a way to not execute the query yet within the if statement?
``ts
const countQuery = db
.select({
count: sql<number>count(${recipeTable.id})`.mapWith(Number),...Define a full-text search index using raw SQL concatenation
Hello, I have a
posts schema that looks like this:
```
export const post_schema = pgTable(
'posts',
{...CTE / WITH + alias
Playground: https://drizzle.run/zb932yr9sv2w1nzn916wzvdt
How can i generate the same SQL code (
left join "bar" as cte1)
without``js
sql${cte} as cte1`...Can't find ``all`` option on join
In this example: https://orm.drizzle.team/docs/joins#many-to-one-example
They use a
.all(); at the end to get more than 1 joined element. I'm trying a very similar thing and there is no all function:
```js
let orders = await database...Search on user's fullname
I have a user's table that stores first, middle and last names, I want to create another field named
search that can be automatically calculated from these three fields.
I saw something on the docs about something called full-text search, but I don't think that is is needed for my case, I just to be able to find users based on any part of their name provided.
I am not a postgres expert, so I will appreciate any advice if I am wrong....Drizzle is not working properly and not creating tables
drizzle studio is not working properly and it only take one table it is not accepting the new tables which i am creating
securityInvoker
Hello,
while generating the schema in version
"drizzle-kit": "^0.30.4", the securityInvoker field comes as string while the (documentation)[https://orm.drizzle.team/docs/rls#rls-on-views] says its a bool . Is there a fix for this?...
What's the hash in the __drizzle_migrations table used for?
I was wondering what the hash in the migration table is used for?
I was playing around a bit to see what happens when I did a
drizzle-kit push and manually update the migration table..
It seems to work by just updating the created_at timestamps to the when timestamp in the journal.
Is it safe to do this? What is the hash used for and when could this create problems?...