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

4 points by aio2 1 year ago | 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.

thesuperbigfrog 1 year ago |

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 1 year ago | |

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

gjvc 1 year ago | |

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

softinio 1 year ago |

For Postgres take a look at this:

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

aio2 1 year ago | |

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