Hacker News new | ask | show | jobs
Ask HN: Trying to learn Postgres and Python, any help?
4 points by aio2 526 days ago
I wish to learn about Postgres and applying it to Python. Any good resources on this? Documentation is confusing me, Chatgpt doesn't give the best lessons, and other websites that I search for don't go into enough depth. Sure, they cover the basics, but I'd like to learn more.

If I had to be selfish, something similar to the Head First series would be greatly appreciated. I was originally going to use it, but they went with mysql. I tried to follow along even though I was using Postgres, but I got stuck on some spots, so something more aligned to postgres would be better for me.

Thanks.

2 comments

Did you try the tutorial in the Postgresql documentation?

https://www.postgresql.org/docs/current/tutorial.html

The psycopgb library is an easy way to use a Postgresql database from Python:

https://www.psycopg.org/psycopg3/docs/

Thanks, I didn't originally see this. This helps a lot.
pg8000 is a pure python postgres library, should op require that
For Postgres take a look at this:

https://www.crunchydata.com/developers/tutorials

Thank you, I'll practice on it for sure.