24 December 2023

26 links · Sunday

How does B-tree make your queries fast?

B-tree is a structure that helps to search through great amounts of data. It was invented over 40 years ago, yet it is still employed by the majority of modern databases. Although there are newer index structures, like LSM trees, B-tree is unbeaten when handli…

Costs of running a macOS app studio business - Alin Panaitiu

I created The low-tech guys, a brand under which I develop macOS apps for a living. I started this business with a good friend of mine, thinking I could help him stop working long hours at his consulting job and ease into more creative work. However, getting t…

.http Files in Visual Studio

The Visual Studio 2022 .http file editor provides an easy way to test Web APIs directly on Visual Studio, without needing to switch to…

Can Microsoft Flight Simulator help me learn to fly (or make me a better pilot)?

Microsoft Flight Simulator has "flight lessons" with a virtual flight instructor, some of which teach concepts that are taught during actual flight training. These simulators are becoming very real...

12 Days of Geekmas

The 12 Days of Geekmas!

Detecting FTL travel with LIGO

TL;DR: a warp trip will show up on a gravitational detector because the space ship’s mass instantly disappears and later re-appears somewhere else. Enterprise at warp. Copyright Paramount Com…

Ownership in the digital age

Digital economy has taken over and with this we need to reevaluate what it means to actually own something. In this article I try to present my definition of ownership and what results from it.

Ask yourself dumb questions – and answer them!

Don’t just read it; fight it! Ask your own questions, look for your own examples, discover your own proofs. Is the hypothesis necessary? Is the converse true? What happens in the classical sp…

Bug story: Sorting by timestamp

While reviewing a co-worker’s results-paging design I realized there was a bug in some paging code I wrote1 a few years ago. It’s unlikely to manifest and kind of subtle, but I thought that describing it here might be useful to others writing such code (includ…

klev - blog

klev - message streaming, storage and processing platform. Learn everything klev - how to use it and for what.

Learning About Transaction Isolation Levels in Databases

I have been working at a database company for over seven years and I must admit I haven't quite figured out isolation levels yet. But I was in a meeting recently where we were discussing materialized views and snapshot isolation, and I just couldn't understand…

Indexing a billion pages

It’s two years since we launched Mwmbl, the open source, non-profit search engine, on Boxing Day 2021. A good time to take stock of where we are and where we’re going. We’ve indexed over 100 million pages Thanks to our volunteers, who crawl the web using the F…

Suno AI

We are building a future where anyone can make great music. No instrument needed, just imagination. From your mind to music.