[PD] [psql] object hand-holding
mjmogo at gmail.com
Sat Dec 8 02:31:03 CET 2007
So, it looks like, from your prototype, that an SQL statement without
comma's could be used on the Hot inlet, while those with comma's would have
to go into the Cold inlet?
To me, that seems kind of clunky.
Also, I still don't see how the external would know where the end of the SQL
statement would be.
On Dec 7, 2007 7:09 PM, Hans-Christoph Steiner <hans at eds.org> wrote:
> I sketched up a quick patch to illustrate what I mean:
> 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
> Mike McGonagle
> On 12/7/07, andy.graybeal at casanueva.com < andy.graybeal at casanueva.com>
> > 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_ERROR
> > i'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 at 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 at iem.at mailing list
> UNSUBSCRIBE and account-management ->
> 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
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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pd-list