#database

What It Actually Takes to Archive Billions of Financial Records Without Taking Production Down

Database archival sounds deceptively simple.

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…

Common Mistakes AI Makes When Generating SQL

AI has made writing SQL much faster.

The Foundations of Backend Engineering — Understanding Databases

The Warehouse of Your Data

Techniques to Expose Progress for Long-Running Jobs Without Polling Your Database to Death

d-lmdb: A Distributed LMDB Built on d-engine (Experimental)

Exploring how to add replication to an embedded KV (LMDB) using d-engine, with minimal changes to the read path.

OpenFDA Drug API vs Commercial Drug APIs for Healthcare Software

When comparing OpenFDA vs commercial drug APIs, the real question is not simply free versus paid. It is about data quality, workflow fit…

Adding Cost Metering and LLM Spend Visibility to a Multi-Agent System

Written by Matteo Rossi.

The Three Database Confusions That Lead Teams to Pick the Wrong Solution

Centralized vs distributed, interface vs syntax, OLAP vs HTAP — untangling concepts that derail GBase Database selection meetings.

Your Database POC Looks Good. Here’s Why It Might Still Be Useless.

A database POC can pass benchmarks and still fail in production. This guide explains three common database POC mistakes — benchmark-only…

System Requirements দেখে সঠিক Database কীভাবে বেছে নেবেন?

Software Engineer হিসেবে আমরা অনেকেই PostgreSQL, MySQL, MongoDB, Redis — এগুলোর নাম খুব সহজেই বলতে পারি।

How to Fix “MySQL Shutdown Unexpectedly” Error in XAMPP

A step-by-step guide to get your local MySQL server running again

What Is Bring Your Own Database Architecture, and Why Does It Matter for Cryptographic Security?

Most organisations running cryptographic discovery or vulnerability assessments accept a hidden trade-off: their sensitive infrastructure…

Alembic in Practice: Structure, Revisions, and the Traps SQLite Sets

What those hex filenames mean, why migrations silently applied to the wrong database for two months, and how to widen a CHECK constraint…

Database locking with raw SQL (FOR UPDATE)

Two concurrent transactions that each SELECT a row, change it in memory, then UPDATE can lose an update or claim the same resource twice…

Tips: Design Fallback Responses Without Creating Data Integrity Bugs

The Five Questions to Pick a Database: A Decision Tree for SQL, NoSQL, Cache, and Search

How to choose a database by the questions you ask your data — a decision tree that starts at Postgres and makes every exit earn its visa.

pgvector is All You Need: Replacing Expensive Vector DBs in Spring Boot

Dedicated vector databases are overpriced and introduce unnecessary network latency. Here is how to implement Retrieval-Augmented…

Database Fundamentals for Data Analysts

Types of Databases 1. Relational Database vs Non-Relational Database Relational Database A Relational Database stores data in the form of…

The API Scaled. The Database Didn’t: A Connection Budget Failure

Code: the complete Docker experiment, API, load generator, sanity test, and raw results are available in…

Database Migrations Done Right: Flyway vs Liquibase in Spring Boot

Your application code lives in Git. Every change is reviewed, versioned, and reproducible. You can check out any commit and rebuild the…

PostgreSQL 學習筆記：認識資料庫索引與 EXPLAIN ANALYZE

本篇為六角學院2026年node.js直播班中，關於資料庫索引的學習筆記整理，課中使用的資料庫為PostgreSQL，筆記內容來自課程、PostgreSQL官方文件整合而來。

Methods to Roll Out Breaking Database Changes Without a Freeze Window

Data Post 27: Revisit Mary’s IT Application — The Full Circle Moment

It has been a while since we checked in on Sally and Mary.

Business To Consumer Marketing Database for Coordinated Direct Marketing

One Audience Foundation Across Several Channels

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.

How Database IndexingActually Works

A beginner’s journey from “CREATE INDEX” to understanding pages, slots, and B-trees.

After 3 Years and 200M Rows, I Finally Stopped Using UUIDs as Primary Keys

The alert hit my phone while I was mid bite into a sandwich, and my first thought was that someone had restarted the wrong service again.

mmap behind the scenes in a database

I have spent the last three years building databases. Two of them actually, both append only, both storing data at TB scale. The first one…

Graph Data Modelling: A Functional Framework for Getting It Right

Using Oil & Gas subsurface data as a real-world case study

Postgres vs ClickHouse is the wrong question. I use both.

My uptime monitor keeps config and incidents in Postgres and check results in ClickHouse. The split is one rule: does a row ever change…

Why Is Oracle Exadata So Much Faster Than Traditional Database Servers?

Consider a scenario common to enterprise data centers: an identical Oracle database instance, containing the exact same tables, schemas…

Cosmos DB and MongoDB: NoSQL Databases for Flexible Schemas and Scale

A practical guide to two of the most widely used NoSQL databases — Azure Cosmos DB and MongoDB — covering the document data model, schema…

Solving SQL Queries Using ER Diagrams: A Simple 4-Step Approach

When working with databases that contain multiple related tables, it can be overwhelming to identify relationships, decide where to start…

How I plan my SQLite Database Schema for Flutter projects.

How I Plan My SQLite Database Schema for Flutter Projects

Problem Transactions Were Designed to Solve

Series: Understanding Spring @Transactional from the Database Up

Your AI Just Rewrote Its Own Playbook. How Do You Know It Got Better?

Every AI system will eventually propose a change that makes things worse. The question is whether you’ll know before or after it runs on…

Synthetic Databases as Audit Logs: How to Make Your AI Models Explainable to Regulators Before They…

You cannot replay production history for every model decision. But you can reconstruct it with synthetic data that behaves like your users…

The Supabase Migration That Silently Nulled a Column in Production

A Supabase column type change looked safe in staging. In production, it quietly turned 2,000 rows of real user data into NULLs.

We hit an at-least-once delivery trap. Here is how we fixed the race conditions.

If you are running an event-driven architecture with message queues like Kafka, you already know the drill, scalability is awesome, but…

25 PostgreSQL Tricks Every Backend Engineer Should Know

Most backend engineers never actually outgrow PostgreSQL. What they outgrow is the way they’re using it.

The Migration That Lied for Two Years

How an outdated CLI tool left behind a corrupt EF Core snapshot — and why a major upgrade finally exposed it

What Actually Happens When You Connect to a Database?

As developers, we write database connection code all the time. Whether it's a single line like:

How to Utilize Excel For Databases

A Guide to Excel’s Handy Database Features

AI Benchmark Said It Was Better. Your Production Database Disagreed

Generic LLM benchmarks measure language model capability. They don’t measure whether your AI SRE tool can still diagnose connection pool…

Database Connection Pooling in Node.js: A Complete Beginner’s Guide

Understanding why every serious Node.js backend needs connection pooling — and how to implement it correctly

Before AI, You Need Data: Understanding Data Warehouses and the Modern Data Stack

A Physics Engineer’s Journey into Data & AI

I Stopped Memorizing SQL Syntax and Started Solving Problems Instead

The mindset shift that made learning databases easier and why it made me a better developer

All About the “AWS Cloud Technical Essentials” — [Module 3: Storage]

Check out the summary to Module 1, Module 2.

Building a Small Internal Survey System with Django: The Operational Lessons I Didn’t Expect