Sessions at EuroPython 2011 about Python and SQLAlchemy

Wednesday 22nd June 2011

• New beauty in Camelot

  by Erik Janssens and Jeroen Dierckx

  Camelot is a Python framework that leverages SQLAlchemy and QT to build rich desktop applications. The model - view definition used was inspired by the Django Admin interface. Some see it as a replacement for MS Access, but it's underlying libraries allow much more advanced features.

  In this talk we will focus on the changes and new features that were introduced in Camelot and more importantly, how they can be used in your applications. Those features range from Matplotlib chart integration and new types of actions to displaying custom SQLAlchemy queries in a table view.

  We will share our experiences with large scale deployment of Python and Camelot applications to the desktop of the user. In a number of case studies we will point out the mistakes we made and how they were corrected.

  • PyQt
  • Python
  • SQLAlchemy

  At 3:30pm to 4:30pm, Wednesday 22nd June

  Coverage video slide deck video

Thursday 23rd June 2011

• Sqlkit: empowering database access

  by Alessandro Dentella

  It's very easy to access databases with Python, and there are many ORMs allowing a high level of abstraction. Still, it's a long road from there to interactive handling of data, even for very simple tasks.

  Sqlkit tries to act as a bridge, offering some mega-widgets that allow you to build GUI applications or directly access data using the 'sqledit' application, shipped with sqlkit; sqlkit is built with PyGTK and SQLAlchemy.

  This presentation covers some of the most powerful features of sqlkit, and shows how easy it is to build small programs for personal use, as well as rich and complex applications. It primarily focuses on two points: how easy it is to create data forms (eventually with one2many or many2many, thanks to a original definition of layouts), and the template system based on OpenOffice which allows easy report creation.

  This presentation shows how sqlkit can be used both as application development framework and as a tool to help us while developing other applications (e.g.: Django, OpenERP,... ).

  To deliver a gradual presentation, we'll use the configuration system of sqledit, starting from a minimal configuration (a single URL) we'll add elements to that until we'll have a full application.

  • Python
  • SQLAlchemy

  At 11:15am to 12:15pm, Thursday 23rd June

  Coverage video