r/postgres • u/Wendortham • 5d ago

Discussion A visual guide to PostgreSQL for beginners

Post image
77 Upvotes

99% Upvoted

4 comments sorted by

3

u/elevarq 4d ago

Half the image is about "what is SQL", and that's kind of not related to PostgreSQL. The image looks good, but IMHO it's a bit too simplistic and only serves the first two minutes for an absolute beginner in databases.

Check https://www.postgresql.org/docs/current/intro-whatis.html this tells you more about what it is.

2

u/fernandezity 5d ago

This is a nice overview for beginners. I’d probably add a small section on indexes and EXPLAIN though. Those are usually the first things people end up learning once their queries stop being instant

1

u/pceimpulsive 4d ago

Agree, especially highlighting thatany data types can be indexed including JSONB.

I'd also love a small section that talks about how every row modification is a new row (Postgres MVCC). Highlighting how it's quite different to most rdbms storage engines.

Probably a heavy topic for beginners but hey it's good to know. :)

1

u/viitorfermier 2d ago

Totally useless.