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