Dump Microsoft Access, Get Kexi

Billed as the “Microsoft Access for Linux,” Kexi is an integrated data management application that allows you to easily work with SQLite, MySQL, and PostgreSQL databases.

Ken Hess

Thursday, November 6th, 2008

Share This:

Buried amongst the fray of KOffice applications is Kexi, the little application that could change your dependency on Microsoft Access or other proprietary desktop databases. The tagline on the Kexi website is “Microsoft Access for Linux.” Kexi is an integrated data management application that allows you to work with SQLite, MySQL, and PostgreSQL databases.

Upon first glance, Kexi closely resembles Access in its organization and appearance. Like Access, Kexi creates and operates on file-based databases and can connect to an ever-increasing list of remote database systems. You can create and operate on Tables, Forms, build Queries, and use Scripts with your databases within the Kexi application.

Figure 1 shows the Kexi interface ready to create databases, tables, forms, queries, and scripts.

Figure One: The Kexi Interface