July 2022 - 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] BaseX YAML Parser?
by Adam Law 29 Jul '22

29 Jul '22

Perhaps you have already seen: https://gist.github.com/joewiz/ed624a43cb6f9e15cc44b6e30553ad5e I think it might be for ExistDB On Wed, Jul 27, 2022 at 6:00 PM <basex-talk-request(a)mailman.uni-konstanz.de> wrote: > 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. Re: Fwd: Available Integration with Apache POI for Excel > Generation? (Eliot Kimber) > 2. BaseX YAML Parser? (Eliot Kimber) > 3. Re: BaseX YAML Parser? (Marco Lettere) > 4. Re: BaseX YAML Parser? (Martin Honnen) > 5. Re: BaseX YAML Parser? (Hans-Juergen Rennau) > 6. Re: BaseX YAML Parser? (?yvind Gjesdal) > 7. Re: BaseX YAML Parser? (Imsieke, Gerrit, le-tex) > 8. Re: BaseX YAML Parser? (Eliot Kimber) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 26 Jul 2022 13:08:24 +0000 > From: Eliot Kimber <eliot.kimber(a)servicenow.com> > To: BaseX <basex-talk(a)mailman.uni-konstanz.de> > Subject: Re: [basex-talk] Fwd: Available Integration with Apache POI > for Excel Generation? > Message-ID: > < > SN4PR0801MB77576BAD6B0F077D6727731CF1949(a)SN4PR0801MB7757.namprd08.prod.outlook.com > > > > Content-Type: text/plain; charset="windows-1252" > > Tim, > > Thanks for the pointer?that?s not quite what I was looking for. > > What I have in mind is adding functions that let you read and write Excel > spreadsheets using the POI API, which is much easier to use than > interacting directly with the OOXML under the covers (Excel uses a lot of > indirection and data normalization to minimize file size that makes > operating on the raw XML really challenging). > > I fully understand that Christian?s team have done this kind of work for > hire and are not keen (or even contractually allowed) to give it away. It?s > valuable stuff. > > But I had to ask? > > 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> > > From: BaseX-Talk <basex-talk-bounces(a)mailman.uni-konstanz.de> on behalf > of Tim Thompson <timathom(a)gmail.com> > Date: Monday, July 25, 2022 at 5:50 PM > To: BaseX <basex-talk(a)mailman.uni-konstanz.de> > Subject: [basex-talk] Fwd: Available Integration with Apache POI for Excel > Generation? > [External Email] > > Resending to the list (forgot to reply all). > > ---------- Forwarded message --------- > From: Tim Thompson <timathom(a)gmail.com<mailto:timathom@gmail.com>> > Date: Mon, Jul 25, 2022 at 5:04 PM > Subject: Re: [basex-talk] Available Integration with Apache POI for Excel > Generation? > To: Eliot Kimber <eliot.kimber(a)servicenow.com<mailto: > eliot.kimber(a)servicenow.com>> > > Hi, Eliot, > > I'm not aware of any integration with Apache POI (which would be great), > but here's a project--it seems unfinished, but may be enough to get started > with? > > https://github.com/eliudmeza/OOXML-Library-XQuery-BaseXdb< > https://urldefense.com/v3/__https:/github.com/eliudmeza/OOXML-Library-XQuer… > > > > All best, > Tim > > > -- > Tim A. Thompson (he, him) > Librarian for Applied Metadata Research > Yale University Library > > > On Mon, Jul 25, 2022 at 2:29 PM Eliot Kimber <eliot.kimber(a)servicenow.com > <mailto:eliot.kimber@servicenow.com>> wrote: > I tried searching for ?BaseX Excel generation? but it didn?t get me > farther than a reference to the CSV module, which of course I am familiar > with. > > I need to add the ability to generate non-trivial Excel spreadsheets, > which I know how to do using the Apache POI library, but being lazy I was > hoping somebody had already done it in a shareable form. > > So my question: Does anyone have or know of a shareable integration of > Apache POI with BaseX for generating Excel spreadsheets or some other > Excel-generation solution that is not just downloading CSV files? > > Thanks, > > E. > _____________________________________________ > Eliot Kimber > Sr Staff Content Engineer > O: 512 554 9368 > M: 512 554 9368 > servicenow.com<https://www.servicenow.com> > LinkedIn< > https://urldefense.com/v3/__https:/www.linkedin.com/company/servicenow__;!!…> > | Twitter< > https://urldefense.com/v3/__https:/twitter.com/servicenow__;!!N4vogdjhuJM!C…> > | YouTube< > https://urldefense.com/v3/__https:/www.youtube.com/user/servicenowinc__;!!N…> > | Facebook< > https://urldefense.com/v3/__https:/www.facebook.com/servicenow__;!!N4vogdjh… > > >

3 3

fn:apply with an updating function
by Hans-Juergen Rennau 28 Jul '22

28 Jul '22

