Kexi

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Kexi
Kexi Application Logo.svg
Kexi 2.2 main window.png
Kexi screenshot
Developer(s) KDE
Initial release 2003
Stable release KOffice 2.3.3  (March 1, 2011; 10 months ago (2011-03-01)) [±]
Preview release Calligra 2.4 Beta 7  (February 1, 2012; 2 days ago (2012-02-01)[1]) [±]
Development status Active
Written in C++ (Qt, KDELibs)
Operating system Cross-platform
Platform Cross-platform
Available in Multilingual
Type Database creation program
License mostly LGPL, minor use of GPL
Website kexi-project.org

Kexi is an integrated data management application, 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 component of Calligra Suite, formerly known as KOffice, with large contributions coming since early 2003 to 2008 from OpenOffice Polska[2][3] (currently OpenOffice Software). It works under Linux/Unix, Mac OS X (using Fink), Solaris, and the Microsoft Windows (using KDE on Windows) operating systems. Kexi application and libraries is available under the LGPL. User and developer documentation is available under the GFDL.[4]

Series 2 of Kexi start with versions 2.2 and 2,3, available within the KOffice suite. Versions 2.4 and newer are planned within the Calligra Suite.

[edit] Features

Kexi can connect to different database servers such as MySQL and PostgreSQL.

It can also work without a server, by utilizing the built-in SQLite 3 database engine. Forms can be created to provide a custom interface to data, and are stored within the database. In 1.x version simple reports can be printed or previewed. Version 2.2 introduced full-featured report designer and previewer. Scripting using Python and Ruby is available as well as application macros, similar to those in Microsoft Access (in experimental stage). All database objects — tables, queries, forms, etc. — are stored in a single database file, making it easy to share data and design.

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. Handling Microsoft SQL Server/Sybase and Oracle databases is in testing phase.

If SQLite is used, the resulting database file can be manipulated using many other SQLite tools.

[edit] See also

[edit] References

  1. ^ http://www.calligra.org/news/announcements/calligra-2-4-beta-7/
  2. ^ http://kde.org/support/thanks.php
  3. ^ http://www.kexi-project.org/wiki/wikiview/index.php@SponsorshipThanks.html
  4. ^ http://kexi-project.org/wiki/wikiview/index.php@KexiLicense.html
Personal tools
Namespaces
Variants
Actions
Navigation
Interaction
Toolbox
Print/export
Languages