Re: [Babeldoc-devel] sql

[Dejan K. <dej...@ya...>]

--- "Leech, Jonathan" <jl...@vi...> wrote:
> Does anybody have interest in a SQL pipeline stage
> that would take a SQL
> query and make an XML document from the results?  I
> think I need to build
> one for my project.

I think it would be very useful. Altough, I am not
sure what actualy you need and if it is possible to
write pipeline stage that would be general enough to
be applied in other situations. I had similiar problem
when trying to get data database for exchange rates
that my company publish every day. 
I tried to solve it by writing sql scanner but XML I
needed was slightly more complicated for sql scanner
(I wanted generic solution). I ended up with scheduled
job in database which generate XML and ftp scanner.




>  
> Also I have an idea for the SQL journal, which is an
> option for compressing
> the BLOB data before writing to the database, and
> decompressing on the way
> out.  I have data that I want to journal where every
> response I get is ~30K,
> and compresses to ~1K.


I think it would be great idea. Of course, this should
be configurable so user could decide wheter they want
compressing or not.


Dejan

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com