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.
PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB

PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB

Comments
12 min read
Timescale 2025: Scaling Real-Time Analytics in Postgres

Timescale 2025: Scaling Real-Time Analytics in Postgres

Comments
5 min read
Supabase Alternatives 🔄 in 2025 😼

Supabase Alternatives 🔄 in 2025 😼

13
Comments
4 min read
Everything about PostgreSQL

Everything about PostgreSQL

7
Comments 6
15 min read
sqlc: Type-Safe Querying in Go

sqlc: Type-Safe Querying in Go

10
Comments
9 min read
Oracle to PostgreSQL Migration: A Comprehensive Guide

Oracle to PostgreSQL Migration: A Comprehensive Guide

1
Comments 1
3 min read
Create a fullstack Next.js 15 app with Drizzle ORM, Postgresql, Docker

Create a fullstack Next.js 15 app with Drizzle ORM, Postgresql, Docker

Comments
6 min read
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 4

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 4

1
Comments
7 min read
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 1

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 1

3
Comments
8 min read
Navigating PostgreSQL - Query Optimizations

Navigating PostgreSQL - Query Optimizations

1
Comments
9 min read
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 2

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 2

3
Comments
9 min read
Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming 🎮

Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming 🎮

4
Comments
2 min read
Efficient Percentile Ranking in PostgreSQL

Efficient Percentile Ranking in PostgreSQL

6
Comments
2 min read
Navigating PostgreSQL - Join Strategies

Navigating PostgreSQL - Join Strategies

3
Comments
5 min read
Postgresql vs. MongoDB

Postgresql vs. MongoDB

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