Load all at once through a CSV file
Machbase allows you to load large amounts of CSV files through a csvimport tool.
More details can be found through practical examples, and are described in brief below.
CSV Format (data.csv)
Prepare a csv file consisting of <tag name, time, value> as above.
Of course, the tag name TAG_0001 must be present in the tag meta.
Using the loading program csvimport
This loads data.csv into a table called TAG.
The -F option specifies the time format stored in the data.csv file.
In addition, -l error.log records the error that occurred when inputting as a separate file.
Input via the RESTful API
For more detailed usage of the RESTful API, please refer to the following examples.
Syntax of Input API
Machbase provides the RESTful API as follows:
It is requested the number of columns in the defined TAG schema to match the above structure.
Input data via the SDK
Machbase provides standard development tools for a variety of languages, including:
Through these libraries, users can create various application programs according to their environment and input data to Machbase.