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

Re: [basex-talk] feed additive,soya lecithin
by tjboshuai_bella 17 Aug '12

17 Aug '12

Dear Sirs, Glad to know your company,We are a specialized Chinese manufacturer of soybean lecithin more than 10 years. Our website: www.tjboshuai.com for your reference. Application: 1.used in the food as food additive,worked as emulsifier release agent and so on,widely used in the chocolate,ice cone,milk,biscuits,confectionary ; 2.used in the animal feed as feed additive,to prove the animal feed's quality and enhance the nutrition of the feeds; we have different grade ,type product ,which one do you want to use?food grade or feed grade?some information for your reference. We highly appreciate your email and sincerely hope we can get further cooperation.have a good week Bella Company name:Tianjin Boshuai Industrial & Trading Co.,Ltd Website:www.tjboshuai.com Phone:022-27915570 022-27396299 Fax:022-27920127 Email: tjboshuai_bella(a)yahoo.com.cn MSN: tjboshuai_bella(a)hotmail.com tjboshuai_bella

1 0

Table visualization of xquery results
by Rob Heiser 17 Aug '12

17 Aug '12

I'm using BaseXGUI to develop xqueries. The xqueries transform some data from the database into XML that will be rendered as a table. Will the table visualization view in BasexGUI work this way? My xqueries look something like this: let $dbName := "foo" return <table> <columns> <column>Name</column> <column>Child name</column> </columns> <rows> { for $item in doc($dbname)/some/xpath return <row> <cell>{$item/name/text()}</cell> <cell>{$item/child/name/text()}</cell> </row> } </rows> </table> The text view of the results look like I expect it to, and using the xqueries inside the application I'm developing works once I get them written and debugged. I'd like to preview the tables inside BaseXGUI if possible, before returning to the IDE and having to run the application, if possible. Thanks for any guidance. -- Rob

4 4

BaseX performances with many users and many files
by Yoann Maingon 16 Aug '12

16 Aug '12

Hi, We are building a solution that is actually using baseX, you can get a brief description there : http://launch.mysimplegrid.com/ The prototype works ok today for a few users. It is basically a spreadsheet UI storing its data in BaseX using the PHP library. Our question today is about this database use. For each spreadsheet we create a database in basex which means if we have a thousand users with 20 spreadsheets each, it makes a total of 20 thousand database in basex. where each one is access by one or a few users (not simulteanously). Would it be better to create just one database containing all the spreadsheets but access by the 1000 users? I'm looking for some information about concurrent performance and the utility of having multiple database or just one database for all? The other option would be to store just xml as text in mysql but It's really handy to work with basex and it allows us to update single nodes when to do that with mysql I would have to save the whole xml everytime. -- Yoann Maingon mydatalinx 0664324966

2 1

BaseX and eXist XML database differences
by mailbox＠actamail.com 16 Aug '12

16 Aug '12

Can anyone help me in telling the differences of BaseX and eXist XML databases? I am looking for a native XML database to use for my web content management system and homepage.

3 2

xslt:transform, spaces and mixed content
by France Baril 14 Aug '12

14 Aug '12

