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.
pg-status - a lightweight microservice for checking PostgreSQL host status

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

Comments
7 min read
Why Tenant Context Must Be Scoped Per Transaction

Why Tenant Context Must Be Scoped Per Transaction

Comments
4 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
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
Cutting My Self-Hosted Analytics Stack Memory by 45%

Cutting My Self-Hosted Analytics Stack Memory by 45%

6
Comments
2 min read
Using Postgres Full-Text Search on a Next.JS Fullstack App

Using Postgres Full-Text Search on a Next.JS Fullstack App

Comments
5 min read
Running AI on premises with Postgres

Running AI on premises with Postgres

Comments
7 min read
PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

Comments
8 min read
Seeding users in Supabase with a SQL seed script

Seeding users in Supabase with a SQL seed script

Comments
2 min read
PostgreSQL backup and restore — Complete guide to backing up and restoring databases

PostgreSQL backup and restore — Complete guide to backing up and restoring databases

Comments
8 min read
Generate UUID in PostgreSQL

Generate UUID in PostgreSQL

Comments
1 min read
Prisma + StackRender: Design Your Database and Start Building Your Backend

Prisma + StackRender: Design Your Database and Start Building Your Backend

5
Comments
6 min read
UNION in SQL Postgre

UNION in SQL Postgre

Comments
1 min read
Databasus showed an example how to use AI in large open source projects

Databasus showed an example how to use AI in large open source projects

Comments
5 min read
Neon Postgres 2025: Why the New Serverless Features Change Everything

Neon Postgres 2025: Why the New Serverless Features Change Everything

Comments
13 min read
Databasus — open source backup tool for PostgreSQL, MySQL and MongoDB

Databasus — open source backup tool for PostgreSQL, MySQL and MongoDB

Comments
3 min read
PostgreSQL MCP Server with Built-in SSH Tunneling

PostgreSQL MCP Server with Built-in SSH Tunneling

Comments
7 min read
Neon Postgres Deep Dive: Why the 2025 Updates Change Serverless SQL

Neon Postgres Deep Dive: Why the 2025 Updates Change Serverless SQL

Comments
8 min read
Consultas geoespaciais com PostGIS

Consultas geoespaciais com PostGIS

Comments
8 min read
The Silent Truncator: Debugging Django's Vague `DataError`

The Silent Truncator: Debugging Django's Vague `DataError`

Comments
2 min read
loading...