BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Re: [basex-talk] Ways of Connecting to basex
by Dirk Kirsten 24 Sep '14

24 Sep '14

Hello Furqan, please keep in mind to always include the mailing list in the list of recipients, as others might also benefit from your questions. Also, other people might have much better answers than I can give you. Sure you can use a network sniffer to listen to the traffic to/from a BaseX server. It is a standard TCP connection, so this is certainly possible. Just give it a try. The same holds for using a proxy: It is a very conventional TCP connection, so using a proxy shouldn't be a problem. Nginx should works as well, I guess (although I am by no means an expert in nginx). We have used it quite some times for projects using RestXQ to load-balance requests. How to actually achieve that heavily depends on the proxy you decide to use, so you might have to read up there how to do it in detail. Cheers, Dirk On 23/09/14 13:13, Furqan Khan wrote: > Derk,just a little quick question > if the using tcp/ip,so assuming my web server is on same machine port 8000 > and the basex server is also on same machine port 1984, > then will it be possible to use a packet sniffer such as wire shark to see > all incoming packets to the baseX-db port 1984... > Further more,is it possible for me to use a reverse proxy in front of basex > server (a web proxy such as nginx may not work)..,so that i may evaluate > incoming packets and trigger my script(java or lua) just as mysql has come > up with mysql proxy as a db-proxy(wh invokes lua scripts),is their any such > option available with basex or any such third party tool that could be > used...i further need to invoke a script,so its not only for analysis > purpose.... > thanks and regards > Furqan > > > On Tue, Sep 23, 2014 at 1:50 PM, Furqan Khan <furqankhan08(a)gmail.com> wrote: > >> thanks for the reply >> cheers >> furqan >> >> On Tue, Sep 23, 2014 at 1:16 PM, Dirk Kirsten <dk(a)basex.org> wrote: >> >>> Hello Furqan, >>> >>> welcome to the wonderful world of XML databases ;) >>> >>> Right now, BaseX only supports TCP/IP for client connect. So by >>> definition it will always be used as default. >>> The details of our server protocol can be found at >>> https://docs.basex.org/wiki/Server_Protocol >>> >>> Cheers, >>> Dirk >>> >>> On 23/09/14 07:27, Furqan Khan wrote: >>>> Hi >>>> i m a little new to xml-db environment. >>>> i need to know what are the possible ways to connect to baseX from >>> client >>>> api's. >>>> just like in sql the clients could connect to db using : >>>> 1)named pipes >>>> 2)shared memory >>>> 3)tcp and etc... >>>> >>>> Does basex offer all the functionalists... >>>> and by default whats the way a client connects,if the tcp connection is >>> not >>>> explicitly specified... >>>> >>>> regards >>>> Furqan >>>> >>> >>> -- >>> Dirk Kirsten, BaseX GmbH, http://basex.org >>> |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz >>> |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: >>> | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle >>> `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22 >>> >> >> > -- Dirk Kirsten, BaseX GmbH, http://basex.org |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22

2 3

Adding documents slows over time
by Gerald de Jong 24 Sep '14

24 Sep '14

I'm finding that adding documents to a database starts at about 1ms, but gradually gets slower (5ms after about 700,000). I'm doing this with autoflush off, and I've tried periodic flush an optimize commands but they have no effect. Is this expected behavior? Is there any way to keep it speedy? -- Delving BV, Vasteland 8, Rotterdam http://www.delving.eu http://twitter.com/fluxe skype: beautifulcode +31629339805

4 25

Getting some double files
by France Baril 23 Sep '14

23 Sep '14

Hi, We are editing files from Oxygen using a webDAV connection. For an unknown reason, we sometimes get a double update (or an update with an add?). The result is that we get a physical file with a double xml document (double root). The content in the 2 root nodes is always the same, and always has the correct/latest corrections made by content editors. Ex. <root id="doc1"><content>Our latest changes</content></root> <root id="doc1"><content>Our latest changes</content></root> Do you have any clue as to why this is happening? Any idea to prevent the behavior? Note that this is not a new issue, we have just always worked around it with a quick repair function. We though we would find the cause at some point and be able to fix it ourselves, but the issue is sticking around. -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 2

List all raw files
by France Baril 23 Sep '14

23 Sep '14

Hi, Is there a way to list files based on their properties. I'm trying to list all raw files. So far, the approach I found takes a while to execute: * db:list * for each listed item check if is-raw Is there a better way to approach this? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 4

Mac OS X, key bindings, 8.0 betas
by James Ball 23 Sep '14

23 Sep '14

