Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
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
Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3
Cover image for Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3

Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3

Comments
2 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26
Cover image for Create Columns from Distinct Values of a Column — From SQL to SPL #26

Create Columns from Distinct Values of a Column — From SQL to SPL #26

6
Comments 1
1 min read
Understanding Database Schema Structure for Beginners
Cover image for Understanding Database Schema Structure for Beginners

Understanding Database Schema Structure for Beginners

1
Comments
4 min read
Educational Credentials in the Digital Age: Ensuring Authenticity and Portability

Educational Credentials in the Digital Age: Ensuring Authenticity and Portability

Comments
3 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

2
Comments 2
3 min read
How to Think in Access Patterns First With DynamoDB
Cover image for How to Think in Access Patterns First With DynamoDB

How to Think in Access Patterns First With DynamoDB

Comments
3 min read
Why Postgres is Your App’s Secret Superpower (And Why You’re Overcomplicating Everything)

Why Postgres is Your App’s Secret Superpower (And Why You’re Overcomplicating Everything)

Comments 1
4 min read
🚀 Boosting React Native Performance with Caching — Made Simple
Cover image for 🚀 Boosting React Native Performance with Caching — Made Simple

🚀 Boosting React Native Performance with Caching — Made Simple

Comments 1
3 min read
How I Got x311 Faster Analytics on 110M Rows

How I Got x311 Faster Analytics on 110M Rows

Comments
3 min read
How Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

4
Comments 2
3 min read
Substring from a Column of Strings — From SQL to SPL #25
Cover image for Substring from a Column of Strings — From SQL to SPL #25

Substring from a Column of Strings — From SQL to SPL #25

5
Comments 1
2 min read
Total under Recursive Relationship — From SQL to SPL #33
Cover image for Total under Recursive Relationship — From SQL to SPL #33

Total under Recursive Relationship — From SQL to SPL #33

7
Comments 1
2 min read
loading...