Kexi/Releases: Difference between revisions

From KDE Community Wiki
No edit summary
(43 intermediate revisions by the same user not shown)
Line 1: Line 1:
See also: [[Kexi/Schedules|Schedules]] | [[/2/|Kexi 2 releases]]
See also: [[Kexi/Schedules|Schedules]] | [[/2/|Kexi 2 releases]] | [[../Building/|Building]]


For general convenience frameworks used in Kexi (KDb, KProperty, KReport), tend to be released in the same time and are prepared for standalone use.
In addition to Kexi, for benefit and convenience of fellow software engineers, we're sharing frameworks originally developed within the Kexi Project (that is [[KDb]], [[KProperty]], [[KReport]]). There are marked with the same version as Kexi and are prepared for general, standalone usage. For general convenience the frameworks tend to be released in the same time as Kexi.


Kexi 3 offers the same list of features as Kexi 2. Exceptions: no scripting (in Kexi 2 it was present as experimental).
{{Note|Check out you Linux distribution for binary packages, or tell your distributor if they are missing. Universal packages for Windows will come be a bit later.}}
 
{{Note|Download universal '''[[../Snapshots/]]''' ready to use for Linux.}}
 
Kexi 3 offers the same list of features as Kexi 2 and uses the same format for <tt>.kexi</tt> files and server projects. Exceptions: no scripting (in Kexi 2 it was present as experimental) and (in 3.0) no "map" elements. Further Kexi version would of course get new features not present in Kexi 2.
 
<div style="background-color:red;color:white;display:inline-block;padding:0.5em;">'''&nbsp;[[Kexi/Contact#Donations|Donate to Kexi directly, pick a fix or feature you want]]'''</div><br/>


__TOC__
__TOC__


== 3.0.0 Downloads ==
== 3.0.0 ==
=== 3.0.0 Alpha 1 ===
 
=== 3.0.0 Downloads ===
Note: source code downloads. The code is known to build and run  with Linux (gcc, clang) and MS Windows (msvc).
 
Click [[/Signatures/|here]] for info about signature verification.
 
You can also download universal [[../Snapshots/]] ready to run on Linux.
 
==== 3.0.0 Alpha 1 ====
September 14, 2016
September 14, 2016
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
Line 24: Line 38:
|}
|}


=== 3.0.0 Beta 1 ===
==== 3.0.0 Beta 1 ====
September 19, 2016
September 19, 2016
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
Line 40: Line 54:
|}
|}


=== 3.0.0 ===
==== 3.0.0 Final ====
October 5, 2016
October 5, 2016
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
Line 56: Line 70:
|}
|}


== 3.0.0 Changes ==
=== 3.0.0 Changes ===
Changes in Kexi
 
'''Changes in Kexi'''
* 3.0.0 Alpha 1 (2.99.90)
* 3.0.0 Alpha 1 (2.99.90)
** Initial Alpha release
** 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)
* 3.0.0 Beta 1 (2.99.91)
** {{commit|kexi|6a3fe65}} Avoid displaying "(I18N_ARGUMENT_MISSING)" for one complicated message
** {{commit|kexi|6a3fe65}} Avoid displaying "(I18N_ARGUMENT_MISSING)" for one complicated message
Line 69: Line 81:
** {{commit|kexi|66011ce}} If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
** {{commit|kexi|66011ce}} If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
* 3.0.0
* 3.0.0
** TODO
**'''New:''' Completely new PostgreSQL database driver, based on libpq. The old one less stable based on libpqxx is discontinued.
**'''New:''' Many improvements in handling database migration, importing e.g. from MS Access to MySQL, then to PostgreSQL, then to SQLite is much more reliable than in Kexi 2.
**'''New:''' Most icons now use the Breeze theme, Kexi is now optimized for this theme as well as the Breeze widget style, and this is the default look.
**{{commit|kexi|6dfcb06}} Fix build when KEXI_GIT_SHA1_STRING is defined but not KEXI_GIT_BRANCH_STRING (e.g. on Jenkins build.kde.org)
**{{commit|kexi|f74a160}} Extend full Kexi version info so major.minor.release is also present for unstable, e.g. 2.99.91
**{{commit|kexi|8e39416}} Make command line options work again {{task|3805}}
**{{commit|kexi|b29e54f}} Show the Welcome page at startup 100ms later to fix vertical position issue
**{{commit|kexi|4a07af5}} Port QRegExp to QRegularExpression in Kexi ({{task|1767}})
**{{commit|kexi|1a3b13e}} Add "Switch Application Language" action to the global action collection
**{{commit|kexi|6591eb2}} Disable extra actions that may be in conflict with the Welcome page (e.g. Donate)
**{{commit|kexi|8880ecb}} Fix moving to another field if input mask is present (for table cell and form widget)
**{{commit|kexi|e43e8e4}} Fix broken input and display of Date/Time values in Kexi tables and forms ({{task|3901}}, {{diff|2924}})


Changes in KDb
 
