Sedang Disiapkan

MySQL to legacy file sync

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 :

[url removed, login to view]

[url removed, login to view]

Kemahiran: Pengaturcaraan C, Delphi, Visual Basic, Destop Windows

Lihat lebih lanjut: delphi sync mysql, mysql legacy, trigger legacy mysql, visual basic services, synchronize table, starting visual basic, source code binary search, simple file database, simple binary code, simple binary, search binary, php code property search, names editing, binary search source code, binary problem, always property, mysql sync trigger, file sync script, mysql trigger sync, mysql delete syn, synchronizing database delphi, visual basic synchronize files, trigger mysql synchronize, mysql file sync, mysql triggers remote

Tentang Majikan:
( 24 ulasan ) Paris, France

ID Projek: #364602