Sponsored Content

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.
Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph

Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph

Comments
3 min read
LatticeDB vs SQLite: I Ran the Graph Traversal Benchmarks. The Gap Is Real but the Fine Print Matters

LatticeDB vs SQLite: I Ran the Graph Traversal Benchmarks. The Gap Is Real but the Fine Print Matters

Comments
8 min read
Turn any SQL schema into an interactive ER diagram

Turn any SQL schema into an interactive ER diagram

Comments
2 min read
I broke my own database with an infinite loop, and here's what I learned about Row Level Security

I broke my own database with an infinite loop, and here's what I learned about Row Level Security

1
Comments
4 min read
How Express Actually Talks to a Database: From HTTP Request to SQL Query

How Express Actually Talks to a Database: From HTTP Request to SQL Query

Comments
12 min read
Can I veto the agent's DDL before it hits main?

Can I veto the agent's DDL before it hits main?

Comments
7 min read
Backups You Have Never Restored Are Just Hope

Backups You Have Never Restored Are Just Hope

Comments
2 min read
SQL Date Functions: How to Group by Month Without Losing One

SQL Date Functions: How to Group by Month Without Losing One

Comments
16 min read
Why Your Database Needs a Taxi Stand: An Intro to Connection Pooling

Why Your Database Needs a Taxi Stand: An Intro to Connection Pooling

Comments
3 min read
Cohort Retention Analysis in SQL, Step by Step

Cohort Retention Analysis in SQL, Step by Step

Comments
14 min read
Funnel Conversion in SQL, and the Step That Shows 100%

Funnel Conversion in SQL, and the Step That Shows 100%

Comments
14 min read
When to Index a Table: A Practical Guide for Analysts

When to Index a Table: A Practical Guide for Analysts

Comments
15 min read
Caching Strategies Explained: From Browser to Database, and the Stale Data in Between

Caching Strategies Explained: From Browser to Database, and the Stale Data in Between

Comments
10 min read
I DNA-encode my encrypted database before writing it to disk - here's why (and why it's not "quantum" anything)

I DNA-encode my encrypted database before writing it to disk - here's why (and why it's not "quantum" anything)

Comments 1
2 min read
Add real search to your Python web app — no Elasticsearch, no separate service

Add real search to your Python web app — no Elasticsearch, no separate service

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