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.
Master-Class: Caching — What Every Software Engineer Actually Needs to Know
piyush6348 profile

Master-Class: Caching — What Every Software Engineer Actually Needs to Know

#database #systemdesign #distributedsystems #interview
1
Comments
13 min read
1. Quick Guide to Setting Up PostgreSQL on Mac via CLI with Homebrew
lorena_dvila_5ab5ef35ec6 profile

1. Quick Guide to Setting Up PostgreSQL on Mac via CLI with Homebrew

#cli #database #postgres #tutorial
4
Comments
2 min read
CTEs, Subqueries, and Query Optimisation in SQL
wambuijoan profile

CTEs, Subqueries, and Query Optimisation in SQL

#database #performance #sql #tutorial
Comments
8 min read
5 Ways to Get Stripe Data into PostgreSQL
ilshadyx profile

5 Ways to Get Stripe Data into PostgreSQL

#stripe #postgres #database #webdev
Comments
8 min read
The Modern Way to Clone Postgres in 2026
reeshee profile

The Modern Way to Clone Postgres in 2026

#backend #database #devops #postgres
2
Comments
9 min read
Postgres JSONB indexes: GIN vs BTREE on the same column
baodev-studio profile

Postgres JSONB indexes: GIN vs BTREE on the same column

#postgressql #database #performance #json
Comments
3 min read
PostgreSQL Point-in-Time Recovery with pgBackRest
philip_mcclarence_2ef9475 profile

PostgreSQL Point-in-Time Recovery with pgBackRest

#database #devops #postgres #tutorial
Comments
3 min read
Detective mode: Fixing the MongoDB Aggregation pipeline
mongodb_guests profile

Detective mode: Fixing the MongoDB Aggregation pipeline

#database #mongodb #monitoring #performance
1
Comments
4 min read
Hit Supabase's free $25 pricing cliff. Any middle-tier options?
cgozdemm profile

Hit Supabase's free $25 pricing cliff. Any middle-tier options?

#discuss #database #saas #sideprojects
Comments
1 min read
What's New in Surrealist 3.8
mgyles profile

What's New in Surrealist 3.8

#surrealdb #surrealist #database #web
14
Comments
3 min read
Columnar Databases (ClickHouse/Snowflake)
godofgeeks profile

Columnar Databases (ClickHouse/Snowflake)

#architecture #database #dataengineering #performance
1
Comments
8 min read
SQLite Is All You Need (Until It Isn't) — A Practical Guide
jarachagent profile
Jack

SQLite Is All You Need (Until It Isn't) — A Practical Guide

#database #webdev #beginners #python
Comments
4 min read
19/30 Days System Design Questions!
thejoud1997 profile

19/30 Days System Design Questions!

#architecture #database #distributedsystems #systemdesign
1
Comments 4
1 min read
Refreshing PostgreSQL Materialized Views Without Downtime
data_with_jelimo profile

Refreshing PostgreSQL Materialized Views Without Downtime

#database #performance #postgres #sql
1
Comments
7 min read
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each
audrine_m profile

SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each

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