Skip to content

Forem

# postgres

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Cover image for The COUNT(DISTINCT) Problem in Postgres (and How HLL Fixes It)

Aug 30 '25

The COUNT(DISTINCT) Problem in Postgres (and How HLL Fixes It)

#postgres #performance #bigdata #analytics

5 min read

Cover image for Stop Spaghetti SQL: Simplify Complex Queries with Postgres CTEs in Supabase

Ivan Kahl

Oct 2 '25

Stop Spaghetti SQL: Simplify Complex Queries with Postgres CTEs in Supabase

#supabase #postgres #webdev #sql

16 min read

Cover image for Skip Elasticsearch: Build Blazing-Fast Full-Text Search Right in Supabase

Manish

Oct 3 '25

Skip Elasticsearch: Build Blazing-Fast Full-Text Search Right in Supabase

#postgres #supabase #database #fulltext

11 min read

Cover image for 🚨 Fix Airflow 2.8.0 LocalExecutor Crashes on macOS: 3 Essential Solutions (2025)

Sep 3 '25

🚨 Fix Airflow 2.8.0 LocalExecutor Crashes on macOS: 3 Essential Solutions (2025)

#airflow #python #devops #postgres

4 min read

Oct 1 '25

How to Install PostgreSQL 18 on Ubuntu 24.04

#programming #webdev #postgres #database

5 min read

Cover image for Beyond Flat Tables: Model Hierarchical Data in Supabase with Recursive Queries

Oct 1 '25

Beyond Flat Tables: Model Hierarchical Data in Supabase with Recursive Queries

#postgres #database #fullstack #dataengineering

7 min read

Tomislav Maricevic

Aug 28 '25

Configuring PostgreSQL server parameters on GitHub Actions

#postgres #githubactions #cicd

1 min read

Cover image for Optimize Read Performance in Supabase with Postgres Materialized Views

Sep 30 '25

Optimize Read Performance in Supabase with Postgres Materialized Views

#postgres #database #performance #supabase

9 min read

Cover image for Beyond Basic Indexes: Advanced Postgres Indexing for Maximum Supabase Performance

Sep 29 '25

Beyond Basic Indexes: Advanced Postgres Indexing for Maximum Supabase Performance

#supabase #postgressql #postgres

14 min read

Md Mahbubur Rahman

Sep 30 '25

Scaling Node.js Applications to Millions of Users: A Practical Guide

#node #websocket #redis #postgres

4 min read

Sep 29 '25

Automating NASA’s Astronomy Picture of the Day with Airflow

#postgres #dataengineering #tutorial #architecture

6 min read

Cover image for Kotlin, JPA and AUTO_INCREMENT field in DB

Aug 26 '25

Kotlin, JPA and AUTO_INCREMENT field in DB

#kotlin #postgres #hibernate #jpa

2 min read

Amos Augo

Sep 28 '25

Building a Real-Time Binance Data Pipeline with Kafka and PostgreSQL

#kafka #postgres

2 min read

Yorgos S.

Sep 28 '25

sqlx4k — first stable release of a high-performance, non-blocking DB driver for Kotlin Multiplatform

#kotlin #postgres #mysql #sqlite

1 min read

jiil

Sep 26 '25

I Built an E-Commerce Platform in Go + Next.js — And You Can Deploy It in 30 Seconds

#webdev #go #typescript #postgres

2 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.