Sessions at EuroPython 2011 about SQLAlchemy with video

Tuesday 21st June 2011

• Sqlkit: database ad accesso immediato

  by Alessandro Dentella

  È molto facile accedere ad un database con Python e ci sono molti ORM che
  permettono un alto livello di astrazione. Da qui c'é ancora una lunga strada
  per arrivare a manipolare interattivamente i dati anche per semplici
  compiti.

  Sqlkit cerca di coprire questa distanza fornendo alcuni mega-widgets che
  permettono di costruire ogni applicazione GUI o accedere direttamente ai
  dati con l'applicazione 'sqledit', che viene distribuita con sqlkit. Sqlkit
  è costruita con PyGTK e SQLAlchemy.

  Questa presentazione esplora alcune fra le più potenti caratteristiche di
  sqlkit e mostra quanto sia semplice costruire piccoli programmini ad uso
  personale o applicazioni ricche ed articolate. Si focalizza principalmente su
  due punti: quanto sia facile creare maschere per editare dati (anche
  relazioni on2many o many2many, grazie al modo originale di definire i
  layout) e al sistema di template basato su OpenOffice che rende
  incredibilmente semplice creare report.

  Questa presentazione vuole mostrare come sqlkit può essere usato sia come
  framework di sviluppo di applicazioni, sia come strumento che ci aiuta
  mentre sviluppiamo altre applicazioni (es.: Django, OpenERP,... ).

  Per rendere la presentazione più graduale, sfrutteremo il sistema di
  configurazione di sqledit Partendo da una configurazione minima -un URL-
  aggiungeremo elementi fino ad ottenere una vera applicazione.

  • SQLAlchemy

  At 3:30pm to 4:30pm, Tuesday 21st June

  Coverage video

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