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.
Neon vs Supabase vs PlanetScale vs AWS: what Postgres costs in 2026
kubeden profile

Neon vs Supabase vs PlanetScale vs AWS: what Postgres costs in 2026

#aws #cloud #database #postgres
13
Comments 1
6 min read
Power BI Data Modelling, Relationships and Joins: A Practical Guide to Building Effective BI Models
samuelmwaurandungu profile

Power BI Data Modelling, Relationships and Joins: A Practical Guide to Building Effective BI Models

#analytics #data #database #tutorial
Comments 1
6 min read
OLTP vs. OLAP: Understanding the Foundation of Modern Data Systems
venuskennedy profile

OLTP vs. OLAP: Understanding the Foundation of Modern Data Systems

#architecture #data #database #systemdesign
Comments
8 min read
Encrypted PostgreSQL Backups to S3 or R2 with One Python Script (and a Tested Restore)
alessio99xx profile

Encrypted PostgreSQL Backups to S3 or R2 with One Python Script (and a Tested Restore)

#postgres #backup #devops #database
Comments
4 min read
Window Functions vs. Aggregate Functions in SQL (With Examples)
ericmwaimiri profile

Window Functions vs. Aggregate Functions in SQL (With Examples)

#database #programming #sql #tutorial
Comments
3 min read
Valkey vs Redis in 2026: The Fork Quietly Won Most of the Market
jamilxt profile

Valkey vs Redis in 2026: The Fork Quietly Won Most of the Market

#valkey #redis #devops #database
3
Comments 3
8 min read
PTO accrual is date math, not a spreadsheet column: four things that break
ptodesk profile

PTO accrual is date math, not a spreadsheet column: four things that break

#architecture #backend #database #softwareengineering
Comments
2 min read
Design a ClickHouse® Table Without Hand-Writing DDL: Schema Studio
kanishga_subramani_49ad73 profile

Design a ClickHouse® Table Without Hand-Writing DDL: Schema Studio

#clickhouse #devops #analytics #database
2
Comments
4 min read
Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You
syed_anzar profile

Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You

#postgres #database #performance #programming
Comments
10 min read
Our product search only returns rows the scanner can actually answer for
daniel_pertu profile

Our product search only returns rows the scanner can actually answer for

#postgres #sql #database #webdev
Comments
5 min read
Difference between windows and aggregate functions in sql.
gigomkenya profile

Difference between windows and aggregate functions in sql.

#devops #beginners #database
1
Comments
1 min read
A Fraud Investigation Agent
mukull-s profile

A Fraud Investigation Agent

#showdev #agents #ai #database
Comments
3 min read
Postgres connection pooling: why your app runs out of connections under load
amitshuklabag profile

Postgres connection pooling: why your app runs out of connections under load

#postgres #database #backend #devops
Comments
4 min read
6 Lessons From 20 Years of SQL Migration Tools (Applied to a NoSQL Migrator in 2026)
keymelgaston profile

6 Lessons From 20 Years of SQL Migration Tools (Applied to a NoSQL Migrator in 2026)

#discuss #database #opensource #postgres
Comments
4 min read
Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling
ephantus_macharia_ profile

Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling

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