Exercises, examples and other material relating to training module Y113. This topic is presented on public courses Learning to program in Python, Python Programming

Data within a Python application can be held and referenced many ways - in regular files, in XML, via a web server (such as an HTML or RSS feed) and within a relational database. This module looks at the two most commonly used databases in Python - MySQL and SQLite, which both use the structured query language, but use different internal models. In then shows how those databases are used from within a Python program, how other databases (which usually follow a similar model) may be used, and how the databases are wrapped if you're using a web framework such as Django.

Articles and tips on this subject		updated
4537	example of SQLite using a local database file through SQLalchemy Here's an example of SQLite using a local database file through SQLalchemy. The SQL statements are hidden from the user - that's the "Object to Relation Mapping" - although you can ask what's going on by runing my program with a -v option. ... example program source [here], seeding data download from ...	2015-10-14
4535	SQLAlchemy - first examples with a Python Object Relationship Mapping system Object to Relational Database mapping - in other words how to you take objects in your language such as Python and save them in database tables, and vice versa, without having to do all the detailed SQL coding yourself? Use on ORM system. An example in Python is SQLalchemy which connects to a variety ...	2015-10-14
4445	Graphing presentations in Python - huge data, numpy and matplotlib A picture paints a thousand words. Our server log files for February are 1.6 Gbytes in size, with 5.3 million individual requests. How busy are we at what times of day? I've been looking at this through matplotlib in Python - here's a wireframe of the month - days on the X axis, hour of the day on ...	2015-02-28
4436	Accessing a MySQL database from Python with mysql.connector On our programming courses we often use SQLite as our database - it installs locally, saves us the need for daemons, saves licensing and password issues, and lets us cover the interfacing very quickly and easily. There's a Python example [here]. However, there are some occasions when a customer may ...	2015-02-21 (longest)
4086	Cacheing class for Python - using a local SQLite database as a key/value store Question from Tom: What did you have for lunch yesterday? Answer: A Sandwich, a piece of cake and some fruit. Question from Dick: What did you have for lunch yesterday? Answer: A Sandwich, a piece of cake and some fruit. Question from Harry: What did you have for lunch yesterday? Answer: A Sandwich, ...	2013-05-18
4024	SQL databases from Python - an SQLite example There's a new example of relational database use in Python [here] on our site - from the Python course I ran last week. If you cut and paste the script onto your system, it should run with little fuss (and without needing a separate database engine) as it uses sqlite - the built in SQL database - as ...	2013-03-02
3139	Steering our Python courses towards wxPython, SQLite and Django With our modular courses that we write ourselves, we've well placed to move forward with technology; more often than not, what's needed is a series of gentle changes, adding in the occasional module for private courses where a particular new subject is needed, with it being introduced into public courses ...	2011-01-21
3136	A framework with python - Django - first steps What is Django and what do I need to be able to use it? Django is a framework - a tool that lets you create, customise, run and maintain web sites in which the data is stored in database tables. It uses the DRY (Don't Repeat Yourself) philospohy of design - quite the opposite of early web sites, where ...	2011-01-19 (longest)
2790	Joining a MySQL table from within a Python program Python is a big subject. MySQL is a big subject. Yet the two fin so well together that they can be firmly linked, and work well together, using the tiniest drops of glue. I've provided examples here before, but in answer to a request from a recent delegate, I've just added a fresh example onto our ...	2010-06-02
2786	Factory methods and SqLite in use in a Python teaching example I've just uploaded a neat little example - [here] from last week's Python course - it's amazing what you can do in a very few lines of code. The application scenario is that we have a database of customers - some are residents at our hotel and others are delegates on our courses. Being mercenary folks, ...	2010-06-02
2746	Model - View - Controller demo, Sqlite - Python 3 - Qt4 The Model - View - Controller approach to application design keeps the Graphic User Interface (the view) separate from the database (the model), with the controller in between the two, describing how the data is displayed, and how changes to the data are saved away in the database. By separating the ...	2010-04-29
2745	Connecting Python to sqlite and MySQL databases For developing a Python application, and for light use, the SQLite database may be a good choice ... but then you may want to be able to expand the system to use a central database with a more classic server such as MySQL at a later date. Using Polymorphism in Python, and with a careful choice of which ...	2010-04-28

alch001	SQL Alchemy - connect and first query
alch002	SQL Alchemy - connect, inserts and queries
databases_python	sqlite3 - connect, create, insert, select
inserts.py	MySQL / Python (1) - connect, drop, create, insert, select, drop
kvcache.py	Cacheing class object / sqlite3
logger	Local MySQL test prior to running examples
multi_resultsets.py	MySQL / Python (2) - connect, drop, create, insert, select with iterate, drop
napreader	reading from http://www.wellho.net/data/wiltshire_busstops.csv
orm_sqlite	sqlalchemy orm with sqlite demo - Python 2.x
prepared_statements.py	MySQL / Python (3) - with prepared statements
pyjson_kvcache	Using our JSON service from Python with key / value cache
selector.py	Simple selector (MySQL database of 168,000 records)