Programming Digest #471: Changing Tires at 100mph: A Guide to Zero Downtime Migrations
#471 — May 09, 2022 | View in browser |
Programming Digest
Spread the word, build the community, share the knowledge with your friends.
sponsor
SSRF Attack Examples and Mitigations
Server-Side Request Forgery along with XSS and CSRF are some of the most serious web security vulnerabilities due to pervasiveness and impact. Strengthen your cybersecurity IQ with these attack and mitigation examples.
this week's favorite
Changing Tires at 100mph: A Guide to Zero Downtime Migrations
As a backend developer at a mobile app company, a common task was migrating a database schema. This could be to improve query performance, change column names/types, or adapt data to new use cases. While this may seem like a straightforward set of SQL commands, it becomes a complex choreographed dance to be achieved with zero downtime.
Modern Microprocessors - A 90-Minute Guide!
Okay, so you're a CS graduate and you did a hardware course as part of your degree, but perhaps that was a few years ago now and you haven't really kept up with the details of processor designs since then.
For the vast majority of my programming career, I've been a mainstream developer. By mainstream, I mean writing in a language and using the tools that most of the category of software development I have been in (mostly web development) has used, such as PHP, JavaScript, and the most popular tools of those ecosystems.
When it comes to code reviews, it’s a common phenomenon that there is much focus and long-winded discussions around mundane aspects like code formatting and style, whereas important aspects (does the code change do what it is supposed to do, is it performant, is it backwards-compatible for existing clients, and many others) tend to get less attention.
The worst bug I've ever worked on – randomly losing our best players
Imagine discovering a serious bug in production immediately after releasing your game. Imagine this bug hurts only your paying customers. Imagine it freezes the game immediately after players complete an in-app purchase. Imagine that when the player restarts, the game freezes during start-up. Imagine the player can never get unstuck and has to uninstall the game. Imagine your app is currently featured on the Apple Store. This is a story of such a bug, the worst bug I have ever dealt with in 30 years of programming. This is a story of how we tracked it down and worked with Unity to fix it.
how did you like this issue?
1 = didn't like it at all and 5 = loved it and shared it with everyone I know
newsletters

Older messages
Programming Digest #470: Writing code is one thing, learning to be a software engineer is another
Sunday, May 1, 2022
And more news, tutorials and articles about programming and technology in this week's issue. #470 — May 02, 2022 View in browser Programming Digest Hello, 👋 I've launched Daily Tech newsletter.
Programming Digest #469: Writing for engineers
Sunday, April 24, 2022
And more news, tutorials and articles about programming and technology in this week's issue. #469 — April 25, 2022 View in browser Programming Digest Spread the word, build the community, share the
Programming Digest #468: Inside the longest Atlassian outage of all time
Sunday, April 17, 2022
And more news, tutorials and articles about programming and technology in this week's issue. #468 — April 18, 2022 View in browser Programming Digest Spread the word, build the community, share the
Programming Digest #467: RFC 9225: Software defects considered harmful
Sunday, April 10, 2022
And more news, tutorials and articles about programming and technology in this week's issue. #467 — April 11, 2022 View in browser Programming Digest Spread the word, build the community, share the
Programming Digest #466: Please put units in names
Sunday, April 3, 2022
And more news, tutorials and articles about programming and technology in this week's issue. #466 — April 04, 2022 View in browser Programming Digest Spread the word, build the community, share the
You Might Also Like
Import AI 399: 1,000 samples to make a reasoning model; DeepSeek proliferation; Apple's self-driving car simulator
Friday, February 14, 2025
What came before the golem? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Defining Your Paranoia Level: Navigating Change Without the Overkill
Friday, February 14, 2025
We've all been there: trying to learn something new, only to find our old habits holding us back. We discussed today how our gut feelings about solving problems can sometimes be our own worst enemy
5 ways AI can help with taxes 🪄
Friday, February 14, 2025
Remotely control an iPhone; 💸 50+ early Presidents' Day deals -- ZDNET ZDNET Tech Today - US February 10, 2025 5 ways AI can help you with your taxes (and what not to use it for) 5 ways AI can help
Recurring Automations + Secret Updates
Friday, February 14, 2025
Smarter automations, better templates, and hidden updates to explore 👀 ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The First Provable AI-Proof Game: Introducing Butterfly Wings 4
Friday, February 14, 2025
Top Tech Content sent at Noon! Boost Your Article on HackerNoon for $159.99! Read this email in your browser How are you, @newsletterest1? undefined The Market Today #01 Instagram (Meta) 714.52 -0.32%
GCP Newsletter #437
Friday, February 14, 2025
Welcome to issue #437 February 10th, 2025 News BigQuery Cloud Marketplace Official Blog Partners BigQuery datasets now available on Google Cloud Marketplace - Google Cloud Marketplace now offers
Charted | The 1%'s Share of U.S. Wealth Over Time (1989-2024) 💰
Friday, February 14, 2025
Discover how the share of US wealth held by the top 1% has evolved from 1989 to 2024 in this infographic. View Online | Subscribe | Download Our App Download our app to see thousands of new charts from
The Great Social Media Diaspora & Tapestry is here
Friday, February 14, 2025
Apple introduces new app called 'Apple Invites', The Iconfactory launches Tapestry, beyond the traditional portfolio, and more in this week's issue of Creativerly. Creativerly The Great
Daily Coding Problem: Problem #1689 [Medium]
Friday, February 14, 2025
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Given a linked list, sort it in O(n log n) time and constant space. For example,
📧 Stop Conflating CQRS and MediatR
Friday, February 14, 2025
Stop Conflating CQRS and MediatR Read on: my website / Read time: 4 minutes The .NET Weekly is brought to you by: Step right up to the Generative AI Use Cases Repository! See how MongoDB powers your