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.
Local Development, Remote Data: Accessing Fly.io PostgreSQL from Your Java API

Local Development, Remote Data: Accessing Fly.io PostgreSQL from Your Java API

Comments
4 min read
Advanced Integration: Connecting PostgreSQL with Node.js in a TypeScript Ecosystem

Advanced Integration: Connecting PostgreSQL with Node.js in a TypeScript Ecosystem

5
Comments
4 min read
A Developers Guide to PostgreSQL Extensions

A Developers Guide to PostgreSQL Extensions

5
Comments
2 min read
8 Postgres Extensions You Need to Know

8 Postgres Extensions You Need to Know

7
Comments
6 min read
How to build a secure project management platform with Next.js, Clerk, and Neon

How to build a secure project management platform with Next.js, Clerk, and Neon

1
Comments
28 min read
Adding Postgres Extensions to Your Database

Adding Postgres Extensions to Your Database

3
Comments
2 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
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

9
Comments
5 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
loading...