I’m a programming language nut. Since my days at CMU I have been fascinated by programming languages and finding the best language for each specific application. At Fashion Metric I write code in PHP and Python and use languages that I don’t consider coding (since they’re really just markup languages) like HTML and CSS.
I was recently training one of the programmers who is working with us on Python and MySQL and thought that I would share with all of you some of the tutorial that I shared with him.
In case you missed the memo, Python is cool again, which is good for guys like me who got into it back in the good old days and then saw languages like PHP steal the limelight. Well now Python is back in a major way, it’s popular again, and thanks to frameworks like Flask it is super-powerful and easy to use for any web-based programming wizardry you throw at it.
So one of the things you’re probably going to want to do with Python is connect to a MySQL database, below are six of my favorite tutorials for getting you started and dangerous enough to get going right-away:
Python + MySQL
1) http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python
2) http://dev.mysql.com/doc/connector-python/en/
SQL Reference
1) http://www.w3schools.com/sql/sql_quickref.asp
2) http://www.sqlcommands.net/
Relational Databases
1) http://stackoverflow.com/questions/4702728/relational-table-naming-convention
2) http://holowczak.com/database-normalization/
Photo Credit: Sebastian Niedlich (Grabthar) via Compfight cc
