Forem

# postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
How to Connect Power BI to a PostgreSQL Database (Localhost and Aiven Cloud)
Cover image for How to Connect Power BI to a PostgreSQL Database (Localhost and Aiven Cloud)

How to Connect Power BI to a PostgreSQL Database (Localhost and Aiven Cloud)

5
Comments
3 min read
Refresh Your Neon Cloud Database from Local Postgres (Without the Data API)

Refresh Your Neon Cloud Database from Local Postgres (Without the Data API)

Comments
2 min read
Databases - Postgresql - Gitea and PGBouncer

Databases - Postgresql - Gitea and PGBouncer

1
Comments
4 min read
137 migrations and counting: building a personal OS schema from scratch
Cover image for 137 migrations and counting: building a personal OS schema from scratch

137 migrations and counting: building a personal OS schema from scratch

2
Comments
6 min read
Integrating PostgreSQL with Power BI for Data Analysis
Cover image for Integrating PostgreSQL with Power BI for Data Analysis

Integrating PostgreSQL with Power BI for Data Analysis

4
Comments
6 min read
Simple guides to table joins and window functions in SQL.
Cover image for Simple guides to table joins and window functions in SQL.

Simple guides to table joins and window functions in SQL.

1
Comments
5 min read
PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each
Cover image for PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

1
Comments
10 min read
Scaling PostgreSQL at OpenAI Notes

Scaling PostgreSQL at OpenAI Notes

Comments
3 min read
OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake
Cover image for OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake

OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake

19
Comments
13 min read
Database Migrations with Claude Code: Safe Schema Changes Without Breaking Production

Database Migrations with Claude Code: Safe Schema Changes Without Breaking Production

1
Comments
3 min read
How We Built a Vector Database for SEC Filings Using PostgreSQL + pgvector
Cover image for How We Built a Vector Database for SEC Filings Using PostgreSQL + pgvector

How We Built a Vector Database for SEC Filings Using PostgreSQL + pgvector

2
Comments
6 min read
SQL Joins & Window Functions

SQL Joins & Window Functions

2
Comments
2 min read
How Feature Flag Rollouts Actually Work (Build One from Scratch in Java)
Cover image for How Feature Flag Rollouts Actually Work (Build One from Scratch in Java)

How Feature Flag Rollouts Actually Work (Build One from Scratch in Java)

9
Comments 4
12 min read
Alena Rybakina: “The path to becoming a PostgreSQL committer starts with your first review”

Alena Rybakina: “The path to becoming a PostgreSQL committer starts with your first review”

2
Comments
5 min read
How We Index 5000+ Minecraft Servers: Database Design and Search Architecture

How We Index 5000+ Minecraft Servers: Database Design and Search Architecture

3
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.