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.
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
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
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
Pk vs Fk 🔑

Pk vs Fk 🔑

Comments
2 min read
MongoDB Arrays: Sort Order and Comparison

MongoDB Arrays: Sort Order and Comparison

2
Comments
16 min read
Full-Stack Interview Prep #1: SQL Injection Explained Simply (with Go & Node.js Examples)

Full-Stack Interview Prep #1: SQL Injection Explained Simply (with Go & Node.js Examples)

9
Comments
7 min read
Couchbase Weekly Updates - August 8, 2025

Couchbase Weekly Updates - August 8, 2025

1
Comments
2 min read
Installation and Configuration of PostgreSQL 16 Barman on Ubuntu 24.04 LTS #postgresql #barman #backup #pitr #opensource

Installation and Configuration of PostgreSQL 16 Barman on Ubuntu 24.04 LTS #postgresql #barman #backup #pitr #opensource

Comments
1 min read
Data Design That Doesn't Crumble at Scale

Data Design That Doesn't Crumble at Scale

Comments
2 min read
Django: Don't put default sorting in the model

Django: Don't put default sorting in the model

Comments
1 min read
SQL Diagnostic Report(26ai, 19.28)

SQL Diagnostic Report(26ai, 19.28)

Comments
2 min read
Junior Developer's Full-Stack AI Journey: Completing the KYC System and Growing

Junior Developer's Full-Stack AI Journey: Completing the KYC System and Growing

Comments
5 min read
Migration Strategies: Moving Applications and Databases Without Breaking Things

Migration Strategies: Moving Applications and Databases Without Breaking Things

11
Comments
4 min read
Use JSON Patch to Resolve Conflicts

Use JSON Patch to Resolve Conflicts

1
Comments
4 min read
Create MySQL ER Diagrams with a Free Design Tool

Create MySQL ER Diagrams with a Free Design Tool

6
Comments
4 min read
loading...