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.
Does AbortSignal Cancel a Node.js Database Query? 4 Drivers Tested

Pool starvation risks revealed across drivers
shubhradev profile

Does AbortSignal Cancel a Node.js Database Query? 4 Drivers Tested

#node #postgres #mysql #database
20
Picked as gem Comments 5
19 min read
Redis 8.12 RC2's SEXPIRE command cuts a set membership check from two round trips to one
alexgeorgiev17 profile

Redis 8.12 RC2's SEXPIRE command cuts a set membership check from two round trips to one

#redis #database #performance #devops
7
Comments 2
7 min read
PostgreSQL 14 End of Life on 12 November 2026: How to Upgrade Postgres in Docker
hamzezarenasiri profile

PostgreSQL 14 End of Life on 12 November 2026: How to Upgrade Postgres in Docker

#postgres #docker #database #devops
Comments
9 min read
Renaming a column in SQL Server, and what it quietly breaks
woodfiresam profile
Sam

Renaming a column in SQL Server, and what it quietly breaks

#sql #sqlserver #database #refactoring
Comments
4 min read
HNSW vs IVF-PQ: You Are Paying for Recall in RAM
gxqwb_ai profile
gxqwb

HNSW vs IVF-PQ: You Are Paying for Recall in RAM

#database #ai #performance #architecture
Comments
4 min read
MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying
tbson87 profile

MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

#mysql #database #sql #devops
Comments
11 min read
I built a Windows SQL client where an LLM drafts the query and you stay in control
mirinai_ai profile

I built a Windows SQL client where an LLM drafts the query and you stay in control

#showdev #sql #database #abotwrotethis
Comments
2 min read
Connection Strings for MySQL, PostgreSQL and Redis: A Practical Reference
o_oliver_3b38e6829628a1e9 profile

Connection Strings for MySQL, PostgreSQL and Redis: A Practical Reference

#mysql #postgres #redis #database
Comments
3 min read
Storing email bodies without building a data swamp
volanea profile

Storing email bodies without building a data swamp

#architecture #backend #database #systemdesign
Comments
1 min read
MySQL LIMIT and OFFSET Explained with Simple Examples
kushkrg profile

MySQL LIMIT and OFFSET Explained with Simple Examples

#mysql #sql #database #php
Comments
6 min read
Deduplicating contacts when the same person has three identities
volanea profile

Deduplicating contacts when the same person has three identities

#architecture #database #systemdesign
Comments
1 min read
Suppression is a compliance surface, not a checkbox
volanea profile

Suppression is a compliance surface, not a checkbox

#architecture #backend #database
Comments
2 min read
CREATE UNIQUE INDEX terminated because a duplicate key was found
woodfiresam profile
Sam

CREATE UNIQUE INDEX terminated because a duplicate key was found

#sql #sqlserver #database #dba
Comments
4 min read
SQL CASE WHEN: How to Categorize Employee Salaries into Low, Medium, and High
kailas_warade_d2a15d1ef8a profile

SQL CASE WHEN: How to Categorize Employee Salaries into Low, Medium, and High

#sql #database #programming #tutorial
Comments
2 min read
Goravel models and migrations with Postgres
krishankumar01 profile

Goravel models and migrations with Postgres

#go #database #postgres #tutorial
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.