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.
#34 50 Advanced SQL Queries Every Developer Should Know

#34 50 Advanced SQL Queries Every Developer Should Know

2
Comments
7 min read
Setting Up PostgreSQL on macOS: A Fresh Start Guide

Setting Up PostgreSQL on macOS: A Fresh Start Guide

2
Comments
5 min read
Scaling PostgreSQL Performance with Table Partitioning

Scaling PostgreSQL Performance with Table Partitioning

48
Comments 7
12 min read
🚀 MongoDB Aggregation Challenge - Lookup & Grouping Mastery 🔥

🚀 MongoDB Aggregation Challenge - Lookup & Grouping Mastery 🔥

Comments
2 min read
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

6
Comments 1
3 min read
New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

5
Comments
2 min read
Beginner’s Guide to Designing a Relational Database Schema

Beginner’s Guide to Designing a Relational Database Schema

13
Comments 5
4 min read
Data Warehouse MAKAUT

Data Warehouse MAKAUT

3
Comments
1 min read
Gradual Database Password Rollover - Oracle 21c

Gradual Database Password Rollover - Oracle 21c

1
Comments
2 min read
No HOT updates on JSONB (write amplification) performance impact

No HOT updates on JSONB (write amplification) performance impact

8
Comments 2
7 min read
Distributed Systems | What can we learn from Roblox's 3-day outage?

Distributed Systems | What can we learn from Roblox's 3-day outage?

Comments
5 min read
What is Caddy and How It Helped My Product DBLayer.dev

What is Caddy and How It Helped My Product DBLayer.dev

12
Comments 1
3 min read
Most Important DWDM questions in MAKAUT exam

Most Important DWDM questions in MAKAUT exam

Comments
3 min read
PostgreSQL on OpenBSD: Upgrade 16 to 17 with pg_upgrade

PostgreSQL on OpenBSD: Upgrade 16 to 17 with pg_upgrade

3
Comments
6 min read
Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

Comments 1
4 min read
How to Access a PostgreSQL Database Remotely

How to Access a PostgreSQL Database Remotely

1
Comments
2 min read
🌍 Redis Geohashing: Storing and Querying Location Data with Ease

🌍 Redis Geohashing: Storing and Querying Location Data with Ease

8
Comments 3
2 min read
Graph database v4.10 is out!

Graph database v4.10 is out!

6
Comments 1
2 min read
DevLog 20250520: Search Engine Architecture

DevLog 20250520: Search Engine Architecture

1
Comments 1
3 min read
The Scaling Gauntlet: The Art of Query Archaeology

The Scaling Gauntlet: The Art of Query Archaeology

Comments 1
5 min read
Hello, Dev Community! 👋

Hello, Dev Community! 👋

8
Comments 1
1 min read
Postgres is Too Good (And Why That's Actually a Problem)

Postgres is Too Good (And Why That's Actually a Problem)

171
Comments 31
7 min read
Data Warehousing and Data Mining

Data Warehousing and Data Mining

Comments
2 min read
SpacetimeDB: Revolutionizing Real-Time Data with Speed and Simplicity

SpacetimeDB: Revolutionizing Real-Time Data with Speed and Simplicity

Comments
3 min read
Oracle 21c Enhancements for TTS Export/Import

Oracle 21c Enhancements for TTS Export/Import

Comments
2 min read
loading...