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.
Solving the OLTP-OLAP Divide: PostgreSQL B-tree and Hash Indexes for Columnar Data

Solving the OLTP-OLAP Divide: PostgreSQL B-tree and Hash Indexes for Columnar Data

Comments
9 min read
PostgreSQL to MongoDB Migration Made Easy – A Step-by-Step Video Guide!

PostgreSQL to MongoDB Migration Made Easy – A Step-by-Step Video Guide!

11
Comments
1 min read
PgDog: Your New Best Friend for PostgreSQL Management

PgDog: Your New Best Friend for PostgreSQL Management

Comments
3 min read
How to Handle PostgreSQL Cursors in Java: A Practical Guide

How to Handle PostgreSQL Cursors in Java: A Practical Guide

Comments
4 min read
Basics of Animal Tracking Databases: Crafting the Schema

Basics of Animal Tracking Databases: Crafting the Schema

Comments
4 min read
How to run postgres in docker ?

How to run postgres in docker ?

1
Comments
3 min read
🚗 Help Wanted: Admin CMS for Car Listing Platform

🚗 Help Wanted: Admin CMS for Car Listing Platform

Comments
1 min read
Connecting Database with NestJS Using Prisma ORM

Connecting Database with NestJS Using Prisma ORM

1
Comments
5 min read
MongoDB vs. PostgreSQL: Which One is Right for You?

MongoDB vs. PostgreSQL: Which One is Right for You?

Comments
1 min read
Writing an LLM Eval with Vercel's AI SDK and Vitest

Writing an LLM Eval with Vercel's AI SDK and Vitest

10
Comments
4 min read
Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

1
Comments
3 min read
A case where SQL joins struggle but MongoDB documents shine

A case where SQL joins struggle but MongoDB documents shine

Comments
8 min read
Postgres: Index Scans

Postgres: Index Scans

Comments
6 min read
Investigating PostgreSQL's `ANALYZE` Runtime Behavior: Sampling, Table Size, and Cache Effects

Investigating PostgreSQL's `ANALYZE` Runtime Behavior: Sampling, Table Size, and Cache Effects

Comments
5 min read
🚀 Getting Started with Spring Boot and PostgreSQL: A Beginner-Friendly Guide

🚀 Getting Started with Spring Boot and PostgreSQL: A Beginner-Friendly Guide

Comments
2 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

5
Comments
7 min read
Automating PostgreSQL Backups on Kubernetes with CronJobs & Persistent Storage

Automating PostgreSQL Backups on Kubernetes with CronJobs & Persistent Storage

Comments
4 min read
Ways to Optimize PostgreSQL Queries

Ways to Optimize PostgreSQL Queries

Comments
2 min read
pg_dump PostgreSQL Backups: A Quick and Practical Guide

pg_dump PostgreSQL Backups: A Quick and Practical Guide

Comments
2 min read
How Real-Time Analytics in Oil & Gas Prevents Million-Dollar Failures

How Real-Time Analytics in Oil & Gas Prevents Million-Dollar Failures

Comments
6 min read
Introducing Nile Auth for B2B apps

Introducing Nile Auth for B2B apps

5
Comments
7 min read
Optimizing Data Sync from PostgreSQL to Databricks with Fivetran

Optimizing Data Sync from PostgreSQL to Databricks with Fivetran

Comments
4 min read
Authentication and Authorization Microservice with Node.js, Express, PostgreSQL, and 2-Factor : Part 1

Authentication and Authorization Microservice with Node.js, Express, PostgreSQL, and 2-Factor : Part 1

Comments
3 min read
DAY5 OF PSQL Using Join Query

DAY5 OF PSQL Using Join Query

3
Comments
2 min read
Top .NET NuGet Packages for PostgreSQL Database

Top .NET NuGet Packages for PostgreSQL Database

Comments
3 min read
loading...