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.
What Data Actually Sits Behind a Credit Score?

What Data Actually Sits Behind a Credit Score?

Comments
5 min read
Pinecone vs Qdrant vs pgvector: The Same RAG Query in All Three (Python Code Comparison)

Pinecone vs Qdrant vs pgvector: The Same RAG Query in All Three (Python Code Comparison)

Comments
2 min read
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Comments
8 min read
MongoDB Internals, Part 1

MongoDB Internals, Part 1

Comments
10 min read
Import CSV Data into DynamoDB with Tables: Validate, Fix, and Retry Invalid Rows

Import CSV Data into DynamoDB with Tables: Validate, Fix, and Retry Invalid Rows

2
Comments 2
6 min read
Deduplicating Property Leads Across Portals and WhatsApp: A Practical Matching Key

Deduplicating Property Leads Across Portals and WhatsApp: A Practical Matching Key

Comments 1
2 min read
I built a zero-dependency CLI to snapshot the remote job market into CSV/JSON/SQLite

I built a zero-dependency CLI to snapshot the remote job market into CSV/JSON/SQLite

Comments
3 min read
How long does a Patroni failover take? We measured it

How long does a Patroni failover take? We measured it

Comments
4 min read
My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

Comments
2 min read
Database Transactions & Consistency

Database Transactions & Consistency

Comments
9 min read
Best Collaborative Data Modeling Tools: SQLDBM Team Features & Alternatives Compared

Best Collaborative Data Modeling Tools: SQLDBM Team Features & Alternatives Compared

Comments
10 min read
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

Comments
4 min read
Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

Comments
3 min read
Design semantic views around business questions, not agents

Design semantic views around business questions, not agents

Comments 1
6 min read
MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

1
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.