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.
Why the Market is Flooded with New Databases And Why It Shouldn’t Be

Why the Market is Flooded with New Databases And Why It Shouldn’t Be

Comments
5 min read
Speed Up Triggers by 7x With Transition Tables

Speed Up Triggers by 7x With Transition Tables

Comments
5 min read
Postgres Query Sorting Traps

Postgres Query Sorting Traps

Comments
2 min read
Introducing EasyREST

Introducing EasyREST

4
Comments
5 min read
Setting Up PostgreSQL Replication with Docker

Setting Up PostgreSQL Replication with Docker

2
Comments
2 min read
MongoDB equivalent for PostgreSQL JSONB operations

MongoDB equivalent for PostgreSQL JSONB operations

5
Comments
12 min read
Task 2 : Database

Task 2 : Database

Comments
2 min read
5 Ways Timescale Cloud Accelerates Software Development

5 Ways Timescale Cloud Accelerates Software Development

1
Comments
2 min read
You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day

You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day

Comments
5 min read
How to Build a Full-Stack Web App with Next.js, Prisma, and PostgreSQL

How to Build a Full-Stack Web App with Next.js, Prisma, and PostgreSQL

Comments
3 min read
Debugging PostgreSQL with GDB + Visual Studio Code

Debugging PostgreSQL with GDB + Visual Studio Code

1
Comments
4 min read
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
SQL

SQL

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

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