'''Changes in KDb'''
* 3.0.0 Alpha 1 (2.99.2)
* 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:
** Initial Alpha release, contains the same features as the report designer library of Kexi 2.9.11, plus:
Line 85: Line 109:
** {{commit|kdb|1c79d93}} If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
** {{commit|kdb|1c79d93}} If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
* 3.0.0
* 3.0.0
** TODO
**{{commit|kdb|abe0859}} Set versions of drivers to 3.0 to match KDb version
**{{commit|kdb|d846d96}} Add KDB_STABLE_VERSION_* macros
**{{commit|kdb|fbb9814}} Check for exact version of drivers in manager
**{{commit|kdb|284b480}} Port QRegExp to QRegularExpression ({{diff|2867}})
**{{commit|kdb|0f1377f}} Fix INSERT prepared statement support for SQLite
 


Changes in KProperty
'''Changes in KProperty'''
* 3.0.0 Alpha 1 (2.99.2)
* 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:
** Initial Alpha release, contains the same features as the property editor library of Kexi 2.9.11, plus:
Line 95: Line 124:
** {{commit|kproperty|1bd714b}} Get git rev and branch even if property widgets are not built
** {{commit|kproperty|1bd714b}} Get git rev and branch even if property widgets are not built
* 3.0.0
* 3.0.0
** TODO
**{{commit|kproperty|b582a74}} Improve look of the boolean editor and delegate, add null boolean editor to the example
**{{commit|kproperty|5cef157}} Add icons resource file, like in Kexi and KReport
**{{commit|kproperty|2e40708}} kpropertyexample: load global icon resource
 


Changes in KReport
'''Changes in KReport'''
* 3.0.0 Alpha 1 (2.99.2)
* 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:
** Initial Alpha release, contains the same features as the report designer library of Kexi 2.9.11, plus:
Line 117: Line 149:
** {{commit|kreport|f49a302}} If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
** {{commit|kreport|f49a302}} If git information is not available try ${CMAKE_SOURCE_DIR}/GIT_VERSION
* 3.0.0
* 3.0.0
** TODO
**{{commit|kreport|958714f}} Make KReport use resource files for icons ({{task|T3666}}, {{diff|2860}})
**{{commit|kreport|eac7b89}} Fix page navigation
**{{commit|kreport|5e8cbbf}} Initial port of web plugin to Qt5/KReport3/QtWebEngine ({{task|3565}}, {{diff|2863}})
**{{commit|kreport|463827a}} Fix icon name to kreport-web-element
 
 
=== 3.0.0 Known issues ===
 
* All modules known from version 2.9.11 has been ported but these are missing:
** map form widget
** experimental scripts (will be replaced with JavaScript solution in later versions)
* {{bug|376970}} Adding table relationships in Query Designer using drag&drop does not work (regression compared to 2.9.x)
 
== 3.0.1==
=== 3.0.1 Downloads ===
Source code downloads. The code is known to build and run  with Linux (gcc, clang) and MS Windows (msvc).
 
Click [[/Signatures/|here]] for info about signature verification.
 
You can also download universal [[../Snapshots/]] ready to run on Linux.
 
March 13, 2017
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
| [[Kexi]]
| {{DownloadUrlSig|stage=stable|project=kexi|ver=3.0.1.1}}
|-
| [[KDb]]
| {{DownloadUrlSig|stage=stable|project=kdb|ver=3.0.1.1}}
|-
| [[KProperty]]
| {{DownloadUrlSig|stage=stable|project=kproperty|ver=3.0.1}}
|-
| [[KReport]]
| {{DownloadUrlSig|stage=stable|project=kreport|ver=3.0.1}}
|}
 
=== 3.0.1 Changes ===
'''Changes in Kexi'''
 
Highlight: Kexi has a few minor memory problems fixed and adds more icons of form widgets for its new standard Breeze theme. In Table Designer altering physical table design has been fixed when lookup fields are in use. Relationships creation using drag & drop has been fixed in Query Designer. There are no new features.
 
*General
**{{commit|kexi|2fbb864}} Make project navigator's "single click" mode work on Windows
**{{commit|kexi|d5aae07}} Use the only supported style (breeze) on Windows and Mac
**{{commit|kexi|e57a6bc}} Make the Status Bar not using KIO copy on Windows (to simplify the runtime)
**{{commit|kexi|b5b757b}} {{commit|kexi|343fd44}} Fix memory leaks related to project migration
**{{commit|kexi|bd39e8a}} Limit size of application icon on Mac
*Table Designer
**{{commit|kexi|06f4c2f}} Fix altering physical table design when lookup fields are in use ({{bug|371958}})
*Query Designer
**{{commit|kexi|798caf7}} Fix adding table relationships in Query Designer using drag&drop (regression since 3.0) ({{bug|376970}}, {{task|5473}}, {{diff|4913}})
*Form Designer
**{{commit|kexi|255b874}} Update button form widget icon (32px)
**{{commit|kexi|93d0b68}} Add breeze icons for combobox form widget
**{{commit|kexi|3a9d4fc}} Add breeze icons for frame form widget
**{{commit|kexi|70632f0}} Add breeze icons for tab widget and page
**{{commit|kexi|802d3df}} Add breeze icons for groupbox widget
**{{commit|kexi|55de5d8}} Add breeze icons for data source tag
**{{commit|kexi|601af3f}} Fix handling mouse release in forms
*Buildsystem
**{{commit|kexi|efae6bd}} Make it possible to find PostgreSQL 9.6
**{{commit|kexi|a7374e3}} Improve icons lookup when Kexi is run without installing
**{{commit|kexi|40d0808}} Improve searching for the MySQL migration build dependencies
**{{commit|kexi|8e54268}} Keep apps in the same bin dir so resources that are kept relative to this dir can be found without installing
 
