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)
Thanks0 Replies