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.
Designing an orders table: it is not that simple

Designing an orders table: it is not that simple

Comments
2 min read
🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

Comments
2 min read
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

Comments 1
5 min read
Stop Paying for Vector Databases: How to Build AI Search in Postgres

Stop Paying for Vector Databases: How to Build AI Search in Postgres

Comments
4 min read
I Built a Database Engine in Rust for My Robot and Learned That SQLite Was the Wrong Battle

I Built a Database Engine in Rust for My Robot and Learned That SQLite Was the Wrong Battle

4
Comments
6 min read
ClickHouse ReplacingMergeTree - Why Your Row Count Does Not Match

ClickHouse ReplacingMergeTree - Why Your Row Count Does Not Match

1
Comments
4 min read
The database has to be a defensive boundary again

The database has to be a defensive boundary again

1
Comments 2
3 min read
Cloud Database Cost Optimization: RDS, Cloud SQL, and Cosmos DB Compared

Cloud Database Cost Optimization: RDS, Cloud SQL, and Cosmos DB Compared

Comments
8 min read
System Design Learning Journey — Week 2: Storage & Retrieval

System Design Learning Journey — Week 2: Storage & Retrieval

Comments
3 min read
PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

Comments
4 min read
Running Postgres at Scale: Lessons Learned

Running Postgres at Scale: Lessons Learned

Comments
2 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

Comments
2 min read
Persistent Chat History with Database Design (Practical Example)

Persistent Chat History with Database Design (Practical Example)

Comments
7 min read
UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

2
Comments
2 min read
null=True on CharField Is Always Wrong — Here Is Why

null=True on CharField Is Always Wrong — Here Is Why

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