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.
Adding Postgres Extensions to Your Database

Adding Postgres Extensions to Your Database

3
Comments
2 min read
Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule

Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule

10
Comments
5 min read
Syncing Prisma Migrations: Aligning Your Schema Drift and Manual SQL Changes in PostgreSQL

Syncing Prisma Migrations: Aligning Your Schema Drift and Manual SQL Changes in PostgreSQL

1
Comments 1
3 min read
Redoed #2: Containerizing the Go Server and PostgreSQL with Docker

Redoed #2: Containerizing the Go Server and PostgreSQL with Docker

1
Comments
4 min read
Simplifying Event Sourcing in Golang

Simplifying Event Sourcing in Golang

Comments
3 min read
Migrating Data from Local SQL Server to AWS RDS PostgreSQL Using AWS DMS - I

Migrating Data from Local SQL Server to AWS RDS PostgreSQL Using AWS DMS - I

5
Comments
3 min read
Why Choose GraphQL? Top Benefits & Examples with PostgreSQL

Why Choose GraphQL? Top Benefits & Examples with PostgreSQL

1
Comments
4 min read
Task 3 - Database

Task 3 - Database

2
Comments
4 min read
Semantic Search With Cohere and PostgreSQL in 10 Minutes

Semantic Search With Cohere and PostgreSQL in 10 Minutes

Comments
7 min read
Vector Search Demystified: A Guide to pgvector, IVFFlat, and HNSW

Vector Search Demystified: A Guide to pgvector, IVFFlat, and HNSW

4
Comments 1
3 min read
How to Postgres indexes review

How to Postgres indexes review

1
Comments
3 min read
Migrating from MySQL to PostgreSQL Key Query Differences and Considerations

Migrating from MySQL to PostgreSQL Key Query Differences and Considerations

Comments
3 min read
Setting up TLS connection for containerized PostgreSQL database

Setting up TLS connection for containerized PostgreSQL database

4
Comments
4 min read
Insert into a jsonb Column in Spring Boot 3 + JPA + PostgreSQL

Insert into a jsonb Column in Spring Boot 3 + JPA + PostgreSQL

3
Comments 1
1 min read
Streaming data from RDBMS with jooq

Streaming data from RDBMS with jooq

Comments
5 min read
Building a CRUD API with ABP Framework, ASP.NET Core, and PostgreSQL

Building a CRUD API with ABP Framework, ASP.NET Core, and PostgreSQL

14
Comments
6 min read
Feature Flag Service: Experimenting with New Technologies and Architectures

Feature Flag Service: Experimenting with New Technologies and Architectures

3
Comments
9 min read
Building High-Performance Apps with Redis, PostgreSQL & Spring Boot

Building High-Performance Apps with Redis, PostgreSQL & Spring Boot

11
Comments 3
15 min read
Setting up TLS connection for containerized PostgreSQL database

Setting up TLS connection for containerized PostgreSQL database

2
Comments
4 min read
How to do Postgres dump specific table with a capital letter in 2025

How to do Postgres dump specific table with a capital letter in 2025

Comments
1 min read
GP2 to GP3 for AWS RDS Postgres

GP2 to GP3 for AWS RDS Postgres

Comments
8 min read
Debugging Complex SQL Queries: A Structured Logging Approach

Debugging Complex SQL Queries: A Structured Logging Approach

Comments 1
3 min read
How to Build and Deploy Full-Stack JavaScript Apps with NextJS, Tailwind, PostgreSQL, and Sevalla⚡👨‍💻

How to Build and Deploy Full-Stack JavaScript Apps with NextJS, Tailwind, PostgreSQL, and Sevalla⚡👨‍💻

47
Comments 13
21 min read
PostgreSql Tasks

PostgreSql Tasks

Comments
4 min read
8 Reasons Postgres for IoT just makes sense

8 Reasons Postgres for IoT just makes sense

1
Comments
5 min read
loading...