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.
Connecting Power BI to PostgreSQL Database

Connecting Power BI to PostgreSQL Database

4
Comments
7 min read
PostgreSQL vs. MongoDB for JSON: The Internal Trade-offs They Don't Tell You in the Docs

PostgreSQL vs. MongoDB for JSON: The Internal Trade-offs They Don't Tell You in the Docs

5
Comments 2
7 min read
Building a Pure Go PostgreSQL SQL Parser (No CGO, No Server, No Runtime Dependencies)

Building a Pure Go PostgreSQL SQL Parser (No CGO, No Server, No Runtime Dependencies)

Comments
2 min read
PostgreSQL: First Approach to Vector Databases with pgvector and Python

PostgreSQL: First Approach to Vector Databases with pgvector and Python

2
Comments
6 min read
Building Semantic Search with Spring Boot, PostgreSQL, and pgvector (RAG Retrieval)

Building Semantic Search with Spring Boot, PostgreSQL, and pgvector (RAG Retrieval)

1
Comments
5 min read
Best PostgreSQL IDE and GUI Tools in 2026

Best PostgreSQL IDE and GUI Tools in 2026

2
Comments
14 min read
Dissecting PostgreSQL — Why Being Read-Optimized Comes at the Cost of Write Speed

Dissecting PostgreSQL — Why Being Read-Optimized Comes at the Cost of Write Speed

5
Comments
8 min read
Building a "Backend-less" Blog Site : My Journey with Coffee Chronicle

Building a "Backend-less" Blog Site : My Journey with Coffee Chronicle

Comments
3 min read
The 4-slot hook pipeline: how every CRUD operation feeds four systems at once"

The 4-slot hook pipeline: how every CRUD operation feeds four systems at once"

2
Comments
7 min read
How to Connect Power BI to a PostgreSQL Database (Localhost and Aiven Cloud)

How to Connect Power BI to a PostgreSQL Database (Localhost and Aiven Cloud)

5
Comments
3 min read
Connecting Power BI to a SQL Database

Connecting Power BI to a SQL Database

6
Comments 1
5 min read
Refresh Your Neon Cloud Database from Local Postgres (Without the Data API)

Refresh Your Neon Cloud Database from Local Postgres (Without the Data API)

Comments
2 min read
PostgreSQL Backups and Point-in-Time Recovery with pgBackRest

PostgreSQL Backups and Point-in-Time Recovery with pgBackRest

4
Comments
4 min read
Talk to Your Data: Analyze Data in AlloyDB Using Natural Language

Talk to Your Data: Analyze Data in AlloyDB Using Natural Language

Comments
7 min read
137 migrations and counting: building a personal OS schema from scratch

137 migrations and counting: building a personal OS schema from scratch

2
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.