Forem

Database

Posts on building, using, and learning about databases.

Posts

πŸ‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Why PostgreSQL Might Be All the Backend You Need: Forget the Kitchen Sink

Why PostgreSQL Might Be All the Backend You Need: Forget the Kitchen Sink

6
Comments
4 min read
Reactive Programming in Node.js

Reactive Programming in Node.js

Comments
3 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

8
Comments 2
5 min read
How I Eliminated 90% of My Database Queries Using CRC32 as a Deterministic Random Seed (And You Can Too!)

How I Eliminated 90% of My Database Queries Using CRC32 as a Deterministic Random Seed (And You Can Too!)

Comments 2
4 min read
How to Connect a PHP Script to MySQL: A Step-by-Step Guide

How to Connect a PHP Script to MySQL: A Step-by-Step Guide

Comments
4 min read
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

How to use EXPLAIN to fix slow queries in MySQL

9
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
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
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

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

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

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
Prisma + Neon DB Error P1001 Explained (with Pizza πŸ•)

Prisma + Neon DB Error P1001 Explained (with Pizza πŸ•)

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

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

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

4
Comments
5 min read
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

TRANSACTIONS IN DATABASE

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

How I Created an API That Enhances the Performance of ChatGPT

2
Comments
3 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

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

2
Comments
4 min read
loading...