Kexi

Rapid Application Development

Kexi is a visual database applications creator. It can be used for designing database applications, inserting and editing data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries, forms, reports – are stored in the database, making it easy to share data and design.

Features

• Full visual designers for tables, queries, forms and reports
• Running queries, support for parametrized queries
• Supports SQLite, MySQL, PostgreSQL and MS SQL Server databases
• The only multiplatform graphical tool importing data from MS Access databases
• Supports query design in dedicated SQL view
• Designing and displaying relational data using combo boxes (lookup columns)
• Direct data entry or import using CSV format
• Locked down User Mode, allowing you to switch off all commands related to editing your project's design
• Scripting using JavaScript, Python or Ruby programming languages (experimental)
• Many more features

Development wiki is at https://community.kde.org/Kexi and home page is at http://www.kexi-project.org.

Documentation, Tutorials and Samples

• Tutorials
• Documentation
  • The Kexi Handbook for Kexi 2
  • This Handbook is also found on docs.kde.org.
  • Kexi Cheat Sheet (planned)
  • Note: scripting is undocumented and experimental, please read [1] for more information
• Samples
  • Simple database (kde-files.org)
  • Data importing using Javascript (kde-files.org)
• Follow the project on Twitter or facebook.

Presentations

• Kexi Architecture

• Kexi - Database Environment and Introduction to KDE Database Layer (Akademy 2005)

• Kexi - Data(base) Environment, Universal Data Layer for KDE (Akademy 2006)

• Kexi - Data(base) Environment - Introduction to universal data layer for KDE (Akademy 2007)

• Kexi: Introduction for KDE Contributors (2nd Calligra Sprint, 2011)

• History of Kexi development (blog, 2013)