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

How could I reuse sub queries?
by donaldjohn 08 Aug '17

08 Aug '17

Hi, everyone: Here is my query that finds the distinct value and counts them, you can see that I used the same sub query twice, first for finding the distinct values, second for count the distinct values, is there a way that I can cache the sub query result and reuse it somewhere else? I think it will run faster in that way.

1 0

jobs:result deadlock
by Kendall Shaw 07 Aug '17

07 Aug '17

Can someone elaborate on this sentence in the documentation about jobs:result: “Please note that this query can easily cause a deadlock if the asynchronously executed query will be queued. “ Referring to this example: let $query := jobs:eval('(1 to 10000000)[. = 1]', map{}, map{ 'cache': true() }) return ( jobs:wait($query), jobs:result($query) ) And this about jobs:wait “If the function is called with the id of a queued job, or repeatedly executed job, it may stall and never terminate.” Can jobs:eval above be queued before jobs:wait is evaluated within the let expression? Kendall

2 1

Web application port
by Thomas Daly 07 Aug '17

07 Aug '17

Regarding http://docs.basex.org/wiki/Options#HTTP_Services , I see there's an option STOPPORT to change the server stop port. I think it should be possible to configure the server listen port (default 8984) there as well. I realise it's possible to do this through command line options, but it would be nice to be able to do it in the .basex file too. Thanks, Thomas

2 1

GUI
by Thomas Daly 06 Aug '17

06 Aug '17

a) It is not possible to log into a BaseX database running on a remote server from a GUI running on a different machine? b) Do I need any particular Linux distribution / GUI version to run the BaseX Linux GUI? Many thanks, Thomas

3 3

Shouldn't CHOP = false make xml:space="preserve" the default behavior?
by Ottid Mes 05 Aug '17

05 Aug '17

>From the documentation about the CHOP option I assumed that since xml:space="preserve" sets CHOP = false for that part of the document, that if I set CHOP = false in my configuration file, that the behavior you get when you use xml:space="preserve" would be applied to the whole database (I created the database after setting the option). However the only way I have ever been able to get this behavior, has been to set xml:space="preserve" at the root element. Am I missing something, or is this a bug? How could I get this behavior by default in my databases? I thought this would not warrent a thorough example given the clear conditions which cause the above situation, but I was asked for it anyway, so here it goes: A little bit of context, although it should not matter, I have had this issue for years (at least 4) under Arch Linux. At the time I just assumed I did something wrong and went with xml:space="preserve" workaround everywhere. > uname -a Linux phoenix 4.9.38 #1-NixOS SMP Sat Jul 15 10:17:55 UTC 2017 x86_64 GNU/Linux The default situation: No config file (.basex) > basex BaseX 8.6.4 [Standalone] > create db chop-test Database 'chop-test' created in 123.01 ms. > open chop-test Database 'chop-test' was opened in 1.19 ms. > replace /a <root><a>foo</a> bar</root> 0 resource(s) replaced in 103.68 ms. > xquery /root <root> <a> foo </a>bar</root> Query executed in 106.05 ms. I never use the REPL other than to create and drop databases, so I was a bit suprised that this did not work: > replace /a <root xml:space="preserve"><a>foo</a> bar</root> "a.xml" (Line 1): Open quote is expected for attribute "xml:space" associated with an element type "root". While this does: > replace /a <root xml:space='preserve'><a>foo</a> bar</root> 1 resource(s) replaced in 4.06 ms. > xquery /root <root xml:space="preserve"><a>foo</a> bar</root> Query executed in 0.95 ms. > quit Have fun. The resource with xml:space="preserve" is the behavior I want to have within my database, because all my documents are mixed content. On the wiki (http://docs.basex.org/wiki/Options#CHOP) this is also mentioned: It explicitly states that in my use case I should set CHOP to false: "The flag should be turned off if a document contains mixed content." It also states that setting the xml:space="preserve" attribute is the same as having CHOP = false: "If the xml:space="preserve" attribute is attached to an element, chopping will be turned off for all descendant text nodes." So lets do that: Let us first confirm that the config file is correctly read: > echo 'FOO = 0' > /some/path/.basex > BASEX_JVM='-Dorg.basex.path=/some/path' basex /some/path/.basex: Unknown option 'FOO'. /some/path/.basex: writing new configuration file. Now we set the option CHOP = false in our config: > echo 'CHOP = false' >> /some/path/.basex So lets see what this changes in the basex REPL: > BASEX_JVM='-Dorg.basex.path=/some/path' basex BaseX 8.6.4 [Standalone] > drop db chop-test Database 'chop-test' was dropped. > create db chop-test Database 'chop-test' created in 106.42 ms. > open chop-test Database 'chop-test' was opened in 0.05 ms. > replace /a <root><a>foo</a> bar</root> 0 resource(s) replaced in 39.24 ms. > xquery /root <root> <a> foo </a> bar</root> Query executed in 97.09 ms. > quit Have fun. This is not what I expect, it should have been: > xquery /root <root><a>foo</a> bar</root> And hence my question: Shouldn't CHOP = false make xml:space="preserve" the default behavior? I even tried this: > BASEX_JVM='-Dorg.basex.path=/some/path' basex BaseX 8.6.4 [Standalone] Try 'help' to get more information. > open chop-test Database 'chop-test' was opened in 90.65 ms. > set chop off CHOP: false > replace /a <root><a>foo</a> bar</root> 1 resource(s) replaced in 45.58 ms. > xquery /root <root> <a> foo </a> bar</root> Query executed in 96.78 ms. > quit See you. Am I making some mistake in the above? Is the wiki simply outdated and should this be configured differently? Is having having mixed content in basex so rare that this bug has gone unnoticed for years?

