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.
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug
soytuber profile
soy

SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

#database #sql #sqlite
Comments
3 min read
The Untold Story of Why Your App Dies at 1,000,000 Rows
iampraveen profile

The Untold Story of Why Your App Dies at 1,000,000 Rows

#webdev #database #performance #architecture
21
Comments 6
6 min read
I Built a PostgreSQL Admin Tool in Rust — ~6MB, No Electron, Sub-1s Startup
abeni16 profile

I Built a PostgreSQL Admin Tool in Rust — ~6MB, No Electron, Sub-1s Startup

#postgres #pgadmin #productivity #database
1
Comments
3 min read
Before you connect AI to PostgreSQL through MCP, run this checklist
mads_hansen_27b33ebfee4c9 profile

Before you connect AI to PostgreSQL through MCP, run this checklist

#postgres #mcp #database #security
1
Comments
2 min read
Database migrations are critical. Forgetting them costs teams hours weekly.
melphins profile

Database migrations are critical. Forgetting them costs teams hours weekly.

#showdev #database #opensource #tooling
1
Comments
1 min read
Rails Performance Optimization: Fixing N+1 Queries with includes, preload, and eager_load
yashika_vijayvargiya profile

Rails Performance Optimization: Fixing N+1 Queries with includes, preload, and eager_load

#ruby #rails #performance #database
7
Comments
3 min read
IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable
michaelfv profile

IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable

#gbase #database #数据库
2
Comments
1 min read
Your Database Is Fast. Your Queries Are Slow.
qodors profile

Your Database Is Fast. Your Queries Are Slow.

#database #sql #linq #dotnet
Comments
4 min read
Troubleshooting Table Locks in GBase 8s: Find and Release Exclusive Locks Fast
michaelfv profile

Troubleshooting Table Locks in GBase 8s: Find and Release Exclusive Locks Fast

#gbase #database #数据库 #onstat
2
Comments
2 min read
Securing PostgreSQL, in the order an attacker would try things
_coderdan profile

Securing PostgreSQL, in the order an attacker would try things

#postgres #security #database #tutorial
2
Comments
7 min read
Desvendando a Arquitetura: Frontend, Backend e Banco de Dados na Prática
kabrau profile

Desvendando a Arquitetura: Frontend, Backend e Banco de Dados na Prática

#ai #backend #frontend #database
Comments
3 min read
JPA: The Good, The Bad, and The Ugly
stephenflavin profile

JPA: The Good, The Bad, and The Ugly

#java #jpa #spring #database
Comments
17 min read
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
michaelfv profile

Inner vs Outer Joins: The Two Fundamental Join Types in SQL

#gbase #database #数据库 #sql
2
Comments
1 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
1
Comments
7 min read
SQL for Developers: The Practical Guide (2026)
armorbreak profile

SQL for Developers: The Practical Guide (2026)

#beginners #database #sql #tutorial
1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.