BetterDev #226 - Build your own Anycast network in 9 steps & UK COVID-19 dashboard built using Postgres and Citus for millions of users
Better Dev #226 Jan 25, 2022
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
Are you trying to establish a good end-to-end testing infrastructure at your company? This is how Facebook does it.
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).
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.
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.
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.
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.
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.
An book you can also read online to learn how to build JavaScript games with Kaboom.js
Code to read
a very simple pure key => value storage system that speaks Redis protocol with Postgres as storage engine and more
GoVideo
My email forwarding service uses Hetzner so it’s cool too see this, also great to peak into data center.
Tools
You can view this issue in web browser.
If you have any suggestion/feedback, do tell me by replying to this email. I read them all.
No longer want to receive these emails? Unsubscribe
Older messages
BetterDev #225 - Neural Network From Scratch
Monday, January 10, 2022
Better Dev #225 Jan 10, 2022 Neural Network From Scratch I'm a big fan of this Napkin Math newsletter. If you haven't subscribe to Napkin Math, you should do it. In this edition of Napkin Math,
BetterDev #224 - How a Single Line of Code Made a 24-core Server Slower Than a Laptop
Wednesday, January 5, 2022
Better Dev #224 Jan 4, 2022 How a Single Line of Code Made a 24-core Server Slower Than a Laptop Imagine you wrote a program for a pleasingly parallel problem, where each thread does its own
BetterDev #223 - Roll your own network and Cache Poisoning at Scale
Tuesday, December 28, 2021
Better Dev #223 Dec 27, 2021 Roll Your Own Network An extensive guide to self hosted many cloud service in your own network, from hardware to software to network configuration. All done by you. Cache
BetterDev #222 - How does NTP works and The team that powers VLC
Tuesday, December 7, 2021
Better Dev #222 Dec 07, 2021 Hi all, It's almost the end of year. BetterDev has been 3 years. I never focus on growing it. All I do is just send out newsletter from thing I think will help everyone
BetterDev #221 - How JavaScript engines achieve great performance
Tuesday, November 30, 2021
Better Dev #221 Nov 29, 2021 Hi all, It has been 3 weeks without an issue and I miss BetterDev myself. We're planning for some new release of a new version of BetterDev to also contribute useful
You Might Also Like
💎 Issue 410 - Being laid off in 2023-2024 as an early-career developer
Thursday, March 28, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 403 - Microsoft defends .NET 9 features competing with open source ecosystem
Thursday, March 28, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 403 Release Date Mar 28, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 410 - Node.js TSC Confirms: No Intention to Remove npm from Distribution
Thursday, March 28, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular Node.js news, articles and
💻 Issue 410 - JSDoc as an alternative TypeScript syntax
Thursday, March 28, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular JavaScript news, articles
📱 Issue 404 - Dependency Injection for Modern Swift Applications Part II
Thursday, March 28, 2024
This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 404 Release Date Mar 28, 2024 Your weekly report of the most popular iOS news, articles and projects Popular
💻 Issue 328 - My new open-source repository to schedule all your content!
Thursday, March 28, 2024
This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 328 Release Date Mar 28, 2024 Your weekly report of the most popular React news, articles and projects
📱 Issue 407 - Apple just announced WWDC24. The keynote for WWDC24 will be held on Monday, June 10th.
Thursday, March 28, 2024
This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 407 Release Date Mar 28, 2024 Your weekly report of the most popular Swift news, articles and projects
💻 Issue 405 - 2024 Edition Update
Thursday, March 28, 2024
This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 405 Release Date Mar 28, 2024 Your weekly report of the most popular Rust news, articles and projects
🤖 What to Expect From Google I/O 2024 — How to Stop Apps From Leaking Your Data
Thursday, March 28, 2024
Also: The Best Camera Straps of 2024, and More! How-To Geek Logo March 28, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by
Infographic | How Small Investments Make a Big Impact Over Time 📈
Thursday, March 28, 2024
Compound interest is a powerful force in building wealth. Here's how it impacts even the most modest portfolio over the long term. View Online | Subscribe Presented by: EnergyX's groundbreaking