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.
Agent Memory's Real Failure Is Currency, Not Retrieval

Agent Memory's Real Failure Is Currency, Not Retrieval

Comments
2 min read
Oracle Indexes: When They Help, When They Hurt, and How to Tell

Oracle Indexes: When They Help, When They Hurt, and How to Tell

Comments
11 min read
The Two Ways AI Memory Breaks

The Two Ways AI Memory Breaks

Comments
2 min read
The Free Server Wiped My SQLite Queue Overnight and the Health Check Never Noticed

The Free Server Wiped My SQLite Queue Overnight and the Health Check Never Noticed

Comments
4 min read
MariaDB vs MySQL vs PostgreSQL: an mpazari Benchmark

MariaDB vs MySQL vs PostgreSQL: an mpazari Benchmark

1
Comments
5 min read
My retrieval counted the same text three times

My retrieval counted the same text three times

Comments 24
4 min read
Implementing IN statements using JooqTemplate

Implementing IN statements using JooqTemplate

Comments
1 min read
One hard question is a better database acceptance test than ten easy ones

One hard question is a better database acceptance test than ten easy ones

1
Comments
1 min read
example.com and example.com/ were two rows, and 86.9% of my database was one bug

example.com and example.com/ were two rows, and 86.9% of my database was one bug

Comments
4 min read
Securing your database connection: TLS, SSH tunnels, and IAM, from the ground up

Securing your database connection: TLS, SSH tunnels, and IAM, from the ground up

Comments
16 min read
what is a purpose of index with order if the query has order 1 column, do we need to use order in index

what is a purpose of index with order if the query has order 1 column, do we need to use order in index

Comments
2 min read
Your Rails Transaction Rolled Back. What Happened to the API Call, Email, or Job?

Your Rails Transaction Rolled Back. What Happened to the API Call, Email, or Job?

5
Comments
7 min read
The First API Call Is the Easy Part: 7 Lessons from Building on Live Vehicle Data

The First API Call Is the Easy Part: 7 Lessons from Building on Live Vehicle Data

Comments 1
4 min read
Distributed Locking in Practice: Guarantees, Failure Scenarios and Better Alternatives (3/4)

Distributed Locking in Practice: Guarantees, Failure Scenarios and Better Alternatives (3/4)

Comments
6 min read
Stop Trusting the App: Enforcing Append-Only at the Database Layer

Stop Trusting the App: Enforcing Append-Only at the Database Layer

1
Comments 1
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.