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

XQDoc for BaseX
by John Snelson 12 Feb '13

12 Feb '13

Hi all, The xquerydoc project is a 100% XQuery 1.0 project which can parse XQuery modules and extract XQDoc style documentation. I've recently extended it to be able to parse XQuery Update and XQuery Full Text, which I believe solves the majority of problems if you want to use it with modules written for BaseX. The project is available here: https://github.com/xquery/xquerydoc I'm happy to add any other syntax that BaseX supports as well, but I'll need help understanding what that is if there is anything. Enjoy your XQuery documentation! John

3 3

Re: [basex-talk] handling large files: is there a streamingsolution?
by pw＠themail.co.uk 12 Feb '13

12 Feb '13

Thanks Fabrice, I am making good progress following your advice. Do you have any heuristics for the best way to distribute data for performant searches and subsetting of data? Am I better having lots of small files or a few large files in a collection? > > > >---- Original Message ---- >From: fetanchaud(a)questel.com >To: pw(a)themail.co.uk, BaseX-Talk(a)mailman.uni-konstanz.de >Subject: RE: [basex-talk] handling large files: is there a >streamingsolution? >Date: Mon, 11 Feb 2013 14:38:54 +0000 > >>Dear Peter, >> >>Did you try to create a collection with the files (CREATE command) ? >>You should start that way, I don't see the point in using file: >module for import. >>I think that once in the database, file size does not matter (until >you reach millions of file in the collection, and do a lot of >document related operations (list, etc...)) >> >> >> >>-----Message d'origine----- >>De : basex-talk-bounces(a)mailman.uni-konstanz.de >[mailto:basex-talk-bounces@mailman.uni-konstanz.de] De la part de >pw(a)themail.co.uk >>Envoyé : lundi 11 février 2013 15:33 >>À : BaseX-Talk(a)mailman.uni-konstanz.de >>Objet : [basex-talk] handling large files: is there a streaming >solution? >> >>Hello List >>I am wanting to do a join with some large (3-400Mb) XML files and >would appreciate guidance on the optimal strategy. >>At present these files are on the filesystem and not in a database >> >>Is there any equivalent to the Zorba streaming xml:parse()? >> >>Would loading the files into a database directly be the approach, or >is it better to split them into smaller files? >> >>Is the file: module a suitable route through which to import the >files? >> >>Thanks for your help >> >>Peter >> >>_______________________________________________ >>BaseX-Talk mailing list >>BaseX-Talk(a)mailman.uni-konstanz.de >>https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>

2 1

handling large files: is there a streaming solution?
by pw＠themail.co.uk 11 Feb '13

11 Feb '13

Hello List I am wanting to do a join with some large (3-400Mb) XML files and would appreciate guidance on the optimal strategy. At present these files are on the filesystem and not in a database Is there any equivalent to the Zorba streaming xml:parse()? Would loading the files into a database directly be the approach, or is it better to split them into smaller files? Is the file: module a suitable route through which to import the files? Thanks for your help Peter

2 1

Load xml files to BaseX in a loop
by Nicholas OR Rita Stevens 10 Feb '13

10 Feb '13

I am new at BaseX so please pardon the newbie question. I am trying to run an xquery script to load a set of xml files in a directory into to BaseX 7.5. If I run replace.xq, shown below, it fails with Out of Main Memory declare %updating function local:upd($path,$file) { db:replace("eams",$path,$file) }; let $files:=for $file in file:list("d:\xmlfiles") return "d:\xmlfiles\"||$file for $file in $files return local:upd("pd",$file) But if I run file replace.bxs, it updates with no problem <commands> <replace path="p1">d:\xmlfiles\drr1.xml</replace> <replace path="p1">d:\xmlfiles\drr2.xml</replace> <replace path="p1">d:\xmlfiles\drr3.xml</replace> <replace path="p1">d:\xmlfiles\dw1.xml</replace> <replace path="p1">d:\xmlfiles\dlp1.xml</replace> </commands> (The same set of files is being processed by both scripts; I checked) The only idea I have is to use xquery to generate the file replace.bxs and then run it. A better way? Thanks.

2 1

Binding external variable to sequence
by Lansing, Jeff J CIV SPAWARSYSCEN-PACIFIC, 56250 09 Feb '13

09 Feb '13

