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.
Incremental Backup with PostgreSQL 17
marionb profile

Incremental Backup with PostgreSQL 17

#database #postgres #tutorial #postgressql
3
Comments 1
7 min read
Ephemeral Database Branches in CI/CD: A Practical Guide to Per-PR Environments at Scale
manualwise profile

Ephemeral Database Branches in CI/CD: A Practical Guide to Per-PR Environments at Scale

#data #cicd #database
1
Comments
10 min read
When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide
akshaykurve profile

When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

#database #sql #nosql #postgres
Comments
19 min read
From 30 Seconds to 3 Milliseconds: Replacing LIKE with FTS5 on 1.7M Patent Records
soytuber profile
soy

From 30 Seconds to 3 Milliseconds: Replacing LIKE with FTS5 on 1.7M Patent Records

#sqlite #database #performance #search
Comments
4 min read
The Slow Query Hidden Inside Your PL/pgSQL Function
philip_mcclarence_2ef9475 profile

The Slow Query Hidden Inside Your PL/pgSQL Function

#database #performance #postgres #sql
Comments
5 min read
Database Indexes Explained: B-Trees, Composite Keys, and When Indexes Hurt Performance (2026)
young_gao profile

Database Indexes Explained: B-Trees, Composite Keys, and When Indexes Hurt Performance (2026)

#database #postgres #performance #backend
Comments
2 min read
Event Sourcing Explained: When CRUD Is Not Enough (Practical Guide 2026)
young_gao profile

Event Sourcing Explained: When CRUD Is Not Enough (Practical Guide 2026)

#architecture #typescript #database #eventsourcing
Comments
5 min read
Multi-Tenant Architecture: Database Per Tenant vs Shared Schema — Pros and Cons (2026)
young_gao profile

Multi-Tenant Architecture: Database Per Tenant vs Shared Schema — Pros and Cons (2026)

#database #architecture #saas #backend
Comments
5 min read
Pagination Done Right: Cursor vs Offset and Why It Matters at Scale
young_gao profile

Pagination Done Right: Cursor vs Offset and Why It Matters at Scale

#backend #database #typescript #webdev
Comments
1 min read
Database Transactions: ACID, Isolation Levels, and Deadlocks
young_gao profile

Database Transactions: ACID, Isolation Levels, and Deadlocks

#database #backend #postgres #webdev
Comments
1 min read
How to Connect PowerBI to a local and cloud-hosted postgreSQL database
michaelmwai profile

How to Connect PowerBI to a local and cloud-hosted postgreSQL database

#database #microsoft #postgres #tutorial
Comments
3 min read
ORMs 101: The Ultimate Guide
ishaaan profile

ORMs 101: The Ultimate Guide

#orm #prisma #database #backenddevelopment
Comments
16 min read
PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)
young_gao profile

PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

#database #postgres #performance #sql
Comments
5 min read
Connecting Power BI to an SQL database
njokijoan003commits profile

Connecting Power BI to an SQL database

#database #analytics #sql #tutorial
Comments
5 min read
Database Migrations in Production: Zero-Downtime Schema Changes (2026 Guide)
young_gao profile

Database Migrations in Production: Zero-Downtime Schema Changes (2026 Guide)

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