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 _______________________________________________ PD-dev mailing list PD-dev@iem.at http://lists.puredata.info/listinfo/pd-dev