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

BaseX 9.6: The Summer Edition
by Christian Grün 28 Nov '24

28 Nov '24

Dear all, We provide you with a new and fresh version of BaseX, our open source XML framework, database system and XQuery 3.1 processor: https://basex.org/ Apart from our main focus (query rewritings and optimizations), we have added the following enhancements: XQUERY: MODULES, FEATURES - Archive Module, archive:write: stream large archives to file - SQL Module: support for more SQL types - Full-Text Module, ft:thesaurus: perform Thesaurus queries - Fulltext, fuzzy search: specify Levenshtein limit - UNROLLLIMIT option: control limit for unrolling loops XQUERY: JAVA BINDINGS - Java objects of unknown type are wrapped into function items - results of constructor calls are returned as function items - the standard package "java.lang." has become optional - array arguments can be specified with the middle dot notation - conversion can be controlled with the WRAPJAVA option - better support for XQuery arrays and maps WEB APPLICATIONS - RESTXQ: Server-Timing HTTP headers are attached to the response For a more comprehensive list of added and updated features, look into our documentation (docs.basex.org) and check out the GitHub issues (github.com/BaseXdb/basex/issues) Have fun, Your BaseX Team

11 43

recursively used variables
by Rob Stapper 12 Aug '24

12 Aug '24

Hi, The code[1] below and send as attachment generates a error message: “Static variable depends on itself: $Q{http://www.w3.org/2005/xquery-local-functions}test”. I use these variables to refer to my private functions in my modules so I can easyly refer to them in a inheritance situation. It’s not a big problem for me but I was wondering if the error-triggering is justified or that it should work. [1]=========================================== declare variable $local:test := local:test#1 ; declare %private function local:test( $i) { if ( $i > 0) then $local:test( $i - 1) } ; $local:test( 10) =========================================== Kind regards, Rob Stapper Sent from Mail for Windows 10 -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 7

xslt:transform-report result
by Andy Bunce 11 Mar '24

11 Mar '24

Hi, Using BaseX 9.7.1 and saxon9he-9.9.1.jar The documentation suggests the ?result from xslt:transform-report should be *a* document-node where possible [1] This seems not quite to be the case when there are processing instructions or comments at the top level. In these cases a sequence of document-nodes is returned. /Andy [1] https://docs.basex.org/wiki/XSLT_Module#xslt:transform-report let $xslt:=<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="3.0"> <xsl:mode on-no-match="shallow-copy"/> </xsl:stylesheet> let $xml:=document{ <?something type="compact"?>, <foo/>} return xslt:transform-report($xml,$xslt) Returns map { "messages": (), "result": (<?something type="compact"?>, <foo/>) }

3 7

Re: [basex-talk] Crash when starting basexgui
by Michael Seiferle 21 Nov '23

21 Nov '23

Dear Joe, Thanks for the report,I haven’t upgraded to Sonoma yet, but will this afternoon :) I will try to reproduce the error and come back to the list. :-) Best Michael Am 24.10.2023 um 13:40 schrieb Joe Wicentowski <joewiz(a)gmail.com>: Hi all, I am experiencing a crash when starting basexgui. The splash screen appears briefly, and then the message pasted in below appears, and I've also attached the referenced error report file and the crash report that appears in the Mac crash dialog. I'm using BaseX 10.7, installed via Homebrew (which installed BaseX's openjdk dependency and thus is using openjdk 21), on macOS Sonoma (14.0). I'd be happy to provide any other info that would help in identifying the cause of the crash. Joe % basexgui 2023-10-24 07:34:22.308 java[69449:3862142] WARNING: Secure coding is automatically enabled for restorable state! However, not on all supported macOS versions of this application. Opt-in to secure coding explicitly by implementing NSApplicationDelegate.applicationSupportsSecureRestorableState:. # # A fatal error has been detected by the Java Runtime Environment: # # SIGILL (0x4) at pc=0x00007ff80d2b1b73, pid=69449, tid=259 # # JRE version: OpenJDK Runtime Environment Homebrew (21.0) (build 21) # Java VM: OpenJDK 64-Bit Server VM Homebrew (21, mixed mode, sharing, tiered, compressed oops, compressed class ptrs, g1 gc, bsd-amd64) # Problematic frame: # C [AppKit+0xc8fb73] _NSCarbonMenuCrashIfNeeded+0x258 # # No core dump will be written. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again # # An error report file with more information is saved as: # /Users/joe/workspace/hsg-project/repos/hsg-shell/hs_err_pid69449.log # # If you would like to submit a bug report, please visit: # https://github.com/Homebrew/homebrew-core/issues # The crash happened outside the Java Virtual Machine in native code. # See problematic frame for where to report the bug. # zsh: abort basexgui <hs_err_pid69449.log.zip> <basex-crash-report-macos.txt.zip>

4 10

Text index on uncommon node
by Matthew Dziuban 30 Oct '23

30 Oct '23

Hi all, I'm working with a database structured like so: <data> <element>...</element> <element>...</element> <element>...</element> </data> There are a total of about 1.5 million <element> nodes in the database. Each <element> has many child nodes, one of which is uncommon -- it only appears in 727 <element>s. I'm writing a query that has a condition on this uncommon field, but the query takes about 20 seconds to run, whereas another with a condition on a child node that appears in every <element> only takes about 20 milliseconds to run. Based on the Info in the GUI, it does appear that the text index is being used -- I see 'apply text index for "..."'. Is it expected that the query time would be this much longer? Is the text index somehow built differently for nodes that don't appear often in the database? Thanks in advance, Matt

2 4

RESTXQ Custom Multipart Response
by Jean-Marc ANSEL 29 Oct '23

29 Oct '23

Hello, I'm trying to do a custom multipart response with basex RESTXQ module. The Custom Response paragraph of https://docs.basex.org/wiki/RESTXQ indicates : Custom responses can be generated in XQuery by returning an |rest:response| element, an |http:response| child node that matches the syntax of the EXPath HTTP Client Module <http://expath.org/spec/http-client> specification, and optional child nodes that will be serialized as usual. So, the §4.1 of http://expath.org/spec/http-client (EXPath HTTP Client Module <http://expath.org/spec/http-client>) indicates : <http:response status = integer message = string> (http:header*, (http:multipart | http:body)?) </http:response> But when I try : declare %rest:path('media4') function page:testjm4() { <rest:response> <http:response status="200" message="OK"> <http:header name="Content-Length" value="100"/> <http:body media-type="text"> TEST </http:body> </http:response> </rest:response>}; The answer is irremediably : Stopped at /root/basex/webapp/test.xqm, 46/39: [basex:restxq] Unexpected node: <http:body xmlns:http="http://expath.org/ns/http-client" media-type="text">
TEST 
</http:body> Neither hhtp:body or http:multipart element can be placed as a child of http:response, that seems contradictory with the expath.org spec... Any help would be appreciated... Thanks o lot! JM Using : BaseX Version 10.7 httpserver : basexhttp Operating System: Ubuntu 18.04.6 LTS Kernel: Linux 4.15.0-197-generic Architecture: x86-64

2 1

Db:token() vs db:attribute(): Attribute is much slower -- why
by Eliot Kimber 26 Oct '23

26 Oct '23

Using 10.6 on macOS: I have a data file with elements like: <record language="en-US" family="pce-test-data" bundlename="bundle-appportman-application-portfolio-management" topicpath="product/application-portfolio-management/concept/application-portfolio-management-landing-page.dita" notviewed="viewed" viewcount="13579"> One such entry for each topic in our public docs server that is accessed at least once (Adobe page views data). I generate a report for all the topics used from a root map that includes the page views data for each topic for which there is an entry. The database with this data set is indexed with an attribute and a token index. In my testing I’m finding that lookup using db:attribute() on the @topicpath attribute (which is always a single value) is about 10x slower than using db:token(). That is, I have this code: $records := db:token($analyticsmgmt:analyticsDatabase, $docPath, 'topicpath')/.. When I run this for a set of about 1200 topics, the db:token version takes about 400ms but the db:attribute version takes 9 seconds! I’m surprised at this result—I would expect the two forms of index to perform with the same speed: the attribute is a single blank-delimited token and I would expect the string match under the covers to be using the same code path. But using the db:token database is clearly faster by a lot. If I report the time each lookup uses, the times vary quite a lot, but for the token lookup they tend to be in the 10-60ms range, but for the attribute lookup, many are in the 1 or 2 second range, which explains the much longer run time. I’m wondering if this result is expected due to implementation details of the attribute index as distinct from the token index or if this indicates some logic bug in the attribute index implementation. Cheers, E. _____________________________________________ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | Twitter<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Facebook<https://www.facebook.com/servicenow>

2 4

Crash when starting basexgui
by Joe Wicentowski 24 Oct '23

24 Oct '23

Hi all, I am experiencing a crash when starting basexgui. The splash screen appears briefly, and then the message pasted in below appears, and I've also attached the referenced error report file and the crash report that appears in the Mac crash dialog. I'm using BaseX 10.7, installed via Homebrew (which installed BaseX's openjdk dependency and thus is using openjdk 21), on macOS Sonoma (14.0). I'd be happy to provide any other info that would help in identifying the cause of the crash. Joe % basexgui 2023-10-24 07:34:22.308 java[69449:3862142] WARNING: Secure coding is automatically enabled for restorable state! However, not on all supported macOS versions of this application. Opt-in to secure coding explicitly by implementing NSApplicationDelegate.applicationSupportsSecureRestorableState:. # # A fatal error has been detected by the Java Runtime Environment: # # SIGILL (0x4) at pc=0x00007ff80d2b1b73, pid=69449, tid=259 # # JRE version: OpenJDK Runtime Environment Homebrew (21.0) (build 21) # Java VM: OpenJDK 64-Bit Server VM Homebrew (21, mixed mode, sharing, tiered, compressed oops, compressed class ptrs, g1 gc, bsd-amd64) # Problematic frame: # C [AppKit+0xc8fb73] _NSCarbonMenuCrashIfNeeded+0x258 # # No core dump will be written. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again # # An error report file with more information is saved as: # /Users/joe/workspace/hsg-project/repos/hsg-shell/hs_err_pid69449.log # # If you would like to submit a bug report, please visit: # https://github.com/Homebrew/homebrew-core/issues # The crash happened outside the Java Virtual Machine in native code. # See problematic frame for where to report the bug. # zsh: abort basexgui

1 0

New escape-solidus option
by Thompson, Timothy 23 Oct '23

23 Oct '23

Hello, I was very happy to see that a new escape-solidus option had been defined for XQuery/XPath 4.0. Is this available in the latest BaseX snapshot? I tried this: <fn:map> <fn:string key="Escape/Solidus">Test</fn:string> </fn:map> => serialize(map {"method": "json", "json": map {"format": "basic", "escape-solidus": "no"}}) But it returns: {"Escape\/Solidus":"Test"} Thank you, Tim -- Tim A. Thompson (he, him) Librarian for Applied Metadata Research Yale University Library

2 3

Access denied using client
by Csaba Fekete 21 Oct '23

21 Oct '23

Hello, A total newbie here, I'm a first time user. I have installed basex on Ubuntu and I'm running the server attached to 127.0.0.1, on port 1984. It looks like this is working and the server is listening. Now I create a password for admin: basex@cac5ba21e248:/opt/basex/bin$ ./basex BaseX 10.8 beta [Standalone] Try 'help' to get more information. > PASSWORD xxx Password of user 'admin' changed. Now I'm trying to connect using the client: basex@cac5ba21e248:/opt/basex/bin$ ./basexclient -n127.0.0.1 -p1984 -Uadmin -Pxxx Access denied: admin. The server log confirms the same: basex@cac5ba21e248:~/basex/.logs$ cat 2023-10-20.log 18:51:30.575 SERVER admin OK Server was started (port: 1984). 18:51:42.316 172.22.0.1:41314 admin ERROR Access denied: admin. 30.7 ms 18:53:04.079 172.22.0.1:59892 admin ERROR Access denied: admin. 23.59 ms What am I missing? Thanks and regards PS. I'm doing this inside a docker container if that matters.

3 6