Hi, I am researching possible solutions for a simple database application delivered to a Pocket Windows PDA (PocketPC). The database will be a subset of a larger company-wide database held on a Linux server using MySQL and PHP.
The PDA database will be used by a small number of people - probably no more than 10 initially - and they will make only a small number of edits to the database, fewer than 5 daily under normal circumstances. The server and database already exist, so no configuration changes are possible, but I can make changes to the database if required. I'd love data replication with the server to be automatic if possible, but if I have to build something to handle that then so be it. For the sake of a nice clean, updatable interface, and to allow for some other multimedia facilities which we can consider unrelated to this database, the interface will be Macromedia Flash. I am looking for the least painful method to enable the above. I have encountered numerous suggestions including - Wrapping the Flash interface inside a eVC wrapper, eVB, e.Net (C#) ... - Using a local Access database, synchronising that with a server copy and then synchronising the server copy of the access database with the main MySQL application. - Saving a record of local updates to text/xml file then passing the saved data to the server for processing on synchronisation. If user A makes updates, a record of those updates is then saved to a special table for users B, C, D ... so that when they synchronise they can download and apply the same edits. ..... but an automatic replication would be far more elegant. So far all of this is speculation. Obviously I have to make a choice as to what methods I will apply and what technologies to employ. Has anyone here done anything similar to above? Can you share comments, suggestions, tools used? TIA Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]