I am currently looking to replace the UFL Loader with a daemon that implements the JDBC driver. I have made connection and done simple queries in both DbVisualizer and through my Java program. I have little experience with PI, so the next step is to make sense of all the different tables. From the documentation I gather that I can insert into the `picomp2` table.
I have a few questions.
- If I look at picomp and picomp2, picomp has value, svalue, and status columns, whereas picomp2 has _index, value, and status columns. What is the purpose of each of these columns and how do they relate?
- My current plan is to build insert statements that act on the picomp2 table. Is this the most efficient way of inserting large amounts of data?
- How do I handle inserting datapoints that have different datatypes. Our current possible types in Java are String, Float, and Integer, but this may change.