Exploring the Global Reach and Unique Development of SQLite | January 18 2025, 17:00

Discovered a plethora of interesting facts about SQLite. For those unaware — it is likely the most widespread database in the world. It’s utilized everywhere: from smartphones to cars and rockets. The scale of deployment — over _a trillion_ instances, billions of active copies worldwide. In your phone, dozens of applications use it.

Initially, SQLite emerged from the need to ensure reliable database operations on the USS Oscar Austin destroyer.

It is supported by _three people_. They do not admit external contributors. You can’t just send a pull request and hope the patch will be approved. SQLite’s development is backed by the company Hwaci. Interestingly, they seem to be involved in music too. Their website is extremely succinct. Office in a private house.

For each line of SQLite code, there are over 600 lines of test code. Tests cover 100% of branches (and 100% MC/DC) of the library. The test suite is highly diverse, including fuzzing tests, boundary value tests, regression tests, and tests simulating operating system crashes, power failures, I/O errors, and out-of-memory errors. Originally, SQLite was an extension of Tcl, and its main test suite is written in Tcl.

Interestingly, some SQLite tests are proprietary. The TH3 (Test Harness 3) test suite, which provides one hundred percent code branch coverage, is proprietary, and access to it is restricted.

I know of no other project that is open-source yet has paid tests.

To gain access, one must join the SQLite Consortium with an annual membership fee of 120 thousand dollars.

This is an interesting business model. Developers generate profit through licenses, paid support, service maintenance, consortium membership, and commercial extensions.

SQLite does not have a Code of Conduct (CoC); instead, they use a Code of Ethics derived from the “kinds of good deeds” from chapter 4 of the Rule of Saint Benedict. Google SQLite Code of Ethics, it’s a very intriguing document.

At the beginning of all source files, instead of legal notices, there is a blessing: “In place of a legal notice, here is a blessing: May you do good and not evil…”

SQLite creator Richard Hipp (D. Richard Hipp, DRH) couldn’t find any version control system that suited him, so he created his own called Fossil. Of course, Fossil is based on SQLite.

It reminded me of how Linus wrote Git.

DRH also wrote his own parser generator called Lemon.

All the above is described in more interesting details (and expanded) in an article on Habr, which is a translation into Russian of an article by Avinash Sajjanshetty. For originals — check the comments

Revolutionary Tales in Print: Gutenberg, Luther, and the Dawn of Mass Communication | January 18 2025, 00:18

Excellent! Why haven’t I heard of Ivan before? Such a cool interview. There’s so much that I want to quote. Here’s almost a random excerpt that I liked:

“…I like to give the example of a ‘startuper’ named Johann Gutenberg. Yes, by today’s standards, he would be a CTO. He invented the printing press, he invented printing technology, which is a technology that made it possible to disseminate information on a scale that was previously impossible. Then radio became that kind of technology, then television, then the internet. There he made the printing press, but he wouldn’t have ‘gone far’ with his press alone. There are examples of people who made similar printing presses but didn’t become as famous.

So what was the trick? He found himself a good CEO. This CEO lived nearby. Martin Luther. He came to Gutenberg, looked at the press and said: ‘We’ll print the Bible because it’s unclear what else to print.’ And Gutenberg says, ‘Fire, what an idea!’ They started printing the Bible in Latin, but people didn’t read it, it was unclear what was written. Let’s translate it, – yes, the CEO says: ‘We need to print the Bible in German, then it will sell well.’ You know, wait, people are illiterate. The CEO thinks we need pictures, so they went to a designer. What was the designer’s name? His name was Dürer, he also lived nearby in the same city. He drew engravings, the engravings in the Bible went down well with those who couldn’t read, and the texts went down well with those who could. And then Luther went to sell it. Well, to give out, to sell, here the story varies, but one way or another – boom, just an explosion, a new technology! People started to think on top of it: ‘Okay, the Bible is cool, but everyone has already bought the Bible, what will be our next theme?’ Yeah, kind of, and then someone gets carried away and says: ‘Ho, a book ‘How to recognize a witch’. That’s a theme that really takes off. A lot of people died because the books ‘How to recognize a witch’ spread mass. Essentially, fake news’.”

This is certainly a beautiful story, but Luther and Dürer were born several years after Gutenberg’s death, which Ivan definitely knows, but with this fact, the beautiful story just doesn’t hold up.

