---
title: "Discussion on \"PostgreSQL: A Practical Guide to the Database Engineers Agree On\" | Hashnode"
description: "Discussion on \"PostgreSQL: A Practical Guide to the Database Engineers Agree On\". What Postgres is good at, when to pick something else, and the habits that keep it fast and safe"
url: "https://hashnode.com/posts/postgresql-practical-guide/6af7eb508797a7997b8a75e0"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [PostgreSQL: A Practical Guide to the Database Engineers Agree On](https://blog.creamdb.com/postgresql-practical-guide?utm_source=hashnode&utm_medium=feed)

What Postgres is good at, when to pick something else, and the habits that keep it fast and safe

2d ago · 9 min read · blog.creamdb.com  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#databases](https://hashnode.com/tag/databases)
-   [#sql](https://hashnode.com/tag/sql)
-   [#backend](https://hashnode.com/tag/backend)
-   [#beginners](https://hashnode.com/tag/beginners)

## Written by

[Cream DB](https://hashnode.com/@creamdb)

@creamdb

  
[View profile](https://hashnode.com/@creamdb)

Every database. One cone.

CreamDB is a web-based database explorer with an AI assistant. Connect your databases, ask questions in plain English and get answers, tables and charts from any browser. Product news and tips here.

## Responses 1

Markdown supported · ⌘↵ to post

[QRiQRa Team](https://hashnode.com/@qriqra)

[1d ago](https://hashnode.com/posts/postgresql-practical-guide/6af7eb508797a7997b8a75e0/comment/6af84c941afc6c818c63d851)

The section on letting the database enforce the rules, not only the application, is a useful starting point. A NOT NULL, a foreign key, or a CHECK constraint will still apply when a new path writes to the same table. I also appreciated the habit of proving a backup actually restores, rather than only confirming that a backup job ran. The "where it does not fit" part is just as valuable as the praise. Knowing when to pick something else keeps this from being a one-tool answer.
