Confused about how to do a transaction

[CelesteComet]

Wanted to figure out how to do a transaction across several collections optimistically.

Been working off https://github.com/electric-sql/electric/tree/main/examples/tanstack-db-web-starter, it makes sense for 1-1 crud operations but I have situations where I need to create an object optimistically that depends on another object for its id (a transaction)

My schema design is that I have Items where each Item can be Post or an Image. These Items are sorted in a Bucket where the Bucket has an array of Item ids.

So my operation is essentially to create a Post where I need to associate it with an Item and then to the Bucket.
Hopefully we can add something to the tanstack-db-web-starter for this pattern.

Thank you so much beforehand.

[KyleAMathews]

Check out the mutations doc — https://tanstack.com/db/latest/docs/guides/mutations

Actions + manual transactions let you create cross-collection transactions.