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.
Schrödinger’s Backups: A Lesson in Uncertainty

Schrödinger’s Backups: A Lesson in Uncertainty

1
Comments
5 min read
Technical Interview - Boilerplate 1 - Node + Typescript + PostgreSQL

Technical Interview - Boilerplate 1 - Node + Typescript + PostgreSQL

6
Comments 1
9 min read
⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

10
Comments
10 min read
🌐 Golang RESTful API with Gin, Gorm, PostgreSQL 🐘

🌐 Golang RESTful API with Gin, Gorm, PostgreSQL 🐘

30
Comments 5
15 min read
Database Setup, JWT Implementation & API

Database Setup, JWT Implementation & API

4
Comments
9 min read
LAPONG DOCKER

LAPONG DOCKER

Comments
1 min read
SQL-92 in TPC Benchmarks: Are They Still Relevant?

SQL-92 in TPC Benchmarks: Are They Still Relevant?

8
Comments
10 min read
Creating a global production ready marketplace with Medusa JS

Creating a global production ready marketplace with Medusa JS

7
Comments
5 min read
🧪 Golang Integration Test With Gin, Gorm, Testify, PostgreSQL

🧪 Golang Integration Test With Gin, Gorm, Testify, PostgreSQL

8
Comments
9 min read
FastAPI, Pydantic, Psycopg3: The Ultimate Trio for Python Web APIs

FastAPI, Pydantic, Psycopg3: The Ultimate Trio for Python Web APIs

8
Comments
9 min read
Exposing replica nodes in Percona Operator for PostgreSQL

Exposing replica nodes in Percona Operator for PostgreSQL

6
Comments
2 min read
Building an API with Go, PostgreSQL, Google Cloud and CockroachDB

Building an API with Go, PostgreSQL, Google Cloud and CockroachDB

1
Comments
13 min read
Building a PostgreSQL Library in D

Building a PostgreSQL Library in D

1
Comments
12 min read
PostgreSQL as a Celery Broker

PostgreSQL as a Celery Broker

4
Comments 2
1 min read
📝 30 Common PostgreSQL Interview Questions 🐘

📝 30 Common PostgreSQL Interview Questions 🐘

2
Comments
7 min read
Example That Covers Many Common Features Of PostgreSQL

Example That Covers Many Common Features Of PostgreSQL

Comments
4 min read
Strange PostgreSQL query planner behavior in subqueries

Strange PostgreSQL query planner behavior in subqueries

Comments
11 min read
Load Testing PostgreSQL on Kubernetes: A YAML-Only Approach

Load Testing PostgreSQL on Kubernetes: A YAML-Only Approach

2
Comments
3 min read
Building a Fast and Efficient Semantic Search System Using OpenVINO and Postgres

Building a Fast and Efficient Semantic Search System Using OpenVINO and Postgres

6
Comments
5 min read
Indexing for a Scalable Serialization Isolation Level

Indexing for a Scalable Serialization Isolation Level

4
Comments 2
5 min read
Streamlining Your Rails 8 App: Migrating from Postgres to SQLite

Streamlining Your Rails 8 App: Migrating from Postgres to SQLite

10
Comments 3
6 min read
Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

2
Comments 1
4 min read
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

3
Comments 3
7 min read
How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data

How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data

1
Comments
5 min read
Choose the Best Database Management Tool for PostgreSQL in 2025

Choose the Best Database Management Tool for PostgreSQL in 2025

10
Comments 4
12 min read
loading...