Kexi

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Kexi
Calligra Kexi icon.svg
Kexi 2.2 main window.png
Kexi screenshot
Developer(s) KDE
Initial release May 31, 2005; 9 years ago (2005-05-31)
Stable release 2.8.6 (24 September 2014; 60 days ago (2014-09-24)[1]) [±]
Preview release 2.8 Beta 2 (12 January 2014; 10 months ago (2014-01-12)[2]) [±]
Development status Active
Written in C++ (Qt, KDE Platform)
Operating system Unix-like
Available in Multilingual
Type Visual database management front-end
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 requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries.

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

The proprietary version of Kexi 1.x

Kexi is a member of Calligra Suite. It works under Linux/Unix and Solaris operating systems. Versions for Mac OS X (using Homebrew) and the Microsoft Windows (using KDE on Windows) are in development.

Kexi application and libraries is available under the LGPL. User and developer documentation is available under the GFDL.[3]

History[edit]

Kexi development began in early 2003 with large contributions coming until 2008 from OpenOffice Polska[4][5] (currently OpenOffice Software).

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

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 (2004-11-24) based on Kexi 0.1.[11] The commercial releases concluded with Kexi 2007.1 in March 2007 based on Kexi 1.1.2/1.1.3.[11][12]

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

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

Features[edit]

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 and PostgreSQL. These 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's Table designer allows 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[13] – introduced full-featured report designer, generator and previewer.[15] 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 to switch off all commands related to editing project's design.

Experimental features[edit]

Scripting using Python and Ruby is available as well as application macros, similar to those in Microsoft Access. Handling Microsoft SQL Server/Sybase and Oracle databases was available in versions 1.x but is disabled in versions 2.x.

See also[edit]

References[edit]

  1. ^ "Calligra 2.8.6 Released". 
  2. ^ "Calligra 2.8 Beta 2 Released". 
  3. ^ "Kexi License". Kexi Project. Retrieved 2012-05-01. 
  4. ^ http://kde.org/support/thanks.php (archived version)
  5. ^ "Sponsorship Thanks". Kexi Project. Retrieved 2012-05-01. 
  6. ^ "Kexi 0.1 beta 2 Announcement". Kexi Project. Retrieved 2012-05-01. 
  7. ^ a b c "Kexi – Older News". Kexi Project. Retrieved 2012-05-01. 
  8. ^ "KOffice 1.4 Released | KDE.news". Dot.kde.org. Retrieved 2012-05-01. 
  9. ^ "KOffice 1.5 Released | KDE.news". Dot.kde.org. Retrieved 2012-05-01. 
  10. ^ "KOffice 1.6 Released | KDE.news". Dot.kde.org. Retrieved 2012-05-01. 
  11. ^ a b "Internet Archive Wayback Machine". Web.archive.org. 2007-12-03. Retrieved 2012-05-01. 
  12. ^ "Internet Archive Wayback Machine". Web.archive.org. 2007-11-03. Retrieved 2012-05-01. 
  13. ^ a b "Blog Archive » KOffice 2.2 Released". KOffice.org. 2010-05-27. Retrieved 2012-05-01. 
  14. ^ "Kexi/Releases/Kexi 2.2 - KDE Community Wiki". Community.kde.org. 2012-04-27. Retrieved 2012-05-01. 
  15. ^ a b "Kexi Project - "Microsoft Access for Linux" - Development". Kexi.automatix.de. Retrieved 2012-05-01. 
  16. ^ "Blog Archive » KOffice 2.3.0 Released". KOffice.org. 2010-12-31. Retrieved 2012-05-01. 
  17. ^ "Kexi/Releases/Kexi 2.3 - KDE Community Wiki". Community.kde.org. 2012-04-27. Retrieved 2012-05-01. 
  18. ^ "Calligra 2.4 Released | Calligra Suite". Calligra.org. 2012-04-11. Retrieved 2012-05-01. 
  19. ^ "Kexi/Releases/Kexi 2.4 - KDE Community Wiki". Community.kde.org. 2012-04-10. Retrieved 2012-05-01.