GeistHaus
log in · sign up

https://backend.how/index.xml

rss
15 posts
Polling state
Status active
Last polled May 19, 2026 03:21 UTC
Next poll May 20, 2026 03:04 UTC
Poll interval 86400s
ETag W/"8b11e5f999370e5d13a5fc829b1df7dd"

Posts

🦉 The Outbox Without an Outbox — Postgres Logical Messages as Eventbus
The outbox pattern asks for what replication already provides — durable, ordered, resumable delivery. Postgres' pg_logical_emit_message lets your application piggyback on that, walked line by line through factlib + OwlPost.
https://backend.how/posts/outbox-without-outbox-pg-logical-messages/
Archive
https://backend.how/archive/
🚂 Temporal — Under the Hood
What you’ll learn #

Durable execution engines like Temporal are increasingly how backend teams handle multi-step workflows — payments, order fulfilment, LLM agent loops, scheduled jobs. They make “run this 4-step thing, retry on failure, wait for a webhook on step 3” trivial to express in code. That’s the pitch.

The pitch makes the cost invisible. By the time you ship, your Postgres is handling an order of magnitude more queries than you expected, and you’re not sure why.

https://backend.how/posts/temporal-under-the-hood/
💸 1B Payments/Day - TigerBeetle & PostgreSQL

India moves money like no other country. By February 2026, UPI was clearing 20+ billion digital transactions per month — nearly half of all real-time payments on Earth.

Month Banks on UPI Volume (Mn) Value (₹ Cr.) Feb-26 694 20,394.18 26,84,229.29 Jan-26 691 21,703.44 28,33,481.22 Dec-25 685 21,634.67 27,96,712.73 Jan-25 647 16,996.00 23,48,037.12 Dec-24 641 16,730.01 23,24,699.91 Nov-24 637 15,482.02 21,55,187.40

Source: NPCI product-statistics

Put those numbers side-by-side: Jan 2025 to Jan 2026, volume jumped from 17B to 21.7B in a single year — 28% YoY growth, month after month. Bank count grew from 647 → 691. Rupee value from ₹23.48L Cr → ₹28.33L Cr.

https://backend.how/posts/1b-payments-per-day/
🏃 Running 101

tldr;

  • Set a clear goal.
  • Track your performance, focus on one metric at a time.
  • Vary your runs, but maintain consistency.
  • Maintain a consistent pace throughout your target run(s).
  • Focus on nutritions and strength training.
Setting Goals #

I am a 27-year-old software engineer writing in the year 2024. I spend most of my time sitting for work, and since grade 12, I’ve been aspiring to have a six-pack as it’s often seen as ‘cool.’ As a football fan, I’m aware that players typically peak between their late twenties and early thirties, with an analysis by The Athletic1 suggesting that the optimal age for different positions ranges from 27 to 31 years old. Thus, I set myself the goal of reaching peak physical fitness by my late twenties.

https://backend.how/posts/running-101/
🔧 Lost SSH Access to Ec2 ?

Losing SSH access to an Amazon EC2 instance can be a frustrating experience, especially when common solutions like EC2 Instance Connect or Session Manager are unavailable. In this blog post, we’ll explore a lesser-known but effective method to regain access by leveraging EC2 user data.

Why This Method Works #

EC2 user data is a feature that allows you to pass scripts or cloud-config directives to an instance at launch time. These scripts run with root privileges when the instance boots. By modifying the user data to include your SSH key, you can ensure that your key is added to the authorized_keys file of a specific user, granting you SSH access.

https://backend.how/posts/lost-ssh-access-to-ec2/
🏎️ Building pre-owned Car Platform With Valkey - Part 2

In Part 1 of our series, we explored the foundational aspects of our platform’s performance optimization. We began by defining our business model, which combines a marketplace and inventory system to facilitate car sales. We detailed the user flow, including how users view ads, generate leads, and book test drives. Our primary focus was on enhancing the performance of individual car pages, where we discussed various strategies to reduce latency and improve load times. We examined the impact of client-side versus server-side rendering and outlined initial approaches to optimizing both frontend and backend components.

https://backend.how/posts/pre-owned-car-platform-with-valkey-part-2/
🐈 A Cat Stereogram - Dark Mode

A stereogram is a unique type of image that creates the illusion of a three-dimensional scene from a two-dimensional pattern. When viewed correctly, stereograms appear to pop out of the background, offering viewers a captivating 3D experience.

