Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
I Built a Real-Time HackerNews Search Engine with 50 Lines of Python (No Airflow, No Kafka)
Cover image for I Built a Real-Time HackerNews Search Engine with 50 Lines of Python (No Airflow, No Kafka)

I Built a Real-Time HackerNews Search Engine with 50 Lines of Python (No Airflow, No Kafka)

5
Comments
3 min read
How to Connect PostgreSQL to Power BI using Local PostgreSQL.
Cover image for How to Connect PostgreSQL to Power BI using Local PostgreSQL.

How to Connect PostgreSQL to Power BI using Local PostgreSQL.

Comments
2 min read
Scaling Your Database: Simple Solutions Anyone Can Use
Cover image for Scaling Your Database: Simple Solutions Anyone Can Use

Scaling Your Database: Simple Solutions Anyone Can Use

Comments
4 min read
The Delete Button Dilemma: When to Soft Delete vs Hard Delete

The Delete Button Dilemma: When to Soft Delete vs Hard Delete

5
Comments
5 min read
# How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup
Cover image for # How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup

# How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup

Comments
3 min read
Database ID Design: Choosing ID Methods and Primary Key Strategies

Database ID Design: Choosing ID Methods and Primary Key Strategies

Comments
4 min read
How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)
Cover image for How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

Comments
2 min read
How Internet Archive Stores & Protects Trillions of Files

How Internet Archive Stores & Protects Trillions of Files

Comments
7 min read
Scaling SQLite with Node worker threads and better-sqlite3
Cover image for Scaling SQLite with Node worker threads and better-sqlite3

Scaling SQLite with Node worker threads and better-sqlite3

26
Comments
8 min read
The Architecture Shift: Why I'm Betting on Local-First in 2026.
Cover image for The Architecture Shift: Why I'm Betting on Local-First in 2026.

The Architecture Shift: Why I'm Betting on Local-First in 2026.

25
Comments 22
3 min read
Secrets to Smarter Architecture: AI's Role in 2025 Decisions

Secrets to Smarter Architecture: AI's Role in 2025 Decisions

Comments
6 min read
Horizontal vs. Vertical Scaling: Building Scalable Apps

Horizontal vs. Vertical Scaling: Building Scalable Apps

Comments
9 min read
Day 20 : Django Learning

Day 20 : Django Learning

Comments
1 min read
AlloyDB Agentic RAG Application with MCP Toolbox [Part 2]

AlloyDB Agentic RAG Application with MCP Toolbox [Part 2]

10
Comments
13 min read
Database Center from Google Cloud — The “Virtual DBA” You Didn’t Know You Hired

Database Center from Google Cloud — The “Virtual DBA” You Didn’t Know You Hired

29
Comments
3 min read
Schema Design with Supabase: Partitioning and Normalization

Schema Design with Supabase: Partitioning and Normalization

Comments
5 min read
Mastering SQL: Revisiting the Basics
Cover image for Mastering SQL: Revisiting the Basics

Mastering SQL: Revisiting the Basics

Comments
3 min read
Quick Recap: NoSQL Databases

Quick Recap: NoSQL Databases

Comments
2 min read
Bitnami MySQL Docker Image Tags Deleted
Cover image for Bitnami MySQL Docker Image Tags Deleted

Bitnami MySQL Docker Image Tags Deleted

Comments
2 min read
🔫Why You Suck at Structuring Data And How to Finally Get Better 💪

🔫Why You Suck at Structuring Data And How to Finally Get Better 💪

2
Comments
3 min read
Building Real-Time Lakehouse with S3 Tables, AWS Glue, and Apache Doris

Building Real-Time Lakehouse with S3 Tables, AWS Glue, and Apache Doris

Comments
3 min read
Quick Recap: Elasticsearch & Lucene

Quick Recap: Elasticsearch & Lucene

Comments
2 min read
Quick Recap: SQL Databases

Quick Recap: SQL Databases

Comments
2 min read
Why You Should Use a Database In Your Projects!
Cover image for Why You Should Use a Database In Your Projects!

Why You Should Use a Database In Your Projects!

Comments
3 min read
Database Migration Strategies for Zero-Downtime

Database Migration Strategies for Zero-Downtime

Comments
9 min read
loading...