[PD-dev] Fwd: Fwd: Fwd: Connecting up an SQL Database to PD

[Mike McGonagle]

On 11/12/07, Jamie Bullock <jamie at postlude.co.uk> wrote:
> I'm sure you've already looked at it, but there's a (maybe) useful
> README and help file here:
>
> http://pure-data.cvs.sourceforge.net/pure-data/externals/postlude/psql/

Jamie,

I was looking at your source code for psql, and was wondering if it
expects there to be only a single result set returned? Or does it
merge all the results into one? I noticed the the comment...

/*  up to 10 fields may be returned. returns floats or symbols */

I would think that making it such that it acted like 'textfile', that
with each bang sent to the sql object, that it would return each
subsequent row, and once the end of that set is reached, it would
output a bang on a second outlet, similar to what 'textfile' does.

Thanks,

Mike M

-- 
Help the Environment, Plant a Bush back in Texas!

"I place economy among the first and most important republican
virtues, and public debt as the greatest of the dangers to be feared.
To preserve our independence, we must not let our rulers load us with
perpetual debt."
-- Thomas Jefferson, third US president, architect and author (1743-1826)

"Give Peace a Chance" -- John Lennon (9 October 1940 – 8 December 1980)

Peace may sound simple—one beautiful word— but it requires everything
we have, every quality, every strength, every dream, every high ideal.
—Yehudi Menuhin (1916–1999), musician

If you think you can, or you think you can't, you are probably right.
—Mark Twain

"Art may imitate life, but life imitates TV."
Ani DiFranco