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.
Understanding the core mechanics of ThingsDB

Understanding the core mechanics of ThingsDB

4
Comments
4 min read
How to effectively monitor regular backups

How to effectively monitor regular backups

1
Comments 5
4 min read
Subqueries vs JOINs: When to Use Each in SQL

Subqueries vs JOINs: When to Use Each in SQL

3
Comments
4 min read
Breaking data for fun

Breaking data for fun

Comments
9 min read
project: StatefulSet with replica's

project: StatefulSet with replica's

2
Comments
3 min read
SQL - PostgreSQL: Execution Order

SQL - PostgreSQL: Execution Order

4
Comments
5 min read
Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

15
Comments 2
5 min read
Building AppReviews: the stack, the choices, and the compromises

Building AppReviews: the stack, the choices, and the compromises

Comments
5 min read
SQL Access for AI Agents — Flexibility with Guardrails

SQL Access for AI Agents — Flexibility with Guardrails

Comments
2 min read
Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

Comments
7 min read
PostgreSQL backup verification — How to test and validate your PostgreSQL backups

PostgreSQL backup verification — How to test and validate your PostgreSQL backups

4
Comments
9 min read
Table Design: Database Fundamentals to Know as a Beginner

Table Design: Database Fundamentals to Know as a Beginner

27
Comments 2
4 min read
What Happens When a User Deletes Their Account? A Guide to Rails ActiveRecord dependent: Strategies

What Happens When a User Deletes Their Account? A Guide to Rails ActiveRecord dependent: Strategies

4
Comments
4 min read
The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps

The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps

Comments
2 min read
MongoDB Document Model and CRUD in Practice

MongoDB Document Model and CRUD in Practice

1
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.