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.
Embedding AI Inside PostgreSQL : Building a Native C++ Extension.

Embedding AI Inside PostgreSQL : Building a Native C++ Extension.

8
Comments 1
3 min read
Hotel Booking: Schema Design Comparison

Hotel Booking: Schema Design Comparison

Comments
25 min read
Locks

Locks

Comments
4 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
REMI Evolved: Beyond the Agentic Postgres Challenge

REMI Evolved: Beyond the Agentic Postgres Challenge

Comments 2
1 min read
Optimizing Connection Pools with PrismaClient Singleton Pattern in Next.js

Optimizing Connection Pools with PrismaClient Singleton Pattern in Next.js

Comments
10 min read
N+1 query in databases

N+1 query in databases

1
Comments 1
3 min read
How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven.

How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven.

Comments
3 min read
🚀 Supabase Connection Scaling: The Essential Guide for FastAPI Developers

🚀 Supabase Connection Scaling: The Essential Guide for FastAPI Developers

Comments
3 min read
Step-by-Step: Implementing Custom Decorators in NestJs Using Class-Validator and Drizzle

Step-by-Step: Implementing Custom Decorators in NestJs Using Class-Validator and Drizzle

1
Comments 1
7 min read
Connecting Power BI to PostgreSQL (Localhost & Aiven Cloud)

Connecting Power BI to PostgreSQL (Localhost & Aiven Cloud)

Comments
4 min read
Think. Update. Automate — PostgreSQL with Rust (Part 2)

Think. Update. Automate — PostgreSQL with Rust (Part 2)

Comments
1 min read
🚀 ทำความเข้าใจ Row-Level Security (RLS) ใน PostgreSQL แบบง่ายที่สุด

🚀 ทำความเข้าใจ Row-Level Security (RLS) ใน PostgreSQL แบบง่ายที่สุด

Comments
1 min read
🧠 "The Pool is Full": A Deep Dive on a Knex.js Bug That Wasn't a Database Problem

🧠 "The Pool is Full": A Deep Dive on a Knex.js Bug That Wasn't a Database Problem

Comments
5 min read
Introducing Developer Tier for Aiven for PostgreSQL® services

Introducing Developer Tier for Aiven for PostgreSQL® services

Comments
4 min read
From Legacy Windows to AI Agent: The Journey of MintBridge to REMI (Final PoC)

From Legacy Windows to AI Agent: The Journey of MintBridge to REMI (Final PoC)

Comments
2 min read
Prepared Statements in PgJDBC

Prepared Statements in PgJDBC

Comments
6 min read
What makes PostgreSQL different from MongoDB, beyond "SQL vs NoSQL"?

What makes PostgreSQL different from MongoDB, beyond "SQL vs NoSQL"?

1
Comments
2 min read
🚀 Unleash Performance: A Deep Dive into Django's Asynchronous ORM Queries

🚀 Unleash Performance: A Deep Dive into Django's Asynchronous ORM Queries

1
Comments
10 min read
Writes, 3 ways: Postgres, Apache Kafka® and Apache Iceberg™

Writes, 3 ways: Postgres, Apache Kafka® and Apache Iceberg™

1
Comments
10 min read
REMI–TIGRA: Patrimonio Agentic Postgres

Agentic Postgres Challenge Submission

REMI–TIGRA: Patrimonio Agentic Postgres

Comments
1 min read
Monthly Partitioning and Automatic Rotation of Tables in PostgreSQL (AWS RDS)

Monthly Partitioning and Automatic Rotation of Tables in PostgreSQL (AWS RDS)

Comments
3 min read
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
Wednesday Links - Edition 2025-11-05

Wednesday Links - Edition 2025-11-05

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