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.
How I got into open source in 2025 (with a PostgreSQL backup tool) after almost losing a ~$1,500/mo project in 2023
rostislav_dugin profile

How I got into open source in 2025 (with a PostgreSQL backup tool) after almost losing a ~$1,500/mo project in 2023

#webdev #opensource #postgres #programming
1
Comments 2
6 min read
The Developer's Guide to Never Messing Up Time Zones Again: A TypeScript, Drizzle, and PostgreSQL Journey
jacksonkasi profile

The Developer's Guide to Never Messing Up Time Zones Again: A TypeScript, Drizzle, and PostgreSQL Journey

#typescript #drizzle #postgres #timezones
7
Comments 4
10 min read
Dump and Sync PostgreSQL Schema with Python (No Data, No BS)
lovestaco profile

Dump and Sync PostgreSQL Schema with Python (No Data, No BS)

#webdev #programming #postgres
26
Comments 4
2 min read
How we built a real-time service that handles 20,000 updates per second
samejr profile

How we built a real-time service that handles 20,000 updates per second

#webdev #programming #tutorial #postgres
24
Comments
6 min read
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast
franckpachot profile

Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

#mongodb #database #postgres #edge
2
Comments 1
14 min read
Automating AlloyDB starts and stops
gleb_otochkin profile

Automating AlloyDB starts and stops

#automation #postgres #data #alloydb
Comments
10 min read
Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL
djamware_tutorial_eba1a61 profile

Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

#nextjs #prisma #postgres #fullstack
Comments
1 min read
Top Free ER Diagram Tools for PostgreSQL in 2025
roxana_haidiner profile

Top Free ER Diagram Tools for PostgreSQL in 2025

#postgres #postgressql #sql #database
11
Comments 1
7 min read
Understanding the PostgreSQL Crosstab Function
altesack profile

Understanding the PostgreSQL Crosstab Function

#postgres #database
3
Comments
4 min read
From JSONL to a normalized relational database. Is a tool necessary?
ketoman profile

From JSONL to a normalized relational database. Is a tool necessary?

#json #database #xml #postgres
5
Comments 4
2 min read
How I Analyzed Retail Sales Data Using SQL
akansrodger profile

How I Analyzed Retail Sales Data Using SQL

#sql #postgres #portfolio #learning
Comments
2 min read
Create ER Diagrams for PostgreSQL with a Free Design Tool
roxana_haidiner profile

Create ER Diagrams for PostgreSQL with a Free Design Tool

#postgres #postgressql #sql #erd
11
Comments 1
5 min read
The Cartesian Product Trap in Django ORM
pomidoroshev profile

The Cartesian Product Trap in Django ORM

#python #django #sql #postgres
1
Comments 2
3 min read
Fun with Postgres Recovery
misachi profile

Fun with Postgres Recovery

#postgres #recovery
1
Comments
9 min read
How I Cut My Local Development Setup Time by 95% Using Makefile
renubhati profile

How I Cut My Local Development Setup Time by 95% Using Makefile

#go #webdev #productivity #postgres
1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.