[Zope] large images to a database via zope.

Dennis Nichols nichols@tradingconnections.com
Thu, 12 Apr 2001 16:05:50 -0500


At 4/12/01 04:40 PM, ghaley@mail.venaca.com wrote:
>we are running zope 2.3.n with mysql 2.23.n (where n is i'm not sure the
>exact port).  there is some sort of practical limit on the size of a file
>that mysql can insert (it's somewhere around 16MB), although a largeblob
>data type should be able to hold over a gig.

The advice usually is to *not* store images in the database, which then 
voids the rest of your question. Store the images in the file system and 
store only a link to them (and any meta-data) in the DB. Searching the 
MySQL archives, you will certainly find repeated discussions of this.

--
Dennis Nichols
nichols@tradingconnections.com