'''Changes in KDb'''
*General
**{{commit|kdb|60059e2}} Check result of closing database while testing connection (ConnectionTestThread)
**{{commit|kdb|6888f59}} Make it possible to set row source values for lookup column back to empty list
**{{commit|kdb|a838c60}} Fix setting properties for lookup column (record source related) ({{bug|371958}})
**{{commit|kdb|00a5688}} Fix identifying table properties as related to lookup field ({{bug|371958}})
**{{commit|kdb|3affb95}} Add safer debug for large values (internal in 3.0.1)
*PostgreSQL support
**{{commit|kdb|8f1a6ce}} Fix database cursors for PostgreSQL: remove use of uninitialized variable ({{bug|371331}})
**{{commit|kdb|141931a}} Fix error on repeated loading of "fuzzystrmatch" extension for the PostgreSQL driver
*Buildsystem
**{{commit|kdb|6791780}} Make it possible to find PostgreSQL 9.6
**{{commit|kdb|43723b4}} Improve support for Qt Translation catalogs (use ecm_install_po_files_as_qm macro)
**{{commit|kdb|8941221}} Fix finding KDb config (use ecm_configure_package_config_file macro)
**{{commit|kdb|68d8ae9}} Add PROJECT_STABLE_VERSION_PATCH constant, extend logic for PROJECT_STABLE* constants
**{{commit|kdb|55f3020}} Improve discovery of PostgreSQL library on Windows
**{{commit|kdb|5923022}} Improve searching for the MySQL driver build dependencies
**{{commit|kdb|b29dc79}} SDC: initialize all variables in from-map constructors regardless of errors, add {} to conditions, improve spacing
**{{commit|kdb|156f898}} Suppress warnings about duplicated drivers if KDB_NO_DUPLICATED_DRIVER_WARNINGS environment variable is set
 
'''Changes in KProperty'''
*General
**{{commit|kproperty|fef75cc}} Make standard icon location a list of unique paths
**{{commit|kproperty|bc30325}} Try to find private icons resource in a dir relative to local bin/
**{{commit|kproperty|b0d7688}} Try to locate rcc files in PATH subdirs too, useful for running apps from the build dir, without installing
**{{commit|kproperty|1f937b9}} There is only one translation catalog currently, load with kpropertycore
**{{commit|kproperty|867e84e}} Add PainterSaver and use it to avoid problems with missing QPainter::restore()
**{{commit|kproperty|9e5396c}} Fix painting grid over scroll areas
**{{commit|kproperty|522b31d}} Fix crash when while removing property that has non-lowercase character in its name
*Examples
**{{commit|kproperty|261a23c}} Fix KPropertyExample when KF5 is not in use
**{{commit|kproperty|b0e48fd}} Make property editor read-only if property or property set is read-only
**{{commit|kproperty|3334295}} Add all PROJECT_STABLE* constants
*Buildsystem
**{{commit|kproperty|b175941}} macro kproperty_add_icons_rcc_file: generate rcc icons in the builddir/bin/data/icons/ dir so it can be used within the builddir
**{{commit|kproperty|8e6fc02}} Keep apps in the same bin dir so resources that are kept relative to this dir can be found without installing
**{{commit|kproperty|d2ebc72}} Use ecm_install_po_files_as_qm macro for Qt Translation catalogs
**{{commit|kproperty|b99d584}} Fix finding KProperty configs - use ecm_configure_package_config_file macro
 
