#performance

MMakroumimakroumi.hashnode.dev

The Query That Looks Instant in Development and Destroys Production at Scale

You push the code on Friday afternoon. Tests pass. Staging looks fine. You deploy and go home. At 2am your phone rings. Response times are 8 seconds. Users are abandoning. The on-call engineer is star

15h ago6 min read

DSDoogal Simpsondoogal.dev

Scaling Profanity Filters: Why I Use Tries for Real-Time Chat

TL;DR: When I'm building high-traffic chat systems, a standard list lookup for profanity is too slow because search time grows with the size of the dictionary. I use a Trie (prefix tree) to move to O(

14h ago5 min read

DSDoogal Simpsondoogal.dev

Why Your Linked List Wants to Be a Bloody Tree

Quick Answer: A linked list hits a wall when searching because it’s stuck in linear O(n) time. By giving every node two pointers instead of one, you create a Binary Search Tree (BST). This wacky struc

14h ago5 min read

PMPhilip McClarencepostgresdba.hashnode.dev

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results Here is a question that surfaces on every spatial database project eventually: "Why does ST_Distance return 3.4 instead of 340,000?" The answer is almost always the SRID. An SRID ...

15h ago5 min read

PMPhilip McClarencepostgresdba.hashnode.dev

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

PostgreSQL vs MySQL vs SQLite: A Developer's Honest Guide to Choosing the Right Database Every project starts with the same question. Do I need a full database server, or is SQLite enough? The answer depends on exactly three things: how many users wr...

15h ago14 min read

DSDavid Shustermandavidshusterman.hashnode.dev

Why Your WordPress Site Is Slow (It's Not What You Think)

Most developers immediately blame plugins or themes when their WordPress site crawls. While these are common culprits, the real performance killers often hide deeper in your infrastructure—and fixing them requires looking beyond the obvious suspects....

16h ago7 min read

MMakroumimakroumi.hashnode.dev

SQLFluff vs Squawk vs SlowQL: Choosing the Right SQL Static Analyzer for Your Stack

There are three serious open source SQL static analyzers worth knowing about in 2026. Most engineers have heard of SQLFluff. Fewer know Squawk. SlowQL is newer. They solve different problems and the d

2d ago7 min read

AAAlex Aceboaacebo.hashnode.dev

🦀Building Rust Procedural Macros Without quote!: Introducing zyn

I've been writing proc macros for a while now. Derive macros for internal tools, attribute macros for instrumentation. And every time, the same two problems: quote! doesn't compose (you end up passing

1d ago9 min read

MBMatthias Brunsblog.matthiasbruns.com

Modern Frontend Architecture — React, Svelte, and the Performance Patterns That Matter

The Framework Choice Is Not the Architecture Decision Every quarter, a new "React vs. Svelte vs. X" benchmark post goes viral. Teams spend weeks evaluating, build a proof-of-concept, and then ship the same over-fetching, client-rendered SPA they woul...

1d ago7 min read

PMPhilip McClarencepostgresdba.hashnode.dev

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

PostgreSQL vs MySQL vs SQL Server: The Enterprise Database Decision, Made on Technical Merit Every enterprise database evaluation lands on the same shortlist: PostgreSQL, MySQL, and SQL Server. The problem is that the decision is usually made based o...

1d ago14 min read

Tag feed

Tag feed

#performance

The Query That Looks Instant in Development and Destroys Production at Scale

Scaling Profanity Filters: Why I Use Tries for Real-Time Chat

Why Your Linked List Wants to Be a Bloody Tree

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

Why Your WordPress Site Is Slow (It's Not What You Think)

SQLFluff vs Squawk vs SlowQL: Choosing the Right SQL Static Analyzer for Your Stack

🦀Building Rust Procedural Macros Without quote!: Introducing zyn

Modern Frontend Architecture — React, Svelte, and the Performance Patterns That Matter

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

#performance

Search Hashnode

#performance

The Query That Looks Instant in Development and Destroys Production at Scale

Scaling Profanity Filters: Why I Use Tries for Real-Time Chat

Why Your Linked List Wants to Be a Bloody Tree

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

Why Your WordPress Site Is Slow (It's Not What You Think)

SQLFluff vs Squawk vs SlowQL: Choosing the Right SQL Static Analyzer for Your Stack

🦀Building Rust Procedural Macros Without quote!: Introducing zyn

Modern Frontend Architecture — React, Svelte, and the Performance Patterns That Matter

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide