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 Speed Up Phrase Search with bigram_index
sanikolaev profile

How to Speed Up Phrase Search with bigram_index

#database #nlp #performance #tutorial
Comments
6 min read
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
How Databases Store Data: B+ Tree Explained Simply for Beginners (With Real-World Examples)
creator79 profile

How Databases Store Data: B+ Tree Explained Simply for Beginners (With Real-World Examples)

#database #beginners #computerscience #tutorial
5
Comments
25 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.