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

Jamie Bullock jamie at postlude.co.uk
Tue Nov 6 11:20:41 CET 2007


Hi,

On Mon, 2007-11-05 at 23:33 +0100, Tim Boykett wrote:
[snip]
> So I would find a PD sql external great!

Well there is one. It's called [sqlsingle] by Iain Mott
(http://www.reverberant.com/PD/index.htm).

This is basically a thin wrapper around the libpq PostgreSQL library,
allowing you to perform a variety of queries using PD messages:
basically CRUD.

I have also made a modified version called [psql], which I thought I
committed to CVS ages ago, but obviously didn't - It's in there now.
[psql] removes the 'single' nature of the external making it
significantly faster for multiple queries ([sqlsingle] flushes the
database after every query). I've also added a Mac OS build target, and
renamed the object to [psql], which seems more accurate.

> 
> I would think that functionality would include:
> 
>   connecting to a database server
>   selecting which database to use
>   creating datasets in a table
>   retrieving data sets from a table

See above. I am happy to maintain this, so if you have any problems, let
me know (unless you want to send a patch).

BTW, I do agree that this is not the best solution for PD/database
connectivity, and that a more modular approach would be better.

Jamie

-- 
www.postlude.co.uk





More information about the Pd-dev mailing list