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.
db-mcp: connect your database to AI
zeslava profile

db-mcp: connect your database to AI

#rust #mcp #ai #database
1
Comments 1
4 min read
SQLite Internals & Audit Patterns; New Open-Source PostgreSQL UI
soytuber profile
soy

SQLite Internals & Audit Patterns; New Open-Source PostgreSQL UI

#database #sql #sqlite
Comments
4 min read
DatAasee 0.9 Released
gramian profile

DatAasee 0.9 Released

#metadata #lakehouse #dataengineering #database
Comments
1 min read
What Statements Are Allowed in GBase 8a READONLY Mode? SHOW, USE, and More
michaelfv profile

What Statements Are Allowed in GBase 8a READONLY Mode? SHOW, USE, and More

#gbase #database #数据库
2
Comments
2 min read
Pruning a Sitemap From 327,621 URLs to 2,483 (And Why That Was the Right Call)
kavelaltd profile
kavela

Pruning a Sitemap From 327,621 URLs to 2,483 (And Why That Was the Right Call)

#wordpress #seo #webdev #database
Comments
4 min read
Load a single record using JooqTemplate
javaer profile

Load a single record using JooqTemplate

#database #java #tutorial #jooq
1
Comments
2 min read
ClickHouse Managed Service: The Hard Truth About Not Managing Your Own Data Infrastructure
heleo profile

ClickHouse Managed Service: The Hard Truth About Not Managing Your Own Data Infrastructure

#cloud #data #database #infrastructure
Comments
9 min read
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
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
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
3
Comments
3 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.