When using SQL REPEATABLE READ isolation level and SQL SERIALIZABLE isolation level, concurrent transactions may fail with a serialization failure, and then you might need to retry them. You server code or your ORM must always account for that.
A good way to explore when it happens is to use the example
Related questions:
- stackoverflow.com/questions/7705273/what-are-the-conditions-for-encountering-a-serialization-failure
- stackoverflow.com/questions/59351109/error-could-not-serialize-access-due-to-concurrent-update
- stackoverflow.com/questions/50797097/postgres-could-not-serialize-access-due-to-concurrent-update/51932824
How to use an Oxford Nanopore MinION to extract DNA from river water and determine which bacteria live in it by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
This article gives an idea of how this kind of biological experiment feels like to a software engineer who has never done any biology like Ciro Santilli.
lujakob/nestjs-realworld-example-app by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
Nest.js entry for gothinkster/realworld.
Didn't manage to get it to work perfectly on Ubuntu 20.10: github.com/lujakob/nestjs-realworld-example-app/issues/57
MSc course of the University of Oxford by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
Faster-than-light implies time travel by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
Bibliography:
- physics.stackexchange.com/questions/13001/does-superluminal-travel-imply-travelling-back-in-time/615079#615079
- physics.stackexchange.com/questions/574395/why-would-ftl-imply-time-travel
- physics.stackexchange.com/questions/516767/how-does-a-tachyonic-antitelephone-work
- www.physicsmatt.com/blog/2016/8/25/why-ftl-implies-time-travel shows the causality violation on a Spacetime diagram
There are two such entries, one pointing to
.data
and the other to .text
(section indexes 1
and 2
).Num: Value Size Type Bind Vis Ndx Name
2: 0000000000000000 0 SECTION LOCAL DEFAULT 1
3: 0000000000000000 0 SECTION LOCAL DEFAULT 2
TODO what is their purpose?
Contains the path to the dynamic loader, i.e.
/lib64/ld-linux-x86-64.so.2
in Ubuntu 18.10. Explained at: stackoverflow.com/questions/8040631/checking-if-a-binary-compiled-with-static/55664341#55664341The default run variant, if you don't pass any options, just has the minimal growth conditions set. What this means can be seen at condition.
Notably, this implies a growth medium that includes glucose and salt. It also includes oxygen, which is not strictly required, but greatly benefits cell growth, and is of course easier to have than not have as it is part of the atmosphere!
But the medium does not include amino acids, which the bacteria will have to produce by itself.
E. Coli K-12 MG1655 gene of unknown function by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
UniProt for example describes YaaX as "Uncharacterized protein YaaX".
As function is discovered, they then change it to a better name, e.g. to names such as the E. Coli K-12 MG1655 transcription unit thrLABC proteins all of which have a clear name due to threonine.
There are many other
y???
as of 2021! Though they do tend to be smaller molecules. Newton supported the corpuscular theory of light by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
Why does 2s have less energy than 1s if they have the same principal quantum number? by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
The principal quantum number thing fully determining energy is only true for the hydrogen emission spectrum for which we can solve the Schrödinger equation explicitly.
For other atoms with more than one electron, the orbital names are just a very good approximation/perturbation, as we don't have an explicit solution. And the internal electrons do change energy levels.
Note however that due to the more complex effect of the Lamb shift from QED, there is actually a very small 2p/2s shift even in hydrogen.
Anomalous magnetic dipole moment of the electron by Ciro Santilli 35 Updated 2025-01-10 +Created 1970-01-01
Richard Feynman Quantum Electrodynamics Lecture at University of Auckland (1979) mentions it several times.
This was one of the first two great successes of quantum electrodynamics, the other one being the Lamb shift.
In youtu.be/UKbp85zpdcY?t=52 from freeman Dyson Web of Stories interview (1998) Dyson mentions that the original key experiment was from Kusch and Foley from Columbia University, and that in 1948, Julian Schwinger reached the correct value from his calculations.
Apparently first published at The Magnetic Moment of the Electron by Kusch and Foley (1948).
Bibliography:
- www.youtube.com/watch?v=Ix-3LQhElvU Anomalous Magnetic Moment Of The Electron | One Loop Quantum Correction | Quantum Electrodynamics by Dietterich Labs (2019)
There are unlisted articles, also show them or only show them.