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.
Most popular PostgreSQL GUIs in 2022: the (almost) scientific list

Most popular PostgreSQL GUIs in 2022: the (almost) scientific list

Reactions 11 Comments
7 min read
How to Connect Strapi to PostgreSQL

How to Connect Strapi to PostgreSQL

Reactions 4 Comments
18 min read
Getting Started with PostGIS on Postgres App

Getting Started with PostGIS on Postgres App

Reactions 4 Comments
2 min read
Build a real-time chat application with Nestjs and PostgreSQL

Build a real-time chat application with Nestjs and PostgreSQL

Reactions 10 Comments 1
8 min read
Postgres: Setup & Basics

Postgres: Setup & Basics

Reactions 5 Comments 2
3 min read
Migrating from Heroku to Render

Migrating from Heroku to Render

Reactions 18 Comments
5 min read
Database indexing in a nutshell with B+tree and Hash in comparison

Database indexing in a nutshell with B+tree and Hash in comparison

Reactions 5 Comments
4 min read
Kesalahan menggunakan pattern matching not like any di PostgreSQL

Kesalahan menggunakan pattern matching not like any di PostgreSQL

Reactions 7 Comments
1 min read
CREATE A TABLE ON A POSTGRESQL DATABASE

CREATE A TABLE ON A POSTGRESQL DATABASE

Reactions 3 Comments
1 min read
A tool to seed your dev database with real data

A tool to seed your dev database with real data

Reactions 7 Comments
1 min read
Protecting privacy with data redaction

Protecting privacy with data redaction

Reactions 4 Comments
3 min read
Database Migration: SQLite to PostgreSQL

Database Migration: SQLite to PostgreSQL

Reactions 3 Comments
5 min read
Counting faster with Postgres

Counting faster with Postgres

Reactions 9 Comments 2
7 min read
# Create user with all privileges in PSQL and add to db

# Create user with all privileges in PSQL and add to db

Reactions 5 Comments
1 min read
HOW TO RUN A SQL FILE AND CREATE A DATABASE

HOW TO RUN A SQL FILE AND CREATE A DATABASE

Reactions 5 Comments
1 min read
Net Core postgreSQL connection string on windows 10

Net Core postgreSQL connection string on windows 10

Reactions 10 Comments
1 min read
🐘🚀 Update/Insert/Soft-Delete from a JSON payload

🐘🚀 Update/Insert/Soft-Delete from a JSON payload

Reactions 6 Comments
4 min read
Data Migrations in NestJS

Data Migrations in NestJS

Reactions 5 Comments
4 min read
3 Things you should know BEFORE you start with Supabase

3 Things you should know BEFORE you start with Supabase

Reactions 10 Comments
3 min read
Speeding Up An Expensive PostgreSQL Query: B-Tree vs. BRIN

Speeding Up An Expensive PostgreSQL Query: B-Tree vs. BRIN

Reactions 6 Comments
6 min read
PostgreSQL 14: TLS Connection

PostgreSQL 14: TLS Connection

Reactions 6 Comments
3 min read
PostgreSQL 14.2 On OpenBSD 7.1: Install

PostgreSQL 14.2 On OpenBSD 7.1: Install

Reactions 4 Comments
3 min read
Tracking dropped database objects in PostgreSQL

Tracking dropped database objects in PostgreSQL

Reactions 10 Comments
2 min read
docker-compose.yaml to start YugabyteDB with POSTGRES_USER POSTGRES_PASSWORD POSTGRES_DB env

docker-compose.yaml to start YugabyteDB with POSTGRES_USER POSTGRES_PASSWORD POSTGRES_DB env

Reactions 9 Comments
2 min read
PERN.TODO

PERN.TODO

Reactions 4 Comments
2 min read
PostgreSQL EXPLAIN – What are the Query Costs?

PostgreSQL EXPLAIN – What are the Query Costs?

Reactions 6 Comments
8 min read
Cloud SQL is not great

Cloud SQL is not great

Reactions 7 Comments 3
6 min read
Deploying PostgreSQL in a Local Kubernetes Cluster

Deploying PostgreSQL in a Local Kubernetes Cluster

Reactions 11 Comments
5 min read
Dockerize Postgres: How to install Postgres with Docker

Dockerize Postgres: How to install Postgres with Docker

Reactions 9 Comments
6 min read
Use PostgreSQL SSL connection in rust with self-signed certificates

Use PostgreSQL SSL connection in rust with self-signed certificates

Reactions 5 Comments
2 min read
Optimiza tu aplicación rails utilizando índices en Postgres

Optimiza tu aplicación rails utilizando índices en Postgres

Reactions 11 Comments
13 min read
Insert CSV Rows into a Database Using Vanilla Ruby

Insert CSV Rows into a Database Using Vanilla Ruby

Reactions 6 Comments
6 min read
Read Committed is a must for Postgres-compatible distributed SQL databases

Read Committed is a must for Postgres-compatible distributed SQL databases

Reactions 9 Comments
7 min read
Saying Goodbye to Heroku Postgres for Now

Saying Goodbye to Heroku Postgres for Now

Reactions 7 Comments
5 min read
Running Database Changes With Zero Downtime