Some of you may be aware that I've been setting up a new business - Indau Industrial Automation. Before setting up the new website and email servers I decided that I was going to look for exchange based email hosting packaged with a Linux web server. This would allow me to retain the Windows Mobile smart phone that I currently use and utilise it for push email and OWA Calendar and task synchronising. Having used Push based email for the past year it was high on the list of things to have - even though it meant retaining a tie to Micro$oft.
Unfortunately there are no comparible solutions available from the open source community yet, There are a few solutions that offer push email from the Linux platform but none that I wanted to risk trying, and none that are as feature rich as the Exchange + Windows mobile solution.
For the hosting package I looked no further than ComWebHosting my current service providers - although not advertised they were able to sort out a package that included Linux based web hosting with PHP and SQL along with exchange based Email. ComWebHosting come highly reccomended - I've used them for the past 8 or 9 years and have never had a problem - even now I'm based in Australia, using a UK based hosting company is not a problem - even for push email from my smart phone.
One new thing to sort out with the web hosting was the SQL database administration. Normally most web hosts provide phpMyAdmin to administer the database, some use other clients but there is normally a way in which you can upload a database backup or run an SQL query. As the sql database server was not the same as the webserver phpMyAdmin was not available so I needed to find a DB client that could be run remotely from the server - allowing me to install it on my local machine but access and administrate the database located on a different server.
A quick google managed to turn up nothing but a search in the ubuntu synaptics repository brough up EMMA - "extendable mysql managing assistant" (http://www.fastflo.de/projects/emma ) After installing the package I easily connected to the database with the info supplied by my web host and was then easily able to upload the database.
How to use EMMA is a bit beyond the scope of this article, but anyone familiar with databases, database structure or other database clients should easily be able to use EMMA. (Checkout the screenshot on the right or go to the fastflo website for a better idea of the interface) One feature I especially liked was that items shown in the query view (similar to phpMyAdmins 'browse') were shown in a table format that allowed direct editing of the values - no waiting for a browser to refresh!!
EMMA is based on "yamysqlfront" by the same author although it has been redesigned with extensibility in mind by utilising a plugin based architecture that allows contributors to provide additional features. Based on Python, EMMA is an open source project that is very easy to use and would easily be able to replace my need for phpMyAdmin for my day to day use.