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.
Deploy to Oracle with drm-cli + Flyway: No Enterprise License Required

Deploy to Oracle with drm-cli + Flyway: No Enterprise License Required

1
Comments
4 min read
Database Reliability: The SRE Approach to Keeping Data Safe

Database Reliability: The SRE Approach to Keeping Data Safe

1
Comments
3 min read
I got tired of juggling 5 database GUIs, so I built one for all of them

I got tired of juggling 5 database GUIs, so I built one for all of them

1
Comments
3 min read
From Tables to Tides: Navigating Databases, Warehouses, Marts, Lakes, and the Lakehouse Revolution

From Tables to Tides: Navigating Databases, Warehouses, Marts, Lakes, and the Lakehouse Revolution

1
Comments
7 min read
PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

Comments
4 min read
How Power BI is Used in Real-World Data Analysis

How Power BI is Used in Real-World Data Analysis

Comments
2 min read
DuckDB Streaming, SQLite BLOB Output, & Securing Postgres for AI Agents

DuckDB Streaming, SQLite BLOB Output, & Securing Postgres for AI Agents

1
Comments
3 min read
Vector Databases for AI (Milvus/Pinecone)

Vector Databases for AI (Milvus/Pinecone)

1
Comments
8 min read
PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

1
Comments
4 min read
Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

1
Comments
4 min read
Don't Trust AI-Generated SQL Blindly: A Developer's Validation Checklist

Don't Trust AI-Generated SQL Blindly: A Developer's Validation Checklist

1
Comments 1
6 min read
Indexing Strategies for Faster Database Queries

Indexing Strategies for Faster Database Queries

1
Comments
7 min read
I built a Graph database to catch money launderers. Here's what I actually learned.

I built a Graph database to catch money launderers. Here's what I actually learned.

Comments
5 min read
No Indexes, No Parameters, No Problem

No Indexes, No Parameters, No Problem

Comments
4 min read
Build SQL Queries Without Writing SQL

Build SQL Queries Without Writing SQL

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