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.
1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
Junior Me: ‘I’ll just add a class_group_id to enrollment’ Future me looking at 2023 data: ‘why is this broken’

Junior Me: ‘I’ll just add a class_group_id to enrollment’ Future me looking at 2023 data: ‘why is this broken’

Comments
2 min read
The Empty Box Problem in Laravel Migrations (And why I stopped using default strings)

The Empty Box Problem in Laravel Migrations (And why I stopped using default strings)

Comments 4
2 min read
How to Backup and Restore a Single PostgreSQL Table with pg_dump

How to Backup and Restore a Single PostgreSQL Table with pg_dump

Comments
5 min read
Dataverse Capacity Migration Checklist (2025 Update)

Dataverse Capacity Migration Checklist (2025 Update)

Comments
2 min read
PostgreSQL DBA Path: Setup, Table Creation, and Database Maintenance Labs

PostgreSQL DBA Path: Setup, Table Creation, and Database Maintenance Labs

Comments
2 min read
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

25
Comments 1
3 min read
Log Databases Done Right

Log Databases Done Right

Comments
5 min read
LSM-Trees, NVMe SSDs, and Modern Storage Realities

LSM-Trees, NVMe SSDs, and Modern Storage Realities

10
Comments
3 min read
Optimizing a 40-Year-Old Government Database: From 3s to 30ms

Optimizing a 40-Year-Old Government Database: From 3s to 30ms

2
Comments
2 min read
Quick Rails Tip: Change Database Adapter

Quick Rails Tip: Change Database Adapter

Comments
1 min read
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

20
Comments
3 min read
Top 10 pg_dump Options You Should Know for Reliable PostgreSQL Backups

Top 10 pg_dump Options You Should Know for Reliable PostgreSQL Backups

Comments
6 min read
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

25
Comments
3 min read
GraphRAG : From Zero to Hero

GraphRAG : From Zero to Hero

Comments
4 min read
🌟introducing orbynt database:OrbMem

🌟introducing orbynt database:OrbMem

Comments
2 min read
dremioframe & iceberg: Pythonic interfaces for Dremio and Apache Iceberg

dremioframe & iceberg: Pythonic interfaces for Dremio and Apache Iceberg

Comments
8 min read
Building a Multi-Tenant Hospital Management System: Architecture & Implementation

Building a Multi-Tenant Hospital Management System: Architecture & Implementation

Comments
2 min read
Understanding the {backpopulate} Parameter in SQLAlchemy Relationships

Understanding the {backpopulate} Parameter in SQLAlchemy Relationships

Comments
3 min read
Choosing a Database Isn’t About Hype - It’s About the Stage of Your Product

Choosing a Database Isn’t About Hype - It’s About the Stage of Your Product

1
Comments
2 min read
Neo4j GraphRAG: Intelligent Knowledge Graph Querying with AI

Neo4j GraphRAG: Intelligent Knowledge Graph Querying with AI

Comments
11 min read
How Database-Driven Kubernetes Automation Actually Works

How Database-Driven Kubernetes Automation Actually Works

Comments
5 min read
How can you make website feel like a native app?

How can you make website feel like a native app?

7
Comments
5 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

25
Comments
3 min read
Why would you ever use an ORM?

Why would you ever use an ORM?

Comments
5 min read
loading...