[PD] accessing mysql database

[B. Bogart]

Hi Tina,

there is [sqlsingle] that works on only PosgreSQL databases. Do you need
mySQL in particular? There was talk on the list about making [sqlsingle]
work on SQL in general rather than a particular database.

some other options are:

Use python to access the database, and load the python script into PD
using pyext.

Write a script in any language that receives messages on a local socket in
the pd [netsend] format, and feed that data into the database.

Use pool or something else to store your data rather than a big database.

..b.

On Wed, March 8, 2006 9:38 am, \\js said:
> hi
>
> On 3/8/06, Tina Shah <surreal8 at hotmail.com> wrote:
>> 2.  I would like to store this value in a mysql database.  How do I get
>> pd
>> to send data to a mysql database?
>
> osc~ ?
>
> you'll prolly need to write something to receive the messages and then
> generate the SQL to stick it in. i think there is code freely
> available in several languages that deals with this issue.
>
>> I really
>> am just looking for a basic tutorial that will teach me how to get pd to
>> send/receive data from a mysql database.
>
> i don't think it exists. if you finish this work, maybe you can write one.
>
> --
> \js  [ http://or8.net/~johns/ ]
>
> _______________________________________________
> PD-list at iem.at mailing list
> UNSUBSCRIBE and account-management ->
> http://lists.puredata.info/listinfo/pd-list
>