I'd write a perl script to pool the device and send the data to the database.
Curtis On Thu, 12 Jun 2003, Becoming Digital wrote: > If I interpret correctly, you'd like to to read sensor data (not in ASCII > format) as FLOATs and insert it into a database on the fly without an > intermediary. While this may be possible, perhaps there's a better solution. > > I would suggest reading the data to a file (which you must be able to do any > way) for the duration of your test. When the test is complete, parse the data > and do a batch insert into the database. MySQL will report the number of rows > recorded, which can act as your polling system. > > If you are able to provide more details about your application, perhaps we can > be of more help. Most significant is likely the data format coming from your > sensors. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Chris Webster" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, 12 June, 2003 11:46 > Subject: soft real-time database > > > Greetings, > I'm new to databases, but I am considering one for soft real-time > data recording of scientific data. Then any client/display program > can grab data. > > I'll be recording 300-500 variables/columns per second for about 10 > hours at a stretch. All variables are floats. > > a) Is there a way to insert/write floats to the DB without converting > to ASCII first? Seems expensive. > > b) I'm still wading through the documentation, but what would be the > prefered method for polling to see if a new row has been written? I > assume there is no notification process available from the server.... > > TIA for any pointers. > > -- > --Chris > > I don't approve of political jokes. > I've seen too many of them get elected. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
