Kexi

Kexi is an integrated data management application. It can be used for designing and implementing databases, data inserting and processing, and performing queries. 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. SQLite has a particular affinity to Tcl programming language.

Kexi is positioned to fill the gap between spreadsheets and database solutions requiring more sophisticated development.

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

Kexi is a component of KOffice with large contributions coming since early 2003 from OpenOffice Polska company. It works under Linux/Unix, Mac OS X (using Fink), Solaris, and the Microsoft Windows operating systems; although the Windows version is not free of cost ("freeware") nor as it is developed using commercial tools (Qt and compiler) by OpenOffice Polska company. Thanks to recent open-sourcing Qt library, open source version for Windows developed by the same team as before is set to release for KDE 4.