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 partitioning — 4 strategies for managing large tables

PostgreSQL partitioning — 4 strategies for managing large tables

2
Comments
8 min read
COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained

COUNT(column) vs COUNT(*) in SQL — With INNER, LEFT, RIGHT & FULL JOIN Explained

Comments
1 min read
Joins and Windows Functions in SQL

Joins and Windows Functions in SQL

2
Comments
5 min read
Building sql-splitter: Correctness Is the Product

Building sql-splitter: Correctness Is the Product

Comments
11 min read
A safe way to let coding agents interact with your database (without prod write access)

A safe way to let coding agents interact with your database (without prod write access)

Comments
12 min read
Ajuste de Rendimiento en PostgreSQL: Lo Que AprendĂ­ Optimizando Consultas en una Base de Datos de 10TB

Ajuste de Rendimiento en PostgreSQL: Lo Que AprendĂ­ Optimizando Consultas en una Base de Datos de 10TB

1
Comments 2
8 min read
8 PostgreSQL security hardening tips for production databases

8 PostgreSQL security hardening tips for production databases

Comments
6 min read
Why Don't Databases Understand Documents?

Why Don't Databases Understand Documents?

Comments
8 min read
Reviewing a Review

Reviewing a Review

Comments
1 min read
I Built a Lightweight Database GUI Because I Was Tired of Heavy Tools

I Built a Lightweight Database GUI Because I Was Tired of Heavy Tools

1
Comments
2 min read
7 MongoDB indexing strategies to speed up your queries

7 MongoDB indexing strategies to speed up your queries

1
Comments
6 min read
From Idea to Database: A Practical Guide to Database Design

From Idea to Database: A Practical Guide to Database Design

Comments
17 min read
Why I Replaced Vector Databases with Markdown Files for AI Agent Memory

Why I Replaced Vector Databases with Markdown Files for AI Agent Memory

Comments
3 min read
Week 6: How GusLift Matches Rides in Real Time

Week 6: How GusLift Matches Rides in Real Time

3
Comments
2 min read
Day 1: My Minimalist Database Setup on macOS 🚀

Day 1: My Minimalist Database Setup on macOS 🚀

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