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.
Think in Sets: Writing High-Performance SQL the Declarative Way

Think in Sets: Writing High-Performance SQL the Declarative Way

Comments
2 min read
Install MongoDB & Create a Database | MongoDB Tutorial 2025

Install MongoDB & Create a Database | MongoDB Tutorial 2025

6
Comments
5 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

1
Comments
2 min read
Materialized Views in SQL: Supercharging Read Performance

Materialized Views in SQL: Supercharging Read Performance

Comments
2 min read
Behind the Scenes: Reading SQL Execution Plans Like a Pro

Behind the Scenes: Reading SQL Execution Plans Like a Pro

Comments
3 min read
Why Netflix Doesn’t Trust Auto-Increment IDs: The Untold Power of UUIDs in a Distributed World

Why Netflix Doesn’t Trust Auto-Increment IDs: The Untold Power of UUIDs in a Distributed World

1
Comments
4 min read
How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide

How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide

Comments
3 min read
A simple, convenience package for the Azure Cosmos DB Go SDK

A simple, convenience package for the Azure Cosmos DB Go SDK

4
Comments
5 min read
PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

1
Comments
3 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

8
Comments
4 min read
How I Replaced Python with C in My Project

How I Replaced Python with C in My Project

3
Comments 2
4 min read
TRANSACTIONS IN DATABASE

TRANSACTIONS IN DATABASE

Comments
2 min read
How I Created an API That Enhances the Performance of ChatGPT

How I Created an API That Enhances the Performance of ChatGPT

Comments
3 min read
Optimizing SQL queries for your AI Agents.

Optimizing SQL queries for your AI Agents.

6
Comments
4 min read
A Guide to Cleaning and Organizing Customer Data

A Guide to Cleaning and Organizing Customer Data

Comments
2 min read
PgDog: Your New Best Friend for PostgreSQL Management

PgDog: Your New Best Friend for PostgreSQL Management

Comments
3 min read
Oracle 21c – pdbTimezone Parameter in DBCA Command

Oracle 21c – pdbTimezone Parameter in DBCA Command

Comments 2
1 min read
Finding and Remediating Idle AWS Databases Made Easy

Finding and Remediating Idle AWS Databases Made Easy

Comments
24 min read
What is redis pipeline

What is redis pipeline

6
Comments
2 min read
Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

1
Comments 2
3 min read
dynq: a free analytic query and data processing CLI tool for DynamoDB

dynq: a free analytic query and data processing CLI tool for DynamoDB

Comments
1 min read
AI in Warehouses: Because Human Errors Are Too Expensive

AI in Warehouses: Because Human Errors Are Too Expensive

1
Comments
3 min read
Don’t Use SQL If Your Client Doesn’t Know What They Want

Don’t Use SQL If Your Client Doesn’t Know What They Want

Comments 2
2 min read
JavaRaft: Raft Distributed Consensus Protocol

JavaRaft: Raft Distributed Consensus Protocol

Comments
10 min read
Amazon RDS Unlocked: Your Ultimate Guide to Managed Databases in AWS (2025 Edition)

Amazon RDS Unlocked: Your Ultimate Guide to Managed Databases in AWS (2025 Edition)

6
Comments 1
12 min read
loading...