#database-design

RY Ryan Y. Kurr

The Database Trade-Off Nobody Gets to Avoid

Every system eventually has to choose between perfect consistency and practical scalability.

Aug 19, 2026 · 5 min read · 0 claps #database-design #data-consistency #sql

ME Melisa Akkuş

SQL’deki “İlişki Beyni” MongoDB’de İşe Yaramıyor — İşte Nedeni

Şu hissi bilirsiniz: Yıllarca SQL dünyasında, Entity Framework Core’un o pamuklara sarılı konfor alanında kod yazmışsınızdır. Primary…

Aug 18, 2026 · 6 min read · 0 claps #yazilim-gelistirme #database #database-design

DSN AI

RA Rahul Chougule

Detecting Conflicts in Database writes with Vector Clocks

Building a Key-Value Store Part 6 Commit covered in this milestone: 56af379

Aug 04, 2026 · 6 min read · 0 claps #key-value-store #database-design #design-systems

ZA Zahir Mohideen

How to store rounded number in Oracle ?

If you have a requirement to store the numbers rounded to nearest hundreds , what would be the easy way. You can satisfying this…

Jul 31, 2026 · 1 min read · 0 claps #oracle-database #database-development #database-design

AB Abdul Moiz

Data Consistency Models Strong, Eventual, Casual & Read-Your-Writes

Ask five engineers what “consistency” means and you’ll get five slightly different answers, and honestly, all five might be right…

Jul 29, 2026 · 5 min read · 1 claps #system-design-interview #distributed-systems #data-consistency

AM Aman

The Outbox Pattern, Explained by a Real Problem (Without Breaking the App)

The obvious solution is a database transaction. Here’s why that breaks across two databases, and what I did instead.

Jul 24, 2026 · 8 min read · 0 claps #database #transactional-outbox #dynamodb

TCH

DE DevOps voice · Stackademic

TimescaleDB: The Complete Guide — Part 1: Foundations

A Practical Guide to Understanding, Installing, and Optimizing TimescaleDB for Production Workloads

Jul 21, 2026 · 9 min read · 22 claps paywalled #timescaledb #database-administration #database-design

ART ECO HUM TCH

TE Techloom.ai Pvt Ltd

Database Normalization: A Complete Guide to Organizing Databases Efficiently

Every modern application relies on well-organized data. Whether you’re building an e-commerce platform, banking system, or student portal…

Jul 21, 2026 · 8 min read · 0 claps #database-normalization #rdbms #database-design

TCH

PR Priyanshu Jajal · Stackademic

How Instagram Stores Billions Of Photos: Database Design Explained

What really happens after you tap the Post button?

Jul 11, 2026 · 6 min read · 1 claps #database-design #system-design-concepts #backend

TH thataidev

The Story Behind MySQL — More Human Than You Think ❤️

Like many developers, I always assumed MySQL was just another technical name.

Jul 10, 2026 · 1 min read · 0 claps #database #mysql #sql-queries

RI Riccardo Perico · Rik in a Data Journey

#tsql2sday #200 — I bet a query it’s bad if I see…

I know we’re on the same page…

Jul 07, 2026 · 3 min read · 0 claps #sql-server #sql #t-sql

SU Sumit Agrawal

Connection Pooling: A Small Feature with a Big Impact

Modern applications rely heavily on databases, but establishing a database connection is an expensive operation. Every new connection…

Jul 07, 2026 · 2 min read · 1 claps #connection-pooling #api-development #database-design

MA Matthew A · ILLUMINATION’S MIRROR

Databases Demystified: An Absolute Beginner’s Guide

Beginner's Guide to Databases

Jul 06, 2026 · 2 min read · 50 claps paywalled #relational-databases #database #application

ART

TE Techloom.ai Pvt Ltd

ER and EER Diagrams for Beginners: A Practical Guide to Database Design

Every well-built database starts life as a drawing before it becomes a single line of SQL. That drawing is usually an ER…

