Ask HN: Trying to learn Postgres and Python, any help?

by aio2on 1/1/2025, 9:47 PMwith 5 comments

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.

by thesuperbigfrogon 1/1/2025, 10:09 PM

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/

by softinioon 1/1/2025, 10:15 PM

For Postgres take a look at this:

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