Somacortoi
DTDrizzle Team
•Created by Somacortoi on 2/6/2025 in #help
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.
What are the options with drizzle? When I say thousands of items I talking about ~10k items (this is something and will increase in time because are money transactions mostly)
Thanks1 replies