How can I bind an external variable to a sequence? I see the syntax trick for escaping commas, but I still don't get a bound sequence. I tried this: import org.basex.core.*; import org.basex.core.cmd.*; import org.junit.*; public class BindingTest { String var = "$ids="; String seq = "('a',,'b',,'c')"; String query = "" + "declare variable $ids external; " + "let $count := count($ids) " + "return if($count gt 1) then element ids { $ids } " + "else error(QName('urn:err', 'not_enough_ids'), xs:string($count)) " ; /** * test binding external variable to sequence */ @Test public void test() { try { Context context = new Context(); new Set(Prop.BINDINGS, var + seq).execute(context); String result = new XQuery(query).execute(context); context.close(); System.out.println(result); } catch(Exception e) { System.err.println(e); } } } I expect to get <ids>...</ids> but instead I get the error. I'm using v7.5, Java 7u13.

2 1

Document modification timestamp
by Bob Myers 09 Feb '13

09 Feb '13

Sorry for the newbie question, but how do I obtain a modification timestamp for a document in a database? Is there any clean way to integrate with a GNU make-based make system? -- Bob

2 1

BaseX has been updated on Filecluster.com
by FileCluster Support 07 Feb '13

07 Feb '13

Dear Developer, You have received this email because we have updated BaseX and this was the contact email for the application. Your application update status BaseX has been updated on FileCluster.com to the 7.6 version. You can check out your application on our site at: http://www.filecluster.com/Business-Office/Database-Management/Download-Bas… If you want to let your users know about your software page on FileCluster.com, to rate it and review it, you can also use this banner to link it: Promote your software As a software website, it`s our duty to help the developers promote their software. Fortunatelly, our software promotions are cost free, for more informations please visit our promotion page. Submit your press releases We are also accepting press releases from software developers. All you have to do is to submit your press release and we will take care of the rest. Useful developer links All the essential links you need as a developer on FileCluster.com: Link to us - download banners or text links for linking to FileCluster.com Submit your software - Submit your software via PAD or manually Submit your press release - submit your press releases using our online form Contact Us - contact our editors Promote your software - our promotions page If you do not wish to receive any further notifications or confirmations from FileCluster.com, please send us an email and request a contact removal (email removal). Keep in mind that this means you will not receive ANY contact from us, including: software promotions, update confirmations or security alerts (antivirus and spyware test results). Regards, Renta Cezar - Senior Editor FileCluster Labs www.filecluster.com

1 0

BaseX 7.6 Update - Soft-Files.com
by Soft-Files Team 07 Feb '13

07 Feb '13

Dear Developer, Your product BaseX 7.6 has been updated. Your product review page is located at: http://www.soft-files.com/basex_72311.html. Sincerely, The Soft-Files Team

1 0

Fwd: basex_7.6-1_amd64.changes ACCEPTED into unstable
by Alexander Holupirek 07 Feb '13

07 Feb '13

