Forem

# 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.
DevPill 6 - SQLC: how to scaffold your database code
Cover image for 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)
Cover image for 🧱 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
Cover image for 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
Cover image for 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
🗄️ 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data
Cover image for Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data

Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data

Comments 1
2 min read
Analyzing psqlrc Settings on GitHub: How PostgreSQL Engineers Configure PostgreSQL
Cover image for Analyzing psqlrc Settings on GitHub: How PostgreSQL Engineers Configure PostgreSQL

Analyzing psqlrc Settings on GitHub: How PostgreSQL Engineers Configure PostgreSQL

4
Comments
17 min read
Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)
Cover image for 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
[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
Setting Up PostgreSQL with Docker Compose for Development and Production
Cover image for Setting Up PostgreSQL with Docker Compose for Development and Production

Setting Up PostgreSQL with Docker Compose for Development and Production

2
Comments
5 min read
How to Create PostgreSQL Backups: A Complete Guide
Cover image for How to Create PostgreSQL Backups: A Complete Guide

How to Create PostgreSQL Backups: A Complete Guide

1
Comments
7 min read
Stop Overcomplicating RAG: Why I Built a "Memory Server" on Postgres (and Open Sourced It)

Stop Overcomplicating RAG: Why I Built a "Memory Server" on Postgres (and Open Sourced It)

Comments
3 min read
PostgreSQL and Node.js

PostgreSQL and Node.js

Comments
1 min read
🐝 How a Simple Supabase RPC Function Cleaned Up My Frontend Logic
Cover image for 🐝 How a Simple Supabase RPC Function Cleaned Up My Frontend Logic

🐝 How a Simple Supabase RPC Function Cleaned Up My Frontend Logic

Comments
2 min read
loading...