How Buffer Pool Works: An Implementation In Go
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
Reconnecting your application after a Postgres failover
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.
MySQL Transactions - the physical side
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.
Advanced Git Features You Didn’t Know You Needed
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.
How Materialize and other databases optimize SQL subqueries
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
What Every Programmer Should Know About Memory
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.
How they SRE
A curated collection of publicly available resources on how technology and tech-savvy organizations around the world practice Site Reliability Engineering (SRE)
Code to read
RIMS is Ruby IMap Server. This gem provides a complete IMAP server by itself. The IMAP server can run as a daemon, mailboxes are provided and messages can be delivered to them
Scrape data from websites using Open Graph, HTML metadata & fallbacks
a collection of Python classes for working with network protocols.
a dynamically typed interpreted programming language written in Python
Command-line admin tool for observing and troubleshooting Postgres.
a framework for building tiny, blazing fast binaries for all major desktop platforms. Developers can integrate any front-end framework that compiles to HTML, JS and CSS for building their user interface. The backend of the application is a rust-sourced binary with an API that the front-end can interact with.
A fast HTTP enumerator that allows you to execute a large number of HTTP requests, filter the responses and display them in real-time.
The AWS exploitation framework, designed for testing the security of Amazon Web Services environments.
The simplest way to de-Google your life and business: Inbox, Calendar, Files, Contacts & much more
Open source vulnerability DB and triage service.
PostgreSQL log analyzer with fully detailed reports and graphs.
Easy email forwarding for your domain
Hanami is a service that allow you to forward email from your domain to personal email and sending email through your domain as well. You can also create unlimited alias on your domain and all of them will be foreward to your personal email.
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this