Forem

Database

Posts on building, using, and learning about databases.

Posts

πŸ‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
Postgres is Too Good (And Why That's Actually a Problem)
Cover image for Postgres is Too Good (And Why That's Actually a Problem)

Postgres is Too Good (And Why That's Actually a Problem)

169
Comments 31
7 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
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
Data storing using file or database, which is more suitable?

Data storing using file or database, which is more suitable?

7
Comments 2
9 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
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
How to configure multiple databases on individual domain names using a single Odoo instance? [A Multi-Tenant Odoo App]
Cover image for How to configure multiple databases on individual domain names using a single Odoo instance? [A Multi-Tenant Odoo App]

How to configure multiple databases on individual domain names using a single Odoo instance? [A Multi-Tenant Odoo App]

Comments
4 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
Learning PostgreSQL

Learning PostgreSQL

Comments
2 min read
Importing Excel with multiple headers into a database
Cover image for Importing Excel with multiple headers into a database

Importing Excel with multiple headers into a database

Comments
1 min read
Batch export database tables to Excel
Cover image for Batch export database tables to Excel

Batch export database tables to Excel

Comments
2 min read
loading...