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.
13 PostgreSQL Backup Best Practices for Developers and DBAs

13 PostgreSQL Backup Best Practices for Developers and DBAs

1
Comments
12 min read
Neo4J Protege Plugin

Neo4J Protege Plugin

Comments
10 min read
Introducing dremioframe - A Pythonic DataFrame Interface for Dremio

Introducing dremioframe - A Pythonic DataFrame Interface for Dremio

Comments
9 min read
4 Rules to Make MySQL Indexes Blazing Fast

4 Rules to Make MySQL Indexes Blazing Fast

3
Comments
2 min read
Self-Hosted vs Cloud PostgreSQL Backups: Full Pros and Cons Guide

Self-Hosted vs Cloud PostgreSQL Backups: Full Pros and Cons Guide

Comments
5 min read
🚀 The Secret Sauce of Scalable Apps: Database Connection Pooling

🚀 The Secret Sauce of Scalable Apps: Database Connection Pooling

Comments
2 min read
Untangling the Rails Monolith - quick look at the code

Untangling the Rails Monolith - quick look at the code

2
Comments
4 min read
Brex Database Disaster Recovery

Brex Database Disaster Recovery

Comments
3 min read
🚀 Boost Your EF Core Performance with AsNoTracking()

🚀 Boost Your EF Core Performance with AsNoTracking()

3
Comments
2 min read
A (very) Short Look at How MySQL Joins Work

A (very) Short Look at How MySQL Joins Work

2
Comments
2 min read
🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

Comments
2 min read
The Connection Leak That Took Down Our Production Database

The Connection Leak That Took Down Our Production Database

Comments
2 min read
Why Your Business Needs Automated PostgreSQL Backups

Why Your Business Needs Automated PostgreSQL Backups

Comments
3 min read
That Dreaded Alembic NotNullViolation Error (and How to Survive It)

That Dreaded Alembic NotNullViolation Error (and How to Survive It)

3
Comments 1
2 min read
PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

Comments
8 min read
Deep Dive: Mastering Active Record Queries & Raw SQL

Deep Dive: Mastering Active Record Queries & Raw SQL

Comments
3 min read
SQLite: A Simple Database with Serious Engineering Inside

SQLite: A Simple Database with Serious Engineering Inside

11
Comments
4 min read
Free Interactive SQL Practice Platform for Developers

Free Interactive SQL Practice Platform for Developers

Comments
1 min read
Building a Type-Safe In-Memory DB

Building a Type-Safe In-Memory DB

Comments
2 min read
Transaction Race Conditions: Why BEGIN on Pool Breaks Everything

Transaction Race Conditions: Why BEGIN on Pool Breaks Everything

Comments
2 min read
Spring Data JPA Relationships

Spring Data JPA Relationships

10
Comments
1 min read
MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

1
Comments
1 min read
How have I managed Date types in my asyncio python web scraper using PostgreSQL?

How have I managed Date types in my asyncio python web scraper using PostgreSQL?

Comments
3 min read
Getting Started with eslint-plugin-pg

Getting Started with eslint-plugin-pg

Comments
2 min read
Generate UUID in PostgreSQL

Generate UUID in PostgreSQL

1
Comments
1 min read
loading...