SQLite by Ciro Santilli 35 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 35 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 35 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 35 Updated +Created
How large primes are found for RSA by Ciro Santilli 35 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 35 Updated +Created
Quantum field theory lecture by Tobias Osborne (2017) by Ciro Santilli 35 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 35 Updated +Created
Earth by Ciro Santilli 35 Updated +Created
Neptune by Ciro Santilli 35 Updated +Created
Quite cool how it was discoverd by the perturbation of Uranus' orbit.
Photonics equipment by Ciro Santilli 35 Updated +Created
Arm on tracks by Ciro Santilli 35 Updated +Created
Snakes and Ladders by Ciro Santilli 35 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 35 Updated +Created
Computer biliography by Ciro Santilli 35 Updated +Created
Video game by number of players by Ciro Santilli 35 Updated +Created
Robot form factor by Ciro Santilli 35 Updated +Created
Porn vlog by Ciro Santilli 35 Updated +Created
This is a porn style defined by Ciro Santilli as:
  • content is designed and owned by the actors
  • full face reveal
  • doing normal vlog things like talking, visiting places, eating, etc., not just fucking
Ciro believes that this is an interesting type of pornography, as it feels more natural and humane than all the horrible trash that comes out of horrendous professional mainstream porn industry.
Yes, it could go down the YouTube/Instagram alley, and lead the vloggers to do things they wouldn't normally do because of the audience. But who is to say that Ciro Santilli doesn't do the same on Stack Overflow to some extent?
That type of porn requires some big courage to make. Or balls if you will. Kudos to those creators, as it is so taboo it could greatly impact their future job prospects.
The travel sex vlog appears to be the most popular way to do it. Presuamably the reason being that you would not be able to interact with people in a normal job, so to keep things interesting you need to go to some random places.
Examples:
Stochastic process by Ciro Santilli 35 Updated +Created

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