Kexi Changelog

What's new in Kexi 3.2.0

Apr 10, 2019
  • Focus of the 3.2 release has been put on improving stability of KEXI and KEXI frameworks, KDb, KProperty, KReport. API of these frameworks is backward compatible with the 3.1.0 version. It is also is guaranteed to be stable until the 4.0.0 release.
  • Since version 3.1.0 KEXI and the frameworks received about 80 improvements and bug fixes.
  • Documentation of the frameworks has also improved and is available at api.kde.org, although tutorials and reference have to be added in coming releases. KEXI user's manual is outdated as it covers older versions 2.x. We're sorry for the inconvenience and invite volunteers to help out.

New in Kexi 3.0.0 (Oct 10, 2016)

  • Changes in Kexi:
  • 3.0.0 Alpha 1 (2.99.90)
  • Initial Alpha release
  • Ported all modules known from version 2.9.11 except for:
  • map form widget
  • experimental scripts (will be replaced with JavaScript solution in later versions)
  • 3.0.0 Beta 1 (2.99.91)
  • 6a3fe65 Avoid displaying "(I18N_ARGUMENT_MISSING)" for one complicated message
  • c9e6040 Remove unused & outdated check for MarbleControlBox::setMarbleWidget
  • b6bc638 Make update_kexi_breeze_list.sh more generic so it can be easier reused by other projects such as KReport
  • 66011ce If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
  • 3.0.0
  • 6dfcb06 Fix build when KEXI_GIT_SHA1_STRING is defined but not KEXI_GIT_BRANCH_STRING (e.g. on Jenkins build.kde.org)
  • f74a160 Extend full Kexi version info so major.minor.release is also present for unstable, e.g. 2.99.91
  • 8e39416 Make command line options work again Task #3805
  • b29e54f Show the Welcome page at startup 100ms later to fix vertical position issue
  • 4a07af5 Port QRegExp to QRegularExpression in Kexi (Task #1767)
  • 1a3b13e Add "Switch Application Language" action to the global action collection
  • 6591eb2 Disable extra actions that may be in conflict with the Welcome page (e.g. Donate)
  • 8880ecb Fix moving to another field if input mask is present (for table cell and form widget)
  • e43e8e4 Fix broken input and display of Date/Time values in Kexi tables and forms (Task #3901, Review #2924)
  • Changes in KDb:
  • 3.0.0 Alpha 1 (2.99.2)
  • Initial Alpha release, contains the same features as the report designer library of Kexi 2.9.11, plus:
  • support for many SQL scalar functions (see Kexi/Plugins/Queries/SQL_Functions)
  • general-purpose API
  • 3.0.0 Beta 1 (2.99.3)
  • 6fbd390 Find python for SDC
  • d6c5178 Output KDb plugins to a co-installable build subdir
  • 862a5e0 Output SQLite extension relative to KDb plugins co-installable build subdir
  • cb1e6da KDbTestUtils: don't crash when driver not found
  • e222064 KDbCreateSharedDataClasses: display message when Python interpreter missing
  • 83cf3f9 Test correctness of KDbDriverManager when no drivers are found
  • 1c79d93 If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
  • 3.0.0
  • abe0859 Set versions of drivers to 3.0 to match KDb version
  • d846d96 Add KDB_STABLE_VERSION_* macros
  • fbb9814 Check for exact version of drivers in manager
  • 284b480 Port QRegExp to QRegularExpression (Review #2867)
  • 0f1377f Fix INSERT prepared statement support for SQLite
  • Changes in KProperty:
  • 3.0.0 Alpha 1 (2.99.2)
  • Initial Alpha release, contains the same features as the property editor library of Kexi 2.9.11, plus:
  • general-purpose API
  • 3.0.0 Beta 1 (2.99.3)
  • 347a580 If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
  • 1bd714b Get git rev and branch even if property widgets are not built
  • 3.0.0
  • b582a74 Improve look of the boolean editor and delegate, add null boolean editor to the example
  • 5cef157 Add icons resource file, like in Kexi and KReport
  • 2e40708 kpropertyexample: load global icon resource
  • Changes in KReport:
  • 3.0.0 Alpha 1 (2.99.2)
  • Initial Alpha release, contains the same features as the report designer library of Kexi 2.9.11, plus:
  • reusable API
  • 3.0.0 Beta 1 (2.99.3)
  • 3c25e8e Find python for SDC
  • 6610367 KDbCreateSharedDataClasses: display message when Python interpreter missing
  • de88a18 Fix handling of events when items are selected across scenes
  • d68306a Improve KReportExample main window by combining designer and preview widgets (Review #2795)
  • ce0214a Save/restore visual state of KReportExample
  • 8dec5d3 Show preview at startup in KReportExample
  • a23ddb8 Set layout of KReportView to 0, it's a QWidget so that's better default
  • 623c707 Improve KReportExample main window by combining designer and preview widgets
  • cf3b4c7 KReportExample: move the toolbox to the left
  • 766d14e KReportExample: use more typical kde.org config folder, set names for the dock and toolbars for better config handling
  • 9566a36 KReportExample: Write settings to kde.org/ dir, not org.kde/
  • 56bc035 KReportExample: Set organization domain and use it (and app name) in QSettings
  • 3b0548a KReportExample: Use KReport version as the KReportExample app's version
  • f49a302 If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
  • 3.0.0
  • 958714f Make KReport use resource files for icons (Task #T3666, Review #2860)
  • eac7b89 Fix page navigation
  • 5e8cbbf Initial port of web plugin to Qt5/KReport3/QtWebEngine (Task #3565, Review #2863)
  • 463827a Fix icon name to kreport-web-element

New in Kexi 2.9.11 (Feb 4, 2016)

  • Featured story: A commercially developed upgrade for MS Access (MDB) Import to Kexi has been donated by Jarosław Staniek (wish 277583). This also fixes import of primary keys (bug 336560). Large Access databases such as the Northwind sample now import better than ever.
  • Other Improvements:
  • Main Window:
  • Make Global Search list should wider to fit the names (bug 358203).
  • Make the default “Smallest readable font” used by Kexi in property editor, toolbar, etc.; allow to specify size using points; no longer depend on screen resolution (bug 358662).
  • Tables:
  • Do not switch to Data View if fetching records failed, and show more clear message. This fixes crash at the attempt to create a table row when table is invalid due to use of a reserved word or failed data fetching (bugs 356888 and 357025). The same category of errors are now also fixed for queries, forms, reports, and CSV export.
  • Fix alignment of table view combo boxes when rows or columns are scrolled (bug 357655).
  • Make combo box popups for tabular view fit in the current screen (bug 357682).
  • Queries:
  • Switching off the visibility of query fields no longer hides data in the last field. This is a fix for SQLite, MySQL, PostreSQL, Sybase/MSSQL (bug 346839).
  • Fix possible crash due to missing removal of cached field information.
  • Support queries having the same field name used in multiple tables (bug 340056).
  • Make "Save button" enabled when going from SQL view to Data and back to SQL (bug 278379).
  • Fix: Changes in query design not retained after changes in SQL view and switching to Data view (bug 358413).
  • Make SQL queries work; also for convenience if either argument is of text type, operator “+” is now assumed to be identical to operator “||”; also fix for MySQL using CONCAT() (bug 358636).
  • Better check result of parsing SQL statements.
  • Make query parameters also work in COLUMNS section, e.g. works now (bug 348473).
  • Fix switching to Data View when using table aliases (bug 278414).
  • Forms:
  • Add sorting to Forms. Current record is unchanged but its index most likely changes, what can be observed in the record navigator (bug 150372).
  • Reports:
  • Fix retrieval of aggregate report values for queries: fix possible crash when changing data source, support tables and queries having the same names, better recognize if report was modified (reviews D764 and D765).
  • Fix handling latitude property for scripting in Report Map element.
  • Fix possible memory leaks (review D780).
  • Allow jump to report page (bug 357217).

New in Kexi 2.9.7 (Sep 8, 2015)

  • General:
  • Fix vertical alignment of text in command link button widgets, it was especially broken in Breeze widget style
  • Tables:
  • Restore ability of altering table design. This was serious regression present in Kexi 2.9.5 and 2.9.6. (bug 350457)
  • Queries:
  • Don’t force saving when switching never stored query to Data view (on 2nd try)
  • CSV Import:
  • Fix detection of primary key column on CSV import (bug 351487)
  • Fix updates of primary key detection when value of ‘Start at line’ changes
  • SQLite databases:
  • Better results and error reporting for prepared statements

New in Kexi 2.9.6 (Jul 12, 2015)

  • General:
  • Fix renames for file storing the Welcome status bar’s GUIs
  • Recent Projects: use file’s base name as a good replacement for caption when caption is not available
  • Fix left margin for the global search box (dependent on style); also react on changing widget style
  • Fix possible crash caused by command line arguments passed to Kexi in a wrong way
  • Fix crash appearing when the –hide-menu command line option is used
  • Queries:
  • Fix possible crash in result handling of queries
  • SQLite databases:
  • Fix compacting databases (properly rename files back to the original name)
  • PostgreSQL databases:
  • Fix crash when importing a PostgreSQL database to a .kexi file (bug 349156)

New in Kexi 2.9.4 (May 8, 2015)

  • General:
  • Close window with object that will be overwritten after “Save as” (bug 344656)
  • Remove “dirty” flag when saving-as modified Kexi object (bug 344653)
  • Save recent position and size of the Kexi Find dialog. It has now minimal size to avoid covering too much of the content. (bug 345689)
  • Properly destroy Kexi’s main window on closing. This lets to properly save settings and clean up.
  • Activate Design tab on switching to design mode (if no other tab was explicitly selected for this window & mode) (bug 335900)
  • Query Designer:
  • Allow to switch from the Design view containing empty query to the SQL view (bug 344654)
  • Show “Incorrect query” message when switching to Data view from Kexi SQL containing an empty statement. Before unclear “Switching view failed” message was presented.
  • Avoid crash in Kexi text editor when text component couldn’t be loaded (applies to script editors too) (bug 346373)
  • Forms:
  • Fix computing type for widget properties. If the custom type is invalid or auto (unspecified), use what Qt properties define. If still undefined, default is the String type, not a pixmap. This fixes at least the map widget’s properties latitude/longitude that were handled as pixmaps.
  • Fix logic for adding new records for Kexi tables and forms. (bug 345210)
  • Map widget: set double type for latitude/longitude properties, and set precision to 7 digits
  • Map widget: improve translation of latitude, longitude, zoom and theme property names
  • Map widget: theme always defaults to Earth and is now a list of all available themes
  • Map widget: property editor’s spin box is now accessible as a slider
  • Map widget: don’t start editing in response to resize events
  • Report:
  • Map element: properly encode unit name (°)
  • Map element: set double type for latitude/longitude properties, and set precision to 7 digits
  • Map element: improve translation of latitude, longitude, zoom and theme property names
  • Map element: theme always defaults to Earth and is now a list of all available themes
  • Map element: property editor’s spin box is now accessible as a slider
  • CSV Import:
  • Usability improvements:
  • Enable single selection of table cells (“current” cell indicator is not visible in Breeze style)
  • Display font of edited column names in bold also during editing
  • Allow editing only first row (column names) but also when “First row contains column names” is off; this let’s the user to fully customize column names before importing
  • Use “Column ” column caption and “column_” column name for empty names

New in Kexi 2.9.1 (Mar 16, 2015)

  • General:
  • Show clear buttons in line edits of the Object Name dialogs.
  • Use consistent style of title naming in window tabs.
  • Fix status bar online updates when e.g. /tmp is on different partition than /home.
  • Fix crash on backward search (bug 337015)
  • Database handling:
  • Fix compacting of .kexi files when e.g. /tmp is on different partition than /home.
  • Tables:
  • Show “No field selected” hint on first use of an empty Kexi table designer.
  • Queries:
  • Make SUBSTR(X, Y [, Z]) built-in SQL function work (bug 333206)
  • Remember and restore dirty flag equal to false while changing modes, e.g. this fixes the flag state when the query designer is opened in SQL view and the visual view fails to open.
  • Reports:
  • Map theme can be picked from the property editor
  • Add keyboard shortcuts for copy/paste/cut/delete actions (bug 334967)
  • Cut action should make the report design dirty.

New in Kexi 2.9.0 (Feb 27, 2015)

  • Kexi, visual data-oriented apps builder received over 150 improvements that make it extra stable and easy to use.

New in Kexi 2.8.7 (Dec 4, 2014)

  • General:
  • Improve main menu widget for QtCurve style.
  • Display "git" version in application’s About box.
  • Fix for Mac OS X build.
  • Fix position of the Calligra logo based on height of the main menu. (bug 340767)
  • Ask for password if needed when Test Connection button is clicked in Kexi. (details)
  • Fix checking for file overwriting on file creation. (details)
  • Fix a few memory leaks and uninitialized variables.
  • Make the main tabbed toolbar more modern, make it work better with more styles (including KDE’s next style Breeze)
  • Forms:
  • Hide some form unnecessary widget properties in Property Editor. (bug 339246)
  • Fix handling of Ctrl+PageUp/PageDown shortcuts in forms. (bug 338663)
  • Reports:
  • Add possibility of creating Kexi reports elements no matter where mouse was pressed and where it was released. Also avoid setting too small size of elements and drawing them outside of the report area. (bug 334967)
  • Fix bug in report toolbox: first element after separator did not function as on/off.
  • Fix old regression: reintroduce report chart plugin (link)
  • Improve UX of Report Designer: better styling of section titles: colors, icons, size; draw them in inactive color when focus is out; switch between sections also when titles are clicked or sections resized.
  • Fix width of ruler in “Detail” section of the Report Designer. (bug 338942)

New in Kexi 2.8.6 (Sep 25, 2014)

  • Fix logic behind visibility of editing indicator in tabular and form views
  • Make Next and Last button in Page selector of Report data view to be disabled on last page.
  • Fix build error on OpenBSD operating system (missing include directory for ICU).
  • Fix row selection/highlighting when clicking/hovering over record marker. (bug 337914)
  • Fix an issue with resolving version of plugins (at least) on Linux.
  • Improve behaviour of tabbed toolbar when Design Tab is present.
  • Avoid displaying actions for parts that do not create objects.
  • Set labels to right in the Find dialog.
  • Fix a crash when pressed Tab on a form with one date picker. (bug 338766)
  • Avoid crashes when closing Kexi views.
  • Allow to create report items of specific size using mouse drag. (bug 334967)
  • Fix crash in Report designer.
  • Fix possible crash on opening report with a barcode element.
  • Fix icon alignment in Kexi record navigator buttons.
  • Add running desktop name and version to the feedback agent. Recognizes Plasma 4 and 5 at least.
  • Position pasted report element with an offset to the active element or to the corner. (bug 334967)
  • Add donations info to Kexi’s status bar. Currently only opens a BountySource page.
  • Improve experience by adding a dedicated database password dialog.
  • Avoid keeping potentially wrong password entered in the password dialog. We don’t want to re-use it.
  • Improve default size of modal assistant dialogs.
  • Hide system PostgreSQL (postgres) and MySQL (performance_schema) databases from the visible database list.
  • Use consistent sorting of unicode text values. (bug 338808)
  • Fix background opacity handling and new background/foreground’s defaults for report elements.
  • Many fixes for Kexi’s Database Import assistant (bugs 336556, 336557, 336558):
  • When needed ask for password to access source or destination servers.
  • Reload source database list if user pressed back and selected different connection.
  • Improve saving recent directories.
  • Do not ask twice about destination filename.
  • In addition to title, properly ask for database name for server destination databases.
  • Properly open imported database (file).

New in Kexi 2.4.4 / 2.5.5 (Jan 28, 2013)

  • General:
  • 2.5.5: A few build issues on Windows.
  • Sheets:
  • 2.4.4 and 2.5.5: A very nasty bug which made recalculations of spreadsheet contents go wrong under some circumstances (BUGS: 312981, 313010)
  • Kexi:
  • Kexi Forms:
  • 2.5.5: Description was ignored in Command Link button
  • 2.4.4: Make palette background color property in text editor work (BUG: 309274)
  • 2.4.4: Fix “data source tag” for text box (regression because of changes in KDE libraries’ line editor)
  • 2.4.4: SQLite Driver: Fix possible data loss of compacted file (when process tools crash or fail for any reason)
  • 2.4.4: Remove limit of 101 fields in Kexi Table Designer (BUG: 309116)
  • 2.4.4 and 2.5.5: Fix MySql login failure when not saving password – fix for case 3.1 (BUG: 313025)
  • 2.4.4 and 2.5.5: Fix possible crash when pressing tab in the global search box
  • 2.5.5: Property editor: make items are always sorted by key