[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