- BaseX-Talk - mailman.uni-konstanz.de

Binding external variable in GUI
by buddyonweb-software＠yahoo.com 15 Feb '16

15 Feb '16

At the risk of a) sounding like a real newbie b) being accused of not Googling for an answer (which I did - but apparently overlooked) I am wondering how I can bind an external variable using just XQuery syntax in the BaseX GUI. I have found how to set the variable via command line options, and how to do it in Java, but I merelywanted to run a quick interactive test in the GUI to test an idea of mine (before writing a bunch of Java code).What I have done is in a tab in the GUI, I have included the module, and before running a function, want to set that external variable. Surprisingly I found myself at a loss on how to do what appears to be a simple task. So, thanks in advance for any help....and for the rest of this community for not laughing at me too loudly Buddy

3 2

Spectactularly slow performance with db:open vs. db:text
by Hondros, Constantine (ELS-AMS) 15 Feb '16

15 Feb '16

Hello Basexers, I'm getting such a low performance on a relatively simple join between two databases that I feel there must be something going wrong here. I can provide the sources if necessary, but basically DB1 is 26 MB, about 80,000 small documents; DB2 is 47 MB, about 18,500 small documents. I'm using 8.4, by the way, haven't tested on other releases. Query 1 [returns in 144 minutes] ---------------------------------------- for $a in (db:open('DB1')/item/order-id) return if (db:open('DB2')//order-id[. = $a]) then $a else () Note that the optimized query uses db:open-pre to access DB2. When I re-write the query myself to use the TEXT index then performance is excellent. But why such a difference? Query 2 [returns in 0.3 second] ---------------------------------------- for $a in (db:open('DB1')/item/order-id) return if (db:text('DB2', $a)/parent::order-id) then $a else () ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 3

Serialization to jsonml / Whitespace-Handling
by Günter Dunz-Wolff 15 Feb '16

15 Feb '16

