It´s there, so implementing it in Wix would be highly appreciated:
@giri-zano Can you please elaborate on the use case you need transactions for?
Oh yes, no problem. Basically, any writing to the DB that needs to be ACID-compliant. Examples: a reservation Main row with n Detail rows (a car, a roofrack and a baby seat), an Main Invoice Row with n details (items), an Order Main row with n Details (items ordered), a Main Wish List row with n Detail rows (items), a Time-And Billing main row and n Detail rows (hours),etc. These actions have to be “all or nothing”: a DB error on any level should roll back everything, to keep the DB in a clean state (=no Main rows without Details, no Detail Rows without a Main Row.)
As we can see from the Forum, people are starting to develop more and more business critical applications with Corvid, moving away from the initial non-critical view (films/actors, recipies/contributors). Because business critical apps NEED ACID, Wix (well MongoDB) was/is a tricky choice, since most developers will shy away from it and go relational (where Transactions are implemented). Doing that with Covid on the front-end is kind off “rough” still, with the (if I am correct, READ-ONLY) drivers Corvid now offers.
SO in short, if Corvid wants to attract more serious application development, Transactions are a must (apart from the other one: being able to make backups).
I hope this is clear enough, if not, let me know. I sincerly hope you will be able to implement it and I offer myself as a beta-tester, since I am now developing an app that needs it.
Thanks for taking the time to respond.
EDIT. Another one came to mind: reliable de-normalization. If I have an app which “loads” a monetary amount (e.g. by credit card) and than writes a row to a db for every Debit and Credit of that account, one normaly de-normañizes the DB: the current balance is kept in a Main Row, so you don´t have to iterate thru all detail rows to CALCULATE the balance (SLOOOOW). This type of actions NEEDS transactions to be reliable.
Basically, the moment “money” is involved, you need transactions.
Just out of curiosity, are you using the MongoDB npm package?
@skmedia No David, just straight up-and-down Wix Corvid. But Corvid uses MongoDB as its DB, as has been confirmed some 2 years ago by Wix.
@giri-zano Yeah, I know this just curious.
@Shay (Wix) Could you please tell me if you are contemplating this feature? It is rather important to know for the db-setup I am working on now (if I can use de-normalization). Thanks.