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.
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
Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Comments
3 min read
Wrong Methods of Storing Data: Mistakes You Should Stop Making Today.

Wrong Methods of Storing Data: Mistakes You Should Stop Making Today.

Comments
2 min read
Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Comments 2
4 min read
Atlas Device Sync

Atlas Device Sync

Comments 2
2 min read
Build a Real-Time Analytics API for a Fitness App with Tinybird

Build a Real-Time Analytics API for a Fitness App with Tinybird

Comments 1
5 min read
Redis cheatsheet

Redis cheatsheet

2
Comments
2 min read
Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

Comments
2 min read
🎯 Day 18 – Revised @PostMapping & @GetMapping, Started @PutMapping in Spring Boot

🎯 Day 18 – Revised @PostMapping & @GetMapping, Started @PutMapping in Spring Boot

Comments 3
1 min read
Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

Comments
2 min read
AWS Databases Unlocked: Choosing the Right Engine for Your Application in 2025

AWS Databases Unlocked: Choosing the Right Engine for Your Application in 2025

5
Comments 1
12 min read
Test Data Management Demystified: A Comprehensive How-To Guide

Test Data Management Demystified: A Comprehensive How-To Guide

25
Comments
8 min read
Human-Readable IDs in PrismaJS with a few lines of code

Human-Readable IDs in PrismaJS with a few lines of code

Comments
2 min read
Schema Changes in MySQL: Will Your Table Be Locked?

Schema Changes in MySQL: Will Your Table Be Locked?

6
Comments
6 min read
loading...