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.
PostgreSQL Data Types: An Essential Guide

PostgreSQL Data Types: An Essential Guide

Comments
1 min read
Day 1: Getting Started with PSQL: The Powerful SQL DataBase.

Day 1: Getting Started with PSQL: The Powerful SQL DataBase.

Comments
3 min read
Optimizing UPDATE of millions of rows easily

Optimizing UPDATE of millions of rows easily

2
Comments
5 min read
Text-to-SQL: A Developer’s Zero-to-Hero Guide

Text-to-SQL: A Developer’s Zero-to-Hero Guide

6
Comments
9 min read
A PostgreSQL Database Replication Guide

A PostgreSQL Database Replication Guide

3
Comments 2
8 min read
🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

11
Comments 2
2 min read
Multitenant app with dedicated databases for each tenant on Azure

Multitenant app with dedicated databases for each tenant on Azure

6
Comments 2
7 min read
PostgreSQL vs MySQL vs Redis: Choose Your Fighter

PostgreSQL vs MySQL vs Redis: Choose Your Fighter

7
Comments
47 min read
Build and Deploy a Full Backend API with Next.js, Drizzle ORM and Neon (PostgreSQL) | Todofy App

Build and Deploy a Full Backend API with Next.js, Drizzle ORM and Neon (PostgreSQL) | Todofy App

4
Comments 3
1 min read
Your Entire Tech Stack Could Be Postgres and a Docker Container

Your Entire Tech Stack Could Be Postgres and a Docker Container

21
Comments 1
4 min read
Postgresql soft-delete strategies: balancing data retention

Postgresql soft-delete strategies: balancing data retention

Comments
3 min read
Who Writes Faster: Mongo or Postgres? I Ran a 1M Record Experiment to Find Out

Who Writes Faster: Mongo or Postgres? I Ran a 1M Record Experiment to Find Out

1
Comments
3 min read
Automating Neon schema deployments with Prisma and GitLab

Automating Neon schema deployments with Prisma and GitLab

Comments
3 min read
Indexing in PostgreSQL: Pros, Cons, and Best Practices

Indexing in PostgreSQL: Pros, Cons, and Best Practices

2
Comments
3 min read
Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL

Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL

2
Comments
2 min read
Mastering Database Consistency: Unlocking the 'C' in ACID with PostgreSQL

Mastering Database Consistency: Unlocking the 'C' in ACID with PostgreSQL

5
Comments
5 min read
🚀 Introducing Pblog – A Dockerized TUI Blogging App

🚀 Introducing Pblog – A Dockerized TUI Blogging App

Comments
3 min read
🐍 PostgreSQL + Python = Absolute Power: Meet PL/Python

🐍 PostgreSQL + Python = Absolute Power: Meet PL/Python

Comments
1 min read
Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

1
Comments
5 min read
How Timescale Solves Real-Time Analytics in Postgres

How Timescale Solves Real-Time Analytics in Postgres

Comments
5 min read
NestJS: Construindo o Módulo de Usuário — Parte 1: Salvando no banco

NestJS: Construindo o Módulo de Usuário — Parte 1: Salvando no banco

2
Comments
12 min read
Postgres Is All You Need

Postgres Is All You Need

94
Comments 9
4 min read
Postgresql vs. MongoDB

Postgresql vs. MongoDB

1
Comments
2 min read
PostgreSQL JSONB Indexing Limitations with B-Tree and GIN

PostgreSQL JSONB Indexing Limitations with B-Tree and GIN

17
Comments 2
8 min read
Getting Started with SQL DISTINCT

Getting Started with SQL DISTINCT

Comments
2 min read
loading...