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.
Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number
systemcraftdev profile

Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number

#sql #database #beginners #tutorial
1
Comments
4 min read
Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL
bodanthebackend profile

Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

#postgres #sql #database #performance
1
Comments 1
5 min read
hello Evry one
karthik_python_e60a29d0fb profile

hello Evry one

#ai #programming #database #tools
Comments
1 min read
pglite vs Tinbase: different tools for different jobs
lucas_martin_8cb158b9a81b profile

pglite vs Tinbase: different tools for different jobs

#postgres #supabase #database #webdev
Comments
4 min read
Preventing Cache Penetration in Spring Boot Using Redis and Bloom Filters
shubham_bhati profile

Preventing Cache Penetration in Spring Boot Using Redis and Bloom Filters

#java #springboot #redis #database
Comments
1 min read
I built a free database client with a modern UI for Postgres, MySQL, MariaDB and SQLite
janvorisek profile

I built a free database client with a modern UI for Postgres, MySQL, MariaDB and SQLite

#database #electron #vue #postgres
1
Comments
2 min read
When a SQL Engine Records Column Types but Never Reads Them
megapixel99 profile

When a SQL Engine Records Column Types but Never Reads Them

#sql #database #node #javascript
Comments
3 min read
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More
franckpachot profile

When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More

#postgres #oracle #database #transactions
1
Comments
33 min read
What Exhausting 50,000 Firestore Reads Taught Me About Database Design
siddarthpatelkama profile

What Exhausting 50,000 Firestore Reads Taught Me About Database Design

#firebase #webdev #architecture #database
Comments
6 min read
TIL: Four Key Configurations Inside the GBase Database `onconfig` File
mmllllzcn profile

TIL: Four Key Configurations Inside the GBase Database `onconfig` File

#todayilearned #gbase #database #数据库
2
Comments
3 min read
An idempotency key needs stored results: testing retries and concurrent requests
hirodeath profile
hiro@

An idempotency key needs stored results: testing retries and concurrent requests

#api #cloudflare #database #testing
Comments 1
4 min read
The Saturday Data Run: 771 Matches, Six Exports, Zero Manual Steps
kickindi_com profile

The Saturday Data Run: 771 Matches, Six Exports, Zero Manual Steps

#architecture #automation #backend #database
Comments
2 min read
Your UUID Primary Keys Are Quietly Taxing Every Insert
jatinjainsaraf profile

Your UUID Primary Keys Are Quietly Taxing Every Insert

#postgres #database #performance #indexing
Comments
9 min read
CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)
guidance_white profile

CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)

#database #vulnerabilities #cve #sql
1
Comments
6 min read
Why a 40-Year-Old Database Is Still Winning in the AI Era
akulkarni01 profile

Why a 40-Year-Old Database Is Still Winning in the AI Era

#postgres #ai #database #dev
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.