"Security"? This has nothing to do with security. Also, it's not great to pollute technical forums with more ChatGPT-generated content when it would be more useful for domain experts to contribute their own knowledge.
In Postgresql, the default ISOLATION LEVEL is "READ COMMITTED", which by standard, allows "NON-REPEATABLE READ" phenomena.
When Transaction on the LEFT is COMMITTED (adding 100 to balance), the Transaction on the RIGHT will add 400 to a balance of 1100, and not to a balance of 1000 (reading NON-REPEATED value).
You can do better than leaving this kind of comment that does not contribute in anything.
Me too, thanks. Would be nice if you can share some articles that you wrote regarding the matter, so I can have more inspiration. Looking forward to read them and learn from different examples and not the same "boiler plate" example that you can find on any DBMS documentation.
I don't get your comment, to be quite honest.
Besides, I don't like 3rd party A.I. services: the content that you see, is the content that I wrote.
And this comment of yours seems more of something to offend than to contribute.
I feel bad for you.
Karma Whore? That's how you speak with people trying to share contents here? Does that does in favor of the rules then?
Buddy, I feel bad for you. I hope you may have someone to love you on this Sunday, for you really need it. Don't be like that. Have a good day.
It seems you can’t see the comment I’m replying to because it’s been flagged and hidden if your settings are set that way – I am not talking about your article, I have no problem with it!
Would you mind to explain your point, please? I'd be glad to learn more about it, for so far, I cannot agree with your comment, based on hands-on testing and documentations. Thanks.
There's no mention of the REPEATABLE READ isolation level, though it mentions that READ COMMITTED can exhibit non-repeatable read behaviour. Here's the docs:
I do believe that a developer's grasp of database concepts, like handling concurrency issues and understanding isolation levels, even if not by specific terminology, can be an indicator of their depth in problem-solving, attention to detail, and experience with complex systems.
16 comments
[ 3.9 ms ] story [ 48.7 ms ] threadIn Postgresql, the default ISOLATION LEVEL is "READ COMMITTED", which by standard, allows "NON-REPEATABLE READ" phenomena.
When Transaction on the LEFT is COMMITTED (adding 100 to balance), the Transaction on the RIGHT will add 400 to a balance of 1100, and not to a balance of 1000 (reading NON-REPEATED value).
You can do better than leaving this kind of comment that does not contribute in anything.
Have good weekend.
That aside, it’s blatantly against the rules here. Go somewhere else if you want botspam
Maybe you can't see dead comments?
[0] https://www.postgresql.org/docs/current/transaction-iso.html