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.
Horizontally Scaling PostgreSQL with YugabyteDB: The Problem, the Fix, and a Three-Node Demo

Horizontally Scaling PostgreSQL with YugabyteDB: The Problem, the Fix, and a Three-Node Demo

Comments
7 min read
Saved to Postgres, never queued: the transactional outbox for Node

Saved to Postgres, never queued: the transactional outbox for Node

Comments 2
6 min read
I built a support copilot for one-person shops that runs Gemma 4 on a laptop

Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle Submission đź’¸

I built a support copilot for one-person shops that runs Gemma 4 on a laptop

Comments
4 min read
Building a Job Portal Backend: From Database Design to Deployment

Building a Job Portal Backend: From Database Design to Deployment

Comments
26 min read
Introducing BioseqDB

Introducing BioseqDB

1
Comments
4 min read
3.9 million PostgreSQL services and the pg_hba line that decides everything

3.9 million PostgreSQL services and the pg_hba line that decides everything

Comments
3 min read
PostgreSQL: UUIDv4 vs UUIDv7

PostgreSQL: UUIDv4 vs UUIDv7

Comments
3 min read
Business Process Automation in Node.js and Postgres: Approval Flows

Business Process Automation in Node.js and Postgres: Approval Flows

Comments
6 min read
🔎 Building IncidentCopilot: Designing a Deterministic Log Correlation Engine

🔎 Building IncidentCopilot: Designing a Deterministic Log Correlation Engine

Comments
2 min read
Supabase maybeSingle() PGRST116: Multiple Rows Returned

Supabase maybeSingle() PGRST116: Multiple Rows Returned

Comments 1
3 min read
Comparing butterfly genomes with BioseqDB, SQLAlchemy and Plotly

Comparing butterfly genomes with BioseqDB, SQLAlchemy and Plotly

Comments
22 min read
GROUP BY, HAVING, and Subqueries in PostgreSQL

GROUP BY, HAVING, and Subqueries in PostgreSQL

Comments
5 min read
My database was too small for my search

My database was too small for my search

1
Comments
7 min read
Introduction to Databases and SQL with PostgreSQL: Window Functions, Joins, CTEs and Subqueries on a simple Hospital Database.

Introduction to Databases and SQL with PostgreSQL: Window Functions, Joins, CTEs and Subqueries on a simple Hospital Database.

Comments
30 min read
why pg‑bouncer can still choke your service under burst load

why pg‑bouncer can still choke your service under burst load

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.