Hello, Is anyone else running the BaseX 8.0 betas on Mac OS X? If so has anyone else found that the key bindings in the GUI: <command> + <return> for Run query and, <command> + <shift> + <return> for Run tests, are not working? The others I’ve tried are ok. I don’t know if this is a quirk of my system or an issue I should log. Many thanks, James

3 9

Exists but doesn't
by Gerald de Jong 23 Sep '14

23 Sep '14

While trying out 8.0-SNAPSHOT I get something strange. There is an exists query which gives true where the answer should be false. There is no dataset with @name='DiMu__abm', yet exists gives "true". The subsequent query shows what is actually in the XML. > xquery exists(doc('narthex_dimcon/narthex_dimcon.xml')/narthex-datasets/dataset[@name='DiMu__abm']) true Query executed in 5.14 ms. > xquery doc('narthex_dimcon/narthex_dimcon.xml') <narthex-datasets> <dataset name="RCE_Beeldbank__adlib"> <origin> <type>origin-drop</type> <who>?</who> <time>2014-09-23T10:05:34.436+02:00</time> </origin> <status> <state>state-saved</state> <time>1411460347570</time> <percent>0</percent> <workers>0</workers> <error/> </status> <delimit> <recordRoot>/adlibXML/recordList/record</recordRoot> <uniqueId>/adlibXML/recordList/record/priref</uniqueId> <recordCount>401960</recordCount> </delimit> <namespaces> <xsi>http://www.w3.org/2001/XMLSchema-instance</xsi> </namespaces> <harvest/> </dataset> </narthex-datasets> Query executed in 3.03 ms. -- Delving BV, Vasteland 8, Rotterdam http://www.delving.eu http://twitter.com/fluxe skype: beautifulcode +31629339805

2 2

Ways of Connecting to basex
by Furqan Khan 23 Sep '14

23 Sep '14

Hi i m a little new to xml-db environment. i need to know what are the possible ways to connect to baseX from client api's. just like in sql the clients could connect to db using : 1)named pipes 2)shared memory 3)tcp and etc... Does basex offer all the functionalists... and by default whats the way a client connects,if the tcp connection is not explicitly specified... regards Furqan

2 1

SQL script parser
by Michael Hancock 22 Sep '14

22 Sep '14

Hi, Hope you can help with the following. I have been asked to create a xquery script that can be used to parse Oracle SQL statements into an XML structure and I would like some pointers on how best to achieve this. Please find below details: 1) The input SQL document is free format text where statements are split by ";" and may be entered over several lines. Example below: "Create table x ( Column1 varchar2(10), Column1 varchar2(10) ); Comment on column x.column1 "xxxxxxxxxxxxxx"; Alter table x add ("column3" varchar2(10));" 2) The XML output for the above example would be something like: <sql command="create table" name="x">Create table x (Column1 varchar2(10),Column1 varchar2(10));</sql> <sql command="comment on" name="column x.column1">Comment on column x.column1 "xxxxxxxxxxxxxx"; </sql> <sql command="alter table" name="x">Alter table x add ("column3" varchar2(10)); </sql> If you could provide some pointers on how best to achieve this result I would be much appreciated. Best regards. Mike Michael Hancock Clinical Applications Systems Programmer Pharm-Olam International The Brackens, London Road, Ascot Berkshire, SL5 8BJ, UK Tel: +44 (0)1344 898 583 Fax: +44 (0)1344 899 199 Email: Michael.Hancock(a)pharm-olam.com This e-mail may contain information that is privileged, confidential and/or subject to legal restrictions and penalties regarding it's unauthorized disclosure or use. Unauthorized viewing, copying, distribution, disclosure or other use of this information is prohibited if you are not the intended recipient. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete this e-mail and attachments from your system. Thank you.

2 1

Fwd: Regarding reverse proxy option in BaseX
by prabhjeet kaur 20 Sep '14

20 Sep '14

Hii Carl, Thanks, for the rply. I go through the documentation and instructions of OpenHIM. It says it only works for MongoDB. But I don't want to convert my xml documents to JSON format as supported by MongoDB. Is OpenHIM support BaseX or is there any other tool which capture my incoming requests or queries before it hits the database server. Kindly, answer for the same. I am very thankful to you. Regards, Prabhjeet Kaur

1 0

db:add or db:replace forget namespaces
by Fabrice Etanchaud 19 Sep '14

19 Sep '14

Dear all @BaseX, in last snapshot, When adding/replacing a document with db:add/db:replace, If xml content is not a document-node, but an element, namespaces definitions are just forgotten in target document. The root element has a prefix, but no definition. Result is valid if you do not pass $xml but document { $xml } In the documentation, one can see that input can be a string (file path or serialized xml) or a document node. Maybe these functions could abort when an element is given ? Thank you for your fantastic tool ! Best regards,

2 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk