[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