some externalernals

[Iain Mott]

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
http://soundart.tripod.com/Pd/readmesql.html). 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 music.mcgill.ca]
Sent: Saturday, 10 March 2001 8:56 AM
To: pd-list at iem.kug.ac.at
Subject: RE: some externalernals

Well, yeah.  I was just kidding (although I have talked to a guy, a web
master
for a fairly large website who was complaining that he was getting bored
with
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
store
and manipulate various musical events.  So, how fast is the response to
queries?

So, why not making it available?

./MiS

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 music.mcgill.ca]
> Sent: Thursday, 8 March 2001 4:24 AM
> To: pd-list at iem.kug.ac.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
be
> 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
it
> > together.