Nope, your ACID database will ensure that two writes in the same time for the same record will not happen. You don't even need to ask database if coupon is used. You just try to use coupon, if already used return message to user.
Node give you freedom from Thread Hell. You enjoy similar performance without locks, threads, synchronisation. Race conditions happen but mostly with cache invalidation where you can have limited consistency guarantees.
Re:Callback Hell (2016)
by paulddraper on Wednesday February 15, 2017 @11:03PM
(#13657676)
Right; you need to put your lock in the database, encoded as an index.
The problem isn't "two writes at the same time", it's the server thinking everything's OK for two separate users.
If can model your database differently for this rudimentary example, then good for you – you're thinking about race conditions. Many web programmers do not think about them at all, and race conditions are usually not trivial to fix.
> Use ACID compliant Database or not
How is that specific to only NodeJs?
agree. the coupon problem would be best fixed with atomic database transactions.
in fact, an entirely synchronous, 1-user-at-a-time server wouldn't fix this, if there were two or more servers. and honestly, who would design any system that only supports 1 concurrent user?
Calling race conditions the "most common" vulnerability seems like some pretty extreme hyperbole. What about SQL injection or XSS?
You're right, I meant to say the most commonly unaware vulnerability.
Take a classic example: a one-time use coupon. Without some kind of locking, two simultaneous requests would be able to use the same coupon successfully. Roughly:
* Since the question was asked for both requests at the same time, the answer was "Not used" in both cases. Node's async model is not going to help you here. You will need something more, such as a mutex.