Hi, I have an issue with spaces in mixed content, when applying the xslt:transform command. I have been working around it for months with a hack in my css that puts the spaces back as   on inline elements, yet I still haven't run upon a clue to help me resolve this for good the clean way. IN SUMMARY - The xslt applied to my xml outside the BaseX environment (Oxygen + Saxon) gets me right html content (with spaces for inline elements in mixed content) - The query, when it returns the XML file from BaseX, shows that the XML file still has its spaces. - When the xslt is applied to the XML file from BaseX (Using Saxon), with the BaseX XSLT module, spaces disappear around inline elements in mixed content. IN DETAILS I have mixed content in a file. Ex. <p>Text <i>italic</i> more text.</p>. I have this function:; declare %rest:path("/how2-html-topic/{$id}/{$menu-id}") %rest:GET function topic:html-get-how2-topic($id as xs:string, $menu-id as xs:string) as node()*{ let $x := topic:xml-get-how2-topic($id) let $params := map{ "menucontext" := $menu-id} let $stylesheet := doc(concat($app:xslt_html_topic, 't')) return xslt:transform($x, $stylesheet, $params) }; My access a web page runs this query. Result (lost spaces): <p>Text<i>italic</i>more text.</p> - Note: The content has been uploaded with chop spaces = false - The xquery module specifies: declare boundary-space preserve; declare option db:chop 'no' If I get the same content without applying the xslt:transform, I get the xml with all the right spaces: declare %rest:path("/how2-html-topic/{$id}/{$menu-id}") %rest:GET function topic:html-get-how2-topic($id as xs:string, $menu-id as xs:string) as node()*{ let $x := topic:xml-get-how2-topic($id) let $params := map{ "menucontext" := $menu-id} let $stylesheet := doc(concat($app:xslt_html_topic, 't')) (: return xslt:transform($x, $stylesheet, $params) :) return $x }; Maybe I am missing some config details for the xslt module, in BaseX? In XLST? My xslt sets the output as follow: <xsl:output indent="yes" method="xml" encoding="UTF-8"/> Regards, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 8

validare:dtd
by France Baril 13 Aug '12

13 Aug '12