Hi all, hi Christian I want to serialize my xml-documents to jsonml like so: json:serialize(doc('bettelweib.xml')//*:body, map { 'format': 'jsonml' }) Inside the jsonml are lots of strings with unnecessary whitespace like: "Das Bettelweib von\n Locarno." How could I remove that whitespace and also \n during or after the serialization? Thanks for any help. Regards, Günter

2 4

Invalid certs
by Marco Lettere 15 Feb '16

15 Feb '16

Hi all, sorry for this maybe dumb question. Is it possible to declare the IGNORECERT option inside a XQuery script that will be executed from inside a Java? Thanks, Marco.

2 3

JavaDoc link?
by buddyonweb-software＠yahoo.com 15 Feb '16

15 Feb '16

I may have overlooked it (and if so, sorry), but I can't seem to find the link to the JavaDocs on any of the online documentation pages.Can you direct me to the online documentation page that has that link? Again sorry if it was right in front of me and I missed it. Thanks, Buddy

3 2

metadata
by Kendall Shaw 15 Feb '16

15 Feb '16

Unless there is now a standard way to associate metadata with documents and collections, is there a preferred method? I could try to ensure that there is always a unique id that can be derived from combination of an id attribute or element in the document + the document’s document uri, then have separate metadata documents that are associated with the unique id. Is there an obviously better approach? Kendall

2 1

Reference the currently open database?
by Hondros, Constantine (ELS-AMS) 11 Feb '16

11 Feb '16

Hello all, Maybe a dumb question, but I need to reference the currently open database. Is there a more elegant way than this? db:name((*)[1]) ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 1

Re: [basex-talk] Connecting database in C#
by Christian Grün 11 Feb '16

11 Feb '16

Hi Raj (cc to the list), > Yes, I did. I have created a Session class (provided online) but unable to connect it to the existing database. > // create session > Session session = new Session("localhost", 1984, "admin", "admin"); > > It doesn't find the localhost on my machine. I guess, I am missing something. Do I need to install SQL server first? BaseX is the database, so there’s no need for SQL server. Did you start a BaseX server instance? Our documentation might give you more insight, see the "Getting Started" Section.

2 3

Re: [basex-talk] BaseX and Git versioning of XML at the same
by Enea Parimbelli 10 Feb '16

10 Feb '16

Thanks Dirk and Eliot, Dirk's suggestion about the WRITEBACK option looks very promising, I'm gonna try it out but I guess it would fit my needs. Update: just tried it and it seems to work also on docs previously imported in a database and retrieved using db:open("DBname", "filename") so that's even better than providing the full path. I was well aware of the bad performances caused by working outside the optimized basex data model (hard to beat a key-value optimized datastore) but performances are not an issue for my specific application. Eliot's project sounds also very cool but I think it's a bit too much of an effort for the initial proof-of-concept tests that I have in mind. Thanks for the great suggestions and timely support... that was FAST :) Best, Enea 2016-02-10 13:55 GMT+01:00 <basex-talk-request(a)mailman.uni-konstanz.de>: > Send BaseX-Talk mailing list submissions to > basex-talk(a)mailman.uni-konstanz.de > > To subscribe or unsubscribe via the World Wide Web, visit > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > or, via email, send a message with subject or body 'help' to > basex-talk-request(a)mailman.uni-konstanz.de > > You can reach the person managing the list at > basex-talk-owner(a)mailman.uni-konstanz.de > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of BaseX-Talk digest..." > > > Today's Topics: > > 1. BaseX and Git versioning of XML at the same time (Enea Parimbelli) > 2. Re: BaseX and Git versioning of XML at the same time > (Dirk Kirsten) > 3. Re: BaseX and Git versioning of XML at the same time > (Eliot Kimber) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 10 Feb 2016 13:33:58 +0100 > From: Enea Parimbelli <enea.parimbelli(a)gmail.com> > To: basex-talk(a)mailman.uni-konstanz.de > Subject: [basex-talk] BaseX and Git versioning of XML at the same time > Message-ID: > <CABz3M_P4mWEsG20tws+UiCXoTbzXTEQqzX7-Ew=+kJJq= > pZsYg(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Dear all, > I'm Enea from Italy (working at the university of Pavia) and this is my > first email to this list and I hope you'll forgive my dumb question. > For one of my projects I was planning to use BaseX to be able to run > Xqueries to manipulate a bunch of XMLs that I have on my filesystem (i.e. > to take advantage of what XQuery can do vs manual editing of the xml > files). > At the same time I would like to have a version control system (Git in my > case) control my files to be able to diff, branch, revert changes etc. > However the way BaseX internally stores files is preventing me from doing > this easily. > > Here is an example of what I have in mind: > 0. I have a bunch of xmls in a folder (versioned with a git repo) > 1. I create a baseX database from these > 2. Run a bunch of updates/edits on the files using Xquery processor from > basex > 3. move back to git to diff what I've accomplished, commit, etc. > 4. (possibly more advanced, not sure if I really need this) I want to be > able to checkout a previous version of the files and have basex do the same > (i.e. if I run a query now I want it to run on the version of the xmls that > I have currently checked-out in my filesystem) > > Here are the (dumb) questions: > 1. Is there a way for basex (maybe some config settings when I create the > database?) to work keeping on the plain xml files? In a way that every > update query would actually change the original xml files (which I can view > with a plain text editor even "outside" the basex environment)? > 2. Is the only way of immediately seeing the changes I made to the xml > files to export the database after every update? > 3. (assuming 1 is doable) Would it be possible to have baseX recognize the > changes made to the xml files using an external editor (i.e. not through > xqueries run in basex)? > 4. From your experience is BaseX the proper tool for my purposes? It feels > to me that I merely want to use its xquery processor capabilities (and I > don't need the full-fledged database) while keeping the files plainly > stored in my filesystem... any suggestion on alternative options if baseX > doesn't sound like the right one? > > Thanks in advance for the help, > and congratulations on the great work (I used basex in the past in a more > orthodox way and was impressed by the numerous nice features... including > being the nice GUI and the hassle-free integration with tomcat!) > > Best regards, > Enea Parimbelli > > -- > Dr. Enea Parimbelli > Post-doctoral research fellow > Laboratory for Biomedical Informatics "Mario Stefanelli" > Department of Electrical, Computer and Biomedical Engineering > University of Pavia, Italy > e-mail: enea.parimbelli(a)gmail.com > phone: +39-0382-985057 +39-0382-985981 > http://www.labmedinfo.org/people/parimbelli >

1 0

BaseX and Git versioning of XML at the same time
by Enea Parimbelli 10 Feb '16

10 Feb '16

Dear all, I'm Enea from Italy (working at the university of Pavia) and this is my first email to this list and I hope you'll forgive my dumb question. For one of my projects I was planning to use BaseX to be able to run Xqueries to manipulate a bunch of XMLs that I have on my filesystem (i.e. to take advantage of what XQuery can do vs manual editing of the xml files). At the same time I would like to have a version control system (Git in my case) control my files to be able to diff, branch, revert changes etc. However the way BaseX internally stores files is preventing me from doing this easily. Here is an example of what I have in mind: 0. I have a bunch of xmls in a folder (versioned with a git repo) 1. I create a baseX database from these 2. Run a bunch of updates/edits on the files using Xquery processor from basex 3. move back to git to diff what I've accomplished, commit, etc. 4. (possibly more advanced, not sure if I really need this) I want to be able to checkout a previous version of the files and have basex do the same (i.e. if I run a query now I want it to run on the version of the xmls that I have currently checked-out in my filesystem) Here are the (dumb) questions: 1. Is there a way for basex (maybe some config settings when I create the database?) to work keeping on the plain xml files? In a way that every update query would actually change the original xml files (which I can view with a plain text editor even "outside" the basex environment)? 2. Is the only way of immediately seeing the changes I made to the xml files to export the database after every update? 3. (assuming 1 is doable) Would it be possible to have baseX recognize the changes made to the xml files using an external editor (i.e. not through xqueries run in basex)? 4. From your experience is BaseX the proper tool for my purposes? It feels to me that I merely want to use its xquery processor capabilities (and I don't need the full-fledged database) while keeping the files plainly stored in my filesystem... any suggestion on alternative options if baseX doesn't sound like the right one? Thanks in advance for the help, and congratulations on the great work (I used basex in the past in a more orthodox way and was impressed by the numerous nice features... including being the nice GUI and the hassle-free integration with tomcat!) Best regards, Enea Parimbelli -- Dr. Enea Parimbelli Post-doctoral research fellow Laboratory for Biomedical Informatics "Mario Stefanelli" Department of Electrical, Computer and Biomedical Engineering University of Pavia, Italy e-mail: enea.parimbelli(a)gmail.com phone: +39-0382-985057 +39-0382-985981 http://www.labmedinfo.org/people/parimbelli

3 2