|
From: Dejan K. <dej...@ya...> - 2003-07-03 16:08:24
|
--- "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 |