Create a MySQL Database from a type def Cluster

[SeanJ]

I have a very large cluster.  I'm going to have to design a database to to match the cluster. 

I know in TestStand it is possible to automatically generate a MySQL database from a test report.  Is there any type of similar functionality in LabVIEW?  Basically, is there an easy way to do it that won't take up a lot of time?

[aputman]

The Insert Data VI in the Database Connectivity Toolkit has an option to create a table if one doesn't exist.

[Mark_Yedinak]

From a DB design perspective, should you see if the data should be saved in a single table? You may get much better performance from the DB if the data was separated into multiple tables. Without knowing the nature of the data it is difficult to tell but generally tables with lots of columns are not very efficient.

[drjdpowell]

You should consider the option of converting the cluster to JSON (using a tool like JSONtext) and storing that.  MySQL has a JSON data type that supports querying inside the JSON as if it were a table.  Depends on your use case, but it is very easy.