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.
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
RLS isolated my tenants. A missing sequence GRANT still broke production.

RLS isolated my tenants. A missing sequence GRANT still broke production.

1
Comments 4
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
I Built an Isolated Multi-Tenant AI Memory DB: Here's What Happened Under Massive Load

I Built an Isolated Multi-Tenant AI Memory DB: Here's What Happened Under Massive Load

1
Comments 3
3 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
Getting into SQL For Beginners:

Getting into SQL For Beginners:

1
Comments 1
4 min read
Apache Data Lakehouse Weekly: August 10 to 18, 2026

Apache Data Lakehouse Weekly: August 10 to 18, 2026

Comments
17 min read
Circular Foreign Keys: Why the First Row Cannot Be Inserted

Circular Foreign Keys: Why the First Row Cannot Be Inserted

Comments
10 min read
PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

Comments
8 min read
24 of the 30 duplicate groups were not duplicates

24 of the 30 duplicate groups were not duplicates

Comments
3 min read
The ledger said 763 assets. The platforms said about 400.

The ledger said 763 assets. The platforms said about 400.

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