4 ms·

It should be an atomic transaction, double-entry style, so it can’t fail between commas. The important thing is not having money go missing.

• withinboredom 2y ago
  The only way that is possible is if the tables exist on the same database server. Otherwise, you are right back at distributed transaction problems.
  • hcarvalhoalves 2y ago
    That's the whole point of double-entry. You don't split the entries.
    • withinboredom 2y ago
      Then this is off-topic af. We are talking about distributed systems here.