Kexi

Kexi screenshot
Developer(s)	KDE
Initial release	May 31, 2005; 7 years ago (2005-05-31)
Stable release	2.6.3 (15 May 2013; 10 days ago (2013-05-15)[1]) [±]
Preview release	2.6 RC3 (18 January 2013; 4 months ago (2013-01-18)[2]) [±]
Development status	Active
Written in	C++ (Qt, KDE Platform)
Operating system	Unix-like, Windows
Available in	Multilingual
Type	Visual database management front-end
License	mostly LGPL, minor use of GPL
Website	kexi-project.org

Kexi is an integrated data management application 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 component of Calligra Suite. 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.^[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 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 – the first release of the second generation^[13] – introduced full-featured report designer and previewer.^[15] 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.

See also [edit]

Free software portal

• Comparison of office suites

References [edit]

1. ^ Calligra 2.6.3 Released
2. ^ http://www.calligra.org/uncategorized/calligra-2-6-release-candidate-3/
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. 

v t e Calligra Suite Applications Words Sheets Stage Flow Karbon Krita Kexi Plan Braindump Architecture Flake Kross Pigment

v t e KDE Community KDE e.V. Akademy KDE.News Konqi People Matthias Kalle Dalheimer Matthias Ettrich Adriaan de Groot Frank Karlitschek Celeste Lyn Paul Nuno Pinheiro Cornelius Schumacher Aaron Seigo David Vignoni Software Compilation KDE 1 KDE 2 KDE 3 KDE SC 4 Workspaces KDesktop KDM Kicker KWin Plasma System Settings Applications Development Cervisia KDbg KDESvn KDevelop KImageMapEditor Kompare Lokalize Quanta Plus Umbrello Education Cantor Kalzium KBibTeX KGeography KHangMan Kig Kiten kst KStars KTouch KTurtle KWordQuiz LabPlot Marble RKWard Step Games KAtomic KBounce Kolf KMines Graphics digiKam Gwenview Karbon KColorEdit KolourPaint KPhotoAlbum KPovModeler Krita KSnapshot Okular Skanlite Internet Akregator KGet KMail KMLDonkey KNode Konqueror Konversation Kopete KPPP KRDC KTorrent ownCloud Rekonq Multimedia Amarok Dragon Player Frescobaldi JuK K3b K9Copy Kaffeine Kdenlive KMPlayer Office Flow KAddressBook Kexi Kile KMyMoney Kontact KOrganizer KPilot KWord Plan Sheets Stage Tellico Words System Dolphin KDE Partition Manager KDE System Guard KInfoCenter Konsole Yakuake Utilities Ark BasKet Note Pads KAlarm Kate KCalc KGPG Klipper KJots Krusader KRename KWallet KWrite RSIBreak SuperKaramba Platform Akonadi Decibel Flake KJS KHTML KIO Kiosk KIPI KParts Kross NEPOMUK Oxygen Phonon QtRuby Solid Sonnet Soprano Strigi ThreadWeaver XMLGUI Packages KDELibs KDEBase Accessibility Administration Bindings Education Games Graphics Multimedia Network PIM SDK Utils Web Dev Calligra Suite KOffice Extragear Category Project Commons Template