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
No More Hardcoded Secrets: Automatic Database Credential Rotation with Vault, AKS and Postgres🔐

No More Hardcoded Secrets: Automatic Database Credential Rotation with Vault, AKS and Postgres🔐

Comments
7 min read
PSQL COMMAND DAY 2

PSQL COMMAND DAY 2

Comments
1 min read
Day 38 - Primary key, Foreign key in Database, Types of SQL Languages

Day 38 - Primary key, Foreign key in Database, Types of SQL Languages

Comments
6 min read
Supercharge Read Performance: 397x Faster Database Queries Through Denormalization

Supercharge Read Performance: 397x Faster Database Queries Through Denormalization

1
Comments 1
2 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 😼

11
Comments
4 min read
Everything about PostgreSQL

Everything about PostgreSQL

7
Comments 6
15 min read
TypeORM Eager - Don't fall for it

TypeORM Eager - Don't fall for it

Comments
2 min read
MySQL vs. PostgreSQL: A Deep Dive to Find Out Which is Best

MySQL vs. PostgreSQL: A Deep Dive to Find Out Which is Best

1
Comments
1 min read
Solving Permission Issues with PostgreSQL and Docker Compose on macOS Using Colima

Solving Permission Issues with PostgreSQL and Docker Compose on macOS Using Colima

Comments
3 min read
sqlc: Type-Safe Querying in Go

sqlc: Type-Safe Querying in Go

9
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
Creating a todo app with JDBC

Creating a todo app with JDBC

Comments
7 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
Navigating PostgreSQL - Join Strategies

Navigating PostgreSQL - Join Strategies

3
Comments
5 min read
Efficient Percentile Ranking in PostgreSQL

Efficient Percentile Ranking in PostgreSQL

6
Comments
2 min read
We don't need DynamoDB when we have Aurora Postgres

We don't need DynamoDB when we have Aurora Postgres

1
Comments
2 min read
SQL Interview questions and answers

SQL Interview questions and answers

Comments 1
3 min read
Task : Database

Task : Database

1
Comments
2 min read
loading...