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.
Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)

Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)

21
Comments
4 min read
What makes PostgreSQL different from MongoDB, beyond "SQL vs NoSQL"?

What makes PostgreSQL different from MongoDB, beyond "SQL vs NoSQL"?

1
Comments
2 min read
Day 2:SQL

Day 2:SQL

1
Comments
1 min read
Day 2:Python Programming

Day 2:Python Programming

1
Comments
1 min read
Understanding Normalization in DBMS: Simplifying Complex Data Structures

Understanding Normalization in DBMS: Simplifying Complex Data Structures

Comments
1 min read
Top 5 Ways to Combine pg_dump with Cloud Storage

Top 5 Ways to Combine pg_dump with Cloud Storage

Comments
5 min read
SFTP, FTPS, or Something Better? Choosing the Right File Transfer Approach for 2026

SFTP, FTPS, or Something Better? Choosing the Right File Transfer Approach for 2026

33
Comments
7 min read
.NET Performance Optimization: Fixing a 15-Second E-Commerce Page Load

.NET Performance Optimization: Fixing a 15-Second E-Commerce Page Load

9
Comments
16 min read
Similarities Between a Stored Procedure in SQL and a Function in Python

Similarities Between a Stored Procedure in SQL and a Function in Python

Comments
3 min read
Built an Audit System in a Single 15MB Binary That Even DBAs Can't Fool

Built an Audit System in a Single 15MB Binary That Even DBAs Can't Fool

2
Comments
4 min read
Database Caching: Optimizing Performance and Scalability

Database Caching: Optimizing Performance and Scalability

Comments
3 min read
From DataWareHouses to BigData Systems: What and Why - Questions that nobody asks, but you should!

From DataWareHouses to BigData Systems: What and Why - Questions that nobody asks, but you should!

Comments
6 min read
Restoring a Lost Datafile from Standby Using RMAN

Restoring a Lost Datafile from Standby Using RMAN

1
Comments
1 min read
The "Distributed State Tax" and Why We Don't Always Need Redis: Introducing C3

The "Distributed State Tax" and Why We Don't Always Need Redis: Introducing C3

3
Comments
5 min read
1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
My Experience on NoSQL Data Analysis Using Dataset From Kaggle

My Experience on NoSQL Data Analysis Using Dataset From Kaggle

Comments
3 min read
🧩 Updated AppDbContext.cs (Full Version)

🧩 Updated AppDbContext.cs (Full Version)

Comments
2 min read
Yoyo migrate vs Golang migrate

Yoyo migrate vs Golang migrate

Comments
2 min read
Launching Gemini CLI extensions for Google Data Cloud

Launching Gemini CLI extensions for Google Data Cloud

48
Comments
6 min read
Module_0.0: The Cloud Computing Introduction: Similarities and Differences Between Traditional IT Infrastructures.

Module_0.0: The Cloud Computing Introduction: Similarities and Differences Between Traditional IT Infrastructures.

Comments
2 min read
How Databases Actually Store Data (And Why You Should Care)

How Databases Actually Store Data (And Why You Should Care)

8
Comments 1
4 min read
Surface-First Schema Design

Surface-First Schema Design

1
Comments
7 min read
Acid Properties in SQL

Acid Properties in SQL

1
Comments
2 min read
My Experience on NoSQL Data Analysis

My Experience on NoSQL Data Analysis

Comments
3 min read
📅 Day 5 — Invoice Module Base Setup —

📅 Day 5 — Invoice Module Base Setup —

Comments
3 min read
loading...