blocks|key|2202935|text|这是您想要添加的特定类型的文件吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2202936|我之所以这样问，是因为如果它不是从数据库中受益的那种数据(文本数据可能是可搜索的，二进制数据是不可搜索的)，那么您最好将其存储在文件系统中并直接提供它-特别是对于图像或视频之类的内容-而不是将其插入数据库并在每次用户请求它时都必须遍历您的应用程序。|2202937|我不是说你没有任何理由想要在数据库中有一个文件，但我认为这是最后的手段，在十年的web编程中，我还没有遇到过有必要这样做的情况。|2202938|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Is it a particular kind of file you want to add? 

I just ask because if it's not data of a kind that benefits from being in a database ( textual data might be searchable, binary data is not ) then you are much better storing it in the filesystem and serving it up straight - especially for stuff like images or video - rather than inserting it into a database and having to go through your application every time a user requests it. 

I'm not saying that there aren't any reasons you might want to have a file in the database, but I treat that as a last resort and in ten years of web programming I've not come across a case where it was necessary.

blocks|key|663606|text|我强烈推荐attachment_fu插件，因为它可以让你很好地创建带有附件的模型，纸夹插件也是一个很好的插件！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|663607|如果您在决定使用哪个附件时遇到困难，据我所知，回形针可以更容易地用于多个附件，例如相册有许多照片，而Attachment_fu更容易用于单个附件，例如用户有一张显示图片。|663608|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I would highly recommend the attachment_fu plugin as this lets you create models with attachments pretty nicely, Paperclip plugin is another good one also!

If you have trouble deciding which one to use, as far as i can remember, Paperclip makes it easier for multiple attachments, such as an Album has many Photos, and Attachment_fu is easier for single attachments such as a User has one display picture.

blocks|key|1964007|text|如今，Paperclip比attachment_fu更受推崇。它与活动记录模型一起使用非常简单和容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1964008|entityMap|0|LINK|mutability|MUTABLE|url|http://github.com/thoughtbot/paperclip/^0|3|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://github.com/thoughtbot/paperclip/" rel="nofollow noreferrer">Paperclip</a> is more recommended than attachment_fu these days. It is really simple and easy to use with your active record model.

blocks|key|663640|text|我们在我管理的一个网站上做这样的事情。与其将这些文件存储在数据库中，我同意这里的其他发帖者的观点，并建议你尝试一下像回形针这样的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|663641|一个警告:如果你想要访问控制，确保回形针不会将你的文件保存在/public下的某个地方，这样任何人只要知道网址就可能访问它们。通过控制器中的send_file将文件传送给用户。|663642|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

We do something like this on a site I'm managing. Instead of storing these files in a database, I'd agree with the other posters here and recommend you try something like Paperclip.

One caveat: if you want access control, make sure that paperclip doesn't save your files somewhere under /public, where anyone could possibly access them if they knew the URL. Deliver files to the user via send_file in your controller.

I've only just started learning ruby on rails and I would like to create an application that will allow me to add files to the database. Currently, I'm developing the rails application using the Aptana plugin for Eclipse and the application is using the default sqllite db.

I have tried generating a scaffold with the following parameters: <code>documents title:string file:varbinary</code>. Then I do a 'rake'->'db'->'migrate'. When I migrate to localhost/documents and click on 'New Document' the application fails and displays an error.

What I would like to do is click on 'New Document', have a field that will allow me to browse for a document on my local computer, select the document and add it to the db on the rails application.

Add a file to a database in a Ruby on Rails application?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我刚刚开始学习ruby on rails，我想创建一个允许我向数据库添加文件的应用程序。目前，我正在使用Eclipse的Aptana插件开发rails应用程序，该应用程序使用默认的sqllite db。我尝试使用以下参数生成一个scaffold：documents title:string file:varbinary...

问向Ruby on Rails应用程序中的数据库添加文件？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问向Ruby on Rails应用程序中的数据库添加文件？EN