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

4 pointsby aio2قبل سنتين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.

3 comments

thesuperbigfrogقبل سنتين

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/

aio2قبل سنتين

Thanks, I didn't originally see this. This helps a lot.

gjvcقبل سنتين

pg8000 is a pure python postgres library, should op require that

softinioقبل سنتين

For Postgres take a look at this:

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

aio2قبل سنتين

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

CliveBloomersقبل سنتين