Re: [ts-7000] Cron job corrupting serial data received

[Dan Weese <>]

Or, the device could quit writing to its own local MySQL instance and park everything on the far end.  I wouldn't host a database on the same device as my serial port handler.

Also, not an option.  The device needs to be able to record data even in the absence of a data connection to the remote server.  The only other option would be to store the data in a flat file of some description, but I shudder at the potential pitfalls there.

Old war story.  Application:  data collection from assembly line quality control robots.  Gathering data from IEEE 488 bus.  When I had a few seconds (as the assembly line moved the next piece into position ), I'd probe for the database at the far end, which happened to be on the manager's desktop.  If it didn't find the database, it would persist to flat files and wait until it could find the database.

Manager went on vacation.  His machine stayed off for a week.

Came back Monday, turned his machine on.  Every robot on that line starting shooting its flat file data up the wire.  Entire line ground to a halt until every SQL INSERT had gone off.

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: =Email Delivery: Digest | m("yahoogroups.com?subject","ts-7000-fullfeatured");=Change Delivery Format: Fully Featured">Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | =Unsubscribe

__,_._,___