Kexi/Releases/1.0.0 Changes

KEXI is a visual database apps builder, developed since 2002.

Changes in KEXI

Highlight:

• Codenamed "Black Mamba"
• Improved data-aware forms.
• Form Designer's Data Source Pane for assigning data source to forms and widgets. Object tree view for easier navigating within widgets hierarchy.
• Import from CSV files and pasting tabular data from clipboard. Export data to CSV files and copying tabular data to clipboard. Automatic detection of delimiters and column types.
• Improved server connection dialog. Stored connection data.
• Support for images in forms (stored as BLOBs).
• New form widget: multiline editor.
• Improved MS Access (mdb/mde) file import (optional plugin).
• Improved import of server databases to a file-based projects. Entire Kexi projects (not only tables) can be imported too.
• Scripting plugin (Python and Ruby) to extend functionality, including example script for HTML export.
• Simple printouts, print settings and print preview for table and query data.
• Handbook added (incomplete).
• More than two hundreds of overall improvements and bug fixes.
• Kexi 1.0 has been produced by Kexi Team - an international group of independent developers, with assistance and workforce (sponsoring) coming from the OpenOffice Polska company.

Details:

• 1.0.0 Alpha 1
  • Initial Alpha, released on 2005-12-21, together with KOffice 1.5 Alpha 1

• 1.0.0 Beta 1
  • Released on 2006-01-31, together with KOffice 1.5 Beta 1
  • Kexi binary packages provided by some Linux/UNIX vendors are available within KOffice release. Testing Facilities with klik are also available.
  • MS Windows installation package from OpenOffice Polska is available.
  • Full Kexi source code ready to compile can be obtained with instructions here.

• 1.0.0 Beta 2
  • Released on 2006-03-14, together with KOffice 1.5 Beta 2
  • Changes since Beta 1
  • Forms
    • Fixed saving images within forms for MySQL and PostgreSQL databases.
  • Database Drivers
    • MySQL: non-latin1 text data (UTF8 encoded) was not properly retrieved.
    • MySQL, PostgreSQL: entering special characters like ', \, ", \n did not work.
  • CSV Import Dialog
    • Fixed crash when importing CSV files smaller than 200 bytes.
    • Fixed CSV importing for MySQL and PostgreSQL databases.
  • Command-line Options
    • Fixed support for -print-preview option.

• 1.0.0 Release Candidate
  • Released on 2006-03-29, together with KOffice 1.5 Release Candidate

• 1.0.0
  • Released on 2006-04-11, together with KOffice 1.5.0
    • Core Library
      • Fixed possible crash when an object has beed saved with a different name than proposed
      • Field draging: API improved, now both query and table fields/columns can be dragged; added support for multiple fields dragging
      • Added 'higlight object' action for KexiProject(external) (available from property pane)
      • Improved API for reaction on object creation/deletion/renaming
      • applications/x-kexi-connectiondata MIME type defined
      • Internal BLOB storage framework added
      • Fixed autogenerating object names (e.g. tables, queries) based on caption: latin1 base name can be now chosen by translator
      • Plugins: added servicetype property: X-Kexi-SupportsDataExport (boolean); true for tables and queries
      • File dialog's filters now contain only filters that make sense, e.g. there's no "mdb" filter when we're writing to a file.
      • Usability: file dialogs now store recent directory paths in the config file, and this is now used everywhere in Kexi
      • Default extension is properly added when there's multiple filters set in the file dialog
      • Custom "Identifier" property type and editor added (allows only entering identifiers); used in Table/Form/Report Designers
      • Possibility of adding non-db-aware windows/tabs in Kexi
    • Table Designer
      • Fix for 'subType' combo box
      • Avoid possible infinite recursion
      • Selecting non-integer type group using 'type combo' clears PKEY flag, if set
      • Fixed retrieving field captions and descriptions
      • Field captions can be now entered by users instead of names. Field names are then automatically generated.
      • Fixed problem with undo button for subtype combo box
      • Avoid asking twice for saving changes to the design on window closing
      • Find unique name for autogenerated primary key fields
    • Query Designer
      • A few bugs for relationships creation fixed
      • Object combo box now also contain queries (supporting queries is not implemented yet though) the list within the combo is property sorted and grouped; it's reused in 'Data source' tab of the Property Pane; the combo now reacts on deleting/creating/renaming of table or query
      • Fixed redrawing (in an unoptimized way)
      • Conditions: ambiguous expressions fixed: "t1.id > 100" is used instead of "id > 100" in queries like SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.id > 100
      • Fixed possible crash when invalid query design is loaded in design view
      • Fixed switching to design mode after invalid query was opened directly in text mode
      • Eat parentheses on criteria loading, in WHERE conditions like (a.id = value)
      • Also accept tableName.fieldName on criteria loading, not only tableName
      • Also accept e.g. "2 = variable" as condition, not only "variable = 2"
      • Graphical representation of joins is generated back from SQL statement, not only based on explicit query schema's relations but are also retrieved from "t1.f1 = t2.f2" expressions within WHERE section
      • Fixed displaying criteria for table view rows when 'visible' column is set to false
      • All-tables-asterisk is also hidden when last table is hidden
      • Fixed possible crash when switching back from SQL View to Design View
      • Fixed displaying criteria if WHERE section contains '('
      • Tables' positions are preserved if possible when relations view updating is needed