Ciro's Edict #5 OurBigBook Library tested on PostgreSQL Updated 2025-07-16
After something broke on the website due to SQLite vs PostgreSQL inconsistencies and took me a day to figure it out, I finally decided to update the test system so that
OURBIGBOOK_POSTGRES=true npm test will run the tests on PostgreSQL.Originally, these were being run only on SQLite, which is the major use case for OurBigBook CLI, which came before the website.
Superconductivity is a a form of superfluidity Updated 2025-07-16
We know that superfluidity happens more easily in bosons, and so electrons joins in Cooper pairs to form bosons, making a superfluid of Cooper pairs!
Isn't that awesome!
Tiananmen Square Protests Updated 2025-07-16
Transmission electron microscopy Updated 2025-07-16
Transmission Electron Microscope by LD SEF (2019)
Source. Images some gold nanopraticles 5-10 nm. You can also get crystallographic information directly on the same machine. x86 Paging Tutorial Process memory layout Updated 2025-07-16
For each process, the virtual address space looks like this:
------------------ 2^32 - 1
Stack (grows down)
v v v v v v v v v
------------------
(unmapped)
------------------ Maximum stack size.
(unmapped)
-------------------
mmap
-------------------
(unmapped)
-------------------
^^^^^^^^^^^^^^^^^^^
brk (grows up)
-------------------
BSS
-------------------
Data
-------------------
Text
-------------------
------------------- 0The kernel maintains a list of pages that belong to each process, and synchronizes that with the paging.
If the program accesses memory that does not belong to it, the kernel handles a page-fault, and decides what to do:
When an ELF file is loaded by the kernel to start a program with the
exec system call, the kernel automatically registers text, data, BSS and stack for the program.The
brk and mmap areas can be modified by request of the program through the brk and mmap system calls. But the kernel can also deny the program those areas if there is not enough memory.brk and mmap can be used to implement malloc, or the so called "heap".mmap is also used to load dynamically loaded libraries into the program's memory so that it can access and run it.Stack allocation: stackoverflow.com/questions/17671423/stack-allocation-for-process
Calculating exact addresses Things are complicated by:
- Address Space Layout Randomization.
- the fact that environment variables, CLI arguments, and some ELF header data take up initial stack space: unix.stackexchange.com/questions/145557/how-does-stack-allocation-work-in-linux/239323#239323
Why the text does not start at 0: stackoverflow.com/questions/14795164/why-do-linux-program-text-sections-start-at-0x0804800-and-stack-tops-start-at-0
x86 Paging Tutorial Sample code Updated 2025-07-16
Minimal example: github.com/cirosantilli/x86-bare-metal-examples/blob/5c672f73884a487414b3e21bd9e579c67cd77621/paging.S
Like everything else in programming, the only way to really understand this is to play with minimal examples.
Cycling in the United Kingdom Updated 2025-07-16
The United Kingdom is a great place to cycle in general as there's plenty of small country roads and interesting new small towns to discover, perhaps much like the rest of Europe, as opposed to the United States, which likely has some huge infinitely long straight roads with a lot of nothing in between.
Of particular interest is the large amount of airfields and small air raid shelters in the fields, an ominous reminder of world war 2. The airfields are in various states, from functional military fields, many converted to civilian usage, some have barely any tarmac left but still see usage. And some were just completely abandoned and decayed and became recreation grounds and farms. The UK is therefore also a great place to be if you want to learn to fly as a hobby!
Good starting point:
Next, you want to decide about nice destinations to reach/go through, and these are good ideas to look into:
- Area of Outstanding Natural Beauty
- National Trust
- Royal Society for the Protection of Birds (RSPB)
Cysteine Updated 2025-07-16
Intel GPU Updated 2025-07-16
Python
__getitem__ Updated 2025-07-16 Spherical harmonic Updated 2025-07-16
Correspond to the angular part of Laplace's equation in spherical coordinates after using separation of variables as shown at: en.wikipedia.org/wiki/Spherical_harmonics#Laplace's_spherical_harmonics
D Updated 2025-07-16
Dance of the Yi People Updated 2025-07-16
Composed by Wang Huiran in 1960.
The Yi people are one of the 55 Chinese ethnic minorities officially recognized by the Chinese government.
Dance of the Yi People performed by Liu Dehai
. Source. From the album Chinese Plucked Instruments: Vol. 2 - Fishermen’s Song At South Sea: www.amazon.co.uk/Chinese-Plucked-Instruments-Fishermens-South/dp/B001HUECZQ (2004) Dan Dascalescu Updated 2025-07-16
This dude is interesting. Quite crazy type. It is hard to differentiate genius from mad.
Ciro Santilli bumps on his Stack Overflow from time to time: stackoverflow.com/users/1269037/dan-dascalescu.
Dan Kaminsky Updated 2025-07-16
Database trigger Updated 2025-07-16
Schön scandal Updated 2025-07-16
One is reminded of Nick Leeson.
One things must be said: the root cause of all of this is the replication crisis.
This is why he managed to go on for so long.
Angular.js Updated 2025-07-16
Unlisted articles are being shown, click here to show only listed articles.