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.
