[PD] MySql database accessing with PureData ?

Frank Barknecht fbar at footils.org
Wed Dec 17 16:46:11 CET 2003

Jean Jacques hat gesagt: // Jean Jacques wrote:

> Unfortunately i don't know anything about python excepted that i
> should learn it !  Could you give me an estimation of the time
> needed by a newbie to script a MySql reader for pd ?

This very much depends on how comfortable and experienced you are with
programming. I learned the basics of Python in about an afternoon, and
I was only slightly experienced in Perl at that time. Start with Guido
van Rossums Python tutorial, it's a short read and lots of fun, too.

For Database access I would highly recommend using SQLObject from
http://sqlobject.org/, which is a wrapper around several databases. It
makes getting started with database programming in Python *very* fast. 

This is a complete DB app in Python:

# start
from SQLObject import *

__connection__ = MySQLConnection(
    host='localhost', db='sqlobject_test',
    user='sqlobject_test', passwd='sqltest')

class Person(SQLObject):

    firstName = StringCol(length=100)
    middleInitial = StringCol(length=1, default=None)
    lastName = StringCol(length=100)

if __name__ == "__main__":
    msp = Person.new("Miller", "S", "Puckettte")
    print "%s wrote Pd" % msp.lastName
    print "Oops, spelling error!"
    msp.lastName = "Puckette"
    print msp
# end

After that, msp is correctly saved in the Database, because all
DB-actions are transparent and automatically written or read when
accessing the attributes like "msp.lastName"

 Frank Barknecht                               _ ______footils.org__

More information about the Pd-list mailing list