6

I have an application that uses the Paperclip plugin for image upload. Now that app should get deployed to an host(heroku) which has a read-only file system. Can I somehow tell paperclip to store the images in the database?

mc.
  • 63
  • 1
  • 1
  • 3

4 Answers4

7

Check out this sample app

http://patshaughnessy.net/2009/5/29/paperclip-sample-app-part-3-saving-file-attachments-in-a-database-blob-column

I guess this is exactly what you need.

HTH

PS: storing images in db is usually a bad idea, I am sure you can use paperclip with S3 / cloudfront ( as mentioned in the answers below )

Rishav Rastogi
  • 15,484
  • 3
  • 42
  • 47
5

Heroku recommends storing file uploads on s3, and provides instructions on how to do so for several Rails file plugins.

ry.
  • 7,885
  • 1
  • 20
  • 10
4

Rethink what you're doing. Storing images in the db is generally a bad idea. For more info, see here.

ry is right to point you towards S3. If nothing else, think of the cost: 500 MB of database space on Heroku is $50/month. On S3, it'll be 15 cents.

Community
  • 1
  • 1
PreciousBodilyFluids
  • 11,881
  • 3
  • 37
  • 44
0

Image serving from S3 is slow. Latencies of 0.5s to 2s are common, which means it should only be used for media assets.

TreeBase
  • 1