From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
rokcso5d ago • 7 min read
How I Ran a Live Production Upgrade in 24 Minutes Without Taking the Site Down
I upgraded Shipstry's production data model for comments and payments, backfilled historical orders,...
#database#devops#webdev#ai
11 4
priteshsurana4d ago • 15 min read
Cassandra Internals: LSM Tree, SSTables, and Compaction
How Cassandra's LSM engine works end to end - CommitLog, Memtable, SSTable, Bloom filters, and compa...
#database#cassandra#backend#performance
2 2
Andrea Debernardi6d ago • 2 min read
From 0 to 1,000 GitHub Stars in 10 Weeks: What Actually Worked
Ten weeks ago I pushed the first binary of Tabularis to GitHub. A cross-platform database client...
#database#github#opensource#showdev
5 3
GDS K S1d ago • 10 min read
The 8 tables behind a real auth system (Postgres schema, explained column by column)
Day 2 of the auth from scratch series. The full Postgres schema for users, sessions, OAuth, reset to...
#postgres#authentication#database#webdev
3 0
Rohith Gilla5d ago • 6 min read
Stop Pasting \timing — Run Your SQL 100 Times and Get p99
Here is a trap I have fallen into more times than I can count. I write a query. I run it. It takes....
#postgres#performance#sql#database
0 0
Aviral Srivastava6d ago • 8 min read
CAP Theorem Revisited: PACELC
The CAP Theorem Got a Makeover: Meet PACELC, Your New Distributed Systems Buddy Remember...
#computerscience#database#distributedsystems#systemdesign
1 0
Alex Merced6d ago • 3 min read
What is Apache Polaris? Unifying the Iceberg Ecosystem
Read the complete Open Source and the Lakehouse series: Part 1: Apache Software Foundation:...
#data#database#dataengineering#opensource
0 0
Alex Merced6d ago • 4 min read
What is Apache Parquet? Columns, Encoding, and Performance
Read the complete Open Source and the Lakehouse series: Part 1: Apache Software Foundation:...
#database#dataengineering#opensource#performance
0 0
Alex Merced4d ago • 7 min read
Apache Data Lakehouse Weekly: April 9–15, 2026
The Iceberg Summit wrapped in San Francisco, leaving behind a set of in-person alignments that are.....
#database#dataengineering#news#opensource
0 0
Ashwin Hariharan6d ago • 14 min read
Semantic Caching in Agentic AI: Determining Cache Eligibility and Invalidation
Not all AI agent queries deserve the same cache treatment. Learn Temporal Context Detection approach...
#ai#tutorial#database#performance
0 0
Alex Merced6d ago • 4 min read
What is Apache Iceberg? The Table Format Revolution
Read the complete Open Source and the Lakehouse series: Part 1: Apache Software Foundation Part 2:...
#architecture#database#dataengineering#opensource
0 0
Franck Pachot1d ago • 3 min read
Mutable BSON and Oracle OSON
AskTom Live is a great source of information from Oracle developer advocates and product managers,.....
#oracle#mongodb#json#database
0 0
Manveer Chawla5d ago • 18 min read
Are ClickHouse JOINs Slow? A 2026 PR-by-PR Analysis
TL;DR Are ClickHouse JOINs slow? Not since 2022. Over 50 merged PRs between 2022 and 2026...
#data#analytics#dataengineering#database
6 0
Sangwoo Lee4d ago • 13 min read
Solving the 100M-Row Problem: A Summary Table Pattern for High-Volume Push Notification Logs
How I redesigned a push notification logging system that had accumulated 100 million rows — without....
#nestjs#typescript#database#bullmq
2 0
Kalio Princewill3d ago • 24 min read
PostgreSQL Read Replicas with Docker: A Step-by-Step Guide
As your application scales, your database becomes the first bottleneck. Every dashboard query, every...
#postgres#distributedsystems#database
6 0
Pedro Parker3d ago • 4 min read
Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto
Como implementei busca por nome em 55M+ empresas brasileiras com PostgreSQL pg_trgm, ILIKE e indexes...
#postgres#search#performance#database
2 0
Wojtek Pluta3d ago • 16 min read
Agent Memory: Why Your AI Has Amnesia and How to Fix It
Why agent memory matters, how working, procedural, semantic, and episodic memory fit together, and h...
#ai#agents#database#oracle
1 0
Yu Qian Yang5d ago • 5 min read
How I Used Bit Manipulation to Speed Up Float-to-Int Conversion in a Storage Engine
In a columnar time-series database, one of the most effective compression tricks is deceptively...
#cpp#performance#database#algorithms
1 3
Olamilekan Lamidi4d ago • 9 min read
Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide
If your web application is slow, the database is almost certainly the bottleneck. Not the frontend.....
#database#postgres#mysql#performance
1 0
Rick Houlihan5d ago • 54 min read
Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro
Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro SQL and JSON aren't...
#database#sql#tutorial
2 0
Darryl Ruggles1d ago • 25 min read
Amazon Aurora DSQL: A Practical Guide to AWS's Distributed SQL Database
Architecture, features, Terraform setup, and real application code - April 2026 When AWS...
#aws#aurora#postgres#database
1 0
Rahman Nugar6d ago • 6 min read
Idempotency Is Not Enough: Designing Deterministic Payment Systems
In payment systems, duplicate processing is not a theoretical problem. It happens in ordinary, borin...
#backend#database#payments#software
3 1
Fazal Mansuri2d ago • 5 min read
⚠️ Race Conditions in APIs - The Bug You Can’t See
There's a category of bugs that don't show up in tests. They don't throw errors. They don't crash...
#backend#database#api#security
1 0
Siddhesh Yellaram6d ago • 7 min read
Stop Putting Everything in the Service Class and Calling It Clean Architecture
There is a file in almost every .NET project that everyone on the team is quietly afraid of. It...
#dotnet#backend#software#database
1 0