fishstamp82
Joined 7 years ago
Joined 7 years ago
If you are running in RC isolation, and perform a select sum() from table, you are reading values committed by other threads BEFORE the select statement began, you are not getting other threads committed values during the select, you are not breaking ACID.
If you are suggesting that running a simple BEGIN; select sum() from table; COMMIT is breaking acid in a default RC level, you are wrong and should best avoid commenting on isolation levels in RDBMS online, to not confuse people further.
If you are however suggesting that we are breaking ACID if we do app side stupidity such as:
value1=BEGIN; SELECT value from table where id=1;commit value2=......
sum = value1+value2....+value10
Then yes obviously its not acid but nobody in their right minds should be doing that. Even juniors quickly learn that this is incorrect code.
If you are suggesting we do repeatable reads in RC then yes its obviously not ACID but your example does not mention repeatable summations only a single one.
Thanks for the link still, it was valuable!
This is not how it works at all. This is called dirty writes and is by default prevented by ACID compliant databases, no matter the isolation level. The second transaction commit will be rejected by the transaction manager.
Even if you start a transaction from your application, it does not change this still.
The ad-on makes the home screen completely white/empty, meaning I just get reminded constantly ohh, yeah I am not supposed to use youtube unless there is something particular I want to watch.
To me it looks like the drop is harder since averaging smooths out the points, so end of july 2025 the adoption is not exactly 12%, but probably more like 8%, where its closer to end of 2023.
It seems big tech is putting a big break on AI tooling, for now.
Dont buy the hype that arch is hard, its a really simple system imo.
I find it valuable at times, depending on the context, but I agree that extensive mock testing like this can get quite useless real quick.