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.
Next.js job board dedupe with Postgres upsert

Next.js job board dedupe with Postgres upsert

Comments
6 min read
GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream

GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream

Comments
2 min read
Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

4
Comments
14 min read
How to Build a REST API in Zig (Using Spider Web Framework)

How to Build a REST API in Zig (Using Spider Web Framework)

2
Comments
6 min read
CP Systems Explained: The Hidden Cost of Strong Consistency

CP Systems Explained: The Hidden Cost of Strong Consistency

Comments
16 min read
SaaS Multi-Tenant en Go: Guia Practica de Row-Level Security en PostgreSQL

SaaS Multi-Tenant en Go: Guia Practica de Row-Level Security en PostgreSQL

3
Comments 1
10 min read
How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

7
Comments
4 min read
INSERT Performance Tuning for TimescaleDB

INSERT Performance Tuning for TimescaleDB

2
Comments
4 min read
How does a linter know your column doesn't exist

How does a linter know your column doesn't exist

Comments
4 min read
Connecting Power BI to an SQL Database for Data Analysis: Local & Cloud-Based Connections

Connecting Power BI to an SQL Database for Data Analysis: Local & Cloud-Based Connections

12
Comments
8 min read
Connecting Power BI to SQL Databases: A Comprehensive Guide

Connecting Power BI to SQL Databases: A Comprehensive Guide

2
Comments
9 min read
Turning PostgreSQL Into a Vector Database with Docker

Turning PostgreSQL Into a Vector Database with Docker

2
Comments
1 min read
Update 3: Kamal + Postgres Finally Running

Update 3: Kamal + Postgres Finally Running

Comments
1 min read
PostgreSQL Query Optimization: 10 Techniques That Actually Work

PostgreSQL Query Optimization: 10 Techniques That Actually Work

2
Comments
12 min read
TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

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