UPDATE: Ivan replied to my comment on YouTube: “…I actually got it mixed up. Lisa and the team added a clarification, and I wrote about this in response to another comment. I meant Hans Lufft and Cranach. They worked with Luther. The first printed, the second illustrated.”

Also, I can’t remember whether it was him or Ilia Strebulaev from a recent ‘Editors’ video, mentioned that in the early years of Google as a startup, there were already search engines on the market, but Google eventually displaced them all and now holds 93% of the market. I tried to recall what these search engines were, and besides AltaVista and Yahoo, nothing much came to mind. Guess I’m not old enough yet. Started researching. Besides altavista (1995-2013), these were lycos, excite (1994), infoseek (1995), hotbot (1996), webcrawler (1994-2001), ask jeeves (1996), yahoo (1994).

Definitely listen to Ilia Strebulaev too. He talks about venture in the Valley.

https://www.youtube.com/watch?v=TxBBzRp0lcM

Discoveries Underwater, Online, and Under Anesthesia | January 16 2025, 22:18

Some novelties for me. Sharing, as they’re likely new for you too. About bulbous bows on ships, about how the body of water under the Paris Opera from “The Phantom of the Opera” actually exists, about how 70% of all global internet traffic passes by my house, and about how no one really knows how general anesthesia or paracetamol works.

= First Discovery =. Large ships may have this thing in front, called a bulbous bow. I didn’t understand what it was for, it seems to disrupt hydrodynamics. Turns out, it’s quite the opposite. It improves it. It creates a counter wave that partially offsets the main bow wave occurring when the ship is moving — especially at high speeds and for large vessels. Each ship’s bulb is designed individually.

= Second Discovery =. Remember “The Phantom of the Opera”? There was a body of water under the Paris Opera where Erik and Christine sailed. Well, it’s not fictional. There really is a body of water beneath the Paris Opera House.

The opera house required a much deeper basement space beneath the stage than other types of buildings, but the groundwater level turned out to be unexpectedly high. In February 1862, wells were drilled and in March eight steam pumps were installed, which operated around the clock, yet the site remained damp. To solve this problem, Garnier designed a double foundation to protect the structure from moisture. The design included waterways and a huge concrete tank (cuve), meant to reduce the pressure of the external groundwater on the basement walls and to serve as a reservoir in case of fire. The construction contract was signed on June 20. Soon, a persistent legend arose that the opera house was built over an underground lake, inspiring Gaston Leroux to include this idea in his novel “The Phantom of the Opera”.

= Third Discovery = Of course I knew it was a lot, but today I saw the number — 70% of internet traffic passes through a place just about 10 minutes from where I live. Around me, more than 130 data centers have been built covering an area of three million square meters. Quite a thrilling neighborhood. I hope no ill-wishers will mark this place on the map with a cross. This cluster specifically consumes about 150 TWh, which by my estimates is like ___THREE MOSCOWS___.

= Fourth Discovery = It turns out that no one really knows how general anesthesia works. There are theories in Wikipedia on how anesthesia functions. But though they exist, none of them is completely convincing. In 2019, it was found that human-like anesthesia even works on plants, like on a mimosa and on a venus flytrap—they stop responding to touch under it. Not to mention, as everyone knows, plants don’t have a central nervous system at all. Not a brain, not even neurons. There’s also xenon anesthesia. Meaning, it’s fundamentally an inert substance, doesn’t react with anything, but somehow works. They recently figured out how aspirin works, but there’s still no full understanding of paracetamol.

Exploring the iBot: A Leap in Personal Mobility Technology | January 11 2025, 00:34

Today I finally made it to the exhibition Paris 1874: The Impressionist Moment – over an hour in line. Nadya says – look at that interesting wheelchair.

Nadya and I had been wheeling her dad around for many years. He fell ill, ended up without legs, and the wheelchair literally became an extension of him in everyday life. Just your “basic” wheelchair. We took him to the Black Sea by car several times, traveled abroad, and of course experienced all the “delights” of accessibility in Russia. Actually, I don’t even know how to translate “accessibility” into Russian properly. “Barrier-free environment”? It was not barrier-free, it was downright threateningly barriered. For example, we simply couldn’t get to the doctor at the clinic because the elevator was too narrow.

