support for SQLite3

[cjoshi]

Hi,

I want to store some structured data with in Orchestrator, probably as a resource element or package file. I don't want to use a DB server. Ideally looking at a serverless solution. I believe SQLite3 & JSON file(s) stored on the filesystem should also work. Has anyone published in open source any library packages/actions to provide a native Orchestrator interface for emulating SQLite3 or working with JSON files (CRUD)?

Thanks.

Regards Shekhar

[cjoshi · Accepted solution]

Answering my own question, JSON is what I actually ended up using. Since that data is not much I don't really care of the performance I will get by using a JSON flat file. I found the following article to be useful, https://www.vcoteam.info/articles/learn-vco/305-creating-json-objects-in-orchestrator.html

I am using the 1st method described in the article to create JSON using vRO Properties.