Jul 02, 2026 · 6 min read · 0 claps #er-diagram #eer-diagrams #database-design

MI Michael Chidiogo Okoli · Towards AWS

I used to think Database replication was magic.

A primary database gets a write. Somehow, a replica on the other side of the world has the same data seconds later. Then I learned about…

Jun 28, 2026 · 2 min read · 0 claps #database-design #replication #system-design-concepts

ART TCH HUM

SA Sadik Shaikh

Unlearning SQL: The Mental Shift Every Engineer Must Make Before Using DynamoDB

The hardest part of learning DynamoDB isn’t understanding its API syntax. It’s completely letting go of everything SQL taught you.

Jun 22, 2026 · 6 min read · 0 claps #dynamodb #aws #database-design

TCH

HA Hafiq Iqmal · Towards Data Engineering

The 100 Million Row Question: Designing a ~50 GB ETL Pipeline Into PostgreSQL

A practitioner walkthrough of a Google interview prompt, treated as the extract, transform and load problem it really is, with runnable…

Jun 20, 2026 · 20 min read · 0 claps paywalled #postgresql #etl #big-data

ECO TCH

AN Anas Issath · Level Up Coding

5 Database Design Patterns Every Python Backend Needs in Production

Your models define your data. Your patterns define whether you can trust it.

Jun 17, 2026 · 10 min read · 45 claps paywalled #django #fastapi #database-design

ART TCH MDA

NI Nithidol Vacharotayan · Stackademic

Fixing This Month’s Report Shouldn’t Break Last Month’s

A practical backend lesson from moving a large reporting database under pressure, and why every major data change needs an impact…

Jun 16, 2026 · 9 min read · 0 claps paywalled #software-architecture #backend-development #database-design

ART

AH Ahmet Elbüz

Bölüm 10: Tablo Oluşturma ve Veri Manipülasyonu (DDL & DML)

Şimdiye kadar sadece var olan verileri sorguluyorduk. Şimdi kendi tablolarımızı oluşturmayı, verileri eklemeyi, güncellemeleri ve silmeyi…

Jun 15, 2026 · 3 min read · 0 claps #sql #create-table-in-sql #database-design

ECO TCH

KA Kaveeshapiumini

How ThunderID Uses Redis for High-Performance Identity Management

From in-memory data structure store to the backbone of a modern IAM system, and how we adapted our SQL-based runtime to make it work

Jun 12, 2026 · 8 min read · 0 claps #identity-management #open-source #redis

AH Ahmet Elbüz

Bölüm 8: DATA TYPES (Veri Tipleri)

SQL öğrenme serimin sekizinci bölümünde DATA TYPES (Veri Tipleri) konusunu ele alacağım. Veritabanı tasarımının temelini oluşturan bu konu…

Jun 10, 2026 · 4 min read · 0 claps #sql #data-type #database-design

ART

SN SNITCH Threads · SNITCH Threads — Tech Blog

Inside SNITCH’s Real-Time Order Allocation Engine

Explore the architecture behind millions of allocation decisions powered by routing data and business rules.

Jun 10, 2026 · 6 min read · 10 claps #engineering #technology #ecommerce

ECO

JO Jonathan Fishner

10 Common Mistakes in Database Design (And How to Avoid Them)

A few years ago, one of my friends’ startups launched their app only to have it collapse because its database lacked proper foreign keys…

Jun 10, 2026 · 6 min read · 0 claps #database #database-design #chartdb

PR Pranav Mehta

ClickHouse fsync: What the History Tells Us

When engineers work with databases like MySQL or PostgreSQL, durability is often taken for granted. It’s natural to expect that every…

Jun 09, 2026 · 3 min read · 5 claps #clickhouse #fsync #durability

TCH

SA Santanu Chandra

SQL Server for Beginners: From Basics to Real-World Use

If you have ever heard the word “database” and immediately felt a wave of confusion wash over you, you are not alone. Most beginners assume…

