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.
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
Cleaning Up Unused Indexes Without Breaking Performance
databaseinsights profile

Cleaning Up Unused Indexes Without Breaking Performance

#sqlserver #database #devops #performance
4
Comments 4
8 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
3
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
Defeating the OFFSET Death Spiral: Cursor Pagination
iprajapatiparesh profile

Defeating the OFFSET Death Spiral: Cursor Pagination

#laravel #php #database #architecture
Comments
4 min read
CloudNativePG Admission Webhook Timeout on GKE Autopilot: Root Cause, Troubleshooting and Production Fix
varsha_hawanna_dd6f8e053e profile

CloudNativePG Admission Webhook Timeout on GKE Autopilot: Root Cause, Troubleshooting and Production Fix

#cloud #database #infrastructure #kubernetes
Comments
6 min read
I built a tuition management SaaS with plain HTML, Supabase and Vercel
pingclass_off profile

I built a tuition management SaaS with plain HTML, Supabase and Vercel

#database #saas #startup #webdev
2
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.