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.
Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches

Hybrid Search in Postgres with pgvector: Field Notes on HNSW, tsvector, and Why Pure Vector Search Missed Exact Matches

1
Comments
7 min read
Preventing Cache Penetration in Spring Boot Using Redis and Bloom Filters

Preventing Cache Penetration in Spring Boot Using Redis and Bloom Filters

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

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

1
Comments
2 min read
When a SQL Engine Records Column Types but Never Reads Them

When a SQL Engine Records Column Types but Never Reads Them

Comments
3 min read
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More

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

1
Comments
33 min read
What Exhausting 50,000 Firestore Reads Taught Me About Database Design

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

Comments
6 min read
TIL: Four Key Configurations Inside the GBase Database `onconfig` File

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

2
Comments
3 min read
CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)

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

1
Comments
6 min read
Why a 40-Year-Old Database Is Still Winning in the AI Era

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

Comments
4 min read
Picodata: a distributed database that speaks PostgreSQL, Redis and Cassandra protocols

Picodata: a distributed database that speaks PostgreSQL, Redis and Cassandra protocols

Comments
3 min read
Excel Dashboards: Product Analysis for Jumia Kenya

Excel Dashboards: Product Analysis for Jumia Kenya

8
Comments 1
5 min read
Migration files and Git do not mix

Migration files and Git do not mix

Comments
6 min read
Apache Data Lakehouse Weekly: August 26 to September 2, 2026

Apache Data Lakehouse Weekly: August 26 to September 2, 2026

Comments
20 min read
Building Z-RevixDB Without Dependencies: What We Had to Rebuild

Building Z-RevixDB Without Dependencies: What We Had to Rebuild

1
Comments
5 min read
GCP The Hard Way — Part 4: Choosing the Wrong NoSQL Database, and Migrating When It Shows

GCP The Hard Way — Part 4: Choosing the Wrong NoSQL Database, and Migrating When It Shows

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