Kexi

From Wikipedia, the free encyclopedia

Kexi

Kexi screenshot
Developed by Kexi Team
Latest release 1.1.3 / June 7, 2007
OS Cross-platform
Genre Database creation program
License GNU Lesser General Public License
Website www.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 highly portable enough.

The commercial version of Kexi
The commercial version of Kexi

Kexi is a component of KOffice, with large contributions coming since early 2003 from OpenOffice Polska. It works under Linux/Unix, Mac OS X (using Fink), Solaris, and the Microsoft Windows operating systems. Although Kexi is an open source application, currently OpenOffice Polska is charging for the full featured Windows version, due to the cost of commercial tools (Qt and compiler) needed to port the software to Windows.[1] Thanks to the recent open-sourcing of the Qt library, a free version for Windows (developed by the same team as before) is set to release for KDE 4.[citation needed]

[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 database engine. Forms can be created to provide a custom interface to data, and are stored within the database. Simple reports can be printed or previewed. 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.

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

[edit] See also

[edit] External links