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.
Pagination: Does It Belong in the Domain or in the Adapter?

Pagination: Does It Belong in the Domain or in the Adapter?

Comments
8 min read
Pessimistic vs Optimistic Locking in Hexagonal PHP

Pessimistic vs Optimistic Locking in Hexagonal PHP

Comments
9 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
DBAL Without an ORM: When a 50-Line Mapper Beats Doctrine

DBAL Without an ORM: When a 50-Line Mapper Beats Doctrine

Comments
9 min read
The Specification Pattern in PHP: Querying Without Leaking SQL

The Specification Pattern in PHP: Querying Without Leaking SQL

Comments
9 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
If someone asked you who accessed your production database last Tuesday, could you answer?

If someone asked you who accessed your production database last Tuesday, could you answer?

Comments 1
4 min read
Customer Shopping Behavior Analysis: Driving Retail Insights with Data

Customer Shopping Behavior Analysis: Driving Retail Insights with Data

Comments
2 min read
Understanding DDL and DML SQL concepts

Understanding DDL and DML SQL concepts

Comments
3 min read
Why Normalizing Data Early Saves Trouble Later

Why Normalizing Data Early Saves Trouble Later

Comments
2 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
I built a local-first hybrid vector database in Rust from scratch

I built a local-first hybrid vector database in Rust from scratch

Comments
1 min read
EF Core Named query filters

EF Core Named query filters

1
Comments
3 min read
I Turned Obsidian Into a Live SOC Dashboard

I Turned Obsidian Into a Live SOC Dashboard

1
Comments 3
9 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.