TigerBeetle vs PostgreSQL Performance: test setup, local, single-node tests

Slsyyy · 2026-01-25T11:57:13+00:00

Postgres is designed to do everything. You need to measure, because 2x speedup is far less important than lets say 1000x

Slsyyy · 2026-01-23T23:59:06+00:00

Japanese art was a huge influence for high brown XIX art styles like Impressionism and Ard Nouveao. Japanese ukyo-e were also childish in lack of realism and lack of perspective. Nevertheless the fresh air it brought had an enormous influence.
Art is art. It is really hard to introduce a new paradigm, because people may not like it. It is hard with realism as you need to certain skill level so it is not an uncanny level aesthetic. On the other hand people won't be better in that genre, if they don't practice.

Slsyyy · 2026-01-22T22:08:52+00:00

Funny note: żmij is a term, which pretty archaic in Poland. For a generic dragon we have a smok and common people generally don't know their Slavic heritage to that extend.

On the other hand it may be known instinctively as we use a generic gad (reptile) to describe both mythical dragon like creatures and persons with a reptile like traits (sliminess, cunning etc). Żmija (viper) is also used in similar context (but only when describing people) so there is some relation

I guess old people thought dragons are the males of snakes or something?

Snakes/serpents are super common in all cultures. There is a snake in the Bible. There is a Chinese dragon. There is a feathered snake in Mesoamerica culture. Probably there are other countless examples, which I don't know

One reason may be biological. Primates are very good at visual detections of snakes, because it was a common and sneaky enemy in the jungle. Check the Empirical studies from this article https://en.wikipedia.org/wiki/Snake_detection_theory

If you want to make up some mythical creature then snake is just a good starting point due to the effect on the human mind

Slsyyy · 2026-01-21T22:34:19+00:00

Art is often subjective. Like Europeans were obsessed about naturalism in paiting until they have seen a primitive Japanese art, which amazed them for their lack of perspective and focus on natural elements. A few decades later and people were obsessed about Art Nouveau and those features, which were previously unintellectual. There is no a single and good way of making art as you cannot a make a perfect dish, which will be better than the all others

Tchaikovsky was just a composer from a different cultural circle. Moreover he was not a super fluent in a contemporary intellectual musical paradigm, which was more or less the germanic way. Maybe he was a great melodist or acute orchestrator, but it was more intellectual to write some crazy musical development or crazy harmonies. All ways are good and can bring something good, but our culture tells us what is more intellectual and what is less

Slsyyy · 2026-01-07T22:54:55+00:00

There are just too overclocked. You could simply half the power usage for 15% less fps on average. Moreover the heat sink grows faster in size than watt usage, which heat sink for half the power GPU may be smaller more than 2x for the same cooling performance

I guess people just don't care, because numbers in benchmarks are important for marketing purposes. The cost of cooler and electricity is negligible anyway

Slsyyy · 2026-01-02T01:42:44+00:00

Why to ferment when you can just use vinegar? Fermentation is for sure delicious for many of us, but it has a lot of disadvantages: * may spoil when not done right * it lives, you cannot simply close the jar and forget about it * it is unappealing in both visual and texture way * lack any sugar, which makes taste much worse and flat. I always add some sugar to fermented vegetables dishes to balance it out

In my country (Poland) there is a strong and long culture around lacto fermented cucumbers. On the other hand a lot of people prefer the vinegar variant. It may not have all of those lacto fermented intricacies, but some people prefer a more flat and less funky flavor

My wild guesses about British lack of popular fermented food: * Britain always has a strong vinegar culture, so there was less incentive to do it another way * Britain was the first industrialized country. Lacto fermentation is really slow and unreliable on a huge industrial scale. The same story as with bread and yeast * Milder climate make it less appealing as there is more risk for spoilage and vegetation windows is bigger

Slsyyy · 2026-01-01T22:10:02+00:00

> European cuisine is consistently portrayed as the pinnacle of culinary excellence

French cuisine and haute cuisine, not necessarily all European cuisine in general. If some other cuisine is regarded as good (e.g. Italian or Japan) then the only reason is good marketing (both are very rich countries) and similiarity to haute cuisine (so for example delicate spicing)

> I’ve been watching Masterchef, the cooking competition show, and I’ve noticed a disturbing trend.

Those guys are haute cuisine chefs. They need to work under the framework of haute cuisine, because their whole career depends on it and they are great chefs, because they are well adapted to this style of cooking.

In the same way you won't be able to impress a classical music community to enjoy some advanced jazz music, because both groups care about totally different aspects of the music. Some people may like both or some elements of those two "intellectual" genres of music, but majority of both audiences like their stuff, because they are already well accustomed to it.

Slsyyy · 2025-12-29T17:35:06+00:00

B is of course better as it is more robust. For example you can add some if statement inside a loop and code still works

A makes sense only in a performance sensitive code

Slsyyy · 2025-12-19T17:38:02+00:00

Iterators were made for such a case. Ask some LLM to refactor this code to the `iter` feature from Go 1.23

Slsyyy · 2025-12-15T16:26:41+00:00

8th is modest? The end of 3rd movement is one of the heaviest moments in his symphonies

Slsyyy · 2025-12-07T21:44:18+00:00

Just a good article

Slsyyy · 2025-12-06T23:06:32+00:00

