Project Detail

Description

We need to edit some legacy binary files, whose structure are fairly simple (see samples):

- first has 128 bytes per record.
- second has 256 bytes per record.
- live records always start with 00
- deleted records start with 01
- files names may vary and shall not be hard coded.

What we need:

First app:
A windows GUI to manually edit these files: EG delete all marked "to be deleted" records. Basic features: add/search/replace/delete

Second app:
- synchronize these files with a Mysql database. The MySQL tables will be very basic:
- first table: one single field "domain.com" or "hostIP"
- second table : 4 fields :email , username, fileref1, filref2.

A windows service that will query a MySQL database and sync (2 ways) with both previous files:

1. Roughly, parse the database and delete/add/replace fields within the bin files. May be a different service for each type of files, thus 2 services ( you may have a different idea). A problem is that I hate the idea of parsing a database that has not been updated. May be the service can receive a "modify" trigger from our PHP app that updates the database. I need expert advice on this one.

2. Update Mysql tables if the binary files have been updated by the legacy app,

3. All records marked for deletion (01 starting byte) will be deleted and synced.

3. Upon editing , a given win32 service shall be restarted, in the local or remote machine.

C/C++/C#/Delphi or even VB

Mandatory:
Bidder are requested to specify which resources they might use.
Very Low memory and cpu overhead.
All source code and property rights transfered
Support and debug for 1 year included


File samples :
domain.dat
users.dat




Additional files submitted:
domain.dat
users.dat