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.
Database Migration: Safely Managing Dev and Production Environments

Database Migration: Safely Managing Dev and Production Environments

Comments
4 min read
flyway implementation

flyway implementation

Comments
3 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
From Postgres to Iceberg

From Postgres to Iceberg

1
Comments
11 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
🗄️ 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

3
Comments 1
4 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
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
Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server

Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server

Comments
2 min read
Analyzing psqlrc Settings on GitHub: How PostgreSQL Engineers Configure PostgreSQL

Analyzing psqlrc Settings on GitHub: How PostgreSQL Engineers Configure PostgreSQL

2
Comments
17 min read
REMI Superada: evolución tras el Agentic Postgres Challenge

REMI Superada: evolución tras el Agentic Postgres Challenge

Comments 2
1 min read
[MyNextHome] Simple Backend Server (Supabase) with Express JS

[MyNextHome] Simple Backend Server (Supabase) with Express JS

2
Comments
4 min read
Scaling Django with PostgreSQL Partitioning: A Deep Dive

Scaling Django with PostgreSQL Partitioning: A Deep Dive

Comments
5 min read
Local RAG with Go, Ollama, and Postgres (pgvector): a minimal guide

Local RAG with Go, Ollama, and Postgres (pgvector): a minimal guide

2
Comments
2 min read
Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)

Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)

Comments 2
2 min read
REMI Evolved: Beyond the Agentic Postgres Challenge

REMI Evolved: Beyond the Agentic Postgres Challenge

Comments 2
1 min read
loading...