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.
SFMC Data Extension Performance: Query Optimization Under Load

SFMC Data Extension Performance: Query Optimization Under Load

Comments
4 min read
Time-Series Databases (InfluxDB/TimescaleDB)

Time-Series Databases (InfluxDB/TimescaleDB)

1
Comments
8 min read
Why We Stopped Using Row-Level Security After 1M Rows

Why We Stopped Using Row-Level Security After 1M Rows

Comments 1
6 min read
PostgreSQL Monitoring Tools Compared (2026)

PostgreSQL Monitoring Tools Compared (2026)

Comments
4 min read
GBase 8a Date Functions: A Complete Guide to Day-Related Built-ins

GBase 8a Date Functions: A Complete Guide to Day-Related Built-ins

2
Comments
3 min read
Don't Calculate Distances in PHP: Master PostGIS in Laravel 🗺️

Don't Calculate Distances in PHP: Master PostGIS in Laravel 🗺️

Comments
2 min read
If someone asked you who accessed your production database last Tuesday, could you answer?

If someone asked you who accessed your production database last Tuesday, could you answer?

Comments 1
4 min read
Customer Shopping Behavior Analysis: Driving Retail Insights with Data

Customer Shopping Behavior Analysis: Driving Retail Insights with Data

Comments
2 min read
Understanding DDL and DML SQL concepts

Understanding DDL and DML SQL concepts

Comments
3 min read
Why Normalizing Data Early Saves Trouble Later

Why Normalizing Data Early Saves Trouble Later

Comments
2 min read
DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

Comments
3 min read
I built a local-first hybrid vector database in Rust from scratch

I built a local-first hybrid vector database in Rust from scratch

Comments
1 min read
I Turned Obsidian Into a Live SOC Dashboard

I Turned Obsidian Into a Live SOC Dashboard

1
Comments 3
9 min read
ClickHouse Is Fast. Your Pipeline Isn't.

ClickHouse Is Fast. Your Pipeline Isn't.

Comments
6 min read
How I Built a Runtime Adaptive Compression System That Selects the Best Algorithm Without Scanning All Data

How I Built a Runtime Adaptive Compression System That Selects the Best Algorithm Without Scanning All Data

Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.