'''Changes in KReport'''
*General
**{{commit|kreport|ced8679}} Add 24x24 icons, useful on classic Windows
**{{commit|kreport|3a47f64}} Try to locate rcc files in PATH subdirs too, useful for running apps from the build dir, without installing
**{{commit|kreport|b76828c}} Fix async rendering of map item ({{diff|3028}})
**{{commit|kreport|ba2223a}} Add all PROJECT_STABLE* and KREPORT_TESTING_EXPORT constants
**{{commit|kreport|b38de8a}} Synchronize plugin versions with KReport version: 3.0
**{{commit|kreport|df25b82}} Check for plugin versions and duplicates in the plugin manager
**{{commit|kreport|e5d6e47}} Fix uninitialized variables in KReportItemMaps()
**{{commit|kreport|e939571}} Fix uninitialized variables in KReportItemText(), OROCheck(), KReportPluginMetaData::Private()
**{{commit|kreport|aae22cd}} Add checks for nullptrs in KReportItemWeb, KReportItemMaps, KReportItemChart
**{{commit|kreport|71beded}} Add missing initializations in KReportSectionData
**{{commit|kreport|7beabb7}} Add missing initializations in KReportItemBarcode
**{{commit|kreport|e9a20cd}} Add BoundedTextItem init, make the type qreal [0..1] for consistency with Qt
**{{commit|kreport|d721688}} Keep apps in the same bin dir so resources that are kept relative to this dir can be found without installing
*Buildsystem
**{{commit|kreport|388828a}} macro kreport_add_icons_rcc_file: generate rcc icons in the builddir/bin/data/icons/ dir so it can be used within the builddir
**{{commit|kreport|6e9ff95}} Use ecm_install_po_files_as_qm macro for Qt Translation catalogs
**{{commit|kreport|ff46de3}} Fix finding KReport config - use ecm_configure_package_config_file macro
 
=== 3.0.1 Known issues ===
* {{bug|377579}} Criterias cannot be saved in Query Designer (regression compared to 2.9)
 
== 3.0.2==
=== 3.0.2 Downloads ===
Source code downloads. The code is known to build and run  with Linux (gcc, clang) and MS Windows (msvc).
 
Click [[/Signatures/|here]] for info about signature verification.
 
You can also download universal [[../Snapshots/]] ready to run on Linux (last version is from May 2017).
 
Aug 11, 2017
{| cellpadding="3" cellspacing="3" style="margin-left:2em;"
| [[Kexi]]
| {{DownloadUrlSig|stage=stable|project=kexi|ver=3.0.2}}
|-
| [[KDb]]
| {{DownloadUrlSig|stage=stable|project=kdb|ver=3.0.2}}
|-
| [[KProperty]]
| {{DownloadUrlSig|stage=stable|project=kproperty|ver=3.0.2}}
|-
| [[KReport]]
| {{DownloadUrlSig|stage=stable|project=kreport|ver=3.0.2}}
|}
 
=== 3.0.2 Changes ===
'''Changes in Kexi'''
 
Highlight: Kexi has a number of general user interface and usability improvements. Some fixes for problems that appeared in version 3.0.0, including backward-compatibility. There are further improvements to the query designer (WHERE conditions and switching between views). Forms and reports also benefit from improvements of queries. Kexi now works better under non-KDE Plasma desktops such as XFCE, what can also have benefits on MS Windows. There are no new features apart from auto-opening command line options that work again.
 
