Re: [basex-talk] Possible to Speed Up This Lookup?

…. 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>

Re: [basex-talk] Possible to Speed Up This Lookup?

Yes, turning on the attribute index definitely improves performa nce dramatically, which is no surprise. Not sure how I missed the need to expressly turn on these indexes. Doing that now. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512

Re: [basex-talk] Possible to Speed Up This Lookup?

Yes, that is 100x faster. Clearly I need to slow down and RTFM a bit more closely. 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.co

Re: [basex-talk] Possible to Speed Up This Lookup?

. _ 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.c

Re: [basex-talk] Possible to Speed Up This Lookup?

database context is the database named in $rkDatabase. A small improvement (0.036 to 0.030) but not dramatic. So I think I’m still missing some detail, probably a configuration issue. Cheers, E, _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M

[basex-talk] What Would "Server is running or permission was denied." Indicate?

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

[basex-talk] Available Integration with Apache POI for Excel Generation?

. _ 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.c

[basex-talk] BaseX YAML Parser?

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

Re: [basex-talk] Fwd: Available Integration with Apache POI for Excel Generation?

, 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<ht

Re: [basex-talk] BaseX YAML Parser?

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>

[basex-talk] RESTXQ: How to Reflect Progress of Long-Running Querries

. _ 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/servicenowi

[basex-talk] Possible to Speed Up This Lookup?

: … _ 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> | T

[basex-talk] Adding Attributes After the Fact: How To?

implications for doing that kind of bulk update to millions of nodes. So any guidance on this kind of bulk update would be helpful. Thanks, Eliot _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.

[basex-talk] Oxygen and BaseX Integrations?

, 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<ht

Re: [basex-talk] BaseX 10 • The Double-Digit Summer Edition

If you just want to comment the entire line, cmd+k at the start will comment the whole line. No need to select it first. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.

[basex-talk] Get All Tokens for Attribute Name?

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.youtub

Re: [basex-talk] Get All Tokens for Attribute Name?

Thanks for the confirmation that I didn’t miss a feature. 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>

Re: [basex-talk] Get All Tokens for Attribute Name?

. _ 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/servicenowi

Re: [basex-talk] RESTXQ: Handling Lots of Parameters?

Of course—I should have thought to inspect the request. Thanks! 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/s

[basex-talk] RESTXQ: Handling Lots of Parameters?

to the page or maybe a dynamically-constructed form. 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> | T

[basex-talk] Log Analysis Tips?

the BaseX HTTP server. Note that we don’t yet have users implemented, so we’re just looking at HTTP requests with different IP addresses. Thanks, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<ht

Re: [basex-talk] Possible to get line number of node?

. _ 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.c

Re: [basex-talk] Possible to get line number of node?

Interesting—I did not know Oxygen provided this option. I’m wondering what I could put in an Excel spreadsheet that would make this work on a user’s machine… Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

[basex-talk] Possible to get line number of node?

in case I’ve missed some trick. 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

Re: [basex-talk] right way to create a db in the middle of processing?

. _ 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/servi

Re: [basex-talk] Pretty print

starting point. 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/service

[basex-talk] Integrating BaseX With Server-Side Python

. _ 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:/

[basex-talk] Constructing "resolved" DITA Map in XQuery: How to Avoid High Memory usage?

simple code that just operates on the resolved map. 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> | T

Re: [basex-talk] Constructing "resolved" DITA Map in XQuery: How to Avoid High Memory usage?

. _ 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/servicenowi

[basex-talk] Help Diagnosing Memory Leak in SAXWrapper or Associated Code

s across the set of documents to be parsed. 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

Re: [basex-talk] Help Diagnosing Memory Leak in SAXWrapper or Associated Code

Christian, Thanks for the top—I’ll try the flight recorder. 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/s

Re: [basex-talk] Reducing logs

by the XQuery code serving the pages that are useful. 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> | T

Re: [basex-talk] Possible to optimize XPath lookup by string match on element content?

. _ 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:/

[basex-talk] Possible to optimize XPath lookup by string match on element content?

ext”, although I suspect that it’s not really offering an advantage over a simple ends-with(.) check. Thanks, Eliot _________ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn<https:/

[basex-talk] Apparent bug when setting @xml:base on element with @base

found the problem). Cheers, 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

Re: [basex-talk] Performance of db:get-value() for large maps

and token indexes to optimize retrieval. But in the sequence of “make it work, make it right, make it fast”, this is a pretty good result. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<ht

[basex-talk] How to get stack trace from an Query Exception?

the stack trace in XQuery? I didn’t find anything searching on the BaseX-supplied DBA app. 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.lin

[basex-talk] Determining if a node is a database node

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/s

Re: [basex-talk] Determining if a node is a database node

. Of course it would also be useful for functions that may operate on database nodes or content parsed from the file system. Cheers, Eliot _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.

[basex-talk] How best to cache an intermediate result in the context of a larger query?

updating options are. 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/service

Re: [basex-talk] Timeframe for supporting fn:load-xquery-module()?

in a Schematron. If there’s anything I can do to assist or test a Schematron implementation, please don’t hesitate to reach out. Cheers, Eliot _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.

[basex-talk] Trying to apply Query Update 3.0 update/transform operations

have, despite my best efforts, figured out how do this map resolution as efficiently as possible. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn

[basex-talk] In XSLT run by Saxon against doc in a database, how to resolve URI references?

