François
DTDrizzle Team
•Created by uri on 3/4/2025 in #help
How should I refactor my transactions?
https://github.com/vkondratiuk482/propagated-transactions Maybe this approach is more to your liking? It would save you adding a new function parameter but its kind of verbose too. But maybe it suits your more than your current solution (which I would prefer)
3 replies
DTDrizzle Team
•Created by MUG Knight on 2/25/2025 in #help
Migration not setting DB column to NOT NULL
So what you say is that the generated sql is not correct or applying it will not result in the expected column state?
3 replies
DTDrizzle Team
•Created by Titan on 3/1/2025 in #help
Postgres insert returning expecting zero arguments
What version are you using and how does your table schema look like?
2 replies
DTDrizzle Team
•Created by iamgengar. on 3/1/2025 in #help
How to make function that takes in a table as parameter with correct types?
This is a bug and was already reported. If you search for a quick fix: Downgrade back to 0.38.
3 replies
DTDrizzle Team
•Created by Vâjhâtz on 12/7/2024 in #help
No schema changes, nothing to migrate 😴
Nevermind then, sorry
11 replies
DTDrizzle Team
•Created by Vâjhâtz on 12/7/2024 in #help
No schema changes, nothing to migrate 😴
Just saw you are using npx
11 replies
DTDrizzle Team
•Created by Vâjhâtz on 12/7/2024 in #help
No schema changes, nothing to migrate 😴
Oh
11 replies
DTDrizzle Team
•Created by Vâjhâtz on 12/7/2024 in #help
No schema changes, nothing to migrate 😴
Are you by any chance using bun for this one project? I had the same issue months ago using bun only. Not sure if it is fixed by now. Maybe it is not and you are running into it now too
11 replies
DTDrizzle Team
•Created by nu on 12/7/2024 in #help
How to add comment on postgres table columns (and other one-time operations like add trigger)
If I were you I would add this kind of work as a custom migration script. This will ensure that it will only be run when the migrations will be applied aka when the database schema is being set up by drizzle kit. Have a look at https://orm.drizzle.team/docs/kit-custom-migrations for more information on migrations
4 replies
DTDrizzle Team
•Created by nu on 12/7/2024 in #help
How to add comment on postgres table columns (and other one-time operations like add trigger)
Hey @nu ,
I think this question can only be answered by yourself because you call the up function yourself no?
4 replies
DTDrizzle Team
•Created by kge on 11/7/2024 in #help
I'm trying using $count, and it giving me fieldAlias missing. What should I do?
Shouldnt it be
?
6 replies
DTDrizzle Team
•Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
Wish I would have enough time to further dig deeper into their code and actually fix it but life....
8 replies
DTDrizzle Team
•Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
So the only fix I see now is downgrading the pg driver to 8.1.0 and hope for a fix on their site. I already opened an issue in their repo: https://github.com/brianc/node-postgres/issues/3325
8 replies
DTDrizzle Team
•Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
Drizzle doesnt put together the query string itself. It calls a method of the pg driver passing a configuration object, that hols the query with the placeholders + an array with the values for the placeholders. The driver then puts together the query. Actuall its the query call I had in my benchmarking code, just with the different parameters. Comparing those two calls, the one with the direct query string and the config+parameters, results in the differences I see when using drizzle. The last version there was no difference was 8.1.0. 8.2.0 introduced a new parser which might be the problem. But still: Why am I the only one experienceing this issue 😄
8 replies
DTDrizzle Team
•Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
Thats what I thought at first too but even starting the timer right before the execute call results in this slow performance. Digging deeper into the code I found out that the problem is the pg driver. From version 8.2.0 upwards the performance is as bad as it is in my example. Using 8.1.0 results in the same times. Its not surprising per se, bugs happen but I am suprised being the only one noticing this.
8 replies