So, back to the wheelchair in the photograph. It’s the iBot by Mobius Mobility. It’s no longer customary to call them “wheelchairs,” it’s a “personal mobility device.” It operates both in balancing mode, where only two wheels are used — essentially, like a Segway, and in a four-wheel mode when terrain handling is needed. In two-wheel mode, the seat raises to a height of 91 cm, allowing the seated individual to be more or less at eye level with others. It also has a mode for climbing/descending stairs — that’s really cool. The range is 35 km in balance mode.

The iBot was invented by the same guy who invented the Segway — Dean Kamen. Overall, this startup is several years old, with several generations of the iBot already released.

Yes, the price of such a device ranges from 32 to 40 thousand dollars. Quite a lot. But it’s said that about half can be covered by insurance (still a lot, though).

There are a few people around us in wheelchairs. And there were few in Russia too. But in Russia, there were few because they just couldn’t leave the house, and each outing for the family or companion turned into a project that would be good to plan in advance. Here in the USA, there are few for another reason. Here, in case of problems, they don’t just hand out a wheelchair, they give a new leg or a new joint. And only if it’s completely irrepairable, then they resort to a wheelchair. Yes, such operations can cost a fortune for people without insurance, it’s a known problem, but usually, some charitable foundations are found.

For example, near our house is the organization ECHO (Every Citizen Has Opportunities). Besides helping financially with adjusting to a new way of life, they offer jobs to people who land in such trouble, they also provide free transportation (to work, to the store, etc.) and socialization.

Exploring the Boundaries of AI in Dreyfus’s Pioneering Work | January 10 2025, 01:40

Currently skimming through a book, Dreyfus (1972) – What Computers Can’t Do – The Limits of Artificial Intelligence. In it, across 300 pages, the author convincingly, with numerous references to scientific papers, argues that, for example, programming a chess game is impossible, and intuitive and situational human tasks, such as understanding natural language, are even more profoundly unprogrammable.

The conclusion of the book is that instead of striving for complete autonomy, AI researchers should focus on enhancing human intelligence and exploring the fundamental differences between human and machine minds. They should probably read this book first.

And 53 years later, I am using AI to translate and extract key ideas from this book.

Hubert Dreyfus passed away 7 years ago. Overall, he probably began to suspect long ago that things were not as he had written in the book, because in 1992 he wrote a second series “What Computers Still Can’t Do”.

But the funniest thing is that the 1972 book was printed in Russian in 2010 and can be purchased; it is still widely sold on “Ozone” for 976 rubles. Labeled as NEW!

Snowfall and Monsters: Unveiling the Apocalypse Hellfire 6×6 | January 06 2025, 14:19

We had snowfall, and monsters began to appear on the roads.

This is the Apocalypse Hellfire 6×6, a product of Apocalypse Manufacturing. It’s based on a Jeep Gladiator with an 800 horsepower engine. Overall, Apocalypse has quite a lot of different designs, and they are all superb from a design standpoint.

In terms of brutality and design, the renders on the website look somewhat better than this particular instance. Perhaps the workshop invests more into aesthetics each year, and on the road, we encountered something from “past collections.”

Plumbing Repairs | January 03 2025, 17:12

Called a plumber for the first time in nine years of living in the USA (yesterday marked exactly nine years!). A threaded connection at the entrance to the water heater burst. Forked out almost 500 bucks for the repair. No birthday discounts were available. Watched the process. Noticed a new tool I hadn’t seen before. It’s a portable pipe press. Asked about it. Costs $4500. The technician says he has three more, slightly different in size and purpose, totaling nearly 10K. Greatly speeds up installation and generally increases reliability due to the absence of threaded connections (though, if something happens, again you’ll need a technician with cutting and crimping equipment).

Tea Selection Disappointment at Wegmans | December 21 2024, 00:00

There is a wide variety of teas at our Wegmans. Here in the photo are all the teas from left to right. But, there’s not a single loose leaf tea. Only various teas for weight loss, in bags, some grains in jars labeled tea. However, a tea ball is sold in the same section — for brewing loose leaf in a cup, and I bought one. But you have to specifically look for loose leaf tea. It’s not popular in the USA.

Surveillance and Society: Insights from Nexus by Yuval Noah Harari | December 20 2024, 00:59

