Questions tagged [transaction]
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.
122
questions
2
votes
1
answer
230
views
Problem with data consistency in Microservice architecture(2pc transaction) when external dependency envolved
I have microservice architecture. I implement a distributed transaction flow (2-phase commit), kafka, and 1 coordinator service. So, my problem is in each step of preparation I am calling an outside ...
1
vote
1
answer
91
views
Handling Distributed Transactions with CompletableFuture in Spring
I'm looking for an opinion about an approach for dealing with distributed transactions. In a Spring Boot program, how can I implement the following business process without sacrificing to code ...
2
votes
1
answer
127
views
Handling Back-dated Transactions and "Online" Transactions on ERP/Banking Systems
I was currently developing a PoC of a "core banking system" in my current company, a pawn shop that generally offers lending services to retail customer and deposit services. We've built a ...
0
votes
0
answers
40
views
Looking for patterns for instantaneous data consistency for DB transactions that span multiple schemas in a Aurora postgres instance
We are currently developing a product in the AWS environment that requires instantaneous data consistency for DB transactions that span multiple schemas in a Aurora postgres instance. Each schema will ...
2
votes
2
answers
195
views
When should I be worried of Time of check time of use vulnerabilities during database queries?
I am having difficulties on understanding when I should be worried about TOCTOU vulnerabilities and how to avoid them because yes, we can use database transactions but there are different level of ...
0
votes
4
answers
198
views
How to handle a scenario where server fails to respond in time with some arbitrary response, but later the transaction is processed?
Client sends request to deduct his account balance for registering with a service.
balance=balance-fee
Server takes a lot of time to process the request.
Since server was taking lot of time, client ...
1
vote
1
answer
163
views
Reserving Unique, Sequential Group Numbers in ASP.NET Core with EF Core and GraphQL
I am developing an API backend using ASP.NET Core Minimal API (.NET 7) with Entity Framework Core, HotChocolate (for GraphQL), and a Microsoft SQL Server database. I've encountered a specific ...
3
votes
1
answer
142
views
Should I use transactions in this scenario?
I am writing a API endpoint in NodeJs, The code is roughly like this:
function myApi(myUserId, userIdToDelete){
if ( checkIfIAmAdmin(myUserId) ) {
deleteUser(userIdToDelete);
}
}
Now,...
2
votes
1
answer
228
views
two diffrent database in unit of work
I will explain my problem in the form of an example.
Suppose we want to use both databases in a transaction.
Data is edited in database 1 (for example, Postgres) and then added to database 2. Finally, ...
1
vote
1
answer
110
views
Moving Transaction Logic to Middle Layer: Pros and Cons
We have an event booking system that allows patrons to add themselves to a waiting list if an event is fully booked. When somebody cancels, the system moves the first person from the waitlist into a ...
2
votes
1
answer
2k
views
Clean Architecture Use Case and db transactions/unit of work
I've started working on a LoB application (as a learning exercise) while trying to express business logic with use cases from Clean Architecture. First use case is customer onboarding where client can ...
5
votes
3
answers
963
views
Group set of commands as atomic transactions (C++)
We're designing the architecture of an embedded device (esp32). One of the tasks is that the device should connect to the internet and use a preprovisioned redeem code to register itself with our web ...
2
votes
1
answer
2k
views
Build a Rust project using Clean architecture and DB transactions in the same DDD bounded context
This is just an example of an (still incomplete) real-world project written in Rust using a clean architecture: https://github.com/frederikhors/rust-clean-architecture-with-db-transactions.
Goals
My ...
1
vote
2
answers
167
views
Strategies to abstract away technical details when dealing with transactions
I like programming in such a way that every component/injectable of the applications I build, has a clearly defined scope, and it's easily tested.
With years working as a Developer I've come to ensure ...
1
vote
2
answers
58
views
adding optional code for bad protocol state check
I've got a GRPC API that I'm designing. It includes an RPC method that requires the caller follow-up with another API call. Some pseudo-code a client might write:
val apiInstsance = makeAPIInstance()
...