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.
Quick Answers: What is the UUID column type good for and what exactly is a UUID?

Quick Answers: What is the UUID column type good for and what exactly is a UUID?

3
Comments
2 min read
PostgreSQL does have SSL (asymmetric key files), but I couldn't get it to work

PostgreSQL does have SSL (asymmetric key files), but I couldn't get it to work

7
Comments
2 min read
"use database_name" with PostgreSQL

"use database_name" with PostgreSQL

2
Comments
1 min read
How to use MySQL/Postgres with Docker

How to use MySQL/Postgres with Docker

8
Comments
2 min read
One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

45
Comments 5
3 min read
Django Project Tutorial for beginners: Settings, Docker-Compose, Postgres and Redis

Django Project Tutorial for beginners: Settings, Docker-Compose, Postgres and Redis

129
Comments 10
30 min read
Anatomy of a PostgreSQL Query Plan

Anatomy of a PostgreSQL Query Plan

9
Comments
10 min read
Postgres Triggers

Postgres Triggers

10
Comments
3 min read
Maintaining Multiple Postgres Version

Maintaining Multiple Postgres Version

17
Comments 1
1 min read
PostgreSQL Interview Questions

PostgreSQL Interview Questions

17
Comments
4 min read
Easy functions and transactions using Postgres + PostgREST or Supabase

Easy functions and transactions using Postgres + PostgREST or Supabase

16
Comments 1
2 min read
Practical example for Ranking with Window Functions

Practical example for Ranking with Window Functions

5
Comments
2 min read
Microservices in Go: Accessing PostgreSQL - Putting it all together

Microservices in Go: Accessing PostgreSQL - Putting it all together

5
Comments
3 min read
How to Query Multiple Schemas With Postgresql

How to Query Multiple Schemas With Postgresql

12
Comments
3 min read
Add Authentication to Your AdonisJS Project

Add Authentication to Your AdonisJS Project

7
Comments
11 min read
Distributed State Management - Without the "E"

Distributed State Management - Without the "E"

4
Comments 2
10 min read
📖 Build a RESTful API on Go: Fiber, PostgreSQL, JWT and Swagger docs in isolated Docker containers

📖 Build a RESTful API on Go: Fiber, PostgreSQL, JWT and Swagger docs in isolated Docker containers

229
Comments 20
27 min read
rails new API with PostgreSQL w/rails g resource

rails new API with PostgreSQL w/rails g resource

10
Comments 1
3 min read
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

6
Comments
1 min read
Understanding Database Connection Pool

Understanding Database Connection Pool

73
Comments
3 min read
Deploy and Manage PostgreSQL on Kubernetes

Deploy and Manage PostgreSQL on Kubernetes

22
Comments
7 min read
Backing up and restoring databases in Postgres

Backing up and restoring databases in Postgres

7
Comments
2 min read
Building Microservices in Go: Accessing PostgreSQL - Statements Builder and Code generators

Building Microservices in Go: Accessing PostgreSQL - Statements Builder and Code generators

6
Comments
3 min read
How I was performing Row Locking for Read-Write Transactions in Postgres

How I was performing Row Locking for Read-Write Transactions in Postgres

5
Comments
5 min read
Anything I Want With Sequel And Postgres

Anything I Want With Sequel And Postgres

8
Comments 3
7 min read
Angels of Supabase

Angels of Supabase

48
Comments 2
9 min read
PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

7
Comments 2
1 min read
I made google docs clone but with a twist

I made google docs clone but with a twist

31
Comments 7
1 min read
Getting PostgreSQL To Work On A Rails App Using Ubuntu And WSL

Getting PostgreSQL To Work On A Rails App Using Ubuntu And WSL

8
Comments 2
3 min read
Running QuestDB on GKE Autopilot

Running QuestDB on GKE Autopilot

3
Comments
7 min read
Postgresql and Django Quickstart Guide

Postgresql and Django Quickstart Guide

