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.
A Practical Guide to Evaluating Data Warehouses for Low-Latency Analytics (2026 Edition)
engineersguide profile

A Practical Guide to Evaluating Data Warehouses for Low-Latency Analytics (2026 Edition)

#dataengineering #analytics #database #webdev
Comments
13 min read
PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies
philip_mcclarence_2ef9475 profile

PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

#database #performance #postgres #sql
Comments
4 min read
The 8 tables behind a real auth system (Postgres schema, explained column by column)
thegdsks profile

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

#postgres #authentication #database #webdev
3
Comments
10 min read
PostgreSQL Backup and Recovery: A Complete Guide
geekyfox90 profile

PostgreSQL Backup and Recovery: A Complete Guide

#database #devops #postgres #tutorial
Comments
5 min read
TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)
iampavel profile

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

#timescaledb #postgres #timeseries #database
Comments
5 min read
Your Vector Database Is Not a Search Engine. Here's Why That's Killing Your RAG.
gabrielanhaia profile

Your Vector Database Is Not a Search Engine. Here's Why That's Killing Your RAG.

#ai #llm #rag #database
Comments 1
9 min read
Criando a melhor arquitetura possĂ­vel para o site de velas virtuais do Padre Marcelo Rossi
wmattei profile

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

#architecture #backend #database #systemdesign
Comments
6 min read
Stop Over-Engineering: Replacing Elasticsearch with a 100MB Go Alternative
dinesh_regar profile

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

#architecture #database #go #performance
1
Comments
2 min read
Stop Losing Data: How to Fix Race Conditions in Laravel 🛑
iprajapatiparesh profile

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

#laravel #database #postgres #backend
Comments
2 min read
Cloudflare D1 + Drizzle ORM: SQLite at the Edge Without the Pain
whoffagents profile

Cloudflare D1 + Drizzle ORM: SQLite at the Edge Without the Pain

#cloudflare #typescript #webdev #database
Comments
4 min read
DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights
soytuber profile
soy

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

#database #sql #sqlite
Comments
3 min read
Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto
pedroparker profile

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

#postgres #search #performance #database
2
Comments
4 min read
Overview: Change Data Capture (CDC)
longtk26 profile

Overview: Change Data Capture (CDC)

#database #dataengineering #distributedsystems #systemdesign
Comments
4 min read
PostgreSQL Full Text Search vs Elasticsearch Comparison
rosgluk profile
Rost

PostgreSQL Full Text Search vs Elasticsearch Comparison

#postgres #architecture #database #sql
Comments
9 min read
Databases Are Not Becoming Chatbots
debba profile

Databases Are Not Becoming Chatbots

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