[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: sql to xml question

Subject: Re: sql to xml question
From: Paul Tchistopolskii <paul@xxxxxxx>
Date: Fri, 21 Jul 2000 10:35:36 -0700
sql2xml
> 
> > I wanted to know what are the different ways to generate XML 
> > on the fly from
> > sql queries.
> > I know there are some that do it.
> 
> I expect that most tools that import SQL results in a XML environment, 
> need to build a internal representation of the result as XML.  

Why do you think so? I think this expectation is not correct.

At least I know that PXSLServlet  is not taking any extra memory 
in SQL2XML part, but it is generating stream of SAX events.

I can imagine a design that will contruct DOM out of SQL, but 
I don't understand why should somebody use DOM for SQL2XML 
conversion ?

>  you cannot afford to do so, due to memory constraints and 
>  all you need is the data as XML, you may be better of by writing 
> a small snippet of code in PHP or similar that generates the 
> XML you need directly as "print" statements.

Not *that* small snippet, actually. Serialization into 
XML is not absolutely trivial thing ( because of & <> e .tc.)

Rgds.Paul.



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.