*General
**{{commit|kexi|3c210bdc8}} Don't move to first Project navigator's item when last object tab is closed (usability fix)
**{{commit|kexi|6a218a1fb}} Improve detection of desktop type and use it in file dialogs and the Feedback Agent
**{{commit|kexi|d5b7a5e21}} Detect single click setting for XFCE
**{{commit|kexi|3bcc45629}} Fix appearance of Kexi tabbed toolbar for gtk2 style used by XFCE
**{{commit|kexi|a41b632d5}} Make auto-opening command line options work for Kexi again ({{bug|378418}}, {{diff|5322}})
**{{commit|kexi|0a03c3e6d}} Fix regression since 3.0.0: store, copy and update user settings for objects, e.g. column widths
**{{commit|kexi|5de2b558b}} Fix regression since 3.0.0: Keep compatibility with older format versions regarding the storage for object type
**{{commit|kexi|90ee47e08}} Fix regression since 3.0.0: Allow to change name and caption of objects ({{bug|379078}})
**{{commit|kexi|499fbf454}} Close window before renaming object on user's request
**{{commit|kexi|08665e10a}} Fix background of the Kexi button for fusion style
**{{commit|kexi|dc7cc8c61}} Fix vertical alignment of the record navigator ({{bug|379844}})
**{{commit|kexi|373d8f4e9}} Return invalid URL when open/save image dialog was canceled
**{{commit|kexi|c5603739a}} Improve image chooser for properties of type Pixmap: display "all supported files" ({{bug|379073}})
*Table Designer
*Query Designer
*{{commit|kexi|ce88fbae8}} {{commit|kexi|464196eac}} {{commit|kexi|24dccc710}} Improve WHERE conditions handling in query designer ({{bug|377579}}, {{diff|5295}})
**{{commit|kexi|ac6b9a503}} Fix updating SQL statement in SQL designer after switching from other views and property revert to previous SQL ({{bug|377579}})
*Form Designer
**{{commit|kexi|236681be7}} Make check boxes two-state by default because this covers 99% of use cases. It is also Qt's default.
**{{commit|kexi|6192dbc38}} Don't set any special minimum size for checkbox form widgets, users may want to set specific small size ([https://forum.kde.org/viewtopic.php?f=221&t=139397&p=373827#p373827 link])
**{{commit|kexi|7e5f20b83}} Fix geometry of the combo box ({{bug|265330}}, {{diff|5486}})
**{{commit|kexi|22e905861}} Make it possible to use vertical alignment property in Text Box form widgets
**{{commit|kexi|e0bf19825}} Fix possible crashes in form's undo/redo actions, make them properly work with alignment properties of widgets ({{bug|380175}}, {{diff|5969}})
*Report Designer
**{{commit|kexi|ce88fbae8}} {{commit|kexi|24dccc710}} Improve WHERE conditions handling in report designer ({{bug|377579}}, {{diff|5295}})
**{{commit|kexi|6e3ada33e}} Hide GUI actions for not implemented export to ODF Text and Spreadsheet formats ({{task|4075}}, {{diff|5846}})
*Buildsystem
**{{commit|kexi|07fddc66d}} {{commit|kexi|ea10b879e}} Fix build for macOS ({{bug|377662}})
**{{commit|kexi|5050ca2b9}} Detect PostgreSQL 10
*Tests
**{{commit|kexi|43724947a}} Search for resource file in bin/data also on non-Windows so tests work OK without installation of the project
 
 
'''Changes in KDb'''
*General
**{{commit|kdb|9730fa06}} Fix possible issue: the WHERE condition can be lost while converting query to SQL. This can be seen in Kexi Query Designer.
**{{commit|kdb|c7dfaa15}} Validate query and offer error message/description while setting or extending WHERE conditions
**{{commit|kdb|d81e9a1e}} Fix WHERE conditions handling ({{diff|5294}})
**{{commit|kdb|875de031}} Make query parameters also work in COLUMNS section. Kexi query parameters do not work in COLUMNS section, e.g. this won't work ('invalid query' error appears): SELECT [Param]. The parameters work only in the WHERE section, e.g. SELECT 123 WHERE [Param] = 1. Port calligra commit 5c0d3ee52fd. ({{bug|348473}})
**{{commit|kdb|a8907bc8}} Support queries such as "SELECT FROM table WHERE condition" for completeness
*Buildsystem
**{{commit|kdb|3572da40}} Add detection for PostgreSQL 10
**{{commit|kdb|dd4a21fc}} Improve information about recommended packages (for drivers, python, etc.)
**{{commit|kdb|dd4a21fc}} Improve SQLite detection
**{{commit|kdb|c62c4296}} FindMySQL script: for Windows use "ProgramFiles(x86)" environemnt variable to locate "Program Files (x86)" folder and find MySQL/MariaDB libs there
**{{commit|kdb|e7bc7bbe}} FindMySQL script: fix it if CMAKE_BUILD_TYPE is not specified (Windows)
*Tests
**{{commit|kdb|6157a64b}} Fix HeadersTest for paths containing spaces
**{{commit|kdb|87dad272}} Add tests related to query parameters to the parser test
 
 
'''Changes in KProperty'''
*General
**{{commit|kproperty|2d1c35c}} Fix comparing double values: use "precision" option instead of "step" option
**{{commit|kproperty|c5e550c}} Improve checking for validity of min/max/step/precision options for date/time/double types
**{{commit|kproperty|f8ed63a}} Fix strikeout/underline font option not available in font dialogs. These options are missing in font dialogs on non-Plasma, non-Windows desktops, e.g. XFCE which has too simplified dialog. The solution is to force using Qt's own dialog ({{bug|379190}}).
**{{commit|kproperty|72a91e6}} Pixmap editor: fix display preview of pixmap value on mouse click
**{{commit|kproperty|4e4c1a6}} Pixmap editor: improve size of the (...) button
**{{commit|kproperty|6267e71}} Pixmap editor: don't display taskbar entry on Windows for the popup, use Tooltip palette
*Buildsystem
**{{commit|kproperty|eb8c218}} Do not check for Sailfish OS since its version 2.1
*Tests
**{{commit|kproperty|cb08dd6}} Fix HeadersTest for paths containing spaces
 
 
'''Changes in KReport'''
*General
**{{commit|kreport|1a2bbd68ba}} New: Port the Group dialog widget from Qt 4. ({{task|6182}}, {{diff|5948}})
**{{commit|kreport|38e3041629}} Fix loading of pen style data ({{bug|378561}}, {{diff|5391}})
**{{commit|kreport|3620452d2b}} Improvements of handling pen width. Set step value of 1.0.
**{{commit|kreport|147c7300a8}} Improve accuracy of line weight property.
**{{commit|kreport|12a075a564}} Fix initialization of report elements created by user, e.g. barcodes had invalid default settings ({{diff|5435}})
**{{commit|kreport|28ed4d6ca3}} Fix possible crashes while switching from design view to preview ({{diff|5508}})
**{{commit|kreport|0ab6d76ef2}} Improve detection of scripting. Always save the script, regardless of whether or not the object script is empty, this way and default to the original script, unless the object script has been changed so the original interpreter should be saved properly. ({{task|668}}, {{diff|5700}}, {{task|6183}}, {{diff|5965}})
**{{commit|kreport|0ac1422c46}} {{commit|kreport|78cf5a7164}} Set the default interpreter to JavaScript if empty
 
