Will AvionDb support multi-document atomic transactions? about aviondb HOT 5 OPEN

I think transaction atomicity is a very valuable feature but I don't think it's trivial to say "we'll include it". MongoDb and CouchDb have reasons for not including it.

In a database of a few terabyte and 1000s of users of the database who sync with each other in a decentralized way resolving transactions takes a lot of work.

If it would be easy to simply add transaction multi-document atomicity in MongoDb's design, MongoDb would already have done it.

I think it would be great to see discussion of tradeoffs in some design document.

from aviondb.

@ChristianKleineidam Transactions are already in our Feature List that we are working on #8

If this answers your question, feel free to close this issue 😉

from aviondb.

The feature list isn't specific about whether the transactions in the future list will be atomic for multiple documents or not. It links to MongoDb description of Transactions and MongoDb transactions that go over multiple documents aren't atomic and speaks about atomicity. Whether that atomicity is per document such as in MongoDb or over multiple documents like in Firestore is an important question.

from aviondb.

@ChristianKleineidam Good point, we should add more details to the feature list in this regard. We're planning to have transaction atomicity for multiple documents like in Firestore.

from aviondb.

Some explanation on how aviondb works under the hood in regards to operations. When a document is modified in any fashion (Whether its multiple or a single one at once). When the operation is first started, the system will search the database for the specified query. Returning a list of IDs. When the operation is broadcasted to the network it includes the operation modifier, and list of IDs to modify. This prevents conflicts of modifying all documents some of which may have not yet propagated across the entire network.

The part on preventing modification conflicts in being looked into. Something like including a StateHash in each operation can mitigate or at least detect operation conflicts.

from aviondb.