Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SelfDB – Ditch Supabase and Firebase Lock-In, Self-Host Simply

SelfDB – Ditch Supabase and Firebase Lock-In, Self-Host Simply

1
Comments 2
3 min read
PostgreSQL vs MySQL - A Real Developer Rates an AI Podcast

PostgreSQL vs MySQL - A Real Developer Rates an AI Podcast

Comments
19 min read
How to use EXPLAIN to fix slow queries in MySQL
Cover image for How to use EXPLAIN to fix slow queries in MySQL

How to use EXPLAIN to fix slow queries in MySQL

6
Comments
6 min read
10 SQL Anti-Patterns You Must Avoid in Production

10 SQL Anti-Patterns You Must Avoid in Production

2
Comments
2 min read
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

1
Comments
2 min read
Working with JSON in PostgreSQL, MySQL & SQL Server

Working with JSON in PostgreSQL, MySQL & SQL Server

1
Comments
2 min read
Think in Sets: Writing High-Performance SQL the Declarative Way

Think in Sets: Writing High-Performance SQL the Declarative Way

Comments
2 min read
Install MongoDB & Create a Database | MongoDB Tutorial 2025
Cover image for Install MongoDB & Create a Database | MongoDB Tutorial 2025

Install MongoDB & Create a Database | MongoDB Tutorial 2025

6
Comments
5 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

1
Comments
2 min read
Materialized Views in SQL: Supercharging Read Performance

Materialized Views in SQL: Supercharging Read Performance

Comments
2 min read
Behind the Scenes: Reading SQL Execution Plans Like a Pro

Behind the Scenes: Reading SQL Execution Plans Like a Pro

Comments
3 min read
Why Netflix Doesn’t Trust Auto-Increment IDs: The Untold Power of UUIDs in a Distributed World

Why Netflix Doesn’t Trust Auto-Increment IDs: The Untold Power of UUIDs in a Distributed World

1
Comments
4 min read
How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide
Cover image for How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide

How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide

Comments
3 min read
A simple, convenience package for the Azure Cosmos DB Go SDK
Cover image for A simple, convenience package for the Azure Cosmos DB Go SDK

A simple, convenience package for the Azure Cosmos DB Go SDK

4
Comments
5 min read
PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

1
Comments
3 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd
Cover image for Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

8
Comments
4 min read
How I Replaced Python with C in My Project
Cover image for How I Replaced Python with C in My Project

How I Replaced Python with C in My Project

3
Comments 2
4 min read
TRANSACTIONS IN DATABASE
Cover image for TRANSACTIONS IN DATABASE

TRANSACTIONS IN DATABASE

Comments
2 min read
How I Created an API That Enhances the Performance of ChatGPT
Cover image for How I Created an API That Enhances the Performance of ChatGPT

How I Created an API That Enhances the Performance of ChatGPT

Comments
3 min read
Optimizing SQL queries for your AI Agents.
Cover image for Optimizing SQL queries for your AI Agents.

Optimizing SQL queries for your AI Agents.

6
Comments
4 min read
A Guide to Cleaning and Organizing Customer Data
Cover image for A Guide to Cleaning and Organizing Customer Data

A Guide to Cleaning and Organizing Customer Data

Comments
2 min read
PgDog: Your New Best Friend for PostgreSQL Management
Cover image for PgDog: Your New Best Friend for PostgreSQL Management

PgDog: Your New Best Friend for PostgreSQL Management

Comments
3 min read
Oracle 21c – pdbTimezone Parameter in DBCA Command

Oracle 21c – pdbTimezone Parameter in DBCA Command

Comments 2
1 min read
Finding and Remediating Idle AWS Databases Made Easy
Cover image for Finding and Remediating Idle AWS Databases Made Easy

Finding and Remediating Idle AWS Databases Made Easy

Comments
24 min read
loading...