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

Proposal for programmatically setting index options
by Andy Bunce 14 May '13

14 May '13

Hi, The index settings for a database can make a huge difference to query performance. I have been playing with a database where the time for a query using distinct-values went from 4secs to 4ms by increasing the MAXCATS value. Currently it is rather fiddly to change these values, particularly to this programmatically. with different values per database. I would find it useful there was an easier way to do this. A quick suggestion as to how this might be done: db:optimize could be extended to taker a third argument that matched the format of in indexes portion of the db:info command <indexes> <uptodate>true</uptodate> <textindex>ON</textindex> <attributeindex>ON</attributeindex> <fulltextindex>OFF</fulltextindex> <updindex>OFF</updindex> <maxcats>100</maxcats> <maxlen>96</maxlen> </indexes> e.g db:optimize("mydb",fn:true(),$indexopts) This would rebuild "mydb" using the settings specified in $indexopts. The extra argument could also be added to db:create. /Andy

2 1

encountered baseX error/potential bug
by Rob Stapper 14 May '13

14 May '13

Hi guys, Probably no news but just to be sure: - The use of the 'http://www.basex.org/serialize'-package gives problems in Basex 7.7 beta. See message below success, Rob Stapper MESSAGE: Error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.7 beta Java: Oracle Corporation, 1.7.0_21 OS: Windows Vista, x86 Stack Trace: java.lang.RuntimeException: $2 as item()* org.basex.util.Util.notexpected(Util.java:53) org.basex.query.QueryStack.pos(QueryStack.java:67) org.basex.query.QueryStack.set(QueryStack.java:90) org.basex.query.QueryContext.set(QueryContext.java:651) org.basex.query.value.item.FuncItem.bindVars(FuncItem.java:122) org.basex.query.value.item.FuncItem.invValue(FuncItem.java:136) org.basex.query.func.FNFunc$1.next(FNFunc.java:100) org.basex.query.iter.Iter.value(Iter.java:64) org.basex.query.expr.ParseExpr.value(ParseExpr.java:73) org.basex.query.QueryContext.value(QueryContext.java:322) org.basex.query.gflwor.Let$1.next(Let.java:75) org.basex.query.gflwor.GFLWOR$2.next(GFLWOR.java:74) org.basex.query.expr.ParseExpr.item(ParseExpr.java:53) org.basex.query.func.StaticFunc.invItem(StaticFunc.java:172) org.basex.query.func.BaseFuncCall.item(BaseFuncCall.java:38) org.basex.query.func.FNStr.concat(FNStr.java:303) org.basex.query.func.FNStr.item(FNStr.java:99) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:46) org.basex.query.func.FNStr.iter(FNStr.java:44) org.basex.query.gflwor.GFLWOR$2.next(GFLWOR.java:78) org.basex.query.func.FNStr.strjoin(FNStr.java:264) org.basex.query.func.FNStr.item(FNStr.java:81) org.basex.query.func.FNStr.concat(FNStr.java:303) org.basex.query.func.FNStr.item(FNStr.java:99) org.basex.query.expr.ParseExpr.value(ParseExpr.java:70) org.basex.query.func.FNStr.value(FNStr.java:57) org.basex.query.QueryContext.value(QueryContext.java:322) org.basex.query.func.StaticFunc.invValue(StaticFunc.java:193) org.basex.query.func.BaseFuncCall.value(BaseFuncCall.java:62) org.basex.query.func.StaticFuncCall.iter(StaticFuncCall.java:85) org.basex.query.MainModule.iter(MainModule.java:69) org.basex.query.QueryContext.iter(QueryContext.java:265) org.basex.query.QueryContext.execute(QueryContext.java:524) org.basex.query.QueryProcessor.execute(QueryProcessor.java:95) org.basex.core.cmd.AQuery.query(AQuery.java:76) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:342) org.basex.core.Command.exec(Command.java:321) org.basex.core.Command.execute(Command.java:78) org.basex.gui.GUI.exec(GUI.java:397) org.basex.gui.GUI$7.run(GUI.java:349)

2 2

Question regarding BaseX support for id and idref
by James Wright 14 May '13

14 May '13

Hello BaseX-Talk, I am new to the boards and BaseX in general. I have been looking for a open source NoSQL database with expressive query abilities and I think BaseX fits the bill. Its been an exciting journey as I am new to the whole X platform aside from the angle brackets... As I think many are. I am currently exploring the capabilities of RestXQ and the xml stack. I especially like its potential coupled with knockout.js, and a truly flexible RESTful metadata/hypermedia driven api. I have implemented an api of this nature in .Net however the metadata and querying capabilities are hindered and unnecessarily complex where I feel xml and XQuery make this dynamic orchestration quite gracefully. Unfortunately I am stuck now that I am exploring referential relationships and xml. I am trying to understand the support BaseX and XML in general has for referential nodes especially when dealing with queries. For example I know the xml standard defines id and idref however I have not been able to find any documentation on these in BaseX or XML in general. For example does BaseX handle idiosyncrasies of id and idref or must I handle these in my queries? For example: let $context := <item id="10"> <child idref="2" /><item><item id="20"> <child idref="2" /> <child idref="1" /></item><item id="30" /> <child id="1" name="firstChild" /><child id="2" name="secondChild" /> for $itemWithFirstChild in $context/item[child/@name = 'firstChild']return $itemWithFirstChild/@id I would like this to return "10 20"Now this example uses a dynamic context node however in the application these would exist as nodes in the database... If it does fully support this how do I enable it or get it to work? Also what about XLink? Any help would be greatly appreciated. Thanks again for your time.- James

