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.
Particionamiento mensual y rotación automática de tablas en PostgreSQL (AWS RDS)

Particionamiento mensual y rotación automática de tablas en PostgreSQL (AWS RDS)

Comments
3 min read
Smart Search in PostgreSQL: How to Perform Fast and Accurate Searches with Full-Text Search and GIN Indexing

Smart Search in PostgreSQL: How to Perform Fast and Accurate Searches with Full-Text Search and GIN Indexing

7
Comments 5
4 min read
How simultaneously swapping unique IDs in Postgres

How simultaneously swapping unique IDs in Postgres

4
Comments
2 min read
Level 3: Building the Database Foundation with Rust + PostgreSQL

Level 3: Building the Database Foundation with Rust + PostgreSQL

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

4
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
loading...