[PD] [psql] object hand-holding

[Hans-Christoph Steiner]

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 at casanueva.com <  
> andy.graybeal at 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_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 -> 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.puredata.info/pipermail/pd-list/attachments/20071207/b66c484b/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql-interface.pd
Type: application/octet-stream
Size: 2585 bytes
Desc: not available
URL: <http://lists.puredata.info/pipermail/pd-list/attachments/20071207/b66c484b/attachment.obj>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.puredata.info/pipermail/pd-list/attachments/20071207/b66c484b/attachment-0001.htm>