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.
10 Common Supabase Security Misconfigurations (and How to Fix Them)

10 Common Supabase Security Misconfigurations (and How to Fix Them)

1
Comments
6 min read
SeaORM 2.0: New Entity Format

SeaORM 2.0: New Entity Format

1
Comments
9 min read
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

2
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

3
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

4
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

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