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.
Create a Restful API with Golang from scratch

Create a Restful API with Golang from scratch

559
Comments 17
13 min read
Connecting to PostgreSQL using GORM

Connecting to PostgreSQL using GORM

72
Comments 12
7 min read
Geolocation with Postgresql+Nestjs+Typeorm

Geolocation with Postgresql+Nestjs+Typeorm

10
Comments
1 min read
What’s new with JSON in PostgreSQL v14

What’s new with JSON in PostgreSQL v14

23
Comments 2
6 min read
Connecting Django to PostgreSQL on Heroku and Perform SQL Command

Connecting Django to PostgreSQL on Heroku and Perform SQL Command

9
Comments
15 min read
Aggregate Functions in SQL

Aggregate Functions in SQL

22
Comments
6 min read
How to persist and backup PostgreSQL Docker container.

How to persist and backup PostgreSQL Docker container.

22
Comments 2
4 min read
Auth with Express with JWT, MongoDB, and Postgres

Auth with Express with JWT, MongoDB, and Postgres

7
Comments
13 min read
Function pipelines: Building functional programming into PostgreSQL using custom operators

Function pipelines: Building functional programming into PostgreSQL using custom operators

2
Comments
20 min read
How percentile approximation works (and why it's more useful than averages)

How percentile approximation works (and why it's more useful than averages)

2
Comments
33 min read
What is the difference between UNION and UNION ALL in SQL?

What is the difference between UNION and UNION ALL in SQL?

16
Comments 2
2 min read
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

81
Comments 29
14 min read
Dockerize & Backup A Postgres Database

Dockerize & Backup A Postgres Database

27
Comments 4
8 min read
Top PostgreSQL monitoring metrics for Prometheus – Includes cheat sheet

Top PostgreSQL monitoring metrics for Prometheus – Includes cheat sheet

26
Comments 3
6 min read
ORDER BY is mandatory in SQL to get a sorted result

ORDER BY is mandatory in SQL to get a sorted result

33
Comments
10 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.