pandareaper
pandareaper
PostsComments
DTDrizzle Team
Created by pandareaper on 8/16/2023 in #help
Using the drizzle object mapping API directly in combination with raw queries
If I were to use the raw query interfaces or even use the underlying database driver to query the database directly, is it possible to use Drizzle to handle mapping of rows to the drizzle schema? I understand it would have it's limitations but I'm really looking to leverage all the custom types and to/from driver translations I have
1 replies
DTDrizzle Team
Created by pandareaper on 8/10/2023 in #help
Support for streaming rows?
Is there planned support or at least would it be considered to support streaming large result sets in Drizzle? Both postgres and mysql drivers support streaming rows and expose it as an async iterator. It would be great if this was supported natively in Drizzle Alternatively, if I could use the underlying driver but still leverage drizzle to map the rows to type safe objects then that would also work well
1 replies
DTDrizzle Team
Created by pandareaper on 8/6/2023 in #help
Issues with timestamp precision with postgres
Hi, I posted the other day about a bug with the date, but it seems this issue runs deeper. https://discord.com/channels/1043890932593987624/1043890932593987627/1136224592764080268 I am also using timestamp which has a similar issue, when using mode string drizzle is returning a Date instance (conflicting with the generated types) To make matters worse, when using mode: 'date' we lose all millisecond precision This is the column I am defining 
createdAt: timestamp('created_at', { mode: 'string', precision: 3 }).defaultNow().notNull();
createdAt: timestamp('created_at', { mode: 'string', precision: 3 }).defaultNow().notNull();
This maintains the precision, but then the types are incorrect. Has anyone faced this issue? Is this is a bug in drizzle?
8 replies