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.
We have a folder called repositories, and 31 files that query the database without going near it

We have a folder called repositories, and 31 files that query the database without going near it

1
Comments
4 min read
What broke when I tested pgvector vs Postgres full-text search vs Hybrid RRF on 30 tricky RAG chunks (and how I fixed it for $0)

What broke when I tested pgvector vs Postgres full-text search vs Hybrid RRF on 30 tricky RAG chunks (and how I fixed it for $0)

Comments 4
3 min read
TIL: How to Check Port Availability Before Installing GBase Database (GBase 8s)

TIL: How to Check Port Availability Before Installing GBase Database (GBase 8s)

2
Comments
3 min read
I ran my text-to-SQL access control on a benchmark I didn't write

I ran my text-to-SQL access control on a benchmark I didn't write

Comments
3 min read
One Null in the Subquery and Your NOT IN Returned Nothing

One Null in the Subquery and Your NOT IN Returned Nothing

Comments
2 min read
# SQL for Data Analysis: Window Functions, Joins, CTEs and Subqueries

# SQL for Data Analysis: Window Functions, Joins, CTEs and Subqueries

Comments
7 min read
Provenance gate: no AI agent memory write without a source

Provenance gate: no AI agent memory write without a source

Comments
7 min read
Fivetran vs Estuary for Postgres to Snowflake Replication

Fivetran vs Estuary for Postgres to Snowflake Replication

15
Comments
8 min read
# A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database

# A Practical Guide to Advanced SQL: Window Functions, Joins, CTEs, and Subqueries Using a Hospital Database

Comments
21 min read
An Idempotency Key Is More Than a Duplicate-Request Flag

An Idempotency Key Is More Than a Duplicate-Request Flag

Comments 1
3 min read
pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch

pg_vectorsearch vs pgvector HNSW: 42 Hours vs 49 Minutes. Here's the Catch

Comments 1
7 min read
O que fazer quando seu banco de dados não aguenta mais? Uma introdução ao Sharding

O que fazer quando seu banco de dados não aguenta mais? Uma introdução ao Sharding

Comments
5 min read
I built a company brain that remembers why decisions were made (on FalkorDB)

I built a company brain that remembers why decisions were made (on FalkorDB)

Comments
6 min read
Append-Only Audit Logs in Postgres with Triggers and Node.js

Append-Only Audit Logs in Postgres with Triggers and Node.js

Comments
5 min read
Entry records need a retention engine, not a purge job

Entry records need a retention engine, not a purge job

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