The Cat Stereogram #
cat stereogram cat stereogram Download
Benefits of Stereograms for Eye Health # Improving Focus and Convergence #

Stereograms require viewers to focus on a single point and adjust their eye convergence. This exercise strengthens the eye muscles responsible for these actions.

https://backend.how/posts/cat-stereogram-dark-mode/
🧩 The Psychology of Seeking Help

In my experience as a backend engineer, I’ve observed various patterns in how people seek help when they encounter problems. Understanding these patterns not only aids in providing effective assistance but also helps in fostering a culture of collaborative problem-solving.

Types of Help Seekers # The Persistent Problem Solver #

Effort Level: High
Difficulty: High

These individuals come to you after trying multiple approaches to solve the problem on their own. They have already narrowed down the issue to a certain extent and are often seeking confirmation or a new perspective.

https://backend.how/posts/the-psychology-of-seeking-help/
📜 The Best Way to Learn Backend Web Development

You’ve probably read ten articles just like this one.

“Learn HTML/CSS first.” “Pick a language.” “Understand databases.” You know the drill. Another roadmap. Another overwhelming list of technologies that leaves you more paralyzed than when you started.

It seems like you’re looking for someone to just tell you what to do, to cut through the noise and give you a real path forward.

Here’s the uncomfortable truth: Most backend learning advice is wrong. Not because it’s technically incorrect, but because it’s optimized for comprehensiveness, not for you actually becoming a backend developer.

https://backend.how/posts/the-best-way-to-learn-backend-web-development/
🪲 The Tiger Style
The Essence Of Style #

“There are three things extremely hard: steel, a diamond, and to know one’s self.” — Benjamin Franklin

TigerBeetle’s coding style is evolving. A collective give-and-take at the intersection of engineering and art. Numbers and human intuition. Reason and experience. First principles and knowledge. Precision and poetry. Just like music. A tight beat. A rare groove. Words that rhyme and rhymes that break. Biodigital jazz. This is what we’ve learned along the way. The best is yet to come.

https://backend.how/posts/the-tiger-style/
🚗 Building blazingly fast pre-owned car platform with Valkey - Part 1

Introduction

The content will cover how to leverage Valkey for serving web pages at blazingly fast speeds. This guide assumes you have some familiarity with backend technology.

What is Valkey? Valkey is an open-source, high-performance key/value datastore licensed under BSD. It supports a variety of workloads such as caching, message queues, and can function as a primary database. Valkey can operate as a standalone daemon or in a cluster with options for replication and high availability. It originated as a fork of Redis after Redis changed its license terms. More details on the forking issue can be found at arstechnica.com.

https://backend.how/posts/building-blazingly-fast-pre-owned-car-platform-with-valkey-part-1/
🧿 Creating Content

At the end of this, you’ll understand the importance of creating content, when to start, and how to begin.

When? #

There’s no ideal time; start as soon as possible. Start NOW!

What? #

What should you write about? Here are several options:

  1. Pick a topic that interests you.
  2. Choose something you find easy but that others might find challenging.
  3. Teach a skill you’ve put a lot of effort into learning.
  4. Write about anything out of the ordinary1 or even simple topics.
Quality #

How do you determine the quality of the content you’re creating? It depends on three things:

https://backend.how/posts/creating-content/
🐘 Postgres - Optimising query

PostgreSQL is a powerful and popular open-source relational database management system. It is known for its reliability, scalability, and ability to handle large amounts of data. However, as with any database system, it is important to optimize queries to ensure that they run as efficiently as possible. In this blog post, we will discuss some techniques for optimizing PostgreSQL queries to improve performance.

Use indexes #

One of the most important ways to optimize queries in PostgreSQL is to use indexes. An index is a data structure that allows the database to quickly locate and retrieve specific rows of data based on the values in one or more columns. By creating indexes on columns that are frequently used in WHERE clauses, you can significantly improve the performance of your queries.

https://backend.how/posts/post-query-optimise/
♥️ System Design - Tinder

Here’s the question that keeps engineers up at night when building a dating app at scale: How do you show someone the right person, right now, within 10 miles, when 75 million people are swiping simultaneously?

Let’s dig in.


Problem Statement #

Beyond the basics of profiles and matching, here are the harder problems worth solving:

  1. The Proximity Paradox: You need to find people near the user, but “near” changes every time they move. Their location updates every few minutes. Multiply this by 75M daily active users.

https://backend.how/posts/system-design-tinder/