SQLite Updated +Created
The minimalism, serverlessness/lack of temporary caches/lack of permission management, Hipp's religious obsession with efficiency, the use of their own pure Fossil version control[ref]. Wait, scrap that last one. Pure beauty!
Official Git mirror: github.com/sqlite/sqlite
Create a table
sqlite3 db.sqlite3 "
CREATE TABLE 'IntegerNames' (int0 INT, char0 CHAR(16));
INSERT INTO 'IntegerNames' (int0, char0) VALUES (2, 'two'), (3, 'three'), (5, 'five'), (7, 'seven');
"
List tables:
sqlite3 db.sqlite3 '.tables'
output:
IntegerNames
Show schema of a table:
sqlite3 db.sqlite3 '.schema IntegerNames'
outputs the query that would generate that table:
CREATE TABLE IF NOT EXISTS 'IntegerNames' (int0 INT, char0 CHAR(16));
Show all data in a table:
sqlite3 db.sqlite3 'SELECT * FROM IntegerNames'
output:
2|two
3|three
5|five
7|seven
Innovate UK Updated +Created
Soviet Union Updated +Created
Ultraviolet catastrophe Updated +Created
Video 1.
What is the Ultraviolet Catastrophe? by Physics Explained (2020)
Source.
Spacetime diagram Updated +Created
Why should I care when I can calculate new x and new time with Lorentz transformation?
Answer: it can give some qualitative intuition on what is larger/smaller happens before/after based only on arguably more intuitive geometric considerations, without requiring you to do any calculations, see e.g. Figure "Spacetime diagram illustrating how faster-than-light travel implies time travel".
Stack Overflow content deletion Updated +Created
Stack overflow allows deleting content/making it visible only to 10k rep users.
Ciro Santilli is strictly against this, and this is an intended core policy of OurBigBook.com.
If you delete people's content randomly, they will be much less likely to write anything.
Getting downvoted to oblivion is one thing, but data loss? Unacceptable.
Only illegal content must ever be deleted. Or extremely obvious spam. But anything in a gray area should never be removed.
Deletion can be done by either:
Bicycles require too much maintenance Updated +Created
It is true, something Ciro Santilli often things about. One likely reason is that the world is broken and most cyclist are speed maniacs willing to put the time in. Unlike Dutch people where everyone cycles.
Blockchain wiki Updated +Created
This section is about wikis that are hosted on a blockchain of some sort.
City in the Netherlands Updated +Created
Cladogram Updated +Created
TODO vs Phylogenetic tree? www.visiblebody.com/blog/phylogenetic-trees-cladograms-and-how-to-read-them:
Cladograms and phylogenetic trees are functionally very similar, but they show different things. Cladograms do not indicate time or the amount of difference between groups, whereas phylogenetic trees often indicate time spans between branching points.
Counties of the United Kingdom Updated +Created
There are few different versions. The most important as of 2020 are:
No one is capable of offering an official/more generalized (why can't Google Maps do this properly?) map than these people: wikishire.co.uk/map/#/centre=54.004,-4.500/zoom=7 So so be it.
Video 1.
English counties explained by Jay Foreman (2021)
Source.
SQL tree traversal Updated +Created
Code golf Updated +Created
Coherence time Updated +Created
It takes time for the quantum state to evolve. So in order to have a deep quantum circuit, we need longer coherence times.
Collegiate university Updated +Created
SQUID device Updated +Created
Can be used as a very precise magnetometer.
Video 1.
Superconducting Quantum Interference Device by Felipe Contipelli (2019)
Source. Good intuiotionistic video. Some points deserved a bit more detail.
Video 2.
Mishmash of SQUID interviews and talks by Bartek Glowaki
. Source.
The videos come from: www.ascg.msm.cam.ac.uk/lectures/. Vintage.
Mentions that the SQUID device is analogous to a double-slit experiment.
One of the segments is by John Clarke.
Video 3.
Superconducting Quantum Interference Devices by UNSW Physics (2020)
Source.
An experimental lab video for COVID-19 lockdown. Thanks, COVID-19. Presented by a cute and awkward Adam Stewart.
Uses a SQUID device and control system made by STAR Cryoelectronics. We can see Mr. SQUID EB-03 written on the probe and control box, that is their educational product.
As mentioned on the Mr. SQUID specs, it is a high-temperature superconductor, so liquid nitrogen is used.
He then measures the I-V curve on an Agilent Technologies oscilloscope.
Unfortunately, the video doesn't explain very well what is happening behind the scenes, e.g. with a circuit diagram. That is the curse of university laboratory videos: some of them assume that students will have material from other internal sources.
Video 4.
The Ubiquitous SQUID by John Clarke (2018)
Source.
Stabilizer (group) Updated +Created
Suppose we have a given permutation group that acts on a set of n elements.
If we pick k elements of the set, the stabilizer subgroup of those k elements is a subgroup of the given permutation group that keeps those elements unchanged.
Note that an analogous definition can be given for non-finite groups. Also note that the case for all finite groups is covered by the permutation definition since all groups are isomorphic to a subgroup of the symmetric group
TODO existence and uniqueness. Existence is obvious for the identity permutation, but proper subgroup likely does not exist in general.
Stack Overflow no duplicate answers policy Updated +Created
It's great right? You can't link to your other answer alone: Stack Overflow link-only answer policy, but you can't copy the other answer either.
And because not all duplicate close votes succeed, see e.g. stackoverflow.com/questions/59649238/how-to-use-the-m5ops-in-gem5-such-m5-exit-and-m5-dump-stats-in-se-mode/63955139#63955139 the result is that someone else will come and answer the same thing in a different wording.
And some answers answer two questions that are not duplicates, e.g. superset/subset questions.
So just do a slight variation wording yourself and get all the reputation.

There are unlisted articles, also show them or only show them.