This collection is part of the club Showmedo's video inventory. For details on how to access this and other collections, just click here

Further Progress with Python - Flexing Your Python Muscles

Programming is about solving real problems in the real world. As your Python skills develop we have video-series that introduce you to some of the practical areas where Python's power starts to shine and you can reap the benefits of its power and efficiency.

An Introduction to Database Programming with Python

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.

Introduction to Python web-programming: CGI

CGI (Common Gateway Interface) is one of the simplest ways to start writing dynamic web applications. It is viewed as quite an "old" way to write web applications, but it does not require the understanding of too many different technologies. It's therefore perfect for writing small one-shot web scripts that are essentially web front-ends to shell scripts.

Despite being an "old" technology CGI is still relevant - as can be seen by it's adoption within Google's App Engine.

This series starts of with a couple of videos introducing CGI and Python's CGI module. Later episodes will show the building of a more complex application (a wiki). The later episodes will be published in April/May 2008.

A Gentle Introduction to the Google App Engine Python SDK

Google App Engine (GAE) promises to remove some of the hassles from starting and maintaining a web-site. Potentially difficult, technical jobs such as server, database and user-identity management are made considerably easier. Google has chosen Python as its initial application development language, allowing new users to leverage the considerable power and usability of such frameworks as Django or Pylons. This series will introduce the GAE, focussing on the use of its Python SDK and webapp framework. It aims to give good idea of GAE's workflow, assumes limited programming knowledge and, while not an introduction to Python, will try to explain most of the code used in a gentle walkthrough.

Robust and Reliable Web Sites with twill and nosetests

Learn how to use twill (a Python+shell web browser) and nosetests to unit-test your website as if you were using the website. With this technique you can reliably test your site whilst you develop.

This is also known as 'functional testing' and it is used within ShowMeDo to test our website before deployment, and used by many larger sites for robust testing.

Publishing schedule - 5 videos will be published by the first week of April.

Python Development on XP

See PyDev and IDLE in action, program and debug code and then learn bullet-proof coding by unit-testing with nosetests.

This series will save you time as you watch 4 years of distilled knowledge. Several exercises will help you to expand your knowledge and you can ask me questions to get feedback on your progress.

Note title change - previously this series was known as 'Python Newbies on XP'.

"I had 3 requirements in mind when decided to look for a Python tutorial...Having completed this series I am glad to say that it is certainly meets all my requirements and above! Thank you Ian for a great course and I certainly [am] going to continue my Python studies with your other series" - Ofer

"As Ian says somewhere, he's found, organized, and presented information that would take weeks or months to learn in the ordinary way. Even if your time is worth only $10 per hour, I figure the value in time saved is at least $800. The skills are priceless." - Vincent DiCarlo

COM and Python with pyWin32

Learn to talk to COM-enabled applications on Windows using the open-source pyWin32 (by Mark Hammond). Here we use Python to control Excel, then we create a Python-based COM server which we call from inside Excel. Possible applications - use Excel as a charting tool, build a scientific/research interface to your Python code, communicate with any COM application, build your own COM servers.

Joining the Club

Access to the video-tutorials in this and all our other collections is available for a single payment of $60. This grants 12 months access to our current videos and any we produce in coming year.

Subscription For Club Showmedo
  • Access 161 existing Club-videos
  • New videos being added all the time
  • Watch on-line or download to watch
  • Enjoy privileged club status *
  • Full Money-back guarantee (below).
  • $29 one-off payment for 12 months access

*as a club member your queries get first priority from Showmedo, as do any requests or recommendations you make for videos you would like to see.

Why are we doing this?

We're passionate about sharing our hard-won knowledge - you get to benefit from our years of experience as we quickly teach you great new skills.

By subscribing you help to support our time and that lets us create more free videos about cool Python tools. Not only do you help us to benefit the entire community, you also benefit as we get to keep the site Ad-free.

Does the subscriber-only archive just grow?

Rather than let the archive grow indefinitely we think it is more beneficial to the community if the older Subscriber-only videos are released for free into the general ShowMeDo pool. These releases will typically occur after a year or so.

By Subscribing you get access to all of the latest Subscriber-only videos and you'll be supporting our efforts to better-document great Python tools which benefits the whole community.

Money back guarantee?

We offer a money-back guarantee. If you're not happy with the tutorials that we produce then get in contact and tell us that you want a refund on the remainder of your subscription - we'll sort it out quickly.

Your Subscription lets you (and just you):


  • ask questions and leave feedback via Comments
    • login and view all of the Subscriber-only videos
    • download the videos for off-line personal use
    • NOTE - you must not upload the videos to video-sharing websites

    Problems with registration?

    First - ask for a password reminder. If that doesn't work then mail 'admin AT' and we'll sort you out.

    This collection is part of the club Showmedo's video inventory. For details on how to access this and other collections, just click here

    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.

    Follow Our Tweets
    For site-news, video announces, info on building a web-site with Python, jQuery, javascript, CSS, Flash (ugh) and plain interesting FOSS news follow our tweets.
    Follow Our Blog
    For in-depth code analyses, new videos, news from the open-source frontier, Python, jQuery etc. hackery just follow our blog.


    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.