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 to Generate Test Data for PostgreSQL (2 Methods)

How to Generate Test Data for PostgreSQL (2 Methods)

Comments
3 min read
Which Document class is best to use in Java to read MongoDB documents?

Which Document class is best to use in Java to read MongoDB documents?

Comments
6 min read
Generate PostgreSQL Test Data Without Code (Step-by-Step)

Generate PostgreSQL Test Data Without Code (Step-by-Step)

Comments
3 min read
Architecture Backwards: Engineering a Self-Defending System Before the UI Arrives

Architecture Backwards: Engineering a Self-Defending System Before the UI Arrives

Comments
8 min read
PostgreSQL Docker backup strategies — How to backup PostgreSQL running in Docker containers

PostgreSQL Docker backup strategies — How to backup PostgreSQL running in Docker containers

Comments
10 min read
Importing & Exporting PSQL Database Dump using Docker

Importing & Exporting PSQL Database Dump using Docker

Comments
1 min read
The Silent Database Conflict

The Silent Database Conflict

2
Comments
4 min read
Zero-Friction Database Branching with Neon, Git Hooks, and Claude Code

Zero-Friction Database Branching with Neon, Git Hooks, and Claude Code

Comments
4 min read
Mocking Your Postgres DB Doesn't Have to Suck

Mocking Your Postgres DB Doesn't Have to Suck

Comments
2 min read
Real-Time Leaderboards: How to Boost Fitness Engagement Through Smart Data Architectures

Real-Time Leaderboards: How to Boost Fitness Engagement Through Smart Data Architectures

Comments
2 min read
B2B Wellness Infrastructure: Securing Sensitive Data with Scalable Database Design

B2B Wellness Infrastructure: Securing Sensitive Data with Scalable Database Design

Comments
2 min read
pg-status - a lightweight microservice for checking PostgreSQL host status

pg-status - a lightweight microservice for checking PostgreSQL host status

Comments
7 min read
Deploy TanStack Start + PostgreSQL to Your Own Server with Haloy

Deploy TanStack Start + PostgreSQL to Your Own Server with Haloy

Comments
7 min read
PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman

PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman

Comments
9 min read
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

Comments
5 min read
How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

Comments
3 min read
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

1
Comments
3 min read
Bringing PostgreSQL Triggers(pg_sql_triggers) into the Rails Era

Bringing PostgreSQL Triggers(pg_sql_triggers) into the Rails Era

Comments
2 min read
Building a Catalog GraphQL API with InversifyJS - Part 2: Database Setup with Prisma & Docker

Building a Catalog GraphQL API with InversifyJS - Part 2: Database Setup with Prisma & Docker

Comments
4 min read
MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

Comments
9 min read
Installation Steps for creating Async APIs using FastAPI

Installation Steps for creating Async APIs using FastAPI

Comments
2 min read
Day 2: Tech Stack Decision - Why Kotlin/Spring Boot + React + Postgres

Day 2: Tech Stack Decision - Why Kotlin/Spring Boot + React + Postgres

Comments
5 min read
Running AI on premises with Postgres

Running AI on premises with Postgres

Comments
7 min read
I Replaced Redis with PostgreSQL (And It's Faster)

I Replaced Redis with PostgreSQL (And It's Faster)

20
Comments 4
9 min read
Seeding users in Supabase with a SQL seed script

Seeding users in Supabase with a SQL seed script

Comments
2 min read
loading...