Sqlkit – Edit data in a database

Sponsored Link

Sqlkit provides a GUI named sqledit to edit data in a database, as well as a package (sqlkit) in PyGtk. Sqledit (the application) can be run from the command line with arguments and will pop directly into the table/mask of the data, or without arguments and will present an input mask to write the database URL. Sqlkit (the Python package) provides SqlMask and SqlTable, two widgets for editing database data. It is meant to be used as a base for database desktop applications.

Features

Main features of sqlkit:

* Editor of databases in 2 modes: SqlTable & SqlMask. Mask can embed tables of related tables.
* Based on sqlalchemy: can cope with many different database backend (Postgresql, Mysql, sqlite the most popular ones). Can be used to edit any selectable you can build with sqlalchemy.
* Very powerfull filtering capabilities:
o each field can be used to filter visible records
o date filtering possible also on relative basis (good for saved queries)
o works on expressions too
o works on fields in related tables embedded in mask
* Completion both on normal fields and foreign key fields
* Very easy way to draw a layout for mask views
* Sqledit -- the standalone program to browse and edit data: python script to edit db
* Completely effortless editing of Relationships
* Very easy way to set Defaults
* Possibility to display Totals in numeric fields
* Constraints: any possible sql constraint can be attached to a Mask or a Table. It can be expressed as a normal sqlalchemy query or with django-like syntax. Works on expressions too.
* SqlMask and SqlTable are widgets with several Signals
* Hooks for a very easy customization of behaviour and for validation
* More than 70 snippets of code to demonstrate each feature

Install sqlkit in Ubuntu

First you need to edit source.list file

gksudo gedit /etc/apt/sources.list

Add the following line

deb http://apt.argolinux.org/ lenny sqlkit

Save and exit the file

Install GPG key

wget http://apt.argolinux.org/sqlkit.list --output-document=/etc/apt/sources.list.d/sqlkit.list

wget -O-  http://apt.argolinux.org/dists/lenny/public.key| sudo apt-key add --

sudo apt-get update

and install it via:

apt-get install python-sqlkit

Screenshot

Sponsored Link