some externalernals

Iain Mott iain.mott at
Sun Mar 11 01:07:52 CET 2001

Sorry I can't do much better than say 'pretty fast' at the moment! Have
addressed a few optimisation issues in the README file for the external (see Also in the PostgreSQL
documentation, have a look for info on indexing and 'primary keys'.

For the work I've been doing - I've actually been running commands in pauses
in the audio - so interruptions or glitches in the audio haven't really been
an issue. Because of this I've also had the liberty of switching off Pd's
DSP - to lend a little more CPU time to Postgres. I'm no expert on Pgres -
but I suppose there must be other ways to speed up response - holding data
in RAM perhaps?

Cheers, iain

-----Original Message-----
From: Michal Seta [mailto:mis at]
Sent: Saturday, 10 March 2001 8:56 AM
To: pd-list at
Subject: RE: some externalernals

Well, yeah.  I was just kidding (although I have talked to a guy, a web
for a fairly large website who was complaining that he was getting bored
analyzing the data and stuff.  I suggested we put the data to music and see
what it sounds like and he liked the idea...).

I would mainly be interested in using the database as a "scratch pad" to
and manipulate various musical events.  So, how fast is the response to

So, why not making it available?


On Wed, 07 Mar 2001, Iain Mott wrote:
> Yes indeed - but as a slightly more realistic suggestion, Postgres can be
> used as a means of finding matching sounds. Eg. If recorded sounds are
> analysed for features such as pitch envelope, centroid envelope, duration
> etc - and this data is placed in tables, one can find "matches" for new
> sound fragments by searching for files in the database with best fitting
> characteristic (ie. run searches on the basis of the least error).
> Cheers, iain
> -----Original Message-----
> From: Michal Seta [mailto:mis at]
> Sent: Thursday, 8 March 2001 4:24 AM
> To: pd-list at
> Subject: Re: some externalernals
> I'd be interested in that one.
> It'd be fun to turn sales into music (although the other way around would
> nice, too).
> ./MiS
> On Thu, 22 Feb 2001, Iain Mott wrote:
> >
> > One thing not included (amongst a few more) is a simple Pd interface to
> > PostgreSQL - allows you to send SQL commands to a database and retrieve
> the
> > results.  If anyone's interested in this - let me know and I'll scrape
> > together.

More information about the Pd-list mailing list