dataKiosk 0.6 released - Mailing list pgsql-general

Hello,

I have released dataKiosk version 0.6.

DataKiosk is a JuK-like database interface tool for generic SQL databases.
What does that mean? Essentially, DataKiosk provides a series of wizards
(anyone familiar with Qt Designer's database wizards will find them familiar)
that allow you to build a custom Juk-like interface for any SQL database with
a QtSQL driver.

New features in this version include the ability to edit the database through
a new configurable edit form with custom widgets depending upon the the
fields data type.  MS Access style combo boxes have been implemented for
Relation combo editors.

Here is a more complete change list:

* Fixed saved searches so that they load after all datatables have been
created.
* Clear advanced searches properly and disable the searchwidget for reports.
* DataTable will have two tabs, one for viewing and one for editing.
* Subclassed QDataBrowser to provide an edit record form.  The edit form uses
a custom editorfactory to provide the right widgets for data relations.  The
main datatable does this too.  You can now edit records, although the layout
and look of the form is not very good at the moment.
* DataKiosk now has flow form layout management for the editor form thanks
to dfaure and Qt4!  FormLayout is based on this new example by TT:
http://doc.trolltech.com/4.0/layouts-flowlayout.html
* Fix an annoying problem with sorting the DataFields.
* Add more advanced kcombobox for relation editor widgets and get ready for
more advanced editor widgets in general.
* Make the formlayout draw every widget with the same width/height.  The width
is calculated after every selectionChange in the QDataTable.  The editor with
the largest content wins.
* The editors in FormLayout are now drawn correctly and the scroll feature of
QDataBrowser works.  A green/red border is drawn around the form based on
what the user is doing.  Update works.
* Change focus policy to try and get a handle on how the data entry can be
made as fast and efficient as possible allowing to navigate with keyboard
only.
* Editors remember state so when they change the colorbox changes.  If the
editors are changed back to match the current database buffer, the colorbox
goes green reflecting that nothing has changed requiring updating.
* Add shortcuts for tab between the datatables.
* Ok, so I've settled on the following for keyboard shortcuts
    Alt+Up              Scrolls the listbox containing the tables... UP
                skipping all the reports. :):)
    Alt+Down        Same as above, just DOWN.
    Alt+Left            Toggles between the edit view and table view plus
                it keeps all of the datatables in sync.  They are all
                toggled.
    Alt+Right           Same as above, just RIGHT.
    Home                Seeks to the first record.
    End                 Seeks to the last record.
    PageUp              Seeks to the previous record.
    PageDown       Seeks to the next record.
    CTRL+s              Commits the changes to the database.

Everything appears to be working and these are all universal shortcuts for the
app, except the Home/End shortcuts don't work when a an editor widget in the
edit view has focus.
* Enforce readonly and do not allow autoediting.
* Make sure that the editForm syncs with the configure table wizard.  Various
fixes.
* Imported and modified libkdepim's kdateedit and ktimeedit into datakiosk.
They are some ugly parts, but they do the job and I didn't feel like
rewriting these widgets.  Created a DateTimeEdit part out of them and made
some fixes so they now handle the Date, Time and DateTime variant editors.
* Added support for nested foreign keys in the Relation Combo editor. This
just about completes the work on the Relation editor.
* Add a configurable RelationCombo that can do MS Access style Combobox's with
a QTable dropdown widget.

DataKiosk also has a new and updated homepage available at:

http://extragear.kde.org/apps/datakiosk/

...complete with screenshots of the new features.

Flash demos of dataKiosk in action can be found here:

http://web.mit.edu/~treat/Public/datakiosk.html

and here:

http://web.mit.edu/~treat/Public/datakiosk-editor.html

Cheers,

Adam Treat