Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)
Cover image for ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)

ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)

Comments
14 min read
Connecting power bi to SQL databases locally and through cloud service.

Connecting power bi to SQL databases locally and through cloud service.

3
Comments
5 min read
Como Usar Supabase CLI: Guia Completo para Desenvolvedores (2026)
Cover image for Como Usar Supabase CLI: Guia Completo para Desenvolvedores (2026)

Como Usar Supabase CLI: Guia Completo para Desenvolvedores (2026)

1
Comments
10 min read
MongoDB vs MySQL: Choosing the Right Database for Your Project
Cover image for MongoDB vs MySQL: Choosing the Right Database for Your Project

MongoDB vs MySQL: Choosing the Right Database for Your Project

17
Comments 1
7 min read
Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast
Cover image for Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

22
Comments 4
5 min read
Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

2
Comments
2 min read
Ujorm3: A New Lightweight ORM for JavaBeans and Records

Ujorm3: A New Lightweight ORM for JavaBeans and Records

Comments 1
5 min read
SQL Query Optimization Guide

SQL Query Optimization Guide

Comments
5 min read
ACID Properties in Database Systems: The Foundation of Reliable Data Management

ACID Properties in Database Systems: The Foundation of Reliable Data Management

2
Comments
4 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Comments
6 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

3
Comments
5 min read
Number Guessing Game

Number Guessing Game

1
Comments 1
2 min read
Two ClickHouse Internals That Change How You Write Queries
Cover image for Two ClickHouse Internals That Change How You Write Queries

Two ClickHouse Internals That Change How You Write Queries

2
Comments
4 min read
PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL
Cover image for PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

1
Comments
12 min read
Introducing MoltenDB: A Local-First, Pure Rust Database for the Browser and Server

Introducing MoltenDB: A Local-First, Pure Rust Database for the Browser and Server

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