How to update db online without closing application ?
Hi, Our application will be a desktop application with data in XML fomrat. The data is nothing but articles stored as XML and will be displayed in HTML format with the help of XSLT. For this we are using BaseX as desktop DB. Just changed to 7.6. The front-end will have a ListBox displaying the names of the articles, when selected by user, will display the transformed (HTML) document. Along with this functionality, we have given a search tool, which have some common XQuery features like; Exact Phrase, Proximity Search, Word1 OR Word, Word1 NOT Word2... This is what we have done successfully. Now we are stucked at one point. We have to give an online update facility through which the user DB will get updated, if not, as soon as he goes online. This part is also done but... While updating, the our application doesnt response till the updates are done. The user can't interact with the application. What we have planned is updating should be done as a background process and the user can interact with the application while updating. Also after updating the DB should get optimize and the updates should get reflected at the front-end. I hope I have cleared our needs and now waiting for your answer/suggestions. Have a nice day Pratik
On Fri, 2013-03-15 at 11:12 +0530, Pratik Kharwade wrote: [...]
While updating, the our application doesnt response till the updates are done. The user can't interact with the application.
Some initial thoughts: The update should be done by a separate process or thread than the user interface code. Update one document at a time: load a complete document to a temporary local file before telling BaseX to import it. An alternative is to work with two databases, updating the non-live one and then switching over. Liam -- Liam Quin - XML Activity Lead, W3C, http://www.w3.org/People/Quin/ Pictures from old books: http://fromoldbooks.org/ Ankh: irc.sorcery.net irc.gnome.org freenode/#xml
Hi Pratik, as Liam already suggested, the usual way of doing this is to work with two databases and update and optimize the aditional database. Next, you could try to use the UPDINDEX option, which will incrementally update your value index structures [1]. Hope this helps, Christian [1] http://docs.basex.org/wiki/Options#UPDINDEX ___________________________ On Fri, Mar 15, 2013 at 2:29 PM, Liam R E Quin <liam@w3.org> wrote:
On Fri, 2013-03-15 at 11:12 +0530, Pratik Kharwade wrote: [...]
While updating, the our application doesnt response till the updates are done. The user can't interact with the application.
Some initial thoughts:
The update should be done by a separate process or thread than the user interface code.
Update one document at a time: load a complete document to a temporary local file before telling BaseX to import it.
An alternative is to work with two databases, updating the non-live one and then switching over.
Liam
-- Liam Quin - XML Activity Lead, W3C, http://www.w3.org/People/Quin/ Pictures from old books: http://fromoldbooks.org/ Ankh: irc.sorcery.net irc.gnome.org freenode/#xml
_______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
participants (3)
-
Christian Grün -
Liam R E Quin -
Pratik Kharwade