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.
🌐 🚀 Scale Your Business with DigitalOcean: Powerful, Affordable Cloud Hosting

🌐 🚀 Scale Your Business with DigitalOcean: Powerful, Affordable Cloud Hosting

Comments
1 min read
How to Backup SQL Server RDS to an S3 Bucket

How to Backup SQL Server RDS to an S3 Bucket

Comments
1 min read
Relational Database Design

Relational Database Design

Comments
12 min read
Advanced Single Table Design Patterns With DynamoDB

Advanced Single Table Design Patterns With DynamoDB

1
Comments
4 min read
Running PostgreSQL, MongoDB, and NestJS concurrently with Docker Compose

Running PostgreSQL, MongoDB, and NestJS concurrently with Docker Compose

Comments
19 min read
The Best Time-Series Databases Compared

The Best Time-Series Databases Compared

2
Comments 2
17 min read
Normalização dos Bancos de Dados Relacionais (Handbook)

Normalização dos Bancos de Dados Relacionais (Handbook)

Comments
4 min read
Building a Go Database Page Management System: A Deep Dive into Efficient Data Storage 🚀

Building a Go Database Page Management System: A Deep Dive into Efficient Data Storage 🚀

Comments
3 min read
A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control

A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control

Comments
3 min read
My first docker app

My first docker app

Comments
1 min read
The Columnar Approach: A Deep Dive into Efficient Data Storage for Analytics 🚀

The Columnar Approach: A Deep Dive into Efficient Data Storage for Analytics 🚀

Comments
4 min read
Resumo de conceitos de bancos de dados relacionais

Resumo de conceitos de bancos de dados relacionais

Comments
4 min read
🚀 Mastering Delta Encoding: The Secret to Smarter Data Compression 💡

🚀 Mastering Delta Encoding: The Secret to Smarter Data Compression 💡

3
Comments
3 min read
A Quick Guide to SQL Data Modification Commands with Examples

A Quick Guide to SQL Data Modification Commands with Examples

1
Comments
3 min read
Working with JSON in MySQL

Working with JSON in MySQL

3
Comments
3 min read
Enterprise Data Architecture and Modeling: Key Practices and Trends

Enterprise Data Architecture and Modeling: Key Practices and Trends

1
Comments
1 min read
Real-Time Data Integration Techniques Using PostgreSQL Foreign Data Wrapper (FDW)

Real-Time Data Integration Techniques Using PostgreSQL Foreign Data Wrapper (FDW)

1
Comments
10 min read
Curiosity: Using Ably.io Realtime Messaging as a Lightweight Database

Curiosity: Using Ably.io Realtime Messaging as a Lightweight Database

Comments
2 min read
Why You Should Use ORM Tools in Your Projects in 2025

Why You Should Use ORM Tools in Your Projects in 2025

Comments
3 min read
Index Filtering in PostgreSQL and YugabyteDB (Index Scan instead of Index Only Scan)

Index Filtering in PostgreSQL and YugabyteDB (Index Scan instead of Index Only Scan)

Comments
12 min read
SQL VS NoSQL

SQL VS NoSQL

Comments
2 min read
What Happens When a Database Crashes Mid-Transaction? Understanding Recovery and Data Integrity

What Happens When a Database Crashes Mid-Transaction? Understanding Recovery and Data Integrity

1
Comments
4 min read
This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points

This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points

6
Comments
7 min read
Choosing the Right Time Series Database for Your Use Case

Choosing the Right Time Series Database for Your Use Case

2
Comments 1
2 min read
Subqueries

Subqueries

Comments
1 min read
On the Andy Pavlo's DB review

On the Andy Pavlo's DB review

1
Comments
2 min read
Calculate monthly account balance and fill in missing dates:From SQL to SPL

Calculate monthly account balance and fill in missing dates:From SQL to SPL

6
Comments
2 min read
2024 in Review: Key Highlights in Cloud Databases

2024 in Review: Key Highlights in Cloud Databases

Comments
5 min read
How And Why The Developer-First Approach Is Changing The Observability Landscape

