Main features of SQL kit:
- Editor of databases in 2 modes: table & mask.
- It based on SQLAlchemy: can cope with many different databases.
- It is very powerful filtering capabilities:
- In this each field can be used to filter visible records.
- Date filtering possible also on relative basis (good for saved queries).
- In SQl kit completion both on local same field and foreign key fields.
- It is a very easy way to draw a layout for mask views.
- SQL edit: Python script to edit db.
- It is 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.
- Completely localized.
- Easy way to add hooks and validation.
How To Install SQL Edit : Under Debian/Ubuntu
On Ubuntu lucid (10.04) and probably also others >= 9.10 you can prepare dependencies:
sudo add-apt-repository ppa:toobaz/sqlkit
On Debian:
echo deb http://ppa.launchpad.net/toobaz/sqlkit/ubuntu lucid main | sudo tee
/etc/apt/sources.list.d/sqlkit.list
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 39012CF8
And install it as follows (this installs python drivers for PostgreSQL and Mysql as well):
sudo apt-get update
sudo apt-get install python-sqlkit python-psycopg2 python-mysqldb
I’ll try to keep this updated as the official package
All about the application :
Version => python-sqlkit 0.9.5-1
Total size => 5.3 MB to download, 15.1 MB when installed
license => Open source
Updates => Canonical does not provide updates for Sqledit. Some updates may be provided by the Ubuntu community.
Comments
Post a Comment