Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 177980

Questions about maintaining consistency between a set of related operations, in a way that either all succeed, or the state of the system remains unchanged.

5 votes

Efficiently processing millions of records every minute

Since you already have a Message Queue, put the message directly on that rather than the db and horizontally scale your Midpoint and App2 App1 -REST-> Midpoint Midpoint (load balanced, multiple ser …
Ewan's user avatar
  • 79.8k
4 votes
Accepted

System design: transactional inserts at application level

If everything goes fine, do a single transaction at the end to copy the rows into the real table, then clear them out of the staging table. …
Ewan's user avatar
  • 79.8k
3 votes

Should I use transactions in this scenario?

No. Consider todays normal practice is to send the "IsAdmin" flag as a claim in a token. A token with an expiration of at least several minutes, if not hours. It's expected and accepted that there is …
Ewan's user avatar
  • 79.8k
2 votes
Accepted

Does separating Domain model and Persistence model have impact on transactional aspect?

The linked blog post is rather vague and seems be a confusion of active record and entity object pattens rather than using data transfer objects. Bear in mind that underneath whatever orm or wrappers …
Ewan's user avatar
  • 79.8k
2 votes

TransactionScope in business or data/repository class?

One of the benefits to transaction scope as opposed to a transaction is that you can use it without reference to the connection. … This allows you to potentially use it outside of the data layer so the business logic can decide whether two or more data operations should be part of the same transaction or not. …
Ewan's user avatar
  • 79.8k
2 votes

Strategies to abstract away technical details when dealing with transactions

The traditional answer would be a "unit of work" pattern. But its not particularly good in my view. A better solution is to do away with the transactions. Or at least remove them from the business lan …
Ewan's user avatar
  • 79.8k
1 vote

Transactional and eventual consistency together -- which operations MUST be transactionally ...

The general solution to this is to have a clean up check which runs periodically. Service C: Perform Operation C Close A (via message to A?) Service D: Look for all open Operation A's …
Ewan's user avatar
  • 79.8k
1 vote

adding optional code for bad protocol state check

With the trend for stateless calls no-one will expect a method call to require closing. But a "Connection" is expected to have state, open, close etc I would rename stuff to lean into that and instea …
Ewan's user avatar
  • 79.8k
0 votes

How to handle transactional operations in an event-driven architecture?

You can't really handle the stock level reservation with a traditional database transaction. Because it's a human clicking through the order process, the transaction would simply be open too long. …
Ewan's user avatar
  • 79.8k