The KOffice Project Kexi Features
Standard Database Features
- Hiding of the database backend specifics from the user, but allowing advanced users full access at the same time
- Table structure altering
- Table creation
- Database query creation, without the need of knowing SQL (Structured Query Language)
- User-friendly data manipulation (even on complicated queries)
Data Processing and Access
- User-defined forms for data input and presentation
- Data migration from MySQL, PostgreSQL.
- Migration from Microsoft Access databases is available as an additional plugin.
- Scripting support with Python and JavaScript/ECMA-Script language and/or Python
- KWord mailmerge integration (planned)
- Easy data report generation (rewrite planned)
Supported Database Backends
Kexi projects are usually stored in a file. This is convenient for databases that are only used by a single person.
However, for some projects, users may prefer to store their data on a remote database server. This allows several users to use the same database. Currently, changes to the database structure should only be made by one user: concurrent modifications to the database structure are not supported.
Kexi supports the following database systems:
- SQLite (version 2 and 3, file-based)
- PostgreSQL (server-based)
- MySQL (server-based)
It is planned to support also other database systems, especially for FireBird/Interbase and ODBC interface, for better corporate usage in the next versions. Typically, most up to date and best supported backends (from KexiDB point of view) are always: SQLite, PostgreSQL and MySQL.
Last update: 2008-02-15
