Facebook was using MySQl 5.6 and missed out many improvement in 5.7 and especially 8.0. Their MySQL 5.6 also has 1700 code patches need to port to 8.0 version too. Given the scale of Facebook, upgrading database like this is huge and difficult.

The Zip file format is now 32 years old. You’d think being 32 years old the format would be well documented. Unfortunately it’s not.

Another database related migration. NoRedInk wanted to re-architecture their core engine to reduce MySQL load. Previous attempt to rewrite that engine failed and had to rolled back. To make it worth, they don’t quite trust their test either. So how they approach to rewrite the core business logic in a more peformance way?

On March 23rd Taras was honored to present at PAC HERO FESTIVAL 2021 their favorite append-only design property. The recording is available on YouTube and this article contains some of its highlights

Instead of returning rows from the database, initialize data structure on your app then serialize them to JSON string, you can ask Postgres to just return JSON and cut out all the middleware access.

In this post, we’ll explore at a high level the key concepts and defining characteristics of video codecs. Then, to further demystify them, we’ll even implement one from scratch in about a hundred lines of Rust.

executables always seemed like black magic to me. I always wondered how stuff worked under the hood, and how binary code is represented inside .exe files, and how hard it is to modify this ‘compiled code’ without access to the original source code.

I think among scripted language, Python has a very powerful import system. You can do relative import, parent import with .., and root import with ... (yes, three dot if you are unfamiliar) and full path import. Once import an object, you can name it anything using import ... as. Even if you aren’t using Python, read to understand how those import/require/include mechainisms work