Build your own Anycast network in 9 steps
Anycast allows you to have same IP address round to different node depend on geo location, This is the kind of guide I wish I know earlier. It’s very practical on how you can run that kind of network yourself, from registering ASN, acquire IP address, find BGP hosting… It can cost zero if you use IPV6 :). That’s the cool thing that you can literally experiment with this kind of tech at very low cost
Distributed Locking with Postgres Advisory Locks
Postgres Advisory Locks are a great solution for arbitrary application locks, particularly in scenarios where you are already using Postgres and have a need to block concurrent mutations to a resource (that resource DOES NOT have to be data in Postgres).
Tricking Postgres into using an insane – but 200x faster – query plan
An optimization story, which is interesting because both the before and after query plans will look somewhat ridiculous (in terms of cost). Moreover, it shows how PostgreSQL row count estimation can go very wrong. In this case, domain knowledge will help us trick PostgreSQL into a different query plan which will be waaay faster, without adding any additional indices.
UK COVID-19 dashboard built using Postgres and Citus for millions of users
This post is a deep dive into how the UK Coronavirus analytics dashboard came to be, and why it’s architected the way it’s architected. In this post you’ll learn about the database challenges the team faced as the dashboard needed to scale—with an eye toward how the UKHSA team uses Azure, the Azure Database for PostgreSQL managed service, and the Citus extension which transforms Postgres into a distributed database.
Five Easy to Miss PostgreSQL Query Performance Bottlenecks
PostgreSQL query planner is full of surprises, so a common-sense approach to writing performant queries is sometimes misleading. In this blog post, I’ll describe examples of optimizing seemingly obvious queries with the help of EXPLAIN ANALYZE and Postgres metadata analysis.
Roblox October Outage Postmortem
Starting October 28th and fully resolving on October 31st, Roblox experienced a 73-hour outage. At scale of Roblox, 73 hour outage is huge. They deep dive into what happen. One great thing is Roblox run their own hardware and will continue to do so instead of moving to cloud.
dude, is my code constant time?
Non-constant time crypto code is dangerous. Exactly 20 years ago Kocher presented the first timing attack on a cryptographic implementation. Since then, a long list of implementations have been broken by timing attacks.
Code to read
a very simple pure key => value storage system that speaks Redis protocol with Postgres as storage engine and more
A library and language for building parsers, interpreters, compilers, etc.
an open source, self-hosted alternative to Trello, Notion, and Asana
Guide your users through a tour of your app
Monitor, optimize and configure multiple PostgreSQL instances.
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this