Kexi/Releases/1.0.0 Changes: Difference between revisions

From KDE Community Wiki
< Kexi‎ | Releases
No edit summary
No edit summary
Line 61: Line 61:
****Custom "Identifier" property type and editor added (allows only entering identifiers); used in Table/Form/Report Designers
****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
****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

Revision as of 22:27, 31 August 2023

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