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.
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
Adding Elastic Read Scaling to Your Supabase Database

Adding Elastic Read Scaling to Your Supabase Database

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
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
The PostgreSQL system architecture

The PostgreSQL system architecture

Comments
1 min read
How to Create PostgreSQL Backups: A Complete Guide

How to Create PostgreSQL Backups: A Complete Guide

1
Comments
7 min read
PostgreSQL and Node.js

PostgreSQL and Node.js

Comments
1 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
🐝 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
How We Achieved Up to 71% Faster Email Search with PostgreSQL Full-Text Search

How We Achieved Up to 71% Faster Email Search with PostgreSQL Full-Text Search

7
Comments
7 min read
When Your Database Became a Library: Guide to PostgreSQL Indexes

When Your Database Became a Library: Guide to PostgreSQL Indexes

Comments
13 min read
Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

1
Comments
6 min read
Building Reproducible n8n Environments with CLI-Based Configuration Management

Building Reproducible n8n Environments with CLI-Based Configuration Management

Comments
6 min read
Como criar e gerenciar seu primeiro banco PostgreSQL na Magalu Cloud

Como criar e gerenciar seu primeiro banco PostgreSQL na Magalu Cloud

5
Comments 1
4 min read
Migrating a Laravel Application From a Relational Database (PostgreSQL) to MongoDB

Migrating a Laravel Application From a Relational Database (PostgreSQL) to MongoDB

2
Comments 1
25 min read
🚀 Leveling Up with Supabase RPC — My “Sell Honey” Transaction Journey

🚀 Leveling Up with Supabase RPC — My “Sell Honey” Transaction Journey

Comments
2 min read
loading...