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.
Closing the KNN rescoring gap between columnar and row-wise storage

Closing the KNN rescoring gap between columnar and row-wise storage

Comments
9 min read
How MongoDB Finds Your Data

How MongoDB Finds Your Data

1
Comments
13 min read
How to Sync Billing Data to Supabase (Stripe, QuickBooks, Xero & Paddle)

How to Sync Billing Data to Supabase (Stripe, QuickBooks, Xero & Paddle)

Comments
10 min read
Your AI Has the Memory of a Goldfish. HydraDB Wants to Fix That.

Your AI Has the Memory of a Goldfish. HydraDB Wants to Fix That.

1
Comments
2 min read
PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

Comments
9 min read
Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Comments
4 min read
Data Modelling, Relationships And Joins In Power BI

Data Modelling, Relationships And Joins In Power BI

Comments
8 min read
Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.

Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.

Comments
9 min read
Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

1
Comments
7 min read
OpenSearch Under the Hood: How It Actually Works

OpenSearch Under the Hood: How It Actually Works

Comments
4 min read
Data Substrate Versus Vector Db Rag

Data Substrate Versus Vector Db Rag

Comments
3 min read
Vector Database Memory Sizing and Cost Math: How Much RAM Do 1 Million Vectors Need?

Vector Database Memory Sizing and Cost Math: How Much RAM Do 1 Million Vectors Need?

Comments
11 min read
Your Database Is Small. That Doesn’t Mean Your Queries Are Fast

Your Database Is Small. That Doesn’t Mean Your Queries Are Fast

1
Comments
3 min read
How to Do Pagination Right: Row Comparison, Datatypes, and Index Range Scans

How to Do Pagination Right: Row Comparison, Datatypes, and Index Range Scans

Comments
16 min read
Database Connection Pooling: Why Opening a New Database Connection Every Time Is a Bad Idea

Database Connection Pooling: Why Opening a New Database Connection Every Time Is a Bad Idea

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