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.
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
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
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
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
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
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
EXPLAIN (ANALYZE, IO) in PostgreSQL 19
franckpachot profile

EXPLAIN (ANALYZE, IO) in PostgreSQL 19

#postgres #sql #database #storage
2
Comments
5 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
SQL Joins Explained: A Beekeeping Co-op in Six Queries
david_mwandairo profile

SQL Joins Explained: A Beekeeping Co-op in Six Queries

#sql #tutorial #database
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.