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.
A trip to China is 311 trips, not 44,473 — and four of the six line items are constants

A trip to China is 311 trips, not 44,473 — and four of the six line items are constants

Comments
3 min read
Navicat Data Modeler Alternative: Database Design Software Without the Enterprise Edition

Navicat Data Modeler Alternative: Database Design Software Without the Enterprise Edition

Comments
12 min read
Database Schema Planning: How to Audit Your Current Setup

Database Schema Planning: How to Audit Your Current Setup

Comments
1 min read
How Do I Backup and Restore a SQL Server Database in SSMS? (Step by Step, 2026)

How Do I Backup and Restore a SQL Server Database in SSMS? (Step by Step, 2026)

Comments
17 min read
I Built db-migrator to Move Data Between Databases and Validate the Results

I Built db-migrator to Move Data Between Databases and Validate the Results

Comments
3 min read
One phone number, two users: normalising WhatsApp sender IDs across Baileys and the Cloud API

One phone number, two users: normalising WhatsApp sender IDs across Baileys and the Cloud API

Comments
2 min read
LISTEN/NOTIFY performance in PostgreSQL

LISTEN/NOTIFY performance in PostgreSQL

Comments
9 min read
GBase Database(GBase 8c): How to Build a Three-Node HA Cluster with gbase.yml

GBase Database(GBase 8c): How to Build a Three-Node HA Cluster with gbase.yml

2
Comments
4 min read
GBase Database(GBase 8c) Installation: The Four-Step Workflow from Trust to Deployment

GBase Database(GBase 8c) Installation: The Four-Step Workflow from Trust to Deployment

2
Comments
4 min read
Instagram Clone Backend — Part 3: Database & Persistence (PostgreSQL 16+, SQLAlchemy 2.0 Async ORM, asyncpg & Alembic)

Instagram Clone Backend — Part 3: Database & Persistence (PostgreSQL 16+, SQLAlchemy 2.0 Async ORM, asyncpg & Alembic)

1
Comments
5 min read
Instagram Clone Backend — Part 5: Performance & Database Optimization (Pagination, Zero N+1 Queries, Optimistic Locking & Integrity Constraints)

Instagram Clone Backend — Part 5: Performance & Database Optimization (Pagination, Zero N+1 Queries, Optimistic Locking & Integrity Constraints)

1
Comments
6 min read
GBase Database(GBase 8c): Why Three Deployment Layouts Have Different Configuration Fields

GBase Database(GBase 8c): Why Three Deployment Layouts Have Different Configuration Fields

2
Comments
3 min read
Best Data Modeling Tools for Databricks: SQLDBM, erwin, Lucidchart & dbt Compared

Best Data Modeling Tools for Databricks: SQLDBM, erwin, Lucidchart & dbt Compared

Comments
11 min read
16,000 databases, and the four ways row-level security silently fails

16,000 databases, and the four ways row-level security silently fails

Comments
4 min read
Redis benchmark: HotKV vs Valkey and Dragonfly in a three-node cluster

Redis benchmark: HotKV vs Valkey and Dragonfly in a three-node cluster

Comments
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.