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
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
What Surprised Me About Migrating Our Monolithic SQL Database to MongoDB in Production

What Surprised Me About Migrating Our Monolithic SQL Database to MongoDB in Production

Comments
6 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
Understanding DDL and DML SQL concepts

Understanding DDL and DML SQL concepts

Comments
3 min read
Vector Databases for RAG: Pinecone vs. Weaviate vs. Milvus vs. PGVector 0.8 (PostgreSQL 18)

Vector Databases for RAG: Pinecone vs. Weaviate vs. Milvus vs. PGVector 0.8 (PostgreSQL 18)

Comments
16 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
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
SQL FUNCTIONS,QUERIES AND JOINTS.

SQL FUNCTIONS,QUERIES AND JOINTS.

Comments
2 min read
Is Lovable Actually Secure? I Checked the Supabase RLS on 50 Apps

Is Lovable Actually Secure? I Checked the Supabase RLS on 50 Apps

1
Comments
3 min read
SQL Fundamentals: DDL, DML, and Practical Data Manipulation

SQL Fundamentals: DDL, DML, and Practical Data Manipulation

Comments
6 min read
Stop Generating Synthetic Datasets. Start Generating Synthetic Systems.

Stop Generating Synthetic Datasets. Start Generating Synthetic Systems.

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