[PD] accessing mysql database

Thomas Grill gr at grrrr.org
Mon Apr 9 00:13:56 CEST 2007


Hi Luigi,

> Yes i can acces the database from python, entering some lines of  
> python:
>
> db = MySQLdb.connect("localhost", "root", "gigiroot", "sfx_database")
> sql = """SELECT * FROM soundfile where description like '%birds%"""
> cursor.execute(sql)
> data = cursor.fetchall()
> print data.
>
>
>
> but from PD it does not work

How does it not work?
You should in any case use the detached mode (send [detach 1(  ) to  
py/pyext to run in the background, otherwise the pd kernel will be  
disturbed during the SQL query.

greetings,
Thomas


--
Thomas Grill
http://grrrr.org






More information about the Pd-list mailing list