Becoming Digital wrote:
The error is in FLOAT(1). Think about that for a moment. What's a float with
one-digit precision? It's an integer. :)
While I agree with your analysis the error was a missing comma. The
float(1), which I originally thought was array size of 1, appeared to
work fine.
Curtis Maurand wrote:
What's the client running on?
Not the same machine as the server. Could either be a windows or
linux box across ethernet.
--Chris
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get
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
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get the data into the database
fine. Assuming new values or rows are added once per second, how
would a client program go about polling the database to see
I'm getting an error with create table, appears that field names
cannot have the underscore character. Is this correct? It would be
quite fatal for us, as we need some sort of delimeter character, so we
can group variables by instrument.
You have an error in your SQL syntax near 'A2DEE1_RWO