As the cvs repository grows in a quite dramatic rate and we'd like to add a subversion repository to it, we need to put new hard drives in the system. As this requires a complete backup+restore cycle, we'd like to take down the server down for all of next monday (21st). It will go down without further notice (we'll of course make sure no commits are in progress) - so please make sure to commit your changes in time.

Here's the Requirements & Specification document I'm working on. I put it here so that you can give me some feedback.

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