Earlier quoted context omitted.
And they call average C developer less experienced in async. The only correct ‘update balance’ operation is: INSERT INTO CashFlow (date, income, expense) VALUES (:date, :income, 0) Get balance: SELECT sum(income)-sum(expense) AS balance FROM CashFlow What modern js still has to reinvent is in-client synchronizing storage which naturally resolves who waits on what (if at all). This is partially simulated by reactjs no…
Operational transformations are not the "only correct" way to update an integer and it comes with a number of performance and memory/storage consumption implications. >What modern js still has to reinvent is in-client synchronizing storage which naturally resolves who waits on what (if at all) I don't understand what this means but it makes me curious. What would be an example of this in one of the languages that hav…
>it comes with a number of performance and memory/storage consumption implications.
Instead of selecting sum(), CREATE TRIGGER then and update a singleton on insert. You can even create a view with N recent transactions and catch inserts into it to maintain that N, if you don’t want a full history.