*Buildsystem
**{{commit|kreport|efe3670072}} Make sure KProperty* libs are not newer than 3.0.x
*Tests
**{{commit|kreport|315c86d6ad}} Fix HeadersTest for paths containing spaces
 
=== 3.0.2 Known issues ===
* See bit.ly/kexibugs

Revision as of 15:16, 11 August 2017

See also: Schedules | Kexi 2 releases | Building

In addition to Kexi, for benefit and convenience of fellow software engineers, we're sharing frameworks originally developed within the Kexi Project (that is KDb, KProperty, KReport). There are marked with the same version as Kexi and are prepared for general, standalone usage. For general convenience the frameworks tend to be released in the same time as Kexi.

Note

Check out you Linux distribution for binary packages, or tell your distributor if they are missing. Universal packages for Windows will come be a bit later.


Note

Download universal Snapshots ready to use for Linux.


Kexi 3 offers the same list of features as Kexi 2 and uses the same format for .kexi files and server projects. Exceptions: no scripting (in Kexi 2 it was present as experimental) and (in 3.0) no "map" elements. Further Kexi version would of course get new features not present in Kexi 2.


3.0.0

3.0.0 Downloads

Note: source code downloads. The code is known to build and run with Linux (gcc, clang) and MS Windows (msvc).

Click here for info about signature verification.

You can also download universal Snapshots ready to run on Linux.

3.0.0 Alpha 1

September 14, 2016

Kexi kexi-2.99.90-1.tar.xz (signature)
KDb kdb-2.99.2.tar.xz (signature)
KProperty kproperty-2.99.2.tar.xz (signature)
KReport kreport-2.99.2.tar.xz (signature)

3.0.0 Beta 1

September 19, 2016

Kexi kexi-2.99.91.tar.xz (signature)
KDb kdb-2.99.3.tar.xz (signature)
KProperty kproperty-2.99.3.tar.xz (signature)
KReport kreport-2.99.3.tar.xz (signature)

3.0.0 Final

October 5, 2016

Kexi kexi-3.0.0.tar.xz (signature)
KDb kdb-3.0.0.tar.xz (signature)
KProperty kproperty-3.0.0.tar.xz (signature)
KReport kreport-3.0.0.tar.xz (signature)

3.0.0 Changes

Changes in Kexi

  • 3.0.0 Alpha 1 (2.99.90)
    • Initial Alpha release
  • 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
    • New: Completely new PostgreSQL database driver, based on libpq. The old one less stable based on libpqxx is discontinued.
    • New: Many improvements in handling database migration, importing e.g. from MS Access to MySQL, then to PostgreSQL, then to SQLite is much more reliable than in Kexi 2.
    • New: Most icons now use the Breeze theme, Kexi is now optimized for this theme as well as the Breeze widget style, and this is the default look.
    • 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:
  • 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


3.0.0 Known issues

  • All modules known from version 2.9.11 has been ported but these are missing:
    • map form widget
    • experimental scripts (will be replaced with JavaScript solution in later versions)
  • Bug #376970 Adding table relationships in Query Designer using drag&drop does not work (regression compared to 2.9.x)

3.0.1

3.0.1 Downloads

Source code downloads. The code is known to build and run with Linux (gcc, clang) and MS Windows (msvc).

Click here for info about signature verification.

You can also download universal Snapshots ready to run on Linux.

March 13, 2017

Kexi kexi-3.0.1.1.tar.xz (signature)
KDb kdb-3.0.1.1.tar.xz (signature)
KProperty kproperty-3.0.1.tar.xz (signature)
KReport kreport-3.0.1.tar.xz (signature)

3.0.1 Changes

Changes in Kexi

Highlight: Kexi has a few minor memory problems fixed and adds more icons of form widgets for its new standard Breeze theme. In Table Designer altering physical table design has been fixed when lookup fields are in use. Relationships creation using drag & drop has been fixed in Query Designer. There are no new features.

  • General
    • 2fbb864 Make project navigator's "single click" mode work on Windows
    • d5aae07 Use the only supported style (breeze) on Windows and Mac
    • e57a6bc Make the Status Bar not using KIO copy on Windows (to simplify the runtime)
    • b5b757b 343fd44 Fix memory leaks related to project migration
    • bd39e8a Limit size of application icon on Mac
  • Table Designer
  • Query Designer
  • Form Designer
    • 255b874 Update button form widget icon (32px)
    • 93d0b68 Add breeze icons for combobox form widget
    • 3a9d4fc Add breeze icons for frame form widget
    • 70632f0 Add breeze icons for tab widget and page
    • 802d3df Add breeze icons for groupbox widget
    • 55de5d8 Add breeze icons for data source tag
    • 601af3f Fix handling mouse release in forms
  • Buildsystem
    • efae6bd Make it possible to find PostgreSQL 9.6
    • a7374e3 Improve icons lookup when Kexi is run without installing
    • 40d0808 Improve searching for the MySQL migration build dependencies
    • 8e54268 Keep apps in the same bin dir so resources that are kept relative to this dir can be found without installing

