Carl-Philip Hänsch – Seite 8

MemCP: First SQL Query is correctly executed

MemCP now executed its first SQL Query:

Bitcoin – The Harder Drive

In this blogpost, I want to show you a video that in a very humorous way explains the stupidity behind bitcoin:

Walnut AI – a CPU-optimized AI neuronal network

Our brain is shaped like a walnut. And that’s for a reason.

Accessing MemCP via scheme

MemCPs native access technology is the scheme scripting language.

Writing a SQL parser in scheme

Functional programming languages are a neat tool to write parsers, especially when equipped with a pattern matching mechanism.

How to benchmark a SQL database

To compare databases against each other, a benchmark like TPC-H is used.

When the benchmark is too slow… (golang http server performance)

Just a shmankerl from the daily life of a developer.

On Compressing NULL values in bit-compressed Integer Storages

Usually, databases store NULL values in form of bitmasks. In this case, each value eats up 1 bit for the possibility to become NULL. I will prove that we can do better.

memcp: Eine OpenSource hochperformante Spaltenbasierte In-Memory-Datenbank als Alternative zu proprietären analytischen Datenbanken

In den letzten 13 Jahren gab es eine Menge Innovationen im Bereich spaltenbasierte Datenbanken. Zu verdanken ist das vor allem einem deutschen ERP-Hersteller, der sich entschieden hat, sich vom Datenbank-Marktführer abzusetzen und sein eigenes Ding zu machen. Es wurde zu einer Erfolgsstory. Zeit, dass OpenSource nachzieht.

Memory-Efficient Indices for In-Memory Storages

Most databases implement indices as a kind of tree. I will show you that columnar storages can do even better.

Autor: Carl-Philip Hänsch