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.
Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE
vivekdraxlr profile

Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE

#sql #database #postgres #analytics
Comments
6 min read
Fully open-source RAG with pgvector + pgai + Ollama, and ragvitals watching for drift
mukundakatta profile

Fully open-source RAG with pgvector + pgai + Ollama, and ragvitals watching for drift

#devchallenge #pgaichallenge #database #ai
Comments
6 min read
Установка MySQL 8.0.46 из tar-архива
ruslan-potomka profile

Установка MySQL 8.0.46 из tar-архива

#database #devops #linux #tutorial
Comments
3 min read
The 10 Best AI Memory Layers for Agents in 2026
jonathanfarrow profile

The 10 Best AI Memory Layers for Agents in 2026

#agents #ai #database #llm
Comments
7 min read
I built a Supabase security tool, then found 14 critical leaks in my own production CRM
perufitlife profile

I built a Supabase security tool, then found 14 critical leaks in my own production CRM

#showdev #database #opensource #security
Comments
3 min read
How to identify database warning signals and plan your zero downtime migration
binadit profile

How to identify database warning signals and plan your zero downtime migration

#database #migration #monitoring #performance
Comments
3 min read
Beyond Basic Indexes: Mastering Partial, Composite, and Covering Indexes in SQL
vivekdraxlr profile

Beyond Basic Indexes: Mastering Partial, Composite, and Covering Indexes in SQL

#sql #database #postgres #performance
Comments
6 min read
Multi-Paxos vs Strong-Sync Primary/Replica vs Raft: Which HA Model Actually Gets You RPO=0 in 2026?
_4f268336f6580845cdc475 profile

Multi-Paxos vs Strong-Sync Primary/Replica vs Raft: Which HA Model Actually Gets You RPO=0 in 2026?

#database #distributedsystems #softwareengineering #cloudcomputing
6
Comments
7 min read
Beyond the Lift-and-Shift: Real-Time MySQL Migration to AWS RDS with GoldenGate 19c
neamanahmed profile

Beyond the Lift-and-Shift: Real-Time MySQL Migration to AWS RDS with GoldenGate 19c

#aws #cloud #database #sql
Comments
1 min read
How I built a key-value database in a single C++ header
dvuvud profile

How I built a key-value database in a single C++ header

#showdev #cpp #database #programming
Comments
5 min read
SQLite Concurrency Corruption, DuckDB Delta Writes, and DuckLake Data Inlining
soytuber profile
soy

SQLite Concurrency Corruption, DuckDB Delta Writes, and DuckLake Data Inlining

#database #sql #sqlite
Comments
3 min read
When the OSS is alive but the license isn't: Sentry, MongoDB, Elasticsearch, Redis (May 2026)
osalt profile

When the OSS is alive but the license isn't: Sentry, MongoDB, Elasticsearch, Redis (May 2026)

#opensource #selfhosted #licensing #database
Comments
5 min read
Ensuring Replication Consistency in GBase 8s: cdr repair vs cdr sync
michaelfv profile

Ensuring Replication Consistency in GBase 8s: cdr repair vs cdr sync

#gbase #database #数据库
Comments
2 min read
Why WHERE phone = NULL Returns Nothing in SQL
dechive profile

Why WHERE phone = NULL Returns Nothing in SQL

#beginners #database #sql #tutorial
Comments
4 min read
OLAP vs OLTP: What's the Difference and Why Does It Matter?
robert_njuguna profile

OLAP vs OLTP: What's the Difference and Why Does It Matter?

#luxdev #database #dataengineering
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.