2
Comments
1 min read
Building Microservices in Go: Accessing PostgreSQL - ORM/ORM-like

Building Microservices in Go: Accessing PostgreSQL - ORM/ORM-like

7
Comments
4 min read
Upgrade a User to be a Super User

Upgrade a User to be a Super User

6
Comments
1 min read
Draw charts from terminal with psql and termgraph

Draw charts from terminal with psql and termgraph

4
Comments
1 min read
Designing a defense-in-depth network security model between Amazon Elastic Kubernetes Service and Amazon RDS

Designing a defense-in-depth network security model between Amazon Elastic Kubernetes Service and Amazon RDS

23
Comments
5 min read
JSON en PostgreSQL

JSON en PostgreSQL

9
Comments
2 min read
Combining IAM Roles for Service Accounts with Pod level Security Groups for a defense-in-depth strategy

Combining IAM Roles for Service Accounts with Pod level Security Groups for a defense-in-depth strategy

14
Comments 1
10 min read
A simple blog in Go

A simple blog in Go

11
Comments 4
6 min read
Securing sensitive Data in amazon RDS

Securing sensitive Data in amazon RDS

8
Comments 1
7 min read
Discover exoplanets with PostgreSQL sample data

Discover exoplanets with PostgreSQL sample data

4
Comments
4 min read
Decoding Django Sessions in PostgreSQL

Decoding Django Sessions in PostgreSQL

9
Comments
6 min read
Hacker BI: Airtable + Metabase

Hacker BI: Airtable + Metabase

9
Comments
10 min read
Work with Production Data Deletion

Work with Production Data Deletion

17
Comments 2
4 min read
Which Is The Best PostgreSQL GUI? 2021 Comparison

Which Is The Best PostgreSQL GUI? 2021 Comparison

9
Comments
15 min read
Building Microservices in Go: Accessing PostgreSQL Databases - Plain SQL

Building Microservices in Go: Accessing PostgreSQL Databases - Plain SQL

7
Comments
5 min read
Iniciando projeto Nodejs com ORM Sequelize

Iniciando projeto Nodejs com ORM Sequelize

8
Comments 4
10 min read
PostgreSQL kĂźmelemede Patroni kullanÄąmÄą

PostgreSQL kĂźmelemede Patroni kullanÄąmÄą

12
Comments
5 min read
Where can I host PostgreSQL with custom extensions for cheap (or free)?

Where can I host PostgreSQL with custom extensions for cheap (or free)?

7
Comments 2
2 min read
Performance differences between Postgres and MySQL

Performance differences between Postgres and MySQL

8
Comments
7 min read
Build a fuzzy search with PostgreSQL

Build a fuzzy search with PostgreSQL

13
Comments 1
5 min read
Querying PaperTrail Object Changes in JSON

Querying PaperTrail Object Changes in JSON

7
Comments
4 min read
EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

9
Comments
5 min read
SQL: Basics to Advanced in a Nutshell

SQL: Basics to Advanced in a Nutshell

10
Comments 2
8 min read
AWS: PostgreSQL on Graviton2

AWS: PostgreSQL on Graviton2

12
Comments
5 min read
Deleted my live production database - Lesson learned

Deleted my live production database - Lesson learned

2
Comments
2 min read
High Priority Fast Lane for the Minion Job Queue

High Priority Fast Lane for the Minion Job Queue

14
Comments 4
3 min read
I wrote an open source alternative to google analytics using timescaledb and rails and opentresty

I wrote an open source alternative to google analytics using timescaledb and rails and opentresty

5
Comments 2
1 min read
🐘 Set up A PostgreSql Database in Django

🐘 Set up A PostgreSql Database in Django

9
Comments 3
3 min read
Postgres Notify for Real Time Dashboards

Postgres Notify for Real Time Dashboards

12
Comments
5 min read
How to create tables on Heroku Postgresql

How to create tables on Heroku Postgresql

12
Comments 3
3 min read
loading...