Comport datastream to sql database

This project received 30 bids from talented freelancers with an average bid price of $ USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

We need a simple C/C++ program that can read and write a text formatted ascii datastream from/to a serial communication port and a sql database.

The serial port can be either a physical port or a virtual serial port( for usb/serial converters)

The datastream is human readable in form of ascii characters.

The datastream contains a start and stop token.

The program shall read a text file at startup and this text file will tell the program the ip address of the (my)sql server, the username, database name and the table name to be used. There are two tables initially. One for read and one for write.

Incoming communication from the serial port shall be placed in the table at the end of the table.

The program shall monitor the outgoing table and if a new port is detected the data in this post shall be written to the serial port according to the prescribed format.

The program does not need to create the tables or manage the tables in any way. For incoming data the program assumes that the fields exist. For outgoing data, the program shall use the field list in the init-file ( same file that describe ip-address, username etc.)

The data flowing to/from the serial port shall always be of the format:

STARTDATA <field name1> <data1> <field name2> <data2> ...<field name n> <data n> ENDDATA

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online