Dear BaseX people, I encounter a problem with standard function fn:apply(), applied to an updating function. declare %updating function f:apply-dbPut($db as xs:string, $input as item(), $path as xs:string) { let $fn := function-lookup(QName('http://basex.org/modules/db', 'put'), 3) let $args := [$db, $input, $path] return apply($fn, $args)}; Message:[XUST0002] Function body must be updating. Therer seems to be a checking looking for an updating function, and apply() cannot, of course, be classified as such. Do I make a mistake, or is it a limitation, or a bug? Thank you for checking, kind regards -Hans-Jürgen

2 2

BaseX YAML Parser?
by Eliot Kimber 26 Jul '22

26 Jul '22

I found myself needing to operate on some YAML documents and tried to find an XQuery YAML parser and did not find one, at least not one of sufficient completeness. It seems like kind of an obvious missing thing in the XQuery world so just curious if I missed something? I don’t have time myself to write one—it can’t be that hard but it’s not that critical of a need for me. I ended up using the Python PyYAML library, which let me quickly convert YAML to JSON, which then I could of course process just fine with XQuery. Thanks, 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>

6 6

Fwd: Available Integration with Apache POI for Excel Generation?
by Tim Thompson 26 Jul '22

26 Jul '22

Resending to the list (forgot to reply all). ---------- Forwarded message --------- From: Tim Thompson <timathom(a)gmail.com> Date: Mon, Jul 25, 2022 at 5:04 PM Subject: Re: [basex-talk] Available Integration with Apache POI for Excel Generation? To: Eliot Kimber <eliot.kimber(a)servicenow.com> Hi, Eliot, I'm not aware of any integration with Apache POI (which would be great), but here's a project--it seems unfinished, but may be enough to get started with? https://github.com/eliudmeza/OOXML-Library-XQuery-BaseXdb All best, Tim -- Tim A. Thompson (he, him) Librarian for Applied Metadata Research Yale University Library On Mon, Jul 25, 2022 at 2:29 PM Eliot Kimber <eliot.kimber(a)servicenow.com> wrote: > I tried searching for “BaseX Excel generation” but it didn’t get me > farther than a reference to the CSV module, which of course I am familiar > with. > > > > I need to add the ability to generate non-trivial Excel spreadsheets, > which I know how to do using the Apache POI library, but being lazy I was > hoping somebody had already done it in a shareable form. > > > > So my question: Does anyone have or know of a shareable integration of > Apache POI with BaseX for generating Excel spreadsheets or some other > Excel-generation solution that is not just downloading CSV files? > > > > Thanks, > > > > 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 1

Available Integration with Apache POI for Excel Generation?
by Eliot Kimber 26 Jul '22

26 Jul '22

I tried searching for “BaseX Excel generation” but it didn’t get me farther than a reference to the CSV module, which of course I am familiar with. I need to add the ability to generate non-trivial Excel spreadsheets, which I know how to do using the Apache POI library, but being lazy I was hoping somebody had already done it in a shareable form. So my question: Does anyone have or know of a shareable integration of Apache POI with BaseX for generating Excel spreadsheets or some other Excel-generation solution that is not just downloading CSV files? Thanks, 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 1

What Would "Server is running or permission was denied." Indicate?
by Eliot Kimber 18 Jul '22

18 Jul '22

One my RESTXQ pages constructs an HTML report that takes a few seconds to construct. The page works fine in my local dev environment but when I deploy the code on my production server the process fails after constructing the report markup with the log messages: Server is running or permission was denied. Server is running or permission was denied. Server is running or permission was denied. That is, the message is emitted three times in a row with about 50ms between and the page generation fails (page never appears in the browser). Any idea what condition this might indicate and how I might track it down? It must be something I’m doing in my code but I can’t find any obvious logic bugs so wondering what kind of thing I might look for. Thanks, Eliot _____________________________________________ 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 1

First steps with client/server on Linux - bulk import; error message in dba
by Florian Schmitt 18 Jul '22

18 Jul '22

Hi all, i'm currently evaluating BaseX running on a headless Linux Server. It took me quite a while to get it running (the docs seem to be focused on Windows environments)... Is there a way to contribute to the documentation? First question: After importing some of documents nicely organized in collections, i've found that the REST client will display all documents on the same "level" instead of showing just the first level of collections. This isn't nice if the db contains a great number of documents.... When accessing the same db using WebDAV (Oxygen), one can nicelly navigate using the collection structure. With REST, adding the collection names to the URL will restrict the output to the db content of those collections. But without such a restriction, it would be great if the REST web interface would just return the first level of collections without any XML resource entries. Second question: What's the "best practice" for bulk imports while retaining the directory structure of the imported files using collections? I've found that Oxygen "translates" subdirectories into collections when using the "import directories" feature. Is there somehing similar using the command line client? And another issue: The "Logs" page of the DBA webapp shows the following error warning: "Unexpected error: Improper use? Potential bug? Your feedback is welcome: Contact..." Is this a critical error? How to debug this? So far, i'found the wrapper-basex log, but it doesn't contain anything useful. Since i'm using the Yajsw Wrapper, there's no debug output or debug option (?). Yours sincerely. Florian

4 8