a database need to read and write data from disk in an efficient manner. And the answer to that is: buffer pool. In this post, we’ll explain how a buffer pool manager works and how to implement one in Go

The most important thing to know about client-side HA is that when a failover happens, the connections to Postgres are lost. Your application will get an error when trying to use the previously established connection, without any way to anticipate the situation.

What exactly the database does during a transaction? How it writes to disk? How it accesses memory? How is checkpoint is created and managed. Even if you aren’t using MySQL, it’s still worth a read.

pull, commit and push are probaly most used git command. To be efficient, productive and wield the full power of git however, one needs to know a few more commands and tricks. We will explore some of the easy to use, remember and configure features of git, that might make your time dealing with version control so much more enjoyable.

Subqueries are a SQL feature that allow writing queries nested inside a scalar expression in an outer query. Using subqueries is often the most natural way to express a given problem, but their use is discouraged because most databases struggle to execute them efficiently. This post gives a rough map of existing approaches to optimizing subqueries and also describes how Materialize differs from them.

In JS, you can call function without passing a full arguments, that bring flexibility but come with a performance cost It turns out that, with a clever trick, we can remove this extra frame, simplify the V8 codebase and get rid of almost the entire overhead. We will learn about that today

Look into the techniques that empower JavaScript to rank higher in techempower benchmark. Note that the techniques are optimized for benchmark, don’t expect those numbers/techniques in your normal workflow/framework.

An interesting and weird encryption scheme of Synology NAS due to they cannot force HTTPS on local lan.

A 114 pages PDF file. I think it’s interesting to gain some low-level knowledge of memory. Sometime I tried to gain this kind of knowledge by searching all over the internet and glue them together. It’s great to have this single PDF file I can look into now.

A curated collection of publicly available resources on how technology and tech-savvy organizations around the world practice Site Reliability Engineering (SRE)