DB persisted attachments?

Has anyone implemented attachments persisted in the database? The latest
version of RForum supports file-based attachments that will not work in
a load balance environment without some drive sharing magic.

Rocket

Rocket Johnson wrote:

Has anyone implemented attachments persisted in the database? The latest
version of RForum supports file-based attachments that will not work in
a load balance environment without some drive sharing magic.

Can’t you use NFS or something like that? I don’t think that keeping big
files in a database is a good idea.

Andreas S. wrote:

Rocket Johnson wrote:

Has anyone implemented attachments persisted in the database? The latest
version of RForum supports file-based attachments that will not work in
a load balance environment without some drive sharing magic.

Can’t you use NFS or something like that? I don’t think that keeping big
files in a database is a good idea.

NFS is how I solved it initially. However, that solution introduces more
complexities in a farmed environment. Nothing hard, but with more moving
parts the more things that can go wrong. Also using a file-based
persistance mechanism means you have another thing to deal with in your
backup/restore strategy.

What are your concerns with keeping big files (FYI, I don’t consider
100k to be big) in a db? Sqlite I can see being a problem but the
industrial-strength databases handle binary data fine when implemented
correctly.

FYI, it was pretty simple to switch to db persisted attachments. Also,
great work on RForum. I have learned a lot about Rails and Ruby using
it.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs