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.
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
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
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)

2
Comments
6 min read
Oracle Database Performance Monitoring: A Practitioner's Decision Framework

Oracle Database Performance Monitoring: A Practitioner's Decision Framework

1
Comments 1
20 min read
Fixing an email confirmation problem in Supabase

Fixing an email confirmation problem in Supabase

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

Filtering, sorting, and pagination with the fluent query builder

Comments
3 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
Stop Writing Ugly SQL: A Developer's Guide to Clean, Readable Queries

Stop Writing Ugly SQL: A Developer's Guide to Clean, Readable Queries

8
Comments 2
6 min read
Stop Checking if Records Exist: Using UPSERT in Rust to Prevent Duplicate Data

Stop Checking if Records Exist: Using UPSERT in Rust to Prevent Duplicate Data

Comments
1 min read
How We Built Sub-0.2ms Player Segmentation That Actually Works in Live Games

How We Built Sub-0.2ms Player Segmentation That Actually Works in Live Games

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