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.
Securing your database connection: TLS, SSH tunnels, and IAM, from the ground up
flextabledev profile

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

#security #database #tutorial #devops
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
viktorle1294 profile

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

#database #performance
Comments
2 min read
The First API Call Is the Easy Part: 7 Lessons from Building on Live Vehicle Data
thecarapi profile

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

#database #webdev #api
Comments 1
4 min read
Distributed Locking in Practice: Guarantees, Failure Scenarios and Better Alternatives (3/4)
morpheus-vera profile

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

#distributedsystems #database #systemdesign #tutorial
Comments
6 min read
Stop Trusting the App: Enforcing Append-Only at the Database Layer
gentlyding profile

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

#architecture #database #postgres #security
1
Comments 1
4 min read
Apache Data Lakehouse Weekly: August 10 to 18, 2026
alexmercedcoder profile

Apache Data Lakehouse Weekly: August 10 to 18, 2026

#bigdata #data #database #opensource
Comments
17 min read
PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones
tbson87 profile

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

#database #postgres #sql #orm
Comments
8 min read
Circular Foreign Keys: Why the First Row Cannot Be Inserted
tbson87 profile

Circular Foreign Keys: Why the First Row Cannot Be Inserted

#database #sql #postgres #mysql
Comments
10 min read
24 of the 30 duplicate groups were not duplicates
untactit profile

24 of the 30 duplicate groups were not duplicates

#database #programming #ai #datascience
Comments
3 min read
The ledger said 763 assets. The platforms said about 400.
untactit profile

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

#ai #devops #testing #database
Comments
3 min read
Prisma Studio is not an admin panel
divinesta profile

Prisma Studio is not an admin panel

#backend #database #prisma #software
1
Comments
4 min read
FinOps Meets Architecture: Tiering ClickHouse from EBS to S3 Without Touching a Query
shadowsaurus profile

FinOps Meets Architecture: Tiering ClickHouse from EBS to S3 Without Touching a Query

#ai #finops #database #aws
2
Comments 3
8 min read
Testing Risky Postgres Migrations Safely with Volume Cloning on Unikraft Cloud
desmondsanctity profile

Testing Risky Postgres Migrations Safely with Volume Cloning on Unikraft Cloud

#postgres #microvm #unikraft #database
1
Comments
13 min read
Subqueries and CTEs: Asking a Question Inside a Question
david_mwandairo profile

Subqueries and CTEs: Asking a Question Inside a Question

#sql #database #tutorial #ctes
Comments
8 min read
Read Replicas Promised Scale. They Also Gave You Stale Data.
gentlyding profile

Read Replicas Promised Scale. They Also Gave You Stale Data.

#architecture #database #performance #systemdesign
1
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.