2 4

Chat with lonely women in your area and hook up.
by root＠readymadetopps.com 12 May '13

12 May '13

Chat with lonely women in your area and hook up. http://redirect.surfsportpages.info 72749 alftj

1 0

now I busy reporting bugs, here another (minor) one
by Rob Stapper 11 May '13

11 May '13

Hi, I found another minor bug. In case of an error in an imported package-file ( index.xqm) while running the mainprogram the package-file cannot be opened from the error-message at the bottom of the editor-window. BaseX returns an message: 'file could not be opened'. Opening the package-file ( index.xqm) from within the query-info window works fine. It's a minor issue but still nice if it is solved. I use BaseX version 7.7 beta If you need more info about the issue, let me know. Rob Stapper

2 2

http-client issue
by Marco Lettere 10 May '13

10 May '13

Hello all, I've stumbled upon an issue related maybe to my scarce knowledge of HTTP. I've setup a Jetty based "jax-ws" server application which I call from basex through the "http:send-request" function. Everything works neatly until the response document (plus the SOAP overhead) violates the 8192 bytes threshold in size. At that point the Xquery containing the request stops working. Investigating I've found out that the server starts sending back the data encoded as base64 instead of plain XML thus causing the failure of the following xquery expressions ( err:XPTY0019:Steps within a path expression must yield nodes; xs:base64Binary found. ) Sniffing around on my HTTP connection I've seen that the server automatically alters the HTTP response at the size of 8192 bytes sending the header "Transfer-Encoding: Chunked" instead of the usual two ("Content-Type:test/xml" and "Content-Length"). This problem doesn't occur if I use Firefox Poster or socat (yet to try other neutral tools). Is it because they're able to handle this aspect transparently? What is the best solution to this? Is there a way (in the http request) to ask the server to avoid this change in behaviour? Do I need to handle this aspect at xquery application level? I'd be rather happy about any suggestions. Thank you in advance. M.

2 2

Job Offers with BaseX background
by Alexander Holupirek 10 May '13

10 May '13

Hi all, for those of you searching for a BaseX-related job in Stuttgart/Germany or Zurich/Swiss. http://www.klett-gruppe.de/karriere/stellenangebote/informatiker+in+compute… http://direktlink.prospective.ch/?view=221CBA8E-237D-9F2C-AC52E3BAE8982539 All the best, Alex

1 0

GraphML
by Ali Rostami 10 May '13

10 May '13

Dear All Since we need to add the graphml visualization to our software, I am wondering if the parser part of BaseX can be used independently? To have an idea, look at the following GraphML from [1], <graphml xmlns="http://graphml.graphdrawing.org/xmlns" xmlns:svg=" http://www.w3.org/2000/svg" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://graphml.graphdrawing.org/xmlns graphml+svg.xsd"> <key id="k0" for="node"> <default> <svg:svg width="5cm" height="4cm" version="1.1"> <svg:desc>Default graphical representation for nodes</svg:desc> <svg:rect x="0.5cm" y="0.5cm" width="2cm" height="1cm"/> </svg:svg> </default> </key> <key id="k1" for="edge"> <desc>Graphical representation for edges</desc> </key> <graph edgedefault="directed"> <node id="n0"> <data key="k0"> <svg:svg width="4cm" height="8cm" version="1.1"> <svg:ellipse cx="2cm" cy="4cm" rx="2cm" ry="1cm"/> </svg:svg> </data> </node> <node id="n1"/> <edge source="n0" target="n1"> <data key="k1"> <svg:svg width="12cm" height="4cm" viewBox="0 0 1200 400"> <svg:line x1="100" y1="300" x2="300" y2="100" stroke-width="5"/> </svg:svg> </data> </edge> </graph> </graphml> Regards, Ali [1] : http://graphml.graphdrawing.org/primer/graphml-primer.html#AttributesExample

2 5

Issue with client:connect() on servlet
by France Baril 10 May '13

10 May '13

Hi, I have created a connect function (restxq) that: - Works perfectly well on my Mac. - Returns a *BXCL0001 *when used on the Linux production server. The function uses: - *client:connect*(*$app:feedback-server-host*, 1984, *$session-user*, * $session-password*) The only reason I can find is that the production server is deployed through a servlet. Could this affect the behaviour? - The admin:users() function does list the user we are trying to use in 'connect', so we are assuming that the server is connected and that the user does exist. - We are using the correct password. - We have tried setting up the value of the SERVERHOST option in .basex to make sure it matches $app:feedback-server-host, although that didn't seem necessary for the mac setup. - 1984 is the configured PORT. - Could the fact that the production server is using TomCat have an impact on the client:connect function? We are out of things to try. Any clue would be helpful. Thanks, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

3 7

SET command?
by Pascal Heus 08 May '13

08 May '13

Having a weird behavior with the SET command as I can'r seem to change any option. Just launching from the shell using the "basex" script, I can GET but not SET. I must be doing something obviously wrong.... This is with 7.6 on MacOSX. BaseX 7.6 [Standalone] Try help to get more information. > GET DBPATH DBPATH: /Applications/basex/data > SET DBPATH /Users/Pascal/BaseXData Unknown option 'DBPATH'. > GET LANG LANG: English > SET LANG French Unknown option 'LANG'. > Also tried: basex -c "SET DBPATH /Users/Pascal/BaseXData" but same results.

3 3