Changes in KDb

  • General
    • 60059e2 Check result of closing database while testing connection (ConnectionTestThread)
    • 6888f59 Make it possible to set row source values for lookup column back to empty list
    • a838c60 Fix setting properties for lookup column (record source related) (Bug #371958)
    • 00a5688 Fix identifying table properties as related to lookup field (Bug #371958)
    • 3affb95 Add safer debug for large values (internal in 3.0.1)
  • PostgreSQL support
    • 8f1a6ce Fix database cursors for PostgreSQL: remove use of uninitialized variable (Bug #371331)
    • 141931a Fix error on repeated loading of "fuzzystrmatch" extension for the PostgreSQL driver
  • Buildsystem
    • 6791780 Make it possible to find PostgreSQL 9.6
    • 43723b4 Improve support for Qt Translation catalogs (use ecm_install_po_files_as_qm macro)
    • 8941221 Fix finding KDb config (use ecm_configure_package_config_file macro)
    • 68d8ae9 Add PROJECT_STABLE_VERSION_PATCH constant, extend logic for PROJECT_STABLE* constants
    • 55f3020 Improve discovery of PostgreSQL library on Windows
    • 5923022 Improve searching for the MySQL driver build dependencies
    • b29dc79 SDC: initialize all variables in from-map constructors regardless of errors, add {} to conditions, improve spacing
    • 156f898 Suppress warnings about duplicated drivers if KDB_NO_DUPLICATED_DRIVER_WARNINGS environment variable is set

Changes in KProperty

  • General
    • fef75cc Make standard icon location a list of unique paths
    • bc30325 Try to find private icons resource in a dir relative to local bin/
    • b0d7688 Try to locate rcc files in PATH subdirs too, useful for running apps from the build dir, without installing
    • 1f937b9 There is only one translation catalog currently, load with kpropertycore
    • 867e84e Add PainterSaver and use it to avoid problems with missing QPainter::restore()
    • 9e5396c Fix painting grid over scroll areas
    • 522b31d Fix crash when while removing property that has non-lowercase character in its name
  • Examples
    • 261a23c Fix KPropertyExample when KF5 is not in use
    • b0e48fd Make property editor read-only if property or property set is read-only
    • 3334295 Add all PROJECT_STABLE* constants
  • Buildsystem
    • b175941 macro kproperty_add_icons_rcc_file: generate rcc icons in the builddir/bin/data/icons/ dir so it can be used within the builddir
    • 8e6fc02 Keep apps in the same bin dir so resources that are kept relative to this dir can be found without installing
    • d2ebc72 Use ecm_install_po_files_as_qm macro for Qt Translation catalogs
    • b99d584 Fix finding KProperty configs - use ecm_configure_package_config_file macro

Changes in KReport

  • General
    • ced8679 Add 24x24 icons, useful on classic Windows
    • 3a47f64 Try to locate rcc files in PATH subdirs too, useful for running apps from the build dir, without installing
    • b76828c Fix async rendering of map item (Review #3028)
    • ba2223a Add all PROJECT_STABLE* and KREPORT_TESTING_EXPORT constants
    • b38de8a Synchronize plugin versions with KReport version: 3.0
    • df25b82 Check for plugin versions and duplicates in the plugin manager
    • e5d6e47 Fix uninitialized variables in KReportItemMaps()
    • e939571 Fix uninitialized variables in KReportItemText(), OROCheck(), KReportPluginMetaData::Private()
    • aae22cd Add checks for nullptrs in KReportItemWeb, KReportItemMaps, KReportItemChart
    • 71beded Add missing initializations in KReportSectionData
    • 7beabb7 Add missing initializations in KReportItemBarcode
    • e9a20cd Add BoundedTextItem init, make the type qreal [0..1] for consistency with Qt
    • d721688 Keep apps in the same bin dir so resources that are kept relative to this dir can be found without installing
  • Buildsystem
    • 388828a macro kreport_add_icons_rcc_file: generate rcc icons in the builddir/bin/data/icons/ dir so it can be used within the builddir
    • 6e9ff95 Use ecm_install_po_files_as_qm macro for Qt Translation catalogs
    • ff46de3 Fix finding KReport config - use ecm_configure_package_config_file macro

3.0.1 Known issues

  • Bug #377579 Criterias cannot be saved in Query Designer (regression compared to 2.9)

3.0.2

3.0.2 Downloads

Source code downloads. The code is known to build and run with Linux (gcc, clang) and MS Windows (msvc).

Click here for info about signature verification.

You can also download universal Snapshots ready to run on Linux (last version is from May 2017).

Aug 11, 2017

Kexi kexi-3.0.2.tar.xz (signature)
KDb kdb-3.0.2.tar.xz (signature)
KProperty kproperty-3.0.2.tar.xz (signature)
KReport kreport-3.0.2.tar.xz (signature)

3.0.2 Changes

Changes in Kexi

Highlight: Kexi has a number of general user interface and usability improvements. Some fixes for problems that appeared in version 3.0.0, including backward-compatibility. There are further improvements to the query designer (WHERE conditions and switching between views). Forms and reports also benefit from improvements of queries. Kexi now works better under non-KDE Plasma desktops such as XFCE, what can also have benefits on MS Windows. There are no new features apart from auto-opening command line options that work again.

  • General
    • 3c210bdc8 Don't move to first Project navigator's item when last object tab is closed (usability fix)
    • 6a218a1fb Improve detection of desktop type and use it in file dialogs and the Feedback Agent
    • d5b7a5e21 Detect single click setting for XFCE
    • 3bcc45629 Fix appearance of Kexi tabbed toolbar for gtk2 style used by XFCE
    • a41b632d5 Make auto-opening command line options work for Kexi again (Bug #378418, Review #5322)
    • 0a03c3e6d Fix regression since 3.0.0: store, copy and update user settings for objects, e.g. column widths
    • 5de2b558b Fix regression since 3.0.0: Keep compatibility with older format versions regarding the storage for object type
    • 90ee47e08 Fix regression since 3.0.0: Allow to change name and caption of objects (Bug #379078)
    • 499fbf454 Close window before renaming object on user's request
    • 08665e10a Fix background of the Kexi button for fusion style
    • dc7cc8c61 Fix vertical alignment of the record navigator (Bug #379844)
    • 373d8f4e9 Return invalid URL when open/save image dialog was canceled
    • c5603739a Improve image chooser for properties of type Pixmap: display "all supported files" (Bug #379073)
  • Table Designer
  • Query Designer
  • ce88fbae8 464196eac 24dccc710 Improve WHERE conditions handling in query designer (Bug #377579, Review #5295)
    • ac6b9a503 Fix updating SQL statement in SQL designer after switching from other views and property revert to previous SQL (Bug #377579)
  • Form Designer
    • 236681be7 Make check boxes two-state by default because this covers 99% of use cases. It is also Qt's default.
    • 6192dbc38 Don't set any special minimum size for checkbox form widgets, users may want to set specific small size (link)
    • 7e5f20b83 Fix geometry of the combo box (Bug #265330, Review #5486)
    • 22e905861 Make it possible to use vertical alignment property in Text Box form widgets
    • e0bf19825 Fix possible crashes in form's undo/redo actions, make them properly work with alignment properties of widgets (Bug #380175, Review #5969)
  • Report Designer
  • Buildsystem
  • Tests
    • 43724947a Search for resource file in bin/data also on non-Windows so tests work OK without installation of the project


Changes in KDb

  • General
    • 9730fa06 Fix possible issue: the WHERE condition can be lost while converting query to SQL. This can be seen in Kexi Query Designer.
    • c7dfaa15 Validate query and offer error message/description while setting or extending WHERE conditions
    • d81e9a1e Fix WHERE conditions handling (Review #5294)
    • 875de031 Make query parameters also work in COLUMNS section. Kexi query parameters do not work in COLUMNS section, e.g. this won't work ('invalid query' error appears): SELECT [Param]. The parameters work only in the WHERE section, e.g. SELECT 123 WHERE [Param] = 1. Port calligra commit 5c0d3ee52fd. (Bug #348473)
    • a8907bc8 Support queries such as "SELECT FROM table WHERE condition" for completeness
  • Buildsystem
    • 3572da40 Add detection for PostgreSQL 10
    • dd4a21fc Improve information about recommended packages (for drivers, python, etc.)
    • dd4a21fc Improve SQLite detection
    • c62c4296 FindMySQL script: for Windows use "ProgramFiles(x86)" environemnt variable to locate "Program Files (x86)" folder and find MySQL/MariaDB libs there
    • e7bc7bbe FindMySQL script: fix it if CMAKE_BUILD_TYPE is not specified (Windows)
  • Tests
    • 6157a64b Fix HeadersTest for paths containing spaces
    • 87dad272 Add tests related to query parameters to the parser test


Changes in KProperty

  • General
    • 2d1c35c Fix comparing double values: use "precision" option instead of "step" option
    • c5e550c Improve checking for validity of min/max/step/precision options for date/time/double types
    • f8ed63a Fix strikeout/underline font option not available in font dialogs. These options are missing in font dialogs on non-Plasma, non-Windows desktops, e.g. XFCE which has too simplified dialog. The solution is to force using Qt's own dialog (Bug #379190).
    • 72a91e6 Pixmap editor: fix display preview of pixmap value on mouse click
    • 4e4c1a6 Pixmap editor: improve size of the (...) button
    • 6267e71 Pixmap editor: don't display taskbar entry on Windows for the popup, use Tooltip palette
  • Buildsystem
    • eb8c218 Do not check for Sailfish OS since its version 2.1
  • Tests
    • cb08dd6 Fix HeadersTest for paths containing spaces


Changes in KReport

  • Buildsystem
    • efe3670072 Make sure KProperty* libs are not newer than 3.0.x
  • Tests
    • 315c86d6ad Fix HeadersTest for paths containing spaces

3.0.2 Known issues

  • See bit.ly/kexibugs