Kexi/Releases

From KDE Community Wiki

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