I’m currently reading Yuval Noah Harari’s “Nexus,” where an interesting story about a Romanian computer scientist named George Iosifescu is described (see my previous notes on the topic – #raufnexus). In 1976, Iosifescu came to his office and found a man sitting at his desk. Iosifescu introduced himself, but the man did not respond. He went about his business while the man just quietly sat, watched the computer screen, and made notes. Overall, it was apparent that he had arrived from the Romanian secret police.

It’s intriguing to look at work through the eyes of this agent. Imagine you have breakfast and then go spend your entire day in someone else’s office in silence, jotting things down. And so for thirteen years! Thirteen, Karl!

For thirteen years, Iosifescu came to work, and the man was always there, at the desk, to observe and record something. It all ended only with the fall of the Romanian government. Harari writes that Iosifescu never found out the man’s name.

But if you think about it, by 2024 we essentially have the same situation, only our agents are digital, numerous, and the data they collect are somewhat scattered and disconnected. Harari quite rightly notes that we are approaching the moment when a pervasive computer network will be able to monitor the population of entire countries around the clock.

Harari also has an interesting story about the mass collection of handwriting samples in Romania. When the Romanian regime discovered anonymous letters criticizing them, sent to Radio Free Europe, Ceaușescu ordered handwriting samples to be collected from all 20 million citizens. Students wrote essays, and adults wrote autobiographies, which were then passed to the Securitate archives. Even typewriter owners were required to register them and provide sample texts.

It’s interesting—they collected them, but how were they supposed to search through such a volume of information? It was probably not intended at all. Perhaps this database was used to create evidence—if someone was suspected, data from various databases were collected about them, and attempts were made to use it in their case. If something accidentally or not coincidentally matched, then that’s it, case closed, person imprisoned.

* * *

I also liked the idea of information networks.

In tribal societies, where there were no written documents or bureaucracy, the human network consisted only of two chains:

1) “person-person” and

2) “person-story” (forming the chain person-story-person).

Power belongs to those who control the nodes connecting different chains. These nodes are the tribe’s foundational myths. Charismatic leaders, orators, and creators of myths were adept at using these stories to shape identity, create alliances, and impact emotions.

In human networks associated with written documents and bureaucratic procedures, society is partly based on interactions between people and documents. In addition to the chains “person-person” and “person-story,” such societies are held together by the chains “person-document.”

Thus, there are three types of chains:

1) person-person

2) person-story

3) person-document

This has led to changes in the distribution of power. Since documents became an important node linking many social chains, significant power was vested in them, and experts in the complex logic of working with documents became new authoritative figures. Administrators, accountants, and lawyers mastered not only reading and writing skills but also the ability to create forms, organize archives, and manage bureaucratic processes.

The person-person chain can be related to the family, the person-document—to the church.

But there are two more chains that have emerged quite recently:

4) computer-person

5) computer-computer

An example of “computer-person” includes social networks like Facebook and TikTok. These chains differ from traditional “person-document” chains because computers can use their power to make decisions, create ideas, and deeply manipulate proximity to influence people in a way that no document could. The Bible has had a profound influence on billions of people, even as a silent document. Now imagine a sacred book that can not only speak and listen but also recognize your deepest fears and hopes and continuously shape them. Indeed, algorithms on social networks (and not only), according to Harari, can influence human behavior on their own, not because the authors of these algorithms embedded such behavior in them. A good example is the accusations against Facebook for inciting hatred in Myanmar, as the social network promoted posts that gained popularity, which were actually about genocide.

Secondly, Harari writes, “computer-computer” chains are emerging, in which computers interact with each other autonomously, and this interaction is rapidly gaining complexity, which can no longer be untangled without the help of other algorithms. Algorithms of this interaction were developed and debugged on volumes that were still understandable and could be troubleshooted, but then it starts “magic”. An example is trading bots and algorithmic trading in general, and for instance, the “flash crash” of 2010, when the U.S. stock market crashed by trillions of dollars within minutes, only to recover just as quickly. The causes of this flash crash were later found, but it was not easy (and there were several reasons).

#raufnexus

Upgrading to Kukirin G2 Max: A New Chapter in Electric Mobility | December 19 2024, 17:49

Updated the electric ride. Now, the old (dead) ecoreco l5+ will head to the dump, and the new kukirin G2 Max will take its place. 1000W, claims a range of 80 km on a single charge, but realistically, if it gets 30-35km with my weight, that would already be very good. People on Reddit write 20% battery for every 10km. Rides swiftly, can accelerate up to 55km/h, but again, weight, terrain, slope, and a sense of self-preservation matter. By the way, it handles grass and other irregularities quite well. The previous one couldn’t at all.