what is the best way to have a local database inside a splunk app?

[RiccardoV]

Hi,
I'm triying to create a little local database inside an app i'm developing for Splunk.
I have to redistribute that app, so the app must be stand-alone and must contains the db inside it.
I tried to use sqlite but I noticed that sqlite3 is not shipped inside splunk.

The only way I found right now is to use a csv file, but it hasn't great performance!

Do you have any suggestion?

Thanks!

[musskopf · Accepted solution]

Have a look on a solution I found to use sqlite3 inside python lookup scripts:

http://answers.splunk.com/answers/109009/splunk6-django-app-importing-sqlite

[yannK]

You could use a real database outide of splunk, see the bdconnect app.

[RiccardoV]

I have to develop a redistributable app, so it has to be "stand-alone", with its own db inside!

[yannK]

Actually, this is more for search language.
it may not work for your python scripting.