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.
Grant Matrices or Query Rewrites: A Debate for Agent SQL Least Privilege
dataio_4921 profile

Grant Matrices or Query Rewrites: A Debate for Agent SQL Least Privilege

#postgres #sql #database #ai
Comments 1
8 min read
Reconciliation doesn't break in the arithmetic
jeffreyjorgensen profile

Reconciliation doesn't break in the arithmetic

#architecture #fintech #testing #database
Comments
10 min read
What if your Python database code didn't care which database you used?
joshtom profile

What if your Python database code didn't care which database you used?

#backend #database #python #sql
Comments
2 min read
Best Open-Source Text-to-SQL Tools in 2025 (Ranked by Privacy & Performance)
veilanalytics profile

Best Open-Source Text-to-SQL Tools in 2025 (Ranked by Privacy & Performance)

#ai #database #opensource #privacy
Comments 1
4 min read
Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)
qasimlak profile

Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)

#architecture #backend #database #sql
Comments
2 min read
Day 12 - NoSQL Deep Dive - Document, Key-Value, Graph কোনটা কখন?
mislam-dev profile

Day 12 - NoSQL Deep Dive - Document, Key-Value, Graph কোনটা কখন?

#architecture #backend #database #software
Comments
2 min read
Why Your Postgres Table Keeps Growing Even Though You're Deleting Rows
mohhddhassan profile

Why Your Postgres Table Keeps Growing Even Though You're Deleting Rows

#postgres #database #backend #devops
5
Comments 7
7 min read
Building Sub-Second Spatial Dispatch Systems with PostGIS & Cloud Infrastructure
calvinburns profile

Building Sub-Second Spatial Dispatch Systems with PostGIS & Cloud Infrastructure

#webdev #ai #architecture #database
Comments
2 min read
What Supero doesn't do yet - the honest list!
srikanth-supero profile

What Supero doesn't do yet - the honest list!

#showdev #webdev #database #security
Comments
2 min read
The migration finished in a second and the rollout ran for eleven minutes
sergey_shinder_ab2d943365 profile

The migration finished in a second and the rollout ran for eleven minutes

#sergeyshinder #releaseengineering #database #devops
Comments
2 min read
AWS Database Mini Projects - RDS, Aurora, DynamoDB & ElastiCache
tejas_shinkar profile

AWS Database Mini Projects - RDS, Aurora, DynamoDB & ElastiCache

#aws #database #devops #python
Comments
4 min read
Apache Data Lakehouse Weekly: September 9 to 17, 2026
alexmercedcoder profile

Apache Data Lakehouse Weekly: September 9 to 17, 2026

#database #opensource #softwaredevelopment
Comments
31 min read
The File Format: Pages, Headers, and Magic Bytes

Inspired by SQLite's magic bytes design
priyanshuverma profile

The File Format: Pages, Headers, and Magic Bytes

#architecture #database #programming #softwaredevelopment
6
Comments 5
6 min read
From MySQL to PostgreSQL: a much lighter server
ozkanpakdil profile

From MySQL to PostgreSQL: a much lighter server

#backend #database #postgres #sql
Comments
2 min read
The slowest requests on our API were the ones that found nothing
vessel_api profile

The slowest requests on our API were the ones that found nothing

#timescaledb #postgres #database #performance
Comments
14 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.