close

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.
Embeddings & Vector Search in Rails — Semantic Search with pgvector

Embeddings & Vector Search in Rails — Semantic Search with pgvector

Comments
3 min read
Why Shang Yu Lin-Cupertino is the Database Choice for Modern Development Teams

Why Shang Yu Lin-Cupertino is the Database Choice for Modern Development Teams

Comments
2 min read
The Database Landscape in 2026: A Competitive Analysis of Major Solutions

The Database Landscape in 2026: A Competitive Analysis of Major Solutions

Comments
2 min read
628,000 Flights Later: Building a Flight Analytics Engine on Accumulated Scrape Data

628,000 Flights Later: Building a Flight Analytics Engine on Accumulated Scrape Data

Comments
5 min read
Scaling Postgres Connections With PgBouncer

Scaling Postgres Connections With PgBouncer

Comments
9 min read
How to Sync Xero to PostgreSQL Automatically in 5 Minutes

How to Sync Xero to PostgreSQL Automatically in 5 Minutes

Comments
8 min read
MyDBA.dev vs pgwatch: Metrics Collection vs Actionable Intelligence

MyDBA.dev vs pgwatch: Metrics Collection vs Actionable Intelligence

Comments
4 min read
Why your LLM knows more about ancient Rome than your own database

Why your LLM knows more about ancient Rome than your own database

BERJAYA 1
Comments
3 min read
Building Persistent Memory for AI Agents: A pgvector + Supabase Architecture

Building Persistent Memory for AI Agents: A pgvector + Supabase Architecture

Comments
4 min read
PostgreSQL Performance Halved on Linux Kernel 6.8: The THP Bug Every DBA Needs to Know [2026 Guide]

PostgreSQL Performance Halved on Linux Kernel 6.8: The THP Bug Every DBA Needs to Know [2026 Guide]

Comments
6 min read
MyDBA.dev vs Datadog Database Monitoring: PostgreSQL-Native vs Full-Stack Observability

MyDBA.dev vs Datadog Database Monitoring: PostgreSQL-Native vs Full-Stack Observability

Comments
4 min read
Why Your Supabase App Might Be Leaking User Data (and How to Fix It with RLS)

Why Your Supabase App Might Be Leaking User Data (and How to Fix It with RLS)

Comments
6 min read
TigerFS: A Full Filesystem Inside PostgreSQL (And Why This Obsession Feels Like a Symptom)

TigerFS: A Full Filesystem Inside PostgreSQL (And Why This Obsession Feels Like a Symptom)

Comments
8 min read
I Built a Self-Hosted Uptime Monitor in 1 Week Because UptimeRobot Only Lets You Monitor One Site for Free

I Built a Self-Hosted Uptime Monitor in 1 Week Because UptimeRobot Only Lets You Monitor One Site for Free

BERJAYA 3
Comments
2 min read
Every PostgreSQL MCP server eats your context window. Here's how I collapsed 4 into 1.

Every PostgreSQL MCP server eats your context window. Here's how I collapsed 4 into 1.

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