Hello, I’m Allie!
Explore posts from serversDTDrizzle Team
•Created by Hello, I’m Allie! on 5/11/2024 in #help
Environment-based Connection Configs?
Hey y'all!
I'm developing a project that will use Cloudflare D1 as the DB. The trouble is that while Drizzle already has native support for querying D1 via the HTTP API, I also want to be able to query against the local version of my DB in the
.wrangler directory. Is there any way to be able to switch between which I query, other than having two separate configs I rename(using better-sqlite3 or something)?5 replies
DTDrizzle Team
•Created by Hello, I’m Allie! on 5/7/2024 in #help
Why must batches be readonly?
Hi y'all!
I'm using
drizzle-orm to insert a lot of rows. I want to avoid making too many trips to my database, so I've decided to batch some statements together. The trouble is, it appears that db.batch requires the statements passed in to be within a read-only array, which means I cannot dynamically build the statements. Is there a specific reason why that is the case?
The underlying DB should be able to support dynamically-built arrays of statements.7 replies
DTDrizzle Team
•Created by Hello, I’m Allie! on 5/3/2024 in #help
Delta Updates(somehow)?
Hi y'all!
I have a dataset of CSV files(some large enough to not fit into memory). I also have a schema set up to insert that data into Cloudflare D1. A fresh copy of this dataset is pulled from an external API once a day, though I do not know whether anything has changed, whether it is only a single file, or even if it is just a single row in a large file that has changed.
Is there some way for me to only push updates for rows/fields that actually need to be changed, minimising the number of operations I need to do against the DB?
3 replies