Name: [008] Kyran Dale
Member: 107 months
Authored: 16 videos
Description: I'm one of the co-founders of Showmedo and an academic researcher by profession. My peripatetic path has taken me from a Philosophy degree via Artificial Intelligence and Evolutionary Robotics to a PhD in Neuroscience. I spent five years in a small room with a colony of reluctant bumble-bees, becomi ...

An Introduction to Database Programming with Python [ID:277]

a series of video-tutorials by Kyran Dale

As you might expect Python makes database programming a relatively painless affair. The Python database API (DBAPI) provides a 'database neutral' programming interface for databases such as MySQL, PostgreSQL, SQLite, MS-SQL and Oracle, among others, based on the structured query language SQL. In this series we show you what the DBAPI is, a bit of how it works, and how it can be used to connect Python programs to SQL databases. We demonstrate how existing databases can be accessed and used and how Python can create new databases, add tables and populate those tables with data.

Video Tutorials

1. Introduction to the Series

Python offers powerful and convenient tools for working with databases. Here we summarize the aims of the upcoming videos.

2. The Python Database API (DBAPI)

The Python DBAPI was created to encourage similarity between Python modules used to access different databases. Such consistency makes it much easier to move code from one database to another or to start programming with an unfamiliar database. Here we run through the fundamental priciples.

3. Connecting Python to the Database

Connecting a Python script to a particular type of database requires a driver module. For example, to work with MySQL requires that the MySQLdb module be imported. In this video we will show you how to connect to a database and perform a simple query. The Python DBAPI means that this lesson is applicable to pretty much all common databases, including PostgreSQL, SQLite and many others. A good st [...]

4. Using and Manipulating a Database from Within a Python Progam

In this video we show how Python can programmatically fetch and manipulate data from within a database and insert data into it. We build up simple examples and, using a live MySQL database command-line, demonstrate comparable queries and changes made to the database. As with all videos in this series, the lesson is applicable to most of the SQL based databases including PostgreSQL, SQLite, Micr [...]

5. Creating a Database With Python

In this video we show how to recreate the simple example database we have used in this series from within a Python program. We use a live MySQL database command-line, to track changes made programmatically. A database is created, a table added to it, and user data inserted into that table. As with all videos in this series, the lesson is applicable to most of the SQL based databases including P [...]

Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.

Kudos and Thanks for Kyran

Learning Paths

This series lies on the following learning-paths. Learning-paths are a new initiative at Showmedo, to start structuring our content better. You can find out more here.

Content

Feedback

Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.

feedback@showmedo.com