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.
View Cluster Details

View Cluster Details

1
Comments
2 min read
TypeORM + PostgresQL

TypeORM + PostgresQL

2
Comments
2 min read
Managing multiple databases in Docker without having 50 commands saved in Notion

Managing multiple databases in Docker without having 50 commands saved in Notion

3
Comments
2 min read
How to Build Semantic Search in ASP.NET Core using PostgreSQL

How to Build Semantic Search in ASP.NET Core using PostgreSQL

Comments
3 min read
Pods aren’t just containers: deep Kubernetes tricks every DevOps should know

Pods aren’t just containers: deep Kubernetes tricks every DevOps should know

3
Comments
27 min read
Complete Guide: Deploy NestJS API with PostgreSQL on AWS Lightsail

Complete Guide: Deploy NestJS API with PostgreSQL on AWS Lightsail

Comments
5 min read
The Long Hunt for a Dockerized PostgreSQL Connection

The Long Hunt for a Dockerized PostgreSQL Connection

Comments
2 min read
First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance

First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance

Comments
5 min read
YouTube Data Processing Pipeline

YouTube Data Processing Pipeline

1
Comments
4 min read
MySQL Queries

MySQL Queries

Comments
3 min read
The COUNT(DISTINCT) Problem in Postgres (and How HLL Fixes It)

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

Comments
5 min read
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

6
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

15
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

8
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
loading...