31 includes:

collect and share resources on postgres and python

On this issue, I list resources I have used related to postgres and python. We can create a new project to work through some of these resources together.

How to Design Programs

How to Design Programs This is the book I am currently reading. I aim to solve the exercises with python and also with the language the book uses. I collect notes and programs for the exercises from this book in this repository.

I list this resource first even though it is not a python resource because the design recipe this book teaches will help us to write programs better than learning any particular language's syntax and semantics will teach us.

Learn python language

documentation on python.org, starting with tutorial on python.org.

learn python the hard way, starting with the appendix that includes prerequisite information on the commandline.

python for everyone, both on youtube and freecodecamp.org. On freecodecamp I took the legacy python for everyone course. Since then, freecodecamp has beefed up their core python course; I have not taken it.

See python applied to domains

freecodecamp.org intro to data analysis with python

CS50 intro to computer science on youtube -- a couple lectures later in the semester use python. One lecture uses it with Flask/Jinja to extend a base web server with endpoints. CS50 on youtube has other courses/playlists. Given that the CS50 intro to computer science was pretty good, I predict the other courses will be good too. e.g.

There are other freecodecamp courses I have not taken but I list them in case they interest you intro to college algebra with python intro to machine learning with python

fullstackpython.com gives pointers to many ways of using python to develop applications.

Learn SQL language and PostgreSQL

The official postgres documentation points to tutorials.

The freeCodeCamp relational database course was useful.

I think my first exposure to SQL was from CodeAcademy.

I remember browsing pages on w3schools for SQL and maybe PostgreSQL.

I remember a previous co-worked enjoyed this book. But, we don't need to buy books. There are a lot of free resources and maybe free copies of typically for-pay resources.

Recall from above discussion of CS50. They also provide a CS50 intro to SQL. I have not taken it.

Getting data from database from within python program

I have used a python library psycopg2.

Execute program written in python from within PostgreSQL

I remember working with co-workers who used PL/Python to make database process execute a program written in python. See also this post on stackoverflow.

Another note on the How to Design Programs book

This sequence of courses -- the first two courses in that sequence use the How to Design Programs book/approach. So, the courses are a complementary way to go through similar material as the book. Those courses can be taken for free. I have not taken those courses, but I may at least browse them after I read through sections of the book.

zipperer / migrate_database_with_michael

collect resources on postgres and python and share #33