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.
PostgreSQL Dead Rows: The Ultimate Guide to MVCC, Database Bloat, Performance Degradation, and Long-Term Optimization
amr-saafan profile

PostgreSQL Dead Rows: The Ultimate Guide to MVCC, Database Bloat, Performance Degradation, and Long-Term Optimization

#postgres #postgressql #sql #database
3
Comments
7 min read
Local-First Is Actually a Governance Revolution
narnaiezzsshaa profile

Local-First Is Actually a Governance Revolution

#security #architecture #webdev #database
Comments
4 min read
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
mazinocodes profile

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

#oracle #sql #beginners #database
29
Comments 2
3 min read
Understanding the core mechanics of ThingsDB
joente profile

Understanding the core mechanics of ThingsDB

#architecture #database #systemdesign
4
Comments
4 min read
How to effectively monitor regular backups
lmadev profile

How to effectively monitor regular backups

#devops #database #crontab #monitoring
1
Comments 5
4 min read
Breaking data for fun
islamov profile

Breaking data for fun

#data #database #programming #tutorial
Comments
9 min read
Subqueries vs JOINs: When to Use Each in SQL
hinlocaesar profile

Subqueries vs JOINs: When to Use Each in SQL

#beginners #database #performance #sql
2
Comments
4 min read
Building AppReviews: the stack, the choices, and the compromises
quentin23soleil profile

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

#programming #webdev #frontend #database
Comments
5 min read
SQL - PostgreSQL: Execution Order
yurilbrok profile

SQL - PostgreSQL: Execution Order

#sql #postgres #dataengineering #database
4
Comments
5 min read
SQL Access for AI Agents — Flexibility with Guardrails
sanchar10 profile

SQL Access for AI Agents — Flexibility with Guardrails

#mcp #dotnet #database #architecture
Comments
2 min read
Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite
lovestaco profile

Explicit Locking, Deadlocks, and Linux Lock Primitives in SQLite

#webdev #programming #database #architecture
15
Comments 2
5 min read
Migrate the legacy Greenplum to Apache Cloudberry with cbcopy
maya_sun_29e7bf629e5dd7b3 profile

Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

#database #dataengineering #postgres #opensource
Comments
7 min read
PostgreSQL backup verification — How to test and validate your PostgreSQL backups
piteradyson profile

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

#database #postgres
4
Comments
9 min read
Table Design: Database Fundamentals to Know as a Beginner
mazinocodes profile

Table Design: Database Fundamentals to Know as a Beginner

#sql #database #beginners #learning
27
Comments 2
4 min read
The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps
ffteamnames profile

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

#architecture #database #performance
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.