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.
How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)
jakelaz profile

How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

#postgres #devops #database #tutorial
Comments
7 min read
SQL Views Explained: Write Once, Query Forever
vivekdraxlr profile

SQL Views Explained: Write Once, Query Forever

#sql #database #postgres #beginners
Comments 1
6 min read
Building a Full-Stack Agentic AI Data Platform on ClickHouse: A Complete Architecture Guide
rakeshtherani profile

Building a Full-Stack Agentic AI Data Platform on ClickHouse: A Complete Architecture Guide

#agents #ai #architecture #database
Comments 2
39 min read
Your PostgreSQL Already Has a Graph Engine — You Just Have to Build It
ineron profile
Eugene

Your PostgreSQL Already Has a Graph Engine — You Just Have to Build It

#postgres #opensource #graphs #database
1
Comments 2
7 min read
Why I Stopped Using STI and Started Using Delegated Types
eayurt profile

Why I Stopped Using STI and Started Using Delegated Types

#rails #design #database
Comments 1
4 min read
When scaling broke my system (and it wasn’t a performance issue)
abojha404 profile

When scaling broke my system (and it wasn’t a performance issue)

#systemdesign #database #vectordatabase #ai
Comments
1 min read
Where should I handle inserting data into multiple related tables: frontend or backend?
erick_mirandag_aea76fba9 profile

Where should I handle inserting data into multiple related tables: frontend or backend?

#discuss #architecture #backend #database
Comments
1 min read
Stop Letting AI Write Your Database Migrations
layzerzero105 profile

Stop Letting AI Write Your Database Migrations

#database #ai #webdev #devops
Comments 1
5 min read
PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic
mohhddhassan profile

PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic

#postgres #database #devops #opensource
5
Comments 1
6 min read
The Agent Data Layer: A Missing Layer in AI Architecture
asghar_shah_fbe97d24ce0d5 profile

The Agent Data Layer: A Missing Layer in AI Architecture

#ai #softwareengineering #database #security
1
Comments
2 min read
Performance and Apache Iceberg's Metadata
alexmercedcoder profile

Performance and Apache Iceberg's Metadata

#architecture #database #dataengineering #performance
Comments
7 min read
What happens when every developer on your team can query production (safely)
mads_hansen_27b33ebfee4c9 profile

What happens when every developer on your team can query production (safely)

#postgres #database #ai #engineering
Comments
2 min read
Replacing Elasticsearch with ClickHouse : A 90% Cost-Reduction Migration
rakeshtherani profile

Replacing Elasticsearch with ClickHouse : A 90% Cost-Reduction Migration

#database #infrastructure #monitoring #performance
4
Comments
33 min read
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database
dattasable profile

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

#sql #database #dataengineering #programming
Comments 1
3 min read
Why I Switched from ChromaDB to ElasticSearch (and What I Miss)
bash-thedev profile

Why I Switched from ChromaDB to ElasticSearch (and What I Miss)

#elasticsearch #ai #database #search
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.