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.
Aurora DSQL: How it Compares to YugabyteDB

Aurora DSQL: How it Compares to YugabyteDB

4
Comments
9 min read
Integrating Locally running Postgres with Claude Desktop

Integrating Locally running Postgres with Claude Desktop

25
Comments
3 min read
How to Transfer PostgreSQL Database from Local to Supabase on macOS

How to Transfer PostgreSQL Database from Local to Supabase on macOS

3
Comments
2 min read
How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL

How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL

Comments
16 min read
Document data modeling to avoid write skew anomalies

Document data modeling to avoid write skew anomalies

19
Comments 5
4 min read
Optimizing Query Performance in Django with PostgreSQL: A Case Study

Optimizing Query Performance in Django with PostgreSQL: A Case Study

3
Comments
4 min read
SQL index types B TREE, HASH, GIST, GIST, BRIN, and GIN

SQL index types B TREE, HASH, GIST, GIST, BRIN, and GIN

1
Comments
2 min read
When to replace IN() with EXISTS() - correlated and uncorrelated subqueries

When to replace IN() with EXISTS() - correlated and uncorrelated subqueries

6
Comments
8 min read
Setting Up Drizzle & Postgres with tRPC and Next.js App

Setting Up Drizzle & Postgres with tRPC and Next.js App

3
Comments 1
6 min read
Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

11
Comments
7 min read
Master Authentication with Auth.js, Next.js, and PostgreSQL: A Comprehensive Guide

Master Authentication with Auth.js, Next.js, and PostgreSQL: A Comprehensive Guide

4
Comments
2 min read
How To Use Materialized Views

How To Use Materialized Views

2
Comments
5 min read
"Тайны Pawsgresville: Дело об исчезнувших данных". Идексы Postgres.

"Тайны Pawsgresville: Дело об исчезнувших данных". Идексы Postgres.

6
Comments
2 min read
Reading Parallel Plans Correctly

Reading Parallel Plans Correctly

Comments
5 min read
Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

2
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.