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 Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

4
Comments 2
3 min read
How to configure multiple databases on individual domain names using a single Odoo instance? [A Multi-Tenant Odoo App]

How to configure multiple databases on individual domain names using a single Odoo instance? [A Multi-Tenant Odoo App]

Comments
4 min read
Substring from a Column of Strings — From SQL to SPL #25

Substring from a Column of Strings — From SQL to SPL #25

5
Comments 1
2 min read
Total under Recursive Relationship — From SQL to SPL #33

Total under Recursive Relationship — From SQL to SPL #33

7
Comments 1
2 min read
Learning PostgreSQL

Learning PostgreSQL

Comments
2 min read
Importing Excel with multiple headers into a database

Importing Excel with multiple headers into a database

Comments
1 min read
Batch export database tables to Excel

Batch export database tables to Excel

Comments
2 min read
How to install PostgreSQL on macOS: Step-by-Step Instructions

How to install PostgreSQL on macOS: Step-by-Step Instructions

Comments
1 min read
Isolation Level for MongoDB Multi-Document Transactions

Isolation Level for MongoDB Multi-Document Transactions

3
Comments 1
11 min read
Couchbase Weekly Updates - May 16, 2025

Couchbase Weekly Updates - May 16, 2025

1
Comments
1 min read
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)

JSONB DeTOASTing (read amplification)

4
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

24
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

12
Comments 2
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
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
loading...