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.
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
Mutable BSON and Oracle OSON
franckpachot profile

Mutable BSON and Oracle OSON

#oracle #mongodb #json #database
Comments
3 min read
SQL Functions You Will Actually Use in Data Work
muriuki_kahuthu_54 profile

SQL Functions You Will Actually Use in Data Work

#beginners #database #sql
Comments
7 min read
PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes
soytuber profile
soy

PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes

#database #sql #sqlite
Comments
3 min read
⚠️ Race Conditions in APIs - The Bug You Can’t See
fazal_mansuri_ profile

⚠️ Race Conditions in APIs - The Bug You Can’t See

#backend #database #api #security
1
Comments
5 min read
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
Multi-site schemas: lessons from evolving one large system over time
heyitsistvan profile

Multi-site schemas: lessons from evolving one large system over time

#architecture #database #backend #systemdesign
Comments
3 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
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
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
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 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.