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.
Retrieval Technique Series-4.How Search Engines Generate Indexes for Trillions of Websites?

Retrieval Technique Series-4.How Search Engines Generate Indexes for Trillions of Websites?

2
Comments
5 min read
Set up a Neon PR branch for a React Native Expo application using GitHub Actions

Set up a Neon PR branch for a React Native Expo application using GitHub Actions

Comments
1 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
Scrape Swiggy Reviews Data | Zomato Reviews Data Extraction

Scrape Swiggy Reviews Data | Zomato Reviews Data Extraction

Comments
3 min read
Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)

Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)

Comments
7 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
What is Data Engineering?

What is Data Engineering?

Comments
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
When Not to Use DB Indexes

When Not to Use DB Indexes

Comments
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
The Day I Passed Out Because of a Single AWS Command

The Day I Passed Out Because of a Single AWS Command

Comments
2 min read
#35 Python & Alteryx Integration: Unlocking Advanced Analytics

#35 Python & Alteryx Integration: Unlocking Advanced Analytics

Comments
3 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

2
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
Oracle 23ai: Direct Joins for UPDATE and DELETE Statements

Oracle 23ai: Direct Joins for UPDATE and DELETE Statements

Comments
1 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
Scaling PostgreSQL Performance with Table Partitioning

Scaling PostgreSQL Performance with Table Partitioning

48
Comments 7
12 min read
🚀 MongoDB Aggregation Challenge - Lookup & Grouping Mastery 🔥

🚀 MongoDB Aggregation Challenge - Lookup & Grouping Mastery 🔥

Comments
2 min read
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

6
Comments 1
3 min read
loading...