[Tutor] python & mysql question

Danny Yoo dyoo at hkn.eecs.berkeley.edu
Thu Sep 7 16:05:34 CEST 2006


>> I have to store and retrieve text files from a database table and the 
>> size of each file is about 500k. Can someone give me an idea on how to 
>> do this?
>>
>> Thanks,
>> Patricia
> http://dustman.net/andy/python/python-and-mysql
> Provides some background for the MySQLdb module.  This should get you
> started.  The next reference provides more background, but may not be
> needed.

And just as a heads up: you'll probably need to configure your database 
tables to use TEXT or LONGTEXT columns, since 500k texts are definitely 
larger than the 255-char limit imposed by varchars.


More information about the Tutor mailing list