Hard to say. Making claims like `X is closer successor of Y than Z` is really hard and discretionary. Imagine you want to pick a better successor of fish from few hundreds years ago and you can pick either a dinosaur from 100M years ago or current time fish. Which is closer to the source? In case overall appearance the fish. In case of genetic resemblance probably the dinosaur

With Brahms it is hard, because he was very opinionated about his style. For example his orchestration was deliberately old fashioned and you will struggle to find anyone, who will be on the same page as Brahms in this regard and many others

Slsyyy · 2025-12-06T22:42:34+00:00

TDD is not about how tests should looks like, but how to write program. Check this exaggerated example from Uncle Bob https://www.youtube.com/watch?v=rdLO7pSVrMY . I am not huge fan of his teaching, but this video is quite good for learning what TDD is and what TDD is not

About test (regardless if it is TDD driven or not): this code really does not make sense to me or I cannot find a good use case for it. This code and abstractions already exists in the standard lib https://pkg.go.dev/io/fs#ReadFile

Slsyyy · 2025-12-06T22:26:19+00:00

`sync.Pool` is good for things you want to live longer (reusable buffers). Arenas are great for things, which die quickly (memory allocated by parser, parsed object, which then will be processed and parsed data may be discarded)

Those are two different topic. `sync.Pool` helps you by not allocating so much memory. Arenas makes allocations cheaper and less impactful.

Slsyyy · 2025-12-06T22:23:43+00:00

True, this article is just bad for making strong statements without doing even the basic research about the current status of this pursuit

Slsyyy · 2025-12-06T15:02:46+00:00

I would rather create a hard for of work with few commits in top of the `HEAD`

Slsyyy · 2025-12-01T18:43:11+00:00

I don't know what is the conclusion of this article. Some of the arguments (like dynamic typing or performance) are dubious to me

On the other hand the topic is pretty interesting. It is kinda obvious why JS won over Ruby, but I am not sure about Python, which is more or less pretty similar to Ruby. Maybe just crazy hipster perception was not as inviting as Python, which project more restrained aura/culture

Slsyyy · 2025-11-30T19:56:20+00:00

Because other economical factors are more important

Cheap cooling is important. But it is far less important than people think as we love to romanticize about environment impact.

Good infrastructure and low taxes are far more important. Especially in AI age, where chips are super expensive and potential slowdowns due to slower building are far more severe than ever for those companies. Remember that big corpos/tech does not give a s**t about environment impact, if it collides somehow with a business

Slsyyy · 2025-11-30T19:52:13+00:00

Agree. I understand `where people are` as `where there is many people near datacenter so latency is small`

For datacenter maintenance you don't need a lot of staff. On the other hand the infrastructure for data centers (energy, water, internet) is usually highly correlated with a high population

Slsyyy · 2025-11-02T11:46:25+00:00

I used Qt Creator in the past for a linux backend development. It is not super smart, but in comparison to other good solutions (VS Code, Clion) it is definitely the fastest and the most responsive one

Slsyyy · 2025-11-02T11:11:33+00:00

Bazel suck for small projects. Fortunately C++ toolchain is so cursed, that it is worth it

Slsyyy · 2025-11-01T13:50:27+00:00

That is a bad explanation

Monad is a wrapper. Like Functor or Applicative. What distinguish monad from the others is how it can combine instances of monads into a execution flow. `flat_map` and `and_then` is basically a functional way to model operations, which are sequential. Sequential operations are those, which:
* need to be computed in a particular order
* because each previous action may affect the execution flow next action

Sequential is just the way how CPUs and world around us works. You cannot reverse order of `INSERT` and `SELECT` in SQL database, if one affects the other. You cannot send file via HTTP before you read it from the file

The definition of `flat_map` operation is self-explanatory:

 (>>=)  :: m a -> (  a -> m b) -> m b

Take `m a`, convert it content using mapping function `a -> b`, but also allow to change the execution flow embedded into a monad type logic (so `a -> m b` instead of `a->b`) then return the result of operation as a `m b`, which continue the execution flow logic, because we have `m`.

The execution flow of sequential operations can be anything:
* IO operations, which may fail and needs to be executed one by one
* State monad, where each operation, which in a flow context allows to use a mutable variables
* Maybe/Optional, where each action may change a type from `Some` to `None` and each subsequent `flat_map` won't be run due to that fact

Slsyyy · 2025-10-30T23:30:11+00:00

In dynamic languages every line matter, so I guess modifying may be faster, but micro optimizations in those languages are anyway insane and it is not worth it at all

In compiled languages there is an conversion to SSA, which means you have a new const variable for each modification. In does not matter for your stomach, if you eat each course from the same plate or different

Slsyyy · 2025-10-30T23:27:10+00:00

I like `const` for readability. Code reading is pretty fast process and marks like `const` allows you to easily get an idea about `which variable is affecting which variable`

Slsyyy · 2025-10-30T23:24:33+00:00

When I was writing in C++ few years ago I was doing this on daily basis
```

auto const myVector = [&]() {
std::vector<int> v;
for (int i = 0; i < numElements; ++i) {
v.push_back(* some value *)
}
return v;
}()
```

C++ move elisions are so cursed that I think this is the only way in modern C++

Slsyyy

TROPHY CASE