Python Data Persistence Using MySQL

[ Thanks to Bhushan Pangaonkar for this link. ]

"The best way to learn new programming techniques is to write an application that exercises them. This article will walk you through the process of building a simple Python application that interacts with a MySQL database. In a nutshell, the application picks up some live data from a web site and then persists it to an underlying MySQL database. For the sake of simplicity, it doesn't deal with a large dataset. Rather, it picks up a small subset of data, storing it as a few rows in the underlying database.

"In particular, the application gets the latest post from the Packt Book Feed page available at http://feeds.feedburner.com/packtpub/sDsa?format=xml. Then, it analyzes the post's title, finding appropriate tags for the article associated with the post, and finally inserts information about the post into the posts and posttags underlying database tables. As you might guess, a single post may be associated with more than one tag, meaning a record in the posts table may be related to several records in the posttags table."

Complete Story

Related Stories:

• Python 3.0 Makes a Big Break(Oct 17, 2008)
• Examining the Compilation Process. Part 1.(Oct 08, 2008)
• Python's New Release Bridges the Gap(Oct 03, 2008)
• Becoming a Free Software Developer, Part V: When and Where Did You Learn?(Sep 28, 2008)
• Automation with Python and STAF/STAX(Sep 23, 2008)
• Writing a Package in Python(Sep 23, 2008)
• With EasyGUI, I Can Stick with Python(Sep 14, 2008)