iska
Explore posts from serversDTDrizzle Team
•Created by iska on 8/19/2024 in #help
syntax atomic transaction d1 not working
getting
[ERROR] To execute a transaction, please use the state.storage.transaction() API instead of the SQL BEGIN TRANSACTION or SAVEPOINT statements. The JavaScript API is safer because it will automatically roll back on exceptions, and because it interacts correctly with Durable Objects' automatic atomic write coalescing.
when using
return await this.db.transaction(async (tx) => {
const encryptedEmail = await encrypt(email, this.env);
const existingUser = await tx.select().from(users).where(eq(users.email, encryptedEmail)).get();
how to do atomic transaction while keeping drizzle orm syntax using d1 ?
2 replies
DTDrizzle Team
•Created by iska on 8/19/2024 in #help
sharding orchestrator support suggestion
dunno if this is the right place to make a suggestion, but this would be such a good feature to support sharding especially for D1 db given their constraints (10 gb) and all the complexity that comes along with it aka "migrations"
1 replies
DTDrizzle Team
•Created by iska on 8/8/2024 in #help
using a monorepo with multiple apps and services
i would like to separate my migrations folder with sub directories
for example a shared one where i could move all my shared schema and one sub directory per app name ? is there something remotely close to do that ?
that would help alot for my ci/cd and avoid me to use some kind of post generate script to reorganize my migration folder
12 replies