We are starting to develop an application for internal use.
Currently, that application is written entirely in Foxpro 2.6.
We are looking to make this application as OS independent as possible. For that reason, we are considering a web server, database engine, server side programming and a browser based user interface.
Translated to Apache, PostgreSQL, PHP, Mozilla.
The Apache and Mozilla parts of this equation are good choices. Its the database and the programming lanquage that are up in the air. Additionally, we would like to keep as much of the Foxpro backend, reporting and printing, as possible.
The programming tools on hand are Visual Studio, but not a contender for the front end, and Coffee Cup.
We are looking for a solution that offers a good IDE, write once use many times, (we have multible clients but the program we use now requires only minor modification for each client).
The database engine must allow backups while running. So, MySQL is out. Would consider Oracle, Sybase, DB2 or anything else if they offer a great tool kit.