SQLite C extension Updated 2025-07-16
Example: sqlite/ip.c, adapted from www.sqlite.org/loadext.html, also mentioned explained at: stackoverflow.com/questions/7638238/sqlite-ip-address-storage/76520885#76520885.
Sample usage in the test program: sqlite/test.sh.
SQL READ COMMITTED isolation level Updated 2025-07-16
Example where this level is sufficient: nodejs/sequelize/raw/parallel_update_async.js.
Wei Dai Updated 2025-07-16
Apache License Updated 2025-07-16
Aperiodic monotile Updated 2025-07-16
Aperiodic tiling Updated 2025-07-16
Doing physics means calculating a number Updated 2025-07-16
It does not matter how, if it is exact, or numerical, or a message from God: a number has to come out of the formulas in the end, and you have to compare it with the experimental data.
Many theoretical physicists seem to forget this in their lectures, see also: Section "How to teach and learn physics".
How Ciro Santilli manages to write so much Updated 2025-07-16
- Suck at your job:
- Have bad memory so you have to take notes: Ciro Santilli's bad old event memory
- Be a compulsive knowledge hoarder: Ciro Santilli's knowledge hoarding
- Seek glory over money: Ciro Santilli's selfish desires
- Try to make a carrier out of it: OurBigBook.com
- Be born compassionate: Ciro Santilli's self perceived compassionate personality
- He doesn't actually write that much, but when he does he focuses on higher impact stuff, see remarks about "He doesn't like to refresh the homepage looking for easy reputation" on Section "Ciro Santilli's Stack Overflow contributions"
- Contribute in a place where it is super easy for people to give you upvotes if they like your stuff. This way, you will see the uploads, and that will motivate you to re-read your content and make it more perfect with additions and corrections.
Special linear group of dimension 2 Updated 2025-07-16
University spin-off company Updated 2025-07-16
Aberration (astronomy) Updated 2025-07-16
Busy beaver Updated 2025-07-16
The busy beaver game consists in finding, for a given , the turing machine with states that writes the largest possible number of 1's on a tape initially filled with 0's. In other words, computing the busy beaver function for a given .
There are only finitely many Turing machines with states, so we are certain that there exists such a maximum. Computing the Busy beaver function for a given then comes down to solving the halting problem for every single machine with states.
Some variant definitions define it as the number of time steps taken by the machine instead. Wikipedia talks about their relationship, but no patience right now.
The Busy Beaver problem is cool because it puts the halting problem in a more precise numerical light, e.g.:
- the Busy beaver function is the most obvious uncomputable function one can come up with starting from the halting problem
- the Busy beaver scale allows us to gauge the difficulty of proving certain (yet unproven!) mathematical conjectures
Busy Beaver Challenge Updated 2025-07-16
Project trying to compute BB(5) once and for all. Notably it has better presentation and organization than any other previous effort, and appears to have grouped everyone who cares about the topic as of the early 2020s.
Very cool initiative!
By 2023, they had basically decided every machine: discuss.bbchallenge.org/t/the-30-to-34-ctl-holdouts-from-bb-5/141
Finite special general linear group Updated 2025-07-16
Just like for the finite general linear group, the definition of special also works for finite fields, where 1 is the multiplicative identity!
Note that the definition of orthogonal group may not have such a clear finite analogue on the other hand.
Mathematics illustration software Updated 2025-07-16
Survey by Ciro Santilli: math.stackexchange.com/questions/1985/software-for-drawing-geometry-diagrams/3938216#3938216
Many plotting software can be used to create mathematics illustrations. They just tend to have more data-oriented rather than explanatory-oriented output.
SQL SERIALIZABLE isolation level Updated 2025-07-16
Mathy Magic: The Gathering thoughts Updated 2025-07-16
In 2019, a paper proved that MTG is Turing complete with a legacy legal deck. Live demo with some hand waving: Video "I Built a COMPUTER in Magic: The Gathering by Because Science (2019)". As Ciro Santilli comments at: github.com/cirosantilli/cirosantilli.github.io/issues/42 this was an interest addition to the previous "indefinite infinite loop" e.g. as found in a Four Horsemen combo deck
Open source standard cell library Updated 2025-07-16
Open source ones:
- www.quora.com/Are-there-good-open-source-standard-cell-libraries-to-learn-IC-synthesis-with-EDA-tools/answer/Ciro-Santilli Are there good open source standard cell libraries to learn IC synthesis with EDA tools?
Pivot (strategy) Updated 2025-07-16
Unlisted articles are being shown, click here to show only listed articles.