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.
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 😻

5
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

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
Install MongoDB & Create a Database | MongoDB Tutorial 2025

Install MongoDB & Create a Database | MongoDB Tutorial 2025

6
Comments
5 min read
Working with JSON in PostgreSQL, MySQL & SQL Server

Working with JSON in PostgreSQL, MySQL & SQL Server

1
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
Think in Sets: Writing High-Performance SQL the Declarative Way

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

Comments
2 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

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
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
TRANSACTIONS IN DATABASE

TRANSACTIONS IN DATABASE

1
Comments
2 min read
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

How I Replaced Python with C in My Project

3
Comments 2
4 min read
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
loading...