Jun 09, 2026 · 6 min read · 0 claps #sql-server #sql #database

PR Pratham Sharma

MongoDB Basics for Beginners

What is MongoDB?

Jun 08, 2026 · 3 min read · 2 claps #mongodb #sde-interview #software-engineering

TCH AI MDA MKT

YA Yash Jain · AlgoMart

SQL Window Functions: The Skill You Need Beyond Basic CRUD

If you are a software engineer, you should learn SQL window functions because dashboards, reports, analytics screens, leaderboards…

Jun 08, 2026 · 4 min read · 51 claps paywalled #sql #sql-window-functions #database-design

ART MDA DSN

RA Rahul Beniwal · Level Up Coding

How I Built My Own Kindle: Code, Architecture, and System Design Lessons

A code-level system design walkthrough of a private EPUB reader with S3 uploads, IndexedDB caching, CFI progress sync, annotations, and an…

Jun 08, 2026 · 11 min read · 51 claps paywalled #design-systems #database-design #interview-questions

MKT TCH

AN Angelo Arcillas

Designing Multi-Module SaaS Systems with Event-Based Cross-Service Communication

I designed a modular SaaS platform where chat, booking, analytics, and workflow modules needed to operate independently while still…

Jun 04, 2026 · 5 min read · 10 claps #distributed-systems #system-design-interview #backend-development

ART

NA Nandhavelan

CQRS and Event Sourcing: The Architecture Duo That Powers High-Scale Systems

When a single database model stops being enough, these two patterns change how you think about data entirely.

Jun 02, 2026 · 9 min read · 1 claps #cqrs #event-driven-architecture #event-sourcing

LIF SPT

KA Kayode Shobalaje

Entity-Relationship Modeling for an Online Flight Reservation System

Designing a Flight Reservation System: A Complete ER Model with Cardinalities, Relationships, and Business Rules

Jun 01, 2026 · 5 min read · 8 claps #entity-relationship #entity-relationship-model #database

DE Deepak

When Removing a SQL JOIN Reduced My Sorting Job Time from 17 Hours to 3 Hours

As developers, we are taught that normalization is good, duplication is bad, and joins are the correct way to design relational databases.

May 30, 2026 · 4 min read · 1 claps #sql-joins #normalization #denormalization

TCH

MI Mimicry

How to Mock an E-Commerce REST API in Mimicry (Products, Orders, and Relations)

Mocking an e-commerce API is one of those tasks that looks easy in tutorials and gets hard fast in practice. A flat array of products…

May 27, 2026 · 10 min read · 0 claps #ecommerce #web-development #rest-api

TCH

AN Angelo Arcillas

Designing Idempotent Retry-Based Workflows for Reliable Async Task Processing

I designed an asynchronous workflow system where user actions triggered background jobs that interacted with external APIs. Failures were…

May 26, 2026 · 5 min read · 0 claps #distributed-systems #system-design-interview #backend-development

TCH

BH Bhaskar Das · Algorithmic and Quantitative Trading

Google Cloud Spanner Schema Design Best Practices to Avoid Hotspots

Modern applications generate massive amounts of data every second. To handle this scale efficiently, organizations rely on distributed…

May 26, 2026 · 4 min read · 0 claps paywalled #google-cloud-platform #algorithmic-trading #distributed-systems

AI ART ECO

NO NorthPeak Technologies

The Vector Search Delusion: Why GraphRAG is the New Architecture Moat

Every startup founder who launched a product over the last two years followed the exact same technical playbook: they took their company’s…

May 25, 2026 · 4 min read · 0 claps #graphrag #software-architecture #database-design

SH Shashikiranshetty

How Databases Actually Work: From a Simple List to B-Trees

Most of us use databases. But very few stop to think about what’s actually happening under the hood when you save or fetch data.

May 25, 2026 · 5 min read · 0 claps #database #database-design

TCH

