Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Posta: Building a Social Blogging Backend with SurrealDB, Nix, and Nushell
Cover image for Posta: Building a Social Blogging Backend with SurrealDB, Nix, and Nushell

Posta: Building a Social Blogging Backend with SurrealDB, Nix, and Nushell

Comments
4 min read
Unraveling the WordPress Query: The Engine Behind Your Content
Cover image for Unraveling the WordPress Query: The Engine Behind Your Content

Unraveling the WordPress Query: The Engine Behind Your Content

Comments
1 min read
Build a Real-time A/B Testing Analytics API with Tinybird

Build a Real-time A/B Testing Analytics API with Tinybird

Comments
4 min read
How to Create a New MySQL User and Grant All Permissions

How to Create a New MySQL User and Grant All Permissions

Comments
2 min read
How to Speed Up EXISTS in Primary-Subtable Joins with esProc

How to Speed Up EXISTS in Primary-Subtable Joins with esProc

6
Comments
5 min read
Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters
Cover image for Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

Comments
4 min read
Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

Comments
4 min read
The Evolution of Data Architectures: From Lakes to Mesh and Beyond

The Evolution of Data Architectures: From Lakes to Mesh and Beyond

1
Comments
9 min read
Entenda Teorema CAP
Cover image for Entenda Teorema CAP

Entenda Teorema CAP

1
Comments
5 min read
How we built our metadata layer on FoundationDB
Cover image for How we built our metadata layer on FoundationDB

How we built our metadata layer on FoundationDB

Comments
5 min read
Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data
Cover image for Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Comments
5 min read
Smarter Databases with SQL Views and Triggers

Smarter Databases with SQL Views and Triggers

Comments
5 min read
Understanding Query Cost in SQL
Cover image for Understanding Query Cost in SQL

Understanding Query Cost in SQL

2
Comments
7 min read
Understanding T-SQL vs PL/SQL Database Curveballs
Cover image for Understanding T-SQL vs PL/SQL Database Curveballs

Understanding T-SQL vs PL/SQL Database Curveballs

1
Comments
3 min read
How Joins work?

How Joins work?

Comments
2 min read
Best MySQL Database Design Tools in 2025
Cover image for Best MySQL Database Design Tools in 2025

Best MySQL Database Design Tools in 2025

11
Comments 2
8 min read
SQL And PHP: People whose birthday is today

SQL And PHP: People whose birthday is today

Comments
1 min read
AWS KMS Customer Managed Key (CMK) for DB Integration

AWS KMS Customer Managed Key (CMK) for DB Integration

Comments
3 min read
Slow SQL? Diagnose & Fix Bottlenecks Fast!

Slow SQL? Diagnose & Fix Bottlenecks Fast!

Comments
6 min read
$lookup: more than just a SQL join (understand performance)
Cover image for $lookup: more than just a SQL join (understand performance)

$lookup: more than just a SQL join (understand performance)

8
Comments 1
5 min read
Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization
Cover image for Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

1
Comments
8 min read
The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck
Cover image for The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

Comments
2 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup
Cover image for PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 min read
Free PostgreSQL Hosting Now Available – Public Access Included

Free PostgreSQL Hosting Now Available – Public Access Included

Comments 1
3 min read
Which LLM writes the best SQL?
Cover image for Which LLM writes the best SQL?

Which LLM writes the best SQL?

Comments
10 min read
loading...