I sketched up a quick patch to illustrate what I mean:

.hc
On Dec 7, 2007, at 4:32 PM, Mike McGonagle wrote:
Andy, have you had a chance to check out the SQLite external yet?
You can get a copy of it here ( http://puredata.info/Members/ mjmogo ), the latest version is 0.13. While this is still under
developement, it is based on the work of Jamie (and others), as far
as how the SQL is handled. They are not exactly the same, but I
would like to make that one of the goals so that these things can
be interchangeable.One thing that I have not done yet is implement any kind of Blob
data types. It appears that SQLite3 (not the external, but the
database) handles Blobs as binary strings. I still don't know quite
how this would work in PD though. I would like to get some feedback
from others about how to do this.As SQLite3 stores its database in a file, rather than a server,
there is no need to set up anything for the database (other than
designing the tables). Also, if you need to, you can use the tools
from SQLite3 to work with the same database file.I work on the Mac, so the Makefile is setup to build a Universal
Binary (thanks to Hans). If you are on another platform, it
shouldn't be difficult to compile these things, as SQLite3 is pure
ANSI C. When I compile it, there are a lot of warnings generated,
but everything works fine. I guess I should turn off all the
warnings for that part of the compile.But, let me know if you try this. I am eager to see how it works
for others.Thanks,
Mike McGonagle
On 12/7/07, andy.graybeal@casanueva.com <
andy.graybeal@casanueva.com> wrote: i installed postgresql, and got it running, created a user for myself, compiled [psql] from postlude (i'm using pd-extended from cvs).i opened up the psql-help file and started with the first
instruction, and it created the database fine, i moved to the second command and get
this error: psql: Action failed. PQresultStatus is PGRES_FATAL_ERRORi'm wondering where i can look for more information about what is
going wrong, and what i can do to fix it.i think it would be wonderful if i could start using a database to
store values :)-andy
PD-list@iem.at mailing list UNSUBSCRIBE and account-management -> http://lists.puredata.info/ listinfo/pd-list
-- Peace may sound simple—one beautiful word— but it requires
everything we have, every quality, every strength, every dream,
every high ideal. —Yehudi Menuhin (1916–1999), musician _______________________________________________ PD-list@iem.at mailing list UNSUBSCRIBE and account-management -> http://lists.puredata.info/ listinfo/pd-list
Terrorism is not an enemy. It cannot be defeated. It's a tactic.
It's about as sensible to say we declare war on night attacks and
expect we're going to win that war. We're not going to win the war
on terrorism. - retired U.S. Army general, William Odom