DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQL Joins Explained - INNER, LEFT, RIGHT, FULL

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 min read
A Technical Deep Dive: The Internals of Database Storage 🔬

A Technical Deep Dive: The Internals of Database Storage 🔬

4
Comments
4 min read
I Built BackupGuardian After a 3AM Production Disaster Taught Me Not to Trust "Good" Backups

I Built BackupGuardian After a 3AM Production Disaster Taught Me Not to Trust "Good" Backups

Comments
1 min read
Trials and tribulations of learning how to code and navigate databases in an AI world

Trials and tribulations of learning how to code and navigate databases in an AI world

17
Comments 6
5 min read
filesql: SQL Driver for CSV, TSV, LTSV, Parquet, and Excel Files in Go

filesql: SQL Driver for CSV, TSV, LTSV, Parquet, and Excel Files in Go

Comments
3 min read
Introducing Aerospike Graph Database 3.0: Faster, simpler, and built for the terabyte scale era

Introducing Aerospike Graph Database 3.0: Faster, simpler, and built for the terabyte scale era

Comments
3 min read
Building NeuroStash - III

Building NeuroStash - III

Comments
5 min read
Browser Storage Explained: LocalStorage vs SessionStorage vs IndexedDB vs Cookies

Browser Storage Explained: LocalStorage vs SessionStorage vs IndexedDB vs Cookies

1
Comments
3 min read
High-Performance Bulk Insert with relationships

High-Performance Bulk Insert with relationships

Comments
5 min read
How to Design a PostgreSQL Schema Visually (Step-by-Step)

How to Design a PostgreSQL Schema Visually (Step-by-Step)

7
Comments 2
4 min read
From Sluggish to Lightning Fast: A Database Performance Optimization Journey

From Sluggish to Lightning Fast: A Database Performance Optimization Journey

Comments
3 min read
Redis AI Platform: Accelerating the Future of AI with Real-Time Data Intelligence

Redis AI Challenge: Real-Time AI Innovators

Redis AI Platform: Accelerating the Future of AI with Real-Time Data Intelligence

1
Comments
6 min read
Stop Your SQL JOINs from Crawling: A Quick Index Fix

Stop Your SQL JOINs from Crawling: A Quick Index Fix

Comments
2 min read
How X Checks Your Username in Milliseconds: A Gentle Guide to Bloom Filters

How X Checks Your Username in Milliseconds: A Gentle Guide to Bloom Filters

1
Comments
4 min read
Meet the Mongorai — new MongoDB Web-UI

Meet the Mongorai — new MongoDB Web-UI

1
Comments
2 min read
Database Locking Explained: Ensuring Integrity While Impacting Performance in Concurrent Systems

Database Locking Explained: Ensuring Integrity While Impacting Performance in Concurrent Systems

Comments
11 min read
Understanding Database Transaction Rollbacks: Resolving Conflicts for Data Integrity and Consistency

Understanding Database Transaction Rollbacks: Resolving Conflicts for Data Integrity and Consistency

Comments
11 min read
🧠 MindMirror: Real-time Mental Health Analysis with RedisAI

Redis AI Challenge: Beyond the Cache

🧠 MindMirror: Real-time Mental Health Analysis with RedisAI

Comments
1 min read
Updates to the Same Value: MongoDB Optimization

Updates to the Same Value: MongoDB Optimization

2
Comments 1
7 min read
🐱 Schrödinger’s Index: It Only Exists When You Observe It and Only the Way You Observe It – in the HydrAIDE Engine

🐱 Schrödinger’s Index: It Only Exists When You Observe It and Only the Way You Observe It – in the HydrAIDE Engine

5
Comments
3 min read
Redis vs. Memcached: How to Choose Your NoSQL Champion

Redis vs. Memcached: How to Choose Your NoSQL Champion

3
Comments
4 min read
Building a Food Price & Inflation Analysis Pipeline in Kenya (2006–2024)

Building a Food Price & Inflation Analysis Pipeline in Kenya (2006–2024)

Comments
3 min read
Building Real-time Magic: Supabase Subscriptions in Next.js 15 ⚡

Building Real-time Magic: Supabase Subscriptions in Next.js 15 ⚡

3
Comments
7 min read
How to Build an ACID Compliant Database

How to Build an ACID Compliant Database

Comments
8 min read
MongoDB Arrays: Sort Order and Comparison

MongoDB Arrays: Sort Order and Comparison

2
Comments
16 min read
loading...