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.
The effect of frequent values on histogram_bounds in PostgreSQL

The effect of frequent values on histogram_bounds in PostgreSQL

Comments 1
4 min read
🚀 Introducing PSQLab – Your In-Browser PostgreSQL Playground

🚀 Introducing PSQLab – Your In-Browser PostgreSQL Playground

7
Comments
3 min read
How did a cloud-native database company quickly achieve SOC 2 and GDPR certifications?

How did a cloud-native database company quickly achieve SOC 2 and GDPR certifications?

Comments
5 min read
The Life of a Query in SQL - It's More Dramatic Than You Think 😨

The Life of a Query in SQL - It's More Dramatic Than You Think 😨

5
Comments
2 min read
Tipos de Índices no SQL: B-Tree, Hash, GiST, GIN e BRIN

Tipos de Índices no SQL: B-Tree, Hash, GiST, GIN e BRIN

Comments
2 min read
Implementing Multi-Tenancy in DynamoDB with Python

Implementing Multi-Tenancy in DynamoDB with Python

Comments
4 min read
One-click import of Excel to database

One-click import of Excel to database

Comments
3 min read
Smooth Database Migrations in a Fast-Moving World

Smooth Database Migrations in a Fast-Moving World

12
Comments
4 min read
Mastering Redis : The In-Memory Data Structure Store You Need to Know 🚀

Mastering Redis : The In-Memory Data Structure Store You Need to Know 🚀

4
Comments 2
9 min read
I Thought My Backups Were Safe - Until I Tried Restoring One

I Thought My Backups Were Safe - Until I Tried Restoring One

20
Comments 15
4 min read
SQL Composite Indexes: When to Use?

SQL Composite Indexes: When to Use?

5
Comments
3 min read
How to Connect a React App with MySQL Database

How to Connect a React App with MySQL Database

9
Comments
4 min read
Stop Using Your Database as a Message Queue: Why It's a Bad Idea

Stop Using Your Database as a Message Queue: Why It's a Bad Idea

Comments
5 min read
Prisma + Neon DB Error P1001 Explained (with Pizza 🍕)

Prisma + Neon DB Error P1001 Explained (with Pizza 🍕)

Comments 1
2 min read
DataCap 2025.1.0 Major Release: New Notification Center & Enhanced Metadata Management

DataCap 2025.1.0 Major Release: New Notification Center & Enhanced Metadata Management

Comments
2 min read
Real-Time As-Of Joins in Streaming Databases: How We Solved Out-of-Order Event Matching

Real-Time As-Of Joins in Streaming Databases: How We Solved Out-of-Order Event Matching

1
Comments
3 min read
Foreign Keys: A must in SQL, but not in a Document Database?

Foreign Keys: A must in SQL, but not in a Document Database?

20
Comments
7 min read
MongoDB for Beginners: The Complete Guide to CRUD Operations

MongoDB for Beginners: The Complete Guide to CRUD Operations

2
Comments
6 min read
The World Is Too Messy for SQL to Work

The World Is Too Messy for SQL to Work

21
Comments 15
10 min read
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

3
Comments
6 min read
Stop One-By-One Inserts! Bulk Insert Data In Rails With insert_all Or activerecord-import ⚡

Stop One-By-One Inserts! Bulk Insert Data In Rails With insert_all Or activerecord-import ⚡

Comments
4 min read
5 Questions You Should Ask Before Adopting a TSDB for IIoT

5 Questions You Should Ask Before Adopting a TSDB for IIoT

Comments
4 min read
Benchmarking Databases for Real-Time Analytics Applications

Benchmarking Databases for Real-Time Analytics Applications

91
Comments 5
3 min read
🚀 Optimize EF Core Queries with AsSplitQuery()

🚀 Optimize EF Core Queries with AsSplitQuery()

8
Comments
3 min read
Oracle 23ai - Hybrid Read-Only Mode for Pluggable Databases

Oracle 23ai - Hybrid Read-Only Mode for Pluggable Databases

Comments
1 min read
loading...