1 0

Performance analysis in web DBA
by Erik Peterson 03 Aug '17

03 Aug '17

Is there a way to get the query plan and stats in the web dba...like the native client has with the info view?

2 1

Artifact in Maven Central?
by Kirsten, Dirk 02 Aug '17

02 Aug '17

Hi guys, awesome database you got there! Imagine you want to use this database in a big enterprisey environment, where they block all kinds of ridiculous stuff, because of reasons... So for example you can't simply add the BaseX repository to your pom.xml, because actually all access is routed through a central mirror repository. So it would be super handy if BaseX was available in Maven central, because this stuff will be available. Unfortunately, the most current BaseX release on Maven central is 7.3.1, which is rather outdated. Are there any plans to release to Maven Central once again? I think the easiest way would be to sign up for http://central.sonatype.org/pages/ossrh-guide.html, which syncs to maven central. There seems to be some maven automation available, so once it is setup I would guess that you simply have to add it to Christians' magic build scripts. My other alternative would be to add the BaseX repository to this proxy repository, which most likely involves me getting a Passagierschein A38. Please don't let me do that :( All the best Dirk Dirk Kirsten ______________________________ Senacor Technologies AG D?sseldorfer Stra?e 13 65760 Eschborn M +49 (151) 4435 1967 Dirk.Kirsten(a)senacor.com www.senacor.com Senacor Technologies Aktiengesellschaft - Sitz: Eschborn - Amtsgericht Frankfurt am Main - Reg.-Nr.: HRB 105546 Vorstand: Matthias Tomann, Marcus Purzer - Aufsichtsratsvorsitzender: Daniel Gr?zinger Diese E-Mail inklusive Anlagen enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten, informieren Sie bitte den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail including any attachments may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the materials in this e-mail is strictly forbidden.

2 3

Connect a BaseX web application to an already running BaseX server
by Fabrice ETANCHAUD 02 Aug '17

02 Aug '17

Dear all, I would like to connect a BaseX web application to an already running BaseX server, But I cannot figure out how to do it without using the Client module. I tried to set the -n (HOST) option at webapp startup but it did not help. Best regards, [cerfranceimage] Fabrice ETANCHAUD Analyste Developpeur Les Rocs, Chavagné CS 40070 79260 LA CRECHE Tél. 05 49 76 45 45- Fax 05 49 25 83 87 Email : fetanchaud(a)pch.cerfrance.fr [cerfrancedevise] poitoucharentes.cerfrance.fr<http://www.poitoucharentes.cerfrance.fr> [facebook]<https://www.facebook.com/Cerfrance-Poitou-Charentes-686810324682939> [twitter]<https://twitter.com/CERFRANCE_PCH> [youtube]<https://www.youtube.com/user/CERFRANCEnational> [linkedin]<https://fr.linkedin.com/company/cerfrance-national-> [viadeo]<http://fr.viadeo.com/fr/company/cerfrance>

2 2

State of replication and clustering
by Andreas Jung 02 Aug '17

02 Aug '17

Hi there, what is the state of replication and clustering of BaseX? I found an XML Prague 2013 presentation but almost no documentation on these topics on the website. In our case we need to scale out horizontally with a growing number of reads (no writes involved). Andreas

4 5

Deployment of BaseX on Windows in Service Fabric?
by Andreas Jung 01 Aug '17

01 Aug '17

Hi there, has anyone experiences with deploying BaseX in Azure Service Fabric on a Windows node either as Guest Executable or Windows Container? Andreas

1 0