How And Why The Developer-First Approach Is Changing The Observability Landscape

Comments
11 min read
Decoding ORM: A Deep Dive into Object-Relational Mapping

Decoding ORM: A Deep Dive into Object-Relational Mapping

Comments
6 min read
Metrics Mayhem

Metrics Mayhem

Comments
1 min read
Redefining Telehealth for Vulnerable Populations

Redefining Telehealth for Vulnerable Populations

Comments
1 min read
MongoDB: Startup replica sets with a config file

MongoDB: Startup replica sets with a config file

Comments
2 min read
MongoDB: How to setup replica sets

MongoDB: How to setup replica sets

Comments
3 min read
Dev Video Review: Firestore Data Structure, Limitations, and IMHO

Dev Video Review: Firestore Data Structure, Limitations, and IMHO

Comments
2 min read
JavaScript using Node.js and accessing and modifying phpMyAdmin database.

JavaScript using Node.js and accessing and modifying phpMyAdmin database.

Comments
2 min read
The Popcorn Problem - lowCal_update 8

The Popcorn Problem - lowCal_update 8

Comments
1 min read
SQL Server: Get database port

SQL Server: Get database port

Comments
1 min read
The difference between the (DDL AND DML) DATABASE

The difference between the (DDL AND DML) DATABASE

Comments
1 min read
How can I securely store user data in a cryptocurrency exchange database?

How can I securely store user data in a cryptocurrency exchange database?

1
Comments
1 min read
Database Scaling NLogN 📈

Database Scaling NLogN 📈

Comments
3 min read
Troubleshooting "canceling statement due to conflict with recovery" in PostgreSQL: A Practical Guide

Troubleshooting "canceling statement due to conflict with recovery" in PostgreSQL: A Practical Guide

1
Comments
4 min read
Monitoring AWS RDS Postgres Parameter Changes

Monitoring AWS RDS Postgres Parameter Changes

Comments 1
4 min read
How to do Review Sentiment Analysis using Python

How to do Review Sentiment Analysis using Python

Comments
6 min read
Do you think schema flexibility justifies using NoSQL? Think twice.

Do you think schema flexibility justifies using NoSQL? Think twice.

Comments
4 min read
Why 54% of Organizations Are Moving to Cloud Data Warehouses

Why 54% of Organizations Are Moving to Cloud Data Warehouses

Comments
5 min read
A Deep Dive into Database Architecture: Building the Backbone of Modern Systems 🏗️

A Deep Dive into Database Architecture: Building the Backbone of Modern Systems 🏗️

Comments
4 min read
Understanding PDO in PHP and Why It is Recommended Over `mysql_*` Functions

Understanding PDO in PHP and Why It is Recommended Over `mysql_*` Functions

Comments
4 min read
Trees in SQL

Trees in SQL

Comments
9 min read
SQL 101 | Chapter 1: Understanding SQL and Databases

SQL 101 | Chapter 1: Understanding SQL and Databases

1
Comments
3 min read
Trees in SQL (part 2)

Trees in SQL (part 2)

Comments
5 min read
3 Things You Need To Take Control Of Your Database

3 Things You Need To Take Control Of Your Database

Comments
3 min read
Sequelize seeders for static data

Sequelize seeders for static data

Comments
2 min read
Sequelize migrations

Sequelize migrations

Comments
2 min read
HadiDB: A Lightweight, Horizontally Scalable Database in Python

HadiDB: A Lightweight, Horizontally Scalable Database in Python

Comments
3 min read
Exploring OSM changesets via DuckDB

Exploring OSM changesets via DuckDB

Comments
9 min read
Big Discovery - lowCalAlt_update 7

Big Discovery - lowCalAlt_update 7

Comments
1 min read
A Simple Guide for Choosing the Right Database

A Simple Guide for Choosing the Right Database

Comments
8 min read
lowCalAlt_update 6

lowCalAlt_update 6

Comments
1 min read
Iterations

Iterations

Comments
6 min read
loading...