SQLite Lineator plugin

[viSci]

I guess the broader topic here is how to store objects or complex data structures in a database.  I think it should be possible to build a cluster to SQLite API but now that we have the lineator I wonder if it is possible and makes more sense to build this as a plugin.  

 

[JackDunaway]

I guess the broader topic here is how to store objects or complex data structures in a database.

 

The general term for this is "object relational mapping".

[unicorn]

Some time ago I made a VI which does the job the other way. It creates clusters from database tables. Using these clusters you can read a line of a database table at once. But it does not create a conversion to different complex data structure. Anyway I think it is quite complicated to do the job  automatically unless you have set of specifications. I think one would get into trouble if you want to create universal specification which are not too tight to ones current Project. So in my case I get only clusters with basic data types and the labels are given by the column names of the database tables.

[Phillip Brooks]

I made something like this too; I posted it on the dark side... 

 

https://decibel.ni.com/content/docs/DOC-19512

[viSci]

Here is my take on converting Clusters to SQLite table records....

Cluster to SQLite Demo.zip