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.
Implementing Soft Delete with Filtered Indexes in Entity Framework Core

Implementing Soft Delete with Filtered Indexes in Entity Framework Core

1
Comments
4 min read
The 8 tables behind a real auth system (Postgres schema, explained column by column)

The 8 tables behind a real auth system (Postgres schema, explained column by column)

3
Comments
10 min read
PostgreSQL Backup and Recovery: A Complete Guide

PostgreSQL Backup and Recovery: A Complete Guide

Comments
5 min read
TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)

TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)

Comments
5 min read
PostgreSQL Row Level Security: A Complete Guide

PostgreSQL Row Level Security: A Complete Guide

1
Comments
2 min read
Criando a melhor arquitetura possĂ­vel para o site de velas virtuais do Padre Marcelo Rossi

Criando a melhor arquitetura possĂ­vel para o site de velas virtuais do Padre Marcelo Rossi

Comments
6 min read
Stop Over-Engineering: Replacing Elasticsearch with a 100MB Go Alternative

Stop Over-Engineering: Replacing Elasticsearch with a 100MB Go Alternative

1
Comments
2 min read
Why We Split meta/root and coordinator in NoKV

Why We Split meta/root and coordinator in NoKV

1
Comments 3
5 min read
Stop Losing Data: How to Fix Race Conditions in Laravel 🛑

Stop Losing Data: How to Fix Race Conditions in Laravel 🛑

Comments
2 min read
PostgreSQL Monitoring: A Practical Guide to Metrics, Tools, and Alerts

PostgreSQL Monitoring: A Practical Guide to Metrics, Tools, and Alerts

1
Comments
9 min read
SQL Index Tuning Tools: What Works and When to Use Them

SQL Index Tuning Tools: What Works and When to Use Them

1
Comments
1 min read
Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto

Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto

2
Comments
4 min read
DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights

DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights

Comments
3 min read
How Teams Really Handle SQL Index Performance Tuning

How Teams Really Handle SQL Index Performance Tuning

1
Comments
1 min read
Database Design Doesn't Start With Table. It Starts With Consequences

Database Design Doesn't Start With Table. It Starts With Consequences

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