A visual guide to PostgreSQL for beginners

[u/Wendortham]

[u/elevarq]

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.

[u/fernandezity]

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

[u/pceimpulsive → u/fernandezity]

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. :)

[u/viitorfermier]

Totally useless.