Re: Cloud SQL & Blobstore Simultaneously -- good way to handle Django image uploads?

[kscott]

I use the blobstore to upload images to my application.

After they are uploaded:

• verify it a valid image 
• convert to jpg
  
• resize the image to <1 meg
• create a thumbnail image store it in another table
  
• put it in data store column(db.BlobProperty() )
  
• delete the blobstore since I do not need it anymore
  

If you use the datastore be sure to only store one blob in a table per key.  If you do the following performance and scalability will suffer.

 

class ImageStore(db.Model):
    thumbId=db.IntegerProperty()

  image=db.BlobProperty()

   thumbnail=db.BlobProperty()

Check out my app: http:// www.hikejournal.com

On Saturday, August 25, 2012 9:10:32 PM UTC-5, seafangs wrote:

Hello,

I'm new to GAE (and this forum), please forgive any ignorance on my part. I've been searching around to find out what the best practice is, to allow users to upload images using Django on GAE. The clincher is that I want to use Cloud SQL.

I see that the docs recommend the Blobstore as the place to store images. I understand that I am also able to store images in a Cloud SQL MEDIUMBLOB (or equivalent) field (or even in a TextField in a binary form). However I also understand that the latter approaches -- storing it into a MEDIUMBLOB or as binary data -- are advised against.

So that brings me back to storing it in the Blobstore. But will I be able to use the Blobstore and Cloud SQL in the same GAE environment? I got the impression that the Datastore and Cloud SQL were more or less alternatives to each other. But I also get the impression that Blobstore is separate, in some sense, from the normal Datastore.

Can anyone offer me any guidance on a best approach?