Latest Architecture news from Tech News
Привет, Хабр! В первой части мы разобрали архитектуру pg-smart-search изнутри: параллельный Promise.race , механизм Zombie Prevention через AbortSigna…
The 100-Million Row Wall In enterprise B2B SaaS platforms at Smart Tech Devs, tracking historical data is a compliance requirement. Tables like audit_…
Disclosure: I am a senior backend tech lead in Paris and I run HostingGuru, a small European PaaS for solo founders and small teams. This article ment…
How a 35-year-old open-source database became the default choice for relational storage, full-text search, vector AI workloads, geospatial queries, an…
Quorum is an incident command plane built on Amazon Aurora DSQL. The failover story lives in another post. This one is about a narrower question that …
When people say they are "adding RAG" to a workflow, the conversation often jumps too quickly to infrastructure choices. Should this use a vector data…
In a multi-tenant B2B platform, data leakage is an extinction-level event. If Property A logs into your dashboard and accidentally sees the guest data…
The Hidden O(N) Pagination Trap When building data-heavy B2B SaaS platforms at Smart Tech Devs, rendering lists of invoices, logs, or user rosters is …
This series of posts traces the evolution from GIN to RUM to Extended RUM, showing how a single architectural idea—store more in the index to do less …
Search looks simple from the outside. A user types something like: short-range copper module and expects the system to return the right product, maybe…
Database Index Anatomy: Performance and Resource Management While developing a production ERP, when I saw query times suddenly double, I realized that…
Database index selection, in my nearly 20 years of experience, has often been a critical topic that is either overlooked or misunderstood. Many develo…
Introduction: Bridging the Gap Between Postgres and JavaScript with ParadeDB The ParadeDB NPM package emerges as a targeted solution to a growing pain…
A DBOS blog post titled "Postgres is all you need for durable execution" reached the Hacker News front page this week (306 points, 132 comments). The …
From Grafana to Real Performance Gains I noticed in the Grafana dashboard that GET /api/v1/dokter/public/jadwal-dokter was on average taking 1 second …
There's a specific kind of frustration that comes from using a health app that feels like it was built by engineers who've never actually used it. The…
At Twio we picked pg-boss for our job queue, ran into trouble when we went serverless, looked at Pub/Sub, and ended up on Google Cloud Tasks. This is …
TypeScript passed it clean. The code reviewer approved it. It shipped to production. Three months later, a penetration tester sent a report. The vulne…
Originally published at spectredev.xyz . Cross-posted here for the Dev.to community. Database sharding explained without the hype. Learn what it actua…
In SQL databases, NULL represents an unknown value — not the absence of a value. When a value is simply non-applicable for a given entity, the correct…
TL;DR Built a PostgreSQL extension that creates UUIDs looking like random v4 but containing hidden timestamps. Result: 50% smaller indexes with perfec…
1 Minute PostgreSQL Tip: Indexing JSONB for Faster Lookups 🚀 Ever struggled with slow queries on your JSONB columns? You're not alone. Many developers…
The Problem with Auto-Incrementing IDs When building a B2B SaaS platform at Smart Tech Devs, using standard auto-incrementing integers (1, 2, 3) for y…
If you're building a multi-tenant SaaS, this is the first real architecture decision that will haunt you if you get it wrong. I've implemented both ap…
Author's Note: This article documents a production incident investigation and the technical findings that emerged from returning to foundational docum…
PostgreSQL 17 in Production: What Actually Matters PostgreSQL 17 shipped with a mix of incremental improvements and a few genuine breakthroughs. After…
I Released AI DB Investigator - A Skill for Structured Database Analysis AI is very good at generating answers. But when it comes to database problems…
Big improvements incoming 👋 Finding the right balance for a feed algorithm is historically really hard. If you optimize purely for clicks and comments…
Most operational infrastructure starts this way: a requirement appears before the architecture does. One day the team needed a database audit solution…
A lot of systems begin with a single database. Usually PostgreSQL. And honestly, in the beginning, that works perfectly fine. The application stores: …