BH Bhaskar Das · Algorithmic and Quantitative Trading

Database Schema Design Guide Using Microsoft Best Practices

In this article, we will explore database schema design step by step using Microsoft’s recommended best practices.

May 24, 2026 · 5 min read · 0 claps paywalled #database #database-design #microsoft

ART

KU Kunal Sinha

Scaling Writes in System Design: A QPS-by-QPS Playbook

From 5K to 100K writes/sec, the cheapest technique that clears your write QPS — before you switch databases.

May 23, 2026 · 4 min read · 50 claps paywalled #system-design-interview #system-design-concepts #database-design

AI TCH

HA Hardika Bhate

Why the best data teams in 2026 aren’t picking one database?

I’ve shipped data pipelines across three eras of this industry — the NoSQL explosion, the lakehouse wars, and now the GenAI stack.

May 22, 2026 · 2 min read · 0 claps #2026-databases #data-engineering #database-design

ECO TCH

BH Bhaskar Das · Algorithmic and Quantitative Trading

How to Organize PostgreSQL Schemas for Trading and Financial Systems

As systems grow, one common challenge appears:

May 22, 2026 · 4 min read · 0 claps paywalled #database #database-design #postgresql

ECO HUM SCI

SR Sruthi Punugu

I Built a Database to Fix the One Thing Universities Are Embarrassingly Bad At

Somewhere in a university right now, a faculty coordinator is digging through their inbox trying to find a research paper submitted three…

May 22, 2026 · 4 min read · 0 claps #sql #database-design #mysql-research-management

ECO TCH

BH Bhaskar Das · Algorithmic and Quantitative Trading

DuckDB Schema Design Best Practices for Financial Data: A Beginner-Friendly Guide for Traders and…

Whether you are:

May 21, 2026 · 4 min read · 0 claps paywalled #database-design #schema-design #algorithmic-trading

GL Glen Patzlaff

Getting Started with SymmetricDS Pro: Your First Database Replication in 15 Minutes

Getting data from one database to another sounds simple until you try it. Different schemas, different vendors, intermittent connectivity…

May 20, 2026 · 7 min read · 0 claps #database #database-administration #database-replication

ECO SOC TCH

BH Bhaskar Das · Algorithmic and Quantitative Trading

Database Schema Design for Financial Markets: Best Practices, Scalability & Common Mistakes

Every financial market depends on databases working flawlessly behind the scenes. In high-frequency environments where milliseconds can…

May 17, 2026 · 5 min read · 0 claps paywalled #database-design #algorithmic-trading #trading

MKT

AD Adithya Karunanidhi

Handling CLOB’s in Cloud

# Handling Legacy Oracle CLOB Data in Cloud Databases for Reporting & Analytics

May 14, 2026 · 3 min read · 0 claps #database-design #clob #complex-data-types

ECO TCH

BH Bhaskar Das · Algorithmic and Quantitative Trading

The Investor’s Guide to Database Schemas: Organizing Financial Data for Performance and Scale

Data is the new oil. But for an algorithmic trader and investor, raw data is more like crude oil — it is messy, overwhelming, and useless…

May 13, 2026 · 4 min read · 0 claps paywalled #database #database-design #algorithmic-trading

TCH DSN

KA Karthik S · Stackademic

Decoding Database Choices: Why Tech Giants Don’t Use a “One-Size-Fits-All” Strategy

The Myth of the “Best” Database and how real systems choose based on this…

May 13, 2026 · 3 min read · 45 claps #database-design #design-systems #software-engineering

TCH

MA Maleesha Nuwanthi Kolombage · AWS Fullstack

AWS DynamoDB Eventual Consistency VS Strong Consistency

Amazon DynamoDB reads data from tables, local secondary indexes (LSIs), global secondary indexes (GSIs), and streams. Both tables and LSIs…

May 11, 2026 · 3 min read · 62 claps #eventual-consistency #strong-consistency #aws-dynamodb