From: Debian FTP Masters <ftpmaster(a)ftp-master.debian.org> Subject: basex_7.6-1_amd64.changes ACCEPTED into unstable Date: 7. Februar 2013 06:17:33 MEZ Accepted: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Wed, 06 Feb 2013 23:06:53 +0100 Source: basex Binary: basex Architecture: source all Version: 7.6-1 Distribution: unstable Urgency: low Maintainer: Alexander Holupirek <alex(a)holupirek.de> Changed-By: Alexander Holupirek <alex(a)holupirek.de> Description: basex - XML database and XPath/XQuery processor Changes: basex (7.6-1) unstable; urgency=low . * New upstream release (February 5, 2012) DATABASE LOCKING: - updates on different databases can now be executed in parallel and won't lock your read-only queries anymore: http://docs.basex.org/wiki/Transaction_Management . XQUERY - when errors are raised, the full stack trace is now returned - the EXPath Geo Module, Fetch Module and HTML Module have been added: http://docs.basex.org/wiki/Module_Library - the Validation, XSLT, Database and Profiling Module have been updated . GUI - error messages are now clickable and linked with the text editor - trace/profiling output is redirected to the info view in realtime . * Packaging: - Changed Vcs-Git field to point to git://github.com/BaseXdb/basex-dist.git To retrieve relevant debian packagin you have to change to linux/debian, however. Checksums-Sha1: 1c81eefebd8c68ae4bc00257c3f0c97b6f6ca51a 1833 basex_7.6-1.dsc a4b3fe3da878daf6c09fee5bc2ed4c87446e2406 1331808 basex_7.6.orig.tar.gz 2081b40c82ad6e06dc7a1f6731ccec2c24dc19e0 98819 basex_7.6-1.debian.tar.gz 955143518430b072a120c4c1c8cdf27c5192ae76 2511046 basex_7.6-1_all.deb Checksums-Sha256: 348ad02b44a6cb307bb9239d2328146c1fbb28ea7f11d9684f55cb42e106d07d 1833 basex_7.6-1.dsc ac919d990dd728bd96e95ba6d24ea4259700faa8c22b52415830a3cb09d9eb63 1331808 basex_7.6.orig.tar.gz 2137997b8caf0cbbcb0a852dacf3a748efad5f63461070fcd184c391e82304fa 98819 basex_7.6-1.debian.tar.gz 37213e808fae4cc84097fdab0c7d6d8e018adb9c56d3d3438f9d3cd66deec110 2511046 basex_7.6-1_all.deb Files: 3b5f662eb0c9c5fdbceea1fb7bcb13c8 1833 database optional basex_7.6-1.dsc c28a850d37fa95141713acafb23cce4e 1331808 database optional basex_7.6.orig.tar.gz d5982d71648e8c5df115230306014a0d 98819 database optional basex_7.6-1.debian.tar.gz 7c01b3056decfd8c83f3edc01ae9b8af 2511046 database optional basex_7.6-1_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJREzbQAAoJECHSBYmXSz6WYSoQAIc7ZmglZhQ07gmhfKOHk+8H y4BUc6ych8GaGhXsVZTnlcvLXLXYeReb3il/0gqPuqMlkPUCf/+NclPv7//lkuWj jDZkwyFokJIUPo5ie64h44heYh5gMpAZUU6SOOTzFcSzA43r1iCazUxP020wtzC4 9mmY+5DFH+tylT2I3qkKFFNNTWvXks2gwvQg4v5MlhAvu5mz+pg/wuOUjq9w2cKB KF2z8+Htu8esD4Hqn944tLny9q2K5WWzdPFqnjCWMGhNkKo4mi3ducRFob6Rnw6O FCeGCjNVCgbkyjiUxoCKWxWGX+JdFEa/30TG+B9DEZuDf3CoXJfiS9nTCrnLO1hz djK2re7GaVQ1OW73V8tjT+O8OzVqQ5CEJWVRLZkMb+HAOfdIOjrtIHDYycLuOKNB D3uyvYRW+Uwgn1+2zVhHjQPmpHRyS9Ds4H+E7TRBSk/SKszGeK0WzXY1iR9qA60O ySzldK4ox++TvH+XVupr7FQDCatXNzwFD9JxreYeiZvx7KEJ8I9ZnNMLfJKstJD4 A2SK/uSMGltcWrpEmkgrxq/tZB170tHqrWidMWPX7kVAJaBtX/FcOT6GHL6DZC0m sKGtoDQXVHQg1w2/s+Oy86uXbsI9sNKTPatEi3PQQT/FidEQWcmjy4EEcMIJfrE7 HUsbPI03OkihunpJXx6J =iSFy -----END PGP SIGNATURE----- Thank you for your contribution to Debian. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Alexander Holupirek |-- Mosbrugger Strasse 9 |-- 78462 Konstanz `-- 07531 80 4 80 65 / 0176 600 25 949

1 0

Re: [basex-talk] Xquery over all collections
by pw＠themail.co.uk 06 Feb '13

06 Feb '13

Hi Lukas That is exactly what I was looking for ... :-) I was clearly just thinking it was more complicated than it really was Thanks Peter > > > >---- Original Message ---- >From: lukaskircher1(a)gmail.com >To: pw(a)themail.co.uk >Subject: Re: [basex-talk] Xquery over all collections >Date: Wed, 6 Feb 2013 08:40:07 +0100 > >>Hi Peter, >> >>for example, if I look for all *<br>* elements over all >>documents/collections: >> >>*for $d in db:list()* >>*return collection($d)//br* >>* >>* >>Is this what you were looking for? >> >>Cheers, >>Lukas >> >> >>On Wed, Feb 6, 2013 at 1:13 AM, <pw(a)themail.co.uk> wrote: >> >>> let $r := (collection('A'), collection('B'), >>> collection('C')) >>> >>

1 0