Open source database utility

Integrating your website with a database opens up a whole new way of delivering content to your audience. Not only does it help you facilitate business transactions, such as online ordering but you can also use it to build booking systems, create web applications or to deliver any kind of dynamic content. The trouble is, database products such as Microsoft Access and Oracle are pretty expensive, which is why Kexi is an attractive option, as it is completely free and open source.

The application organises information from a spreadsheet, consulting database servers such as MySQL or ProgresSWL. In many ways Kexi’s working model is very similar to Access, particularly in terms of macros. It boasts full compatibility with scripting languages such as Python and Ruby and also uses CSV for imports and exports. This is made easier because the tabular and forms databases are stored as a single file.

The program is compatible with Windows, Mac and Linux, making it an ideal data mangement tool for integrating with many server-side programs and technologies.

Kexi is an integrated data management application. It can be used for creating database schemas, inserting data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries and forms – are stored in the database, making it easy to share data and design.

Kexi is considered as a long awaited Open Source competitor for Microsoft Access, FileMaker and Oracle Forms. Its development is motivated by the lack of Rapid Application Development RAD) tools for database systems that are sufficiently powerful, inexpensive, open standards driven and portable across many operating systems and hardware platforms.