Ciro Santilli @cirosantilli 37

../../../nodejs/sequelize/raw/parallel_update_worker_threads.js contains a base example that can be used to test what can happen when queries are being run in parallel. But it is broken due to a sqlite3 Node.js package bug: github.com/mapbox/node-sqlite3/issues/1381...

../../../nodejs/sequelize/raw/parallel_update_async.js is an async version of it. It should be just parallel enough to allow observing the same effects.

This is an example of a transaction where the SQL READ COMMITTED isolation level if sufficient.

These examples run queries of type:

Sample execution:which does:

The fear then is that of a classic read-modify-write failure.

But as www.postgresql.org/docs/14/transaction-iso.html page makes very clear, including with an explicit example of type UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345;, that the default isolation level, SQL READ COMMITTED isolation level, already prevents any problems with this, as the update always re-reads selected rows in case they were previously modified.

Since in PostgreSQL "Read uncommitted" appears to be effectively the same as "Read committed", we won't be able to observe any failures on that database system for this example.

nodejs/sequelize/raw/parallel_create_delete_empty_tag.js contains an example where things can actually blow up in read committed.

Double cover of $SO(3)$.

Isomorphic to the quaternions.

TODO understand better, mentioned e.g. at Subtle is the Lord by Abraham Pais (1982) page 20, and is something that Einstein worked on.

Ciro Santilli likes Magic: The Gathering and he was pleased when he learned that Steve Wozniak does too, and has an expensive collection: redsunsoft.com/2019/03/how-a-post-to-play-magictg-turned-into-an-afternoon-with-the-woz/

Basically a synonym for second quantization.

Cute synonym for second brain, sample usage: beepb00p.xyz/exobrain/#cntnt

Huge respect to this companies.

Makes RNA from RNA.

Used in Positive-strand RNA virus to replicate.

I don't think it's present outside viruses. Well regulated organisms just transcribe more DNA instead.

www.youtube.com/watch?v=6DxlkxA82FM COVID-19 Symposium: Entry of Coronavirus into Cells | Dr. Paul Bates

Interaction points:

Claims provably fair. satoshidice.com/fair clarifies what that means: they prove fairness by releasing a hash of the seed before the bets, and the actual seed after the bets.

As mentioned in bitcoin.it, it functions basically as cryptocurrency tumbler in practice.