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
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 wa
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.
There is an intermediary which is doing the inserting
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 whe
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 t
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.
-
