Using Local Databases in WebDialogs

TommyK · 25 Nov 2015, 16:06

I am looking at putting together an extension that remembers previous content input into the classifier system, and allow future content to be autocompleted as the user starts to type.

(Personally, I want to start making Specifications and Schedules of Work within the model, which then gets generated into reports, but it could be very useful for many kinds of tagging).

It is clear I need a local indexed database for this. Ideally, I would use a database that can be manipulated/searched directly from the webdialog through javascript, but a Ruby-based database is an option. I have investigated:

indexedDB - was promising, but turns out WebDialog in OS X turns this feature off. Shame, as it seems to work in Safari. Anyone know any different?
XML file - simple, but am concerned that searching for strings would take too long.
WebSQL - no support for IE, and is set to be depreciated in future. Not an option really.
Ruby SQLite - it is ruby, more discussion here: http://sketchucation.com/forums/viewtopic.php?f=180%26amp;t=11594 . There seems to be a lot of doubts about getting it working well within Sketchup, with performance problems. But maybe this is the way to go?

I would really appreciate some advice on what the best path is. Has anyone tried using databases and what has been their experience?

Thanks in advance.