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.
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
What is free memory in Linux?

What is free memory in Linux?

19
Comments
5 min read
Window Functions in SQL: Part 1

Window Functions in SQL: Part 1

7
Comments
4 min read
Seeding Postgres with Docker

Seeding Postgres with Docker

28
Comments 2
1 min read
Realworld Redwood Firebase PostgreSQL Example

Realworld Redwood Firebase PostgreSQL Example

7
Comments
1 min read
🚀 Think about Primary Key & Indexes before anything else 🐘

🚀 Think about Primary Key & Indexes before anything else 🐘

56
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.