The talk will give an introduction to the concepts used in the Python Database API and relational databases in general. Connection, cursors and transactions are discussed, and their use in a typical Python database application are demonstrated. The talk will also touch upon some advanced database programming techniques and discuss best practices.
To Relate or Not to Relate, that is the question raised by the NoSQL movement. There is a lot of buzz about Couch, Casandra, MongoDB, and other non relational databases, and at the same time there are decades of hard work that's gone into optimizing databases built around the relational model.
I would actually argue that there is no such thing as a NoSQL database -- there are a variety of compelling options to relational database -- each of which have different features and different performance characteristics. So no one-sized fits all comparison will do. So, I'll try to outline a general taxonomy for persistence mechanisms, and then proceed to comparing relational DB's to their new friends in practice.
The talk will contain quite a few stories from the trenches with CouchDB, MongoDB, MySQL, Postgres, Tokyo Cabinet, ZODB, and other databases, and will help you think about the data storage needs of your applications in new ways.
by Marco Nenciarini
How Python was used to implement a tool for the daily backup of an over 50 terabyte distributed data warehouse based on Greenplum Database technology.
The talk covers our experiences, from the initial customer requirements to the first alpha release of the tool, describing the main issues we faced and the Python modules we adopted to address them, while using agile methods.
Though the application is not currently available as an open-source project, the talk gives valuable insights into the development of distributed and parallel applications using Python.
20th–26th June 2011