Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1
Cover image for PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

16
Comments
12 min read
Supadex: A Mobile Dashboard for Supabase Developers 🚀
Cover image for Supadex: A Mobile Dashboard for Supabase Developers 🚀

Supadex: A Mobile Dashboard for Supabase Developers 🚀

1
Comments 1
2 min read
ACID in Databases: What It Really Means (with Real-Life Bank Scenarios in the USA & Germany)
Cover image for ACID in Databases: What It Really Means (with Real-Life Bank Scenarios in the USA & Germany)

ACID in Databases: What It Really Means (with Real-Life Bank Scenarios in the USA & Germany)

2
Comments
2 min read
Database optimization best practices
Cover image for Database optimization best practices

Database optimization best practices

Comments
3 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

2
Comments 2
1 min read
Join the Redis AI Challenge: $3,000 in Prizes!
Cover image for Join the Redis AI Challenge: $3,000 in Prizes!

Join the Redis AI Challenge: $3,000 in Prizes!

148
Comments 40
4 min read
A spanner-cli Contributor's Perspective on the Official Spanner CLI
Cover image for A spanner-cli Contributor's Perspective on the Official Spanner CLI

A spanner-cli Contributor's Perspective on the Official Spanner CLI

Comments
12 min read
How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds
Cover image for How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds

How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds

8
Comments 5
14 min read
Entendendo a Replicação de Banco de Dados: Uma Chave para Sistemas Robustos

Entendendo a Replicação de Banco de Dados: Uma Chave para Sistemas Robustos

Comments
3 min read
No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)
Cover image for No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)

No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)

1
Comments
12 min read
I Built a Database from Scratch in Go - Here's What I Learned About B+ Trees, ACID Transactions, and 1,800 ops/sec Performance 🚀

I Built a Database from Scratch in Go - Here's What I Learned About B+ Trees, ACID Transactions, and 1,800 ops/sec Performance 🚀

1
Comments
4 min read
Adicionando um certificado cliente em uma wallet Oracle
Cover image for Adicionando um certificado cliente em uma wallet Oracle

Adicionando um certificado cliente em uma wallet Oracle

Comments
3 min read
ORMs: The Good, The Bad, and The Ugly Performance

ORMs: The Good, The Bad, and The Ugly Performance

1
Comments
9 min read
How to Bring SQL Database Online From Recovery Pending State
Cover image for How to Bring SQL Database Online From Recovery Pending State

How to Bring SQL Database Online From Recovery Pending State

1
Comments 1
6 min read
A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn
Cover image for A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

2
Comments
5 min read
I built an Event-Sourcing Database Engine, because I love Event-Driven Architectures: Meet Genesis DB

I built an Event-Sourcing Database Engine, because I love Event-Driven Architectures: Meet Genesis DB

Comments
2 min read
How to Achieve Website Accessibility Compliance in 2025

How to Achieve Website Accessibility Compliance in 2025

Comments
1 min read
How to Design a Relational Database Schema in 2025
Cover image for How to Design a Relational Database Schema in 2025

How to Design a Relational Database Schema in 2025

17
Comments 1
8 min read
DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications
Cover image for DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications

DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications

Comments
3 min read
The Seven Types of Locks in InnoDB

The Seven Types of Locks in InnoDB

Comments
5 min read
Automating PostgreSQL Backups with a Shell Script

Automating PostgreSQL Backups with a Shell Script

3
Comments
3 min read
Segmented Accumulation by Condition — From SQL to SPL #30
Cover image for Segmented Accumulation by Condition — From SQL to SPL #30

Segmented Accumulation by Condition — From SQL to SPL #30

6
Comments 1
1 min read
Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization
Cover image for Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

5
Comments
7 min read
🌍 How STPX Global Is Fueling a World Revolution in AI and Growing Fast

🌍 How STPX Global Is Fueling a World Revolution in AI and Growing Fast

5
Comments
3 min read
Best Practices for Syncing Hive Data to Apache Doris — From Scenario Matching to Performance Tuning

Best Practices for Syncing Hive Data to Apache Doris — From Scenario Matching to Performance Tuning

Comments
4 min read
loading...