Hi, This is probably more a suggestion than a question. I am building a restxq application, and when the DTD is modified, I want to run validation all existing content. let $db := app:open-db($lang) let $topic-validation := <ul>{for $x in $db/*[name()='topic' or name()= 'media'] return try {validate:dtd($x, $app:dtd-topic) } catch BXVA0001 { <li>File $x/base-uri() doesn't validate.</li> } } </ul> return $topic-validation When everything works fine, when the content validates against the dtd, I get an empty <ul/> as expected. However, if there is an error, the whole process stops, returns an error on the html page that indicates what the error is (but with the wrong filename(??)). Note that the filename changes everytime I run the process). - I would like to be able to catch errors, accumulate error messages and return them la instead of having the process stop at the first error. - Filename is probably a bug(??). I am running v7.4 Regards, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 2

Hawthorn Extract
by Export Dept 11 Aug '12

11 Aug '12

Dear Sir/Madam. Have a good day. We are Shaanxi king stone enterprise company limited is a major company engaged in plant extract industry. It is loactaed in middle of China. We own our plant to produce plant extract for health products use. This time we especially recommend our "Hawthorn Extract" to you. and now we have goods in stock as followings: | Hawthorn Extract | | Botanical Source: | Fructus Crataegi | | Appearance | Yellow brown powder | | CAS | 36052-37-6 | | Specification: | Flavone :10%～80%，10：1 | | Test Method | UV HPLC | | Function | | 1) Dilating coronary artery, improving myocardial blood and decreasing myocardium oxygen consumption, thus preventing ischemic heart disease | | 2) Inhibiting thyroid peroxidase, anticancer and antibacterial | | 3) Decreasing blood lipid, inhibiting platelet aggregation and spasmolysis | | 4) Scavenging free radicals and enhancing the immunity | We can provide sample for new client. We own our new special patent to produce the product, So the cost and quality is competitive compared with other suppliers. Please contace me If you interested our products. Your further comments will be highly appreciated. Shaanxi king stone enterprise company limited Fax:86-29-88353140 ; Tel:86-29-88353805 E-Mail:export@king-stone.co http://www.king-stone.co

1 0

motivation for using connection pools
by Godmar Back 11 Aug '12

11 Aug '12

Hi, Christian and I had a brief discussion regarding create db, session semantics and the use of connection pools on github [1]. He asked for real user feedback. I'll try to briefly describe what motivated us to use connection pools; I believe our experience may be indicative of that of others developing applications in which BaseX provides the database tier. Our application is an AJAX-based front-end that allows users to manage information stored in a BaseX database. When a user clicks on some part of the user interface, the resulting AJAX request may trigger one or more operations on a BaseX database. Typically between 1 and as many as 10. (Now part of these operations could perhaps be avoided through caching, but caching comes of course with its own problems since we have no easy way to keep multiple caches for the same BaseX instance coherent). These operations include queries, updates, creating/renaming databases, and the like. In this common situation, how would one manage access to BaseX? Option A. is to create a new TCP connection to BaseX for every single query,update, or command. That would involve 1-10 TCP connection setups, plus whatever (and however small) session setup costs BaseX has, per user event. As a ballpark number, if the BaseX server runs on a separate machine in our cluster, as is good practice, this can involve many milliseconds of overhead, which adds to the overall latency of our application. (I note that one source of overhead is the need to serialize our in-memory DOM objects for each query, and to parse the result. But of course there's framework delay, network delay etc. Many of which are infrastructure-dependent, thus difficult to avoid/optimize.) Option B. is to create a new connection for each AJAX request, and close it when the AJAX request has finished. This would reduce the TCP connection/session setup overhead in that only one would be required per event round-trip. However, our application uses the ZK framework, which is event-based. As a consequence, the framework doesn't provide us with hook points where we'd learn when the handling of an AJAX request starts and when it ends. Instead, execution is event-driven and may involve exceptional control flow. In short, we couldn't reliably close those connections. Option C. is the use of connection pools. When an AJAX request arrives, we execute our application logic. Whenever we reach a BaseX query/update/command in the execution, we check for an available connection. Up to a maximum number, we create new connections on demand. If the maximum number is reached, we wait (we could also reject the request, there are different load management options here). We use that connection, independent of which queries/updates/commands were previously executed within the session that this connection represents. That's why it's important for us that BaseX provide means to avoid inadvertent session state. For these reasons, we believe that the use of connection pools is an appropriate means to handle connection management to the BaseX server. What experience do others have that use BaseX as a database tier in their web applications? - Godmar [1] https://github.com/BaseXdb/basex/issues/551

1 0

Re: [basex-talk] soya lecithin,feed additive
by tjboshuai_bella 11 Aug '12

11 Aug '12

Dear Sirs, Glad to know your company,We are a specialized Chinese manufacturer of soybean lecithin more than 10 years. Our website: www.tjboshuai.com for your reference. Application: 1.used in the food as food additive,worked as emulsifier release agent and so on,widely used in the chocolate,ice cone,milk,biscuits,confectionary ; 2.used in the animal feed as feed additive,to prove the animal feed's quality and enhance the nutrition of the feeds; we have different grade ,type product ,which one do you want to use?food grade or feed grade?some information for your reference. We highly appreciate your email and sincerely hope we can get further cooperation.have a good week Bella Company name:Tianjin Boshuai Industrial & Trading Co.,Ltd Website:www.tjboshuai.com Phone:022-27915570 022-27396299 Fax:022-27920127 Email: tjboshuai_bella(a)yahoo.com.cn MSN: tjboshuai_bella(a)hotmail.com tjboshuai_bella

1 0

Re: [basex-talk] feed additive,soya lecithin
by tjboshuai_bella 11 Aug '12

11 Aug '12

Dear Sirs, Glad to know your company,We are a specialized Chinese manufacturer of soybean lecithin more than 10 years. Our website: www.tjboshuai.com for your reference. Application: 1.used in the food as food additive,worked as emulsifier release agent and so on,widely used in the chocolate,ice cone,milk,biscuits,confectionary ; 2.used in the animal feed as feed additive,to prove the animal feed's quality and enhance the nutrition of the feeds; we have different grade ,type product ,which one do you want to use?food grade or feed grade?some information for your reference. We highly appreciate your email and sincerely hope we can get further cooperation.have a good week Bella Company name:Tianjin Boshuai Industrial & Trading Co.,Ltd Website:www.tjboshuai.com Phone:022-27915570 022-27396299 Fax:022-27920127 Email: tjboshuai_bella(a)yahoo.com.cn MSN: tjboshuai_bella(a)hotmail.com tjboshuai_bella

1 0