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.
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL
franckpachot profile

Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

#mongodb #postgres #oracle #denormalization
1
Comments
9 min read
Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.
opeyemi_oluwagbemiga_a213 profile

Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

#database #systemdesign #postgres
2
Comments
2 min read
How to Connect PostgreSQL to Google Apps Script (JDBC Guide)
jpoehnelt profile

How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

#postgres #google #googleworkspace #appsscript
Comments
15 min read
PostgreSQL global statistics on partitionned table require a manual ANALYZE
franckpachot profile

PostgreSQL global statistics on partitionned table require a manual ANALYZE

#postgres #sql #database #partitioning
6
Comments
8 min read
Implementing pagination with PostgreSQL and the MantaHQ SDK
mantahq profile

Implementing pagination with PostgreSQL and the MantaHQ SDK

#postgres #react #pagination #webdev
4
Comments
5 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely
mickelsamuel profile

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend
3
Comments
5 min read
One Database Per Branch — Stop Breaking Your Local DB
bijomathewjose profile

One Database Per Branch — Stop Breaking Your Local DB

#postgres #backend #productivity #agents
Comments
1 min read
PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL
philip_mcclarence_2ef9475 profile

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql
1
Comments
12 min read
pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations
defnotwig profile

pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

#postgres #node #typescript #database
5
Comments
3 min read
PostgreSQL connection pooling — PgBouncer vs Pgpool-II compared in 5 key areas
dave-anisimov profile
Dave

PostgreSQL connection pooling — PgBouncer vs Pgpool-II compared in 5 key areas

#database #postgres
1
Comments
9 min read
7 PostgreSQL monitoring tools every DBA should know in 2026
dave-anisimov profile
Dave

7 PostgreSQL monitoring tools every DBA should know in 2026

#database #postgres
Comments
7 min read
Aurora DSQL: The Serverless PostgreSQL That Scales to Zero (Should You Migrate?)
dineshelumalai profile

Aurora DSQL: The Serverless PostgreSQL That Scales to Zero (Should You Migrate?)

#aws #database #postgres #serverless
4
Comments
8 min read
🐳 Fixing “FATAL: database does not exist” in PostgreSQL Docker (Healthcheck Mistake)
frio_16 profile

🐳 Fixing “FATAL: database does not exist” in PostgreSQL Docker (Healthcheck Mistake)

#docker #postgres #dotnet #api
Comments
2 min read
Why I don't trust AI with my query plans
ash_mse profile

Why I don't trust AI with my query plans

#postgres #database #performance #sql
Comments
2 min read
From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform
freelancingsolutions profile

From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

#postgres #database #performance #optimization
Comments
9 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.