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.
Top Tools for Enterprise Data Analytics on Snowflake

Top Tools for Enterprise Data Analytics on Snowflake

Comments
3 min read
How SQL Queries Really Work: From Parsing to Execution

How SQL Queries Really Work: From Parsing to Execution

3
Comments
4 min read
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 🔬

5
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
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
Why LLMs struggle with analytics

Why LLMs struggle with analytics

Comments
10 min read
Building NeuroStash - III

Building NeuroStash - III

Comments
5 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
PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL | mrcaption49

PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL | mrcaption49

5
Comments
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
loading...