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.
How to Implement JOIN Operations Between Tables from Different Databases with esProc?

How to Implement JOIN Operations Between Tables from Different Databases with esProc?

6
Comments 1
8 min read
🚀 My DevOps Journey: From Linux Basics to Dockerized Projects — Follow Along on GitHub! 🐧🐳

🚀 My DevOps Journey: From Linux Basics to Dockerized Projects — Follow Along on GitHub! 🐧🐳

3
Comments
1 min read
Cache OpenAI Embeddings with SQLite for Low-Cost Astro Builds

Cache OpenAI Embeddings with SQLite for Low-Cost Astro Builds

Comments
6 min read
JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database

JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database

7
Comments 1
5 min read
How to Handle Millions of Rows in SQL Without Killing Performance

How to Handle Millions of Rows in SQL Without Killing Performance

29
Comments 1
2 min read
How to Set Up a PostgreSQL Database with Drizzle ORM and Neon DB in Node.js

How to Set Up a PostgreSQL Database with Drizzle ORM and Neon DB in Node.js

13
Comments 2
7 min read
I Replaced MongoDB with a Single Postgres Table

I Replaced MongoDB with a Single Postgres Table

107
Comments 31
7 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

5
Comments 1
4 min read
Couchbase Weekly Updates - May 23, 2025

Couchbase Weekly Updates - May 23, 2025

1
Comments
1 min read
Configurer des sauvegardes incrémentales avec PostgreSql - Introduction-Partie 1

Configurer des sauvegardes incrémentales avec PostgreSql - Introduction-Partie 1

1
Comments
8 min read
Pydantic 2: The Complete Guide for Python Developers - From Basics to Advanced Techniques

Pydantic 2: The Complete Guide for Python Developers - From Basics to Advanced Techniques

3
Comments
25 min read
What's the worst mistake you've ever pushed to production or deleted by accident? 🤔

What's the worst mistake you've ever pushed to production or deleted by accident? 🤔

3
Comments 4
1 min read
Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

5
Comments
8 min read
#34 50 Advanced SQL Queries Every Developer Should Know

#34 50 Advanced SQL Queries Every Developer Should Know

2
Comments
7 min read
Setting Up PostgreSQL on macOS: A Fresh Start Guide

Setting Up PostgreSQL on macOS: A Fresh Start Guide

2
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.