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 Storage & Hybrid Vault: Dense pgvector + Sparse BM25 + Mathematical Reciprocal Rank Fusion (Part 3)
nagachaitanya_inamdar_56c profile

The Storage & Hybrid Vault: Dense pgvector + Sparse BM25 + Mathematical Reciprocal Rank Fusion (Part 3)

#database #llm #postgres #rag
Comments
5 min read
Why Generated SQL Is Never Auto-Executed
jeff_pdc profile
Jeff

Why Generated SQL Is Never Auto-Executed

#database #programming #webdev
Comments
3 min read
TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server
kausarraza profile

TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server

#sqlserver #database #devops #powershell
Comments
7 min read
One SQL predicate, eleven implementations: unifying them and what our differential harness caught
motedb profile
mote

One SQL predicate, eleven implementations: unifying them and what our differential harness caught

#rust #database #robotics #ai
1
Comments
5 min read
Drizzle ORM: Your Database Schema, Written in TypeScript
practicaldevblog profile

Drizzle ORM: Your Database Schema, Written in TypeScript

#typescript #drizzle #database #orm
Comments
6 min read
Designing an Item Master for eTIMS: Item Codes, Product Types, Unit Conversions and Stock Movement Types
yit2022 profile

Designing an Item Master for eTIMS: Item Codes, Product Types, Unit Conversions and Stock Movement Types

#erp #database #architecture #api
Comments
12 min read
Can You Find Employees Who Joined This Month Using SQL? (Oracle TRUNC & ADD_MONTHS)
kailas_warade_d2a15d1ef8a profile

Can You Find Employees Who Joined This Month Using SQL? (Oracle TRUNC & ADD_MONTHS)

#sql #database #dataengineering #datascience
Comments 1
2 min read
Fifteen Chinese cities have more sights than beds — and that is a feature, not a gap
sinostay profile

Fifteen Chinese cities have more sights than beds — and that is a feature, not a gap

#data #database #sql #travel
Comments
2 min read
The Enterprise Guide to Model Context Protocol (MCP): Building Secure, Production-Grade Tool Servers for Proprietary Databases
soham2710 profile

The Enterprise Guide to Model Context Protocol (MCP): Building Secure, Production-Grade Tool Servers for Proprietary Databases

#ai #python #architecture #database
Comments
6 min read
Transactional DDL in PostgreSQL, MySQL and CockroachDB: Which Failed Migrations Roll Back?
tbson87 profile

Transactional DDL in PostgreSQL, MySQL and CockroachDB: Which Failed Migrations Roll Back?

#postgres #mysql #cockroachdb #database
Comments
10 min read
PGHist | History and audit of table changes in PostgreSQL
pgsuite profile

PGHist | History and audit of table changes in PostgreSQL

#postgres #opensource #sql #database
Comments
3 min read
Final Completions Data Handover & Archiving Checklist
beefedai profile

Final Completions Data Handover & Archiving Checklist

#database
Comments
9 min read
Rules-Only or LLM Judge? A Scoring Harness for the Second Reviewer of Agent SQL
dataio_4921 profile

Rules-Only or LLM Judge? A Scoring Harness for the Second Reviewer of Agent SQL

#sql #ai #testing #database
Comments
7 min read
Why a 2ms ALTER TABLE Took Down Our 512GB Postgres Table (And How We Fixed It)
anwariqbaldawar profile

Why a 2ms ALTER TABLE Took Down Our 512GB Postgres Table (And How We Fixed It)

#postgres #database #devops #backend
1
Comments 1
40 min read
Having a Backup Does Not Mean You Can Recover
hoagminh profile

Having a Backup Does Not Mean You Can Recover

#selfhosted #devops #docker #database
2
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.