#Postgres

June 13, 2026
15:45

PGWeb

Cross-platform client for PostgreSQL databases.
BM869 Database, Postgres
March 5, 2026
22:21

9 Advanced PostgreSQL Features I Wish I Knew Sooner

GENERATED columns, EXCLUDE constraints, DISTINCT ON, Foreign Data Wrappers… PostgreSQL has powerful features you might not know about. Here are my favorites.
BM814 Database, Postgres, Selfhosting
22:21

SQL Window Functions and PARTITION BY in Practice

Sharing our experience with window functions in a recent client project involving historical data management
BM813 Database, Postgres, SQL, Selfhosting
October 4, 2025
00:59

Pgbackweb

Effortless PostgreSQL backups with a user-friendly web interface
BM634 Backup, Database, Postgres, Selfhosting
July 29, 2025
17:47

n8n-local: Run n8n + Postgres + pgAdmin via Docker Compose

Docker Compose setup to self-host n8n with a Postgres backend and pgAdmin for DB management — quick local automation stack.
BM558 Automation, Docker, Postgres, Selfhosting, n8n
July 8, 2025
12:25

Yamtrack: Self-Hosted Media Tracker (Movies, TV, Books)

Open-source self-hosted media tracker built with Django — tracks movies, TV shows, books, and more, with Docker deployment and Postgres/SQLite support.
BM543 Docker, Media-Server, Movies, Postgres, SQLite, Selfhosting, TVShows
June 28, 2025
10:10

Self-Hosted URL Shortener (Go + Gin + Postgres + Redis)

Self-hosted URL shortening service built in Go/Gin-Gonic with user auth, a link management dashboard, Redis caching, Postgres storage, and Docker deployment behind Nginx.
BM524 Docker, Go, Nginx, Postgres, Selfhosting, URLShortener