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.
PostGres Database Replication Using Pglogical

PostGres Database Replication Using Pglogical

Comments
3 min read
Denormalization: When and Why to Flatten Your Data

Denormalization: When and Why to Flatten Your Data

Comments
4 min read
Remote-to-Remote PostgreSQL Migration: Theory and Practice

Remote-to-Remote PostgreSQL Migration: Theory and Practice

Comments
14 min read
How Exposed Postgres view Took 8 Minutes to Retrieve data

How Exposed Postgres view Took 8 Minutes to Retrieve data

Comments
3 min read
Getting Started with Ent: Facebook’s Open-Source ORM for Go Developers

Getting Started with Ent: Facebook’s Open-Source ORM for Go Developers

1
Comments
7 min read
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
Hybrid Search for E-commerce: When Keywords Alone Fail

Hybrid Search for E-commerce: When Keywords Alone Fail

1
Comments
3 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.