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.
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
OLAP and OLTP Explained Simply for Curious Developers

OLAP and OLTP Explained Simply for Curious Developers

Comments
4 min read
DB_DEVELOPER_ROLE Role in Oracle Database 23ai

DB_DEVELOPER_ROLE Role in Oracle Database 23ai

Comments
3 min read
Handling Transactions on Large Tables in High-Traffic C# Applications

Handling Transactions on Large Tables in High-Traffic C# Applications

Comments
2 min read
C# How to ambient transaction work under the hood

C# How to ambient transaction work under the hood

1
Comments
6 min read
Ecto para Elixir: Guia para Iniciantes sobre Interações com Banco de Dados

Ecto para Elixir: Guia para Iniciantes sobre Interações com Banco de Dados

1
Comments
3 min read
Ecto for Elixir: A Beginner's Guide to Database Interactions

Ecto for Elixir: A Beginner's Guide to Database Interactions

1
Comments
3 min read
Day 4 I have revised some of oracle concepts

Day 4 I have revised some of oracle concepts

Comments
1 min read
Building a conversational AI tool for real-time analytics

Building a conversational AI tool for real-time analytics

1
Comments
8 min read
SQL Fundamentals for Beginners

SQL Fundamentals for Beginners

Comments
4 min read
Indexing Deep Dive: Composite Indexes & Real Query Experiments

Indexing Deep Dive: Composite Indexes & Real Query Experiments

2
Comments
2 min read
DuckDB 🦆 : Libérez le puissant moteur de Requêtes

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

Comments
8 min read
Data Engineering: The Hero Behind Smart Data Decisions

Data Engineering: The Hero Behind Smart Data Decisions

Comments
1 min read
loading...