orm, but this seems to be a blocker. I’m sure it would work to use the BaseX REST API to access the docs from the XSLT, but that of course requires having a running server and HTTP handler. I was hoping this would just work. Thanks, E. _ Eliot Kimber Sr Staff Conte

[basex-talk] Trying to apply Query Update 3.0 update/transform operations

_ 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.c

Re: [basex-talk] Trying to apply Query Update 3.0 update/transform operations

(.)) } ,() ) _ 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.c

Re: [basex-talk] How best to cache an intermediate result in the context of a larger query?

XQuery tree walk of the incoming XML to make the HTML). 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> | T

Re: [basex-talk] How best to cache an intermediate result in the context of a larger query?

. We’ll see how this approach works. 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

[basex-talk] Values stored to a database vs using the new store

and I’m very excited to take advantage of this new feature. 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>

[basex-talk] Setting up redirects and https

seeing of ChatGPT can get me close to a solution. 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> | T

[basex-talk] Performance of db:get-value() for large maps

as element()* := $keySpace?keyscopes?($scopeKey)?keydefs?($keyName) 3. Is there some other maps-in-a-database optimization technique I’m overlooking? Thanks, Eliot _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

Re: [basex-talk] Consistent NPE loading content on one server, other server works

); } if(meta.ftindex) ftIndex = new FTIndex(this); The idmap is only set of meta.updIndex is true. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn

Re: [basex-talk] Consistent NPE loading content on one server, other server works

I will test forthwith. 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

Re: [basex-talk] Using ft:search() across element boundaries: possible?

, it probably makes sense to have a dedicated title index or maybe a “title and block elements” index. I’ll have to think on that more. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<ht

Re: [basex-talk] Generate CSV with literal "&", not ""

file:write-text() did the trick—that did not occur to me at all. 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/s

[basex-talk] Using ft:search() across element boundaries: possible?

to this requirement? Note that in this case I don’t care about finding different word forms—for this particular search I only care about exact word matches. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

[basex-talk] Generate CSV with literal "&", not ""

ouver”;)" Note that the “&” is still escaped. Reviewing the docs for the CVS module and the serialize options, I don’t see any option that looks like it would control how escaping is handled. Is there a way to do what I want? Thanks, E. _____ E

[basex-talk] Consistent NPE loading content on one server, other server works

'attrindex' : true(), 'tokenindex' : true(), 'updindex' : true() }) ) } catch * { util:logToConsole( 'analyticsmgmt:storeAnalyticsCsvReport', ``[`{$err:code}`: `{$err:description}`]``, 'error' ) } Thanks, Eliot ____

[basex-talk] Odd "Access denied" messages in the log

something generated by my own code. Any idea what this might be? It’s started relatively recently, which makes me think it might be some sort of penetration test. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

Re: [basex-talk] error Access Denied

If you’re using version 10 or newer there is no default admin password—you have to set it as a one-time task after you start the server for the first time. See https://docs.basex.org/wiki/Database_Server Cheers, Eliot _ Eliot Kimber Sr Staff Content

Re: [basex-talk] hof:until is gone?

This feels like an ideal use case for XSLT for-each-group—something that is challenging to implement in XQuery. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer Digital Content & Design O: 512 554 9368 M: 512 554 9368 servicenow.com&l

[basex-talk] Optimize database never returns, leaves database in "opened by another process" state

for me to set up). 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

Re: [basex-talk] Optimize database never returns, leaves database in "opened by another process" state

for the old Query feature in the DBA app. 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<http

[basex-talk] DBA Editor behavior in v11 not as expected

into the panel, the Run button is enabled. I think this behavior is incorrect—as long as there is some content in the editor the Run button should be enabled. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

Re: [basex-talk] DBA Editor behavior in v11 not as expected

I use “.xqy” for full XQuery scripts and “.xqm” for XQuery modules. 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/s

Re: [basex-talk] Optimize database never returns, leaves database in "opened by another process" state

As reported in a separate thread, I’m still getting the optimization failure for large databases but not smaller ones. This behavior is consistent in my tests. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

Re: [basex-talk] DBA Editor behavior in v11 not as expected

saved). In my case I’m switching between two little test scripts: one to store docs and one to operate on them, so having to respond to an unnecessary confirmation every time I switch is annoying. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O

[basex-talk] Inconsistency in base-uri()

Using BaseX 11 (but I think the code is the same in BaseX 10). I’m trying to understand how base-uri() behaves relative to how it should behave when the database path of a document is not a valid URI, i.e., it has a space in it. First I have this test: let $doc as document-node() := document

Re: [basex-talk] Inconsistency in base-uri()

document type in common usuage that has a similar hyperlink structure that depends on using xml:base. Cheers, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368 servicenow.com<https://www.servicenow.com> LinkedIn

Re: [basex-talk] Optimize database never returns, leaves database in "opened by another process" state

that cannot now be fetched. But I’m not finding any maven options that will work around this failure. Any idea how I can move past this? Or is there a nightly build somewhere I can download? Thanks, Eliot _____ Eliot Kimber Sr Staff Content Engineer O:

Re: [basex-talk] Optimize database never returns, leaves database in "opened by another process" state

Using the latest build, 11.0 beta 17d8426, the prof:dump() function is reported as an unknown function. What replaces it (or where can I find the V11 docs)? Thanks, E. _ Eliot Kimber Sr Staff Content Engineer O: 512 554 9368 M: 512 554 9368

Re: [basex-talk] Optimize database never returns, leaves database in "opened by another process" state

Found the latest build at https://files.basex.org/releases/latest/ 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/s

<    1   2   3