Kexi

Last updated
Kexi
Developer(s) KDE
Initial releaseMay 31, 2005;19 years ago (2005-05-31)
Stable release 3.2.0 [1]   OOjs UI icon edit-ltr-progressive.svg (9 April 2019;5 years ago (9 April 2019)) [±]
Repository cgit.kde.org/kexi.git
Written in C++
Operating system Linux, Windows, FreeBSD, NetBSD, OpenBSD
Type Database management system
License Mostly LGPL, minor use of GPL
Website kexi-project.org

Kexi is a visual database applications creator tool by KDE, designed to fill the gap between spreadsheets and database solutions[ buzzword ] requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries. It is developed within the Calligra project but is released separately.

Contents

The impetus for developing Kexi came from a noticeable lack of applications having the features of LibreOffice Base, Microsoft Access, FoxPro, Oracle Forms or FileMaker while at the same time being powerful, inexpensive, open-standards-driven and sufficiently portable.

Kexi 3.0 user interface KEXI 3.0.png
Kexi 3.0 user interface

Kexi works natively under Linux/Unix (FreeBSD, OpenBSD, NetBSD, Solaris) and Microsoft Windows operating systems. Older versions were available for Mac OS X (using Homebrew). macOS version was not released but can be compiled.

Kexi application and its frameworks are available under the LGPL. User and developer documentation is available under the GFDL. [2]

History

Kexi development started in 2002. OpenOffice Polska [3] [4] (currently OpenOffice Software) contributed to it largely between 2003 and 2008.

Although Kexi was a KOffice project since the beginning, [5] the first release was independent of KOffice. The first public beta release of Kexi was version 0.1 beta 2 on January 22, 2004. [6] The first stable release was 0.9 – made available on May 31, 2005. [6] A Kexi version with a lower version number – 0.8 – was shipped afterward with KOffice 1.4 on June 21, 2005. [6] [7] Further stable versions of Kexi were released with KOffice 1.5 [8] and 1.6 in 2006. [9]

From 2004 until 2007 OpenOffice Polska made commercial Kexi releases using release years as version numbers. The first release was Kexi 2004 LT on November 24, 2004 based on Kexi 0.1. [10] The commercial releases concluded with Kexi 2007.1 in March 2007 based on Kexi 1.1.2/1.1.3. [10] [11]

The porting process to KDE Platform 4 took rather long and was finished with the release of KOffice 2.2 in May 2010. [12] Among its new features was a new Report Designer plug-in [13] to replace the KOffice 1.6 stand-alone reporting application Kugar. [14] Kexi 2.3 was released with KOffice 2.3 on December 31, 2010 [15] with – among other features – a reworked Project Navigator pane. [16]

After the KOffice 2.3 release, Kexi moved into Calligra Suite and both were released as version 2.4 on April 11, 2012. [17] The most user-visible change was a redone main user interface dubbed Modern Menu. [18]

Since version 3.1 Kexi again officially supports Microsoft Windows.

Features

Kexi users can choose from various database engines that can be utilized for data and design storage. By default built-in SQLite 3 database engine is used that eliminates a need for installation and maintenance of a database server. For more advanced use Kexi can use database servers such as MySQL/MariaDB, PostgreSQL and Microsoft SQL Server/Sybase. Database servers have to be accessible to user on the same or any other computer.

All database objects – tables, queries, forms, etc. – are stored in tables of a single database (either file or server), making it easy to share data and design. Resulting database can be to certain extent manipulated using dedicated database tools. In Kexi, such data and definition of objects is known as project.

Kexi Table designer allows users to design tables, which can then be created and opened for data entry, sorting and searching. Standard data types are available common to supported database engines. Among them is "Object" data type allowing to store images of many types.

Queries can be designed visually or in built-in dedicated SQL editor, then they can be executed. There is support for parametrized queries and searching through the data. The scope of the SQL supported is limited compared to raw database engines (MySQL and even SQLite) but the SQL dialect supported by Kexi is (by design) common to all supported database engines. This can simplify switching between engines.

Forms can be created to provide a custom interface to data. There is a designer, and a previewer capable of data entry. Wide range of graphical elements can be used including web browser and world map viewer. Simple actions can be assigned to form buttons.

Kexi 2.2 – the first release of the second generation [12] – introduced full-featured report designer, generator and previewer. [14] Simple formulas can be assigned to report elements.

The application can also import data (tables) from external data sources (MySQL, PostgreSQL, Microsoft Access files, dBASE files) and export data to MySQL or PostgreSQL servers. There is rich support for importing and exporting CSV files. The same CSV format can be used for copying and pasting clipboard data so the data can be easily transferred to/from applications like spreadsheets or word processors.

In a special User Mode Kexi allows users to switch off all commands related to editing project's design.

Experimental features

Kexi offered experimental scripting support using Python and Ruby in version 2. Scripting since version 3 is planned to be based on JavaScript. Handling Oracle databases was available in versions 1.x but is disabled in versions 2.x.

See also

Related Research Articles

<span class="mw-page-title-main">Calligra</span> Office suite made for KDE

Calligra Suite is a graphic art and office suite by KDE. It is available for desktop PCs, tablet computers, and smartphones. It contains applications for word processing, spreadsheets, presentation, databases, vector graphics, and digital painting.

<span class="mw-page-title-main">Microsoft Access</span> Database manager part of the Microsoft 365 package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">Calligra Sheets</span> Calculation and spreadsheet application for KDE desktop environment

Calligra Sheets is a free software spreadsheet application that is part of Calligra Suite, an integrated graphic art and office suite developed by KDE.

<span class="mw-page-title-main">Calligra Stage</span> Presentation program for KDE desktop environment

Calligra Stage is a free presentation program that is part of the Calligra Suite, an integrated office suite developed by KDE.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

The Access Database Engine is a database engine on which several Microsoft products have been built. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database.

A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table within one or more discrete categories. The aggregations or summaries of the groups of the individual terms might include sums, averages, counts, or other statistics. A pivot table is the outcome of the statistical processing of tabularized raw data and can be used for decision-making.

In computing, a materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary using an aggregate function.

<span class="mw-page-title-main">Kugar</span>

Kugar is a discontinued tool for generating business quality reports for KOffice. The reports can be viewed and printed. It includes a standalone report viewer and a KParts report viewer. The latter means that any K Desktop Environment 3 application can embed the report viewing functionality and that reports can be viewed using the Konqueror browser.

<span class="mw-page-title-main">HeidiSQL</span> Administration tool for relational databases

HeidiSQL is a free and open-source administration tool for MariaDB, MySQL, as well as Microsoft SQL Server, PostgreSQL and SQLite. Its codebase was originally taken from Ansgar Becker's own MySQL-Front 2.5 software. After selling the MySQL-Front branding to an unrelated party, Becker chose "HeidiSQL" as a replacement. The name was suggested by a friend as a tribute to Heidi Klum, and was further reinforced by Becker's own nostalgia for Heidi, Girl of the Alps.

<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Flake or a Vector Shape is a programming library that is used in Calligra Suite and the KOffice 2 series. Flake provides the basic concept of a "shape". To the end user a shape appears as some piece of content such as an image or a text. A shape can be in any form and contain any kind of media since the Shape is responsible for drawing itself. All components of KOffice are being overhauled to use Flake as much as possible.

<span class="mw-page-title-main">Calligra Plan</span> KDE project management application

Calligra Plan is a project management application that can create Gantt-style charts and is part of Calligra Suite – formerly included with KOffice.

<span class="mw-page-title-main">KOffice</span> Former office suite for the KDE Desktop Environment

KOffice was a free and open source office and graphics suite developed by KDE for Unix-like and Windows systems. KOffice contains a word processor (KWord), a spreadsheet (KSpread), a presentation program (KPresenter), and a number of other components that varied over the course of its development.

<span class="mw-page-title-main">KWord</span>

KWord is a deprecated word processor and a desktop publishing application, part of the KOffice suite. It has been obsoleted by Calligra Words of the Calligra Suite.

<span class="mw-page-title-main">Database Workbench</span>

Database Workbench is a software application for development and administration of multiple relational databases using SQL, with interoperationality between different database systems, developed by Upscene Productions.

References

  1. "Kexi Releases 3.2.0". 9 April 2019.
  2. "Kexi License". Kexi Project. Retrieved 2012-05-01.
  3. http://kde.org/support/thanks.php (archived version)
  4. "Sponsorship Thanks". Kexi Project. Retrieved 2012-05-01.
  5. "Kexi 0.1 beta 2 Announcement". Kexi Project. Retrieved 2012-05-01.
  6. 1 2 3 "Kexi – Older News". Kexi Project. Retrieved 2012-05-01.
  7. "KOffice 1.4 Released | KDE.news". Dot.kde.org. 21 June 2005. Retrieved 2012-05-01.
  8. "KOffice 1.5 Released | KDE.news". Dot.kde.org. 11 April 2006. Retrieved 2012-05-01.
  9. "KOffice 1.6 Released | KDE.news". Dot.kde.org. Archived from the original on 2012-04-03. Retrieved 2012-05-01.
  10. 1 2 "News/Kexi Releases - Kexi - Databases for Everyone". 2007-12-03. Archived from the original on December 3, 2007. Retrieved 2012-05-01.
  11. "News/Kexi Releases/Kexi 2007.1 - Kexi - Databases for Everyone". 2007-11-03. Archived from the original on November 3, 2007. Retrieved 2012-05-01.
  12. 1 2 "Blog Archive » KOffice 2.2 Released". KOffice.org. 2010-05-27. Archived from the original on 2011-07-17. Retrieved 2012-05-01.
  13. "Kexi/Releases/Kexi 2.2 - KDE Community Wiki". Community.kde.org. 2012-04-27. Retrieved 2012-05-01.
  14. 1 2 "Kexi Project - "Microsoft Access for Linux" - Development". Kexi.automatix.de. Retrieved 2012-05-01.
  15. "Blog Archive » KOffice 2.3.0 Released". KOffice.org. 2010-12-31. Archived from the original on 2011-06-07. Retrieved 2012-05-01.
  16. "Kexi/Releases/Kexi 2.3 - KDE Community Wiki". Community.kde.org. 2012-04-27. Retrieved 2012-05-01.
  17. "Calligra 2.4 Released | Calligra Suite". Calligra.org. 2012-04-11. Retrieved 2012-05-01.
  18. "Kexi/Releases/Kexi 2.4 - KDE Community Wiki". Community.kde.org. 2012-04-10. Retrieved 2012-05-01.