Sqlkit: empowering database access

Summary

[EuroPython 2011] Alessandro Dentella - 23 June 2011 in "Track Spaghetti"

"/>

Description

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.