DEV Community

# 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.
Stop Spaghetti SQL: Simplify Complex Queries with Postgres CTEs in Supabase

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

2
Comments
16 min read
Skip Elasticsearch: Build Blazing-Fast Full-Text Search Right in Supabase

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

2
Comments
11 min read
🚨 Fix Airflow 2.8.0 LocalExecutor Crashes on macOS: 3 Essential Solutions (2025)

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

1
Comments
4 min read
Beyond Flat Tables: Model Hierarchical Data in Supabase with Recursive Queries

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

2
Comments
7 min read
How to Install PostgreSQL 18 on Ubuntu 24.04

How to Install PostgreSQL 18 on Ubuntu 24.04

5
Comments 2
5 min read
Configuring PostgreSQL server parameters on GitHub Actions

Configuring PostgreSQL server parameters on GitHub Actions

Comments
1 min read
Optimize Read Performance in Supabase with Postgres Materialized Views

Optimize Read Performance in Supabase with Postgres Materialized Views

8
Comments
9 min read
Beyond Basic Indexes: Advanced Postgres Indexing for Maximum Supabase Performance

Beyond Basic Indexes: Advanced Postgres Indexing for Maximum Supabase Performance

14
Comments 1
14 min read
Scaling Node.js Applications to Millions of Users: A Practical Guide

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

7
Comments 2
4 min read
Kotlin, JPA and AUTO_INCREMENT field in DB

Kotlin, JPA and AUTO_INCREMENT field in DB

Comments
2 min read
Building a Real-Time Binance Data Pipeline with Kafka and PostgreSQL

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

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

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

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

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

Comments
2 min read
Cracking the MERN Interview: React 19, Next.js 15, Supabase, PostgreSQL & Design Patterns Cheat Sheet

Cracking the MERN Interview: React 19, Next.js 15, Supabase, PostgreSQL & Design Patterns Cheat Sheet

1
Comments 1
3 min read
The Power of Postgres Arrays in Your Supabase Projects

The Power of Postgres Arrays in Your Supabase Projects

7
Comments
12 min read
From Idea to Deployment with FastAPI and Postgres

From Idea to Deployment with FastAPI and Postgres

Comments
3 min read
Lock Down Your Data: Implement Row-Level Security Policies in Supabase SQL

Lock Down Your Data: Implement Row-Level Security Policies in Supabase SQL

8
Comments
13 min read
PostgreSQL Bukan Satu-satunya: 5 Database Lain yang Perlu Kamu Tau!

PostgreSQL Bukan Satu-satunya: 5 Database Lain yang Perlu Kamu Tau!

Comments
3 min read
SQL GROUP BY Explained with Examples

SQL GROUP BY Explained with Examples

6
Comments
4 min read
🔥 How I Replaced My Entire Backend With Supabase in 3 Hours — Real Talk, Real Code

🔥 How I Replaced My Entire Backend With Supabase in 3 Hours — Real Talk, Real Code

1
Comments 2
4 min read
How to Configure BigAnimal

How to Configure BigAnimal

Comments
1 min read
What is BigAnimal in PostgreSQL

What is BigAnimal in PostgreSQL

Comments
2 min read
PostgreSQL: Delete database and user

PostgreSQL: Delete database and user

Comments
1 min read
Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Comments 1
8 min read
PostgreSQL: Create database with custom owner

PostgreSQL: Create database with custom owner

Comments
1 min read
loading...