Nuxt.js by Ciro Santilli 37 Updated +Created
Launchpad (website) by Ciro Santilli 37 Updated +Created
Superconducting qubit type by Ciro Santilli 37 Updated +Created
Nested set model by Ciro Santilli 37 Updated +Created
This is particularly important in SQL: Nested set model in SQL, as it is an efficient way to transverse trees there, since querying parents every time would require multiple disk accesses.
As a tree:
As the sets:
 __________________________________________________________________________
|  Root 1                                                                  |
|   ________________________________    ________________________________   |
|  |  Child 1.1                     |  |  Child 1.2                     |  |
|  |   ___________    ___________   |  |   ___________    ___________   |  |
|  |  |  C 1.1.1  |  |  C 1.1.2  |  |  |  |  C 1.2.1  |  |  C 1.2.2  |  |  |
1  2  3___________4  5___________6  7  8  9___________10 11__________12 13 14
|  |________________________________|  |________________________________|  |
|__________________________________________________________________________|
Consider the following nested set:
0, 8, root
  1, 7, mathematics
    2, 3, geometry
      3, 6, calculus
        4, 5, derivative
        5, 6, integral
      6, 7, algebra
  7, 8, physics
When we want to insert one element, e.g. limit, normally under calculus, we have to specify:
  • parent
  • index within parent
so we have a method:
insert(parent, previousSibling)
SELECT (SQL) by Ciro Santilli 37 Updated +Created
SQLite by Ciro Santilli 37 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
Spin-transfer torque by Ciro Santilli 37 Updated +Created
Video 1.
Introduction to Spintronics by Aurélien Manchon (2020) spin-transfer torque section
. Source.
Describes how how spin-transfer torque was used in magnetoresistive RAM
20% time rule by Ciro Santilli 37 Updated +Created
The Google Story suggests that this practice existed in academia, where it was brought from. But I can't find external references to it easily:
At Google, the preference is for working in small teams of three, with individual employees expected to allot 20 percent of their time to exploring whatever ideas interest them most. The notion of "20 percent time" is borrowed from the academic world, where professors are given one day a week to pursue private interests.
ORF1ab by Ciro Santilli 37 Updated +Created
How large primes are found for RSA by Ciro Santilli 37 Updated +Created
Answers suggest hat you basically pick a random large odd number, and add 2 to it until your selected primality test passes.
The prime number theorem tells us that the probability that a number between 1 and is a prime number is .
Therefore, for an N-bit integer, we only have to run the test N times on average to find a prime.
Since say, A 512-bit integer is already humongous and sufficiently large, we would only need to search 512 times on average even for such sizes, and therefore the procedure scales well.
Raspberry Pi Pico variant by Ciro Santilli 37 Updated +Created
Quantum field theory lecture by Tobias Osborne (2017) by Ciro Santilli 37 Updated +Created
This is a bit "formal hocus pocus first, action later". But withing that category, it is just barely basic enough that 2021 Ciro can understand something.
Lecture notes transcribed by a student: github.com/avstjohn/qft
18 1h30 lectures.
Protein dimer by Ciro Santilli 37 Updated +Created
Earth by Ciro Santilli 37 Updated +Created
Neptune by Ciro Santilli 37 Updated +Created
Quite cool how it was discoverd by the perturbation of Uranus' orbit.
Photonics equipment by Ciro Santilli 37 Updated +Created
Arm on tracks by Ciro Santilli 37 Updated +Created
Snakes and Ladders by Ciro Santilli 37 Updated +Created
"Game" is a bit of a stretch as there are no player choices at all.
A more precise word would be simulation.
More precise, this "game" is exactly an absorbing Markov chain.
Argument from authority by Ciro Santilli 37 Updated +Created

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