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.
BetterStructureSql - Clean Database Schema Dumps for Rails (Beta)

BetterStructureSql - Clean Database Schema Dumps for Rails (Beta)

8
Comments
5 min read
DevPill 6 - SQLC: how to scaffold your database code

DevPill 6 - SQLC: how to scaffold your database code

Comments
1 min read
Database ID Design: Choosing ID Methods and Primary Key Strategies

Database ID Design: Choosing ID Methods and Primary Key Strategies

Comments
4 min read
🧱 Lesson 5  - Working with PostgreSQL (Multi-Database Setup)

🧱 Lesson 5  - Working with PostgreSQL (Multi-Database Setup)

Comments
3 min read
Fixing SQL Injection Vulnerabilities to Strengthen Security

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Schema Design with Supabase: Partitioning and Normalization

Schema Design with Supabase: Partitioning and Normalization

Comments
5 min read
Effortless PostgreSQL Environment in Docker For Windows

Effortless PostgreSQL Environment in Docker For Windows

Comments
5 min read
How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

3
Comments
9 min read
Connecting Power BI to PostgreSQL (Aiven & Localhost): A Simple Step-by-Step Guide

Connecting Power BI to PostgreSQL (Aiven & Localhost): A Simple Step-by-Step Guide

Comments
2 min read
Building an AI Code Review Swarm with Gemini & Tiger Cloud Postgres

Building an AI Code Review Swarm with Gemini & Tiger Cloud Postgres

Comments
2 min read
Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs

Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs

2
Comments
3 min read
🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building

🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building

1
Comments 1
4 min read
How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

1
Comments
3 min read
How to load test PostgreSQL database and not miss anything

How to load test PostgreSQL database and not miss anything

3
Comments
14 min read
Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data

Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data

5
Comments 2
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.