General highlight: 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 the 3.1.0 release KEXI and the frameworks received over ?????????? 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.

Note

KEXI 3.2.x depends on the KEXI frameworks in version 3.2.x or newer. There is no guarantee that it works with older frameworks. Just like the KDE Frameworks, we recommend to upgrade all the KEXI frameworks to the same version as KEXI.

Contents

Changes in KEXI

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

Highlight:

Date, Date/Time and Time type support has greatly improved in KEXI. Users requested to have clear way to enter date/time constants. It is now possible in a clear way without need to use text strings. Documentation of the format is currently accessible at here.
In the future date/time related SQL functions would be added as well as planned here.

Date constants in SELECT queries

Date constants in conditions of SELECT queries

Apart from the above notation improvements, data entry for dates are more reliably supported on computers that default default to two-digit years. KEXI switches itself to four-digit years by default (it can be switched off) to address the fact that for example date 19-01-21 can mean both 1919-01-21 and 2019-01-21.

Years are 4 digits now in tables and forms. On the output INFO message says as explained at https://bugs.kde.org/show_bug.cgi?id=378481#c5. Data entry works based on this new year format. Changes are properly saved to db. Display output e.g. in queries and reports follow this format too.

Set AllowTwoDigitYearFormats=true in kexirc, [General] section to force using 2 digits.

Changes in KProperty

KProperty is a property editing framework with editor widget similar to what is known from Qt Designer.

Highlight: Developers can now plug own handler for file/url selection to the Url type. Also, relative URLs can be now used. KPropertyExample example application has been updated to demonstrate these features.