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.
ETL vs ELT: Which One Should You Use and Why?
robert_njuguna profile

ETL vs ELT: Which One Should You Use and Why?

#dataengineering #database #data #luxdev
1
Comments
7 min read
Designing an orders table: it is not that simple
charliet1802 profile

Designing an orders table: it is not that simple

#softwareengineering #softwaredevelopment #careerdevelopment #database
Comments
2 min read
SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation
soytuber profile
soy

SQLite Join Benchmarks, PostgreSQL for AI Graphs with pgvector, & pGenie for SQL Validation

#database #sql #sqlite
Comments
3 min read
5 Reasons AdventureWorks Is a Terrible Test Database in 2026
mindweavetech profile

5 Reasons AdventureWorks Is a Terrible Test Database in 2026

#ai #database #testing #opensource
Comments
2 min read
PostgreSQL JSONB for Tracking European Video Trends
ahmet_gedik778845 profile

PostgreSQL JSONB for Tracking European Video Trends

#postgres #database #analytics #webdev
Comments
3 min read
Designing an orders table: it is not that simple
charliet1802 profile

Designing an orders table: it is not that simple

#softwareengineering #softwaredevelopment #careerdevelopment #database
Comments
2 min read
🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀
shreyash_ogale profile

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

#beginners #database #mysql #sql
Comments
2 min read
I Built a Database Engine in Rust for My Robot and Learned That SQLite Was the Wrong Battle
motedb profile
mote

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

#rust #database #embedded #opensource
4
Comments
6 min read
System Design Learning Journey — Week 2: Storage & Retrieval
majdsufian profile

System Design Learning Journey — Week 2: Storage & Retrieval

#systemdesign #sql #database #scala
Comments
3 min read
Cloud Database Cost Optimization: RDS, Cloud SQL, and Cosmos DB Compared
muskan_8abedcc7e12 profile
Muskan

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

#cloud #database #cost #optimization
Comments
8 min read
ClickHouse ReplacingMergeTree - Why Your Row Count Does Not Match
ankitmalikg profile

ClickHouse ReplacingMergeTree - Why Your Row Count Does Not Match

#clickhouse #database #warehouse #analytics
1
Comments
4 min read
PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained
philip_mcclarence_2ef9475 profile

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql
Comments
4 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types
shreyash_ogale profile

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

#beginners #database #mysql #sql
Comments
2 min read
Persistent Chat History with Database Design (Practical Example)
janefrances profile

Persistent Chat History with Database Design (Practical Example)

#backenddevelopment #database #backend #databasedesign
Comments
7 min read
UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison
digipackhq profile

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

#sql #database #python #beginners
2
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.