6 replies

Possible to chain requests?

If I have a user table and a usersettings table, the way i create a user now is something like:

await db.transaction(async tx => {
  const [{id: userId}] = await tx.insert(users).values(user).returning();
  await tx.insert(userSettings).values({...settings, userId});
})

await db.transaction(async tx => {
  const [{id: userId}] = await tx.insert(users).values(user).returning();
  await tx.insert(userSettings).values({...settings, userId});
})

This takes 2 trips to the DB. Is it possible to somehow chain the requests together such that i send both SQL statements at once?

Use case: my db is located in us-west-1 and my user and edge function is located in africa. If both sql statements could be made in one trip, it would lead to a faster response time.

If this is not currently possible, is such a feature conceivably possible?

Drizzle Team•3y ago•

6 replies

jakeleventhal

Possible to chain requests?

If I have a user table and a usersettings table, the way i create a user now is something like:

await db.transaction(async tx => {
  const [{id: userId}] = await tx.insert(users).values(user).returning();
  await tx.insert(userSettings).values({...settings, userId});
})

await db.transaction(async tx => {
  const [{id: userId}] = await tx.insert(users).values(user).returning();
  await tx.insert(userSettings).values({...settings, userId});
})

Possible to chain requests?

Similar Threads

Possible to chain requests?

Similar Threads

Similar Threads

Similar Threads