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.
Local Analysis of Garmin Activities and Fitness Data without Cloud

Local Analysis of Garmin Activities and Fitness Data without Cloud

Comments
4 min read
How We Built a Disaggregated Storage Layer for a Columnar MPP Database (And What Broke in Production)

How We Built a Disaggregated Storage Layer for a Columnar MPP Database (And What Broke in Production)

Comments
6 min read
TradeMemory An AI-Powered Persistence Layer for Disciplined Trading

TradeMemory An AI-Powered Persistence Layer for Disciplined Trading

1
Comments
4 min read
I built a storage engine from scratch. Here’s everything I learned.

I built a storage engine from scratch. Here’s everything I learned.

Comments 2
5 min read
How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

1
Comments
6 min read
Seed Data Without a Dependency Tree: A Tiny PHP CLI Instead of Faker

Seed Data Without a Dependency Tree: A Tiny PHP CLI Instead of Faker

Comments
10 min read
Secure Database Access for AI Agents: Building an MCP Server with SQLatte

Secure Database Access for AI Agents: Building an MCP Server with SQLatte

2
Comments 3
6 min read
Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘

Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘

2
Comments
4 min read
PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

Comments
4 min read
Apache IoTDB in Connected Vehicle Management: Scaling Telemetry for Millions

Apache IoTDB in Connected Vehicle Management: Scaling Telemetry for Millions

Comments
3 min read
Filtering, sorting, and pagination with the fluent query builder

Filtering, sorting, and pagination with the fluent query builder

Comments
3 min read
Apache Data Lakehouse Weekly: April 9–15, 2026

Apache Data Lakehouse Weekly: April 9–15, 2026

Comments
7 min read
Using RPAD in GBase 8s: Syntax, Examples, and a Stored Procedure Hack

Using RPAD in GBase 8s: Syntax, Examples, and a Stored Procedure Hack

2
Comments
2 min read
SQL vs NoSQL: Which one to choose for your next project?

SQL vs NoSQL: Which one to choose for your next project?

Comments
3 min read
Redis Caching Strategies: What Actually Works in Production

Redis Caching Strategies: What Actually Works in Production

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