使用SQLite 3将RoR应用程序部署到Heroku失败 [英] Deploying RoR app to Heroku with SQLite 3 fails

问题描述

我正在尝试将我的第一个应用部署到Heroku。我使用SQLite作为数据库。据我所知，Heroku不使用SQLite，它在后台切换到Postgres。

I'm trying to deploy my first app to Heroku. I'm using SQLite as the database. As far as I know Heroku doesn't use SQLite - it switches to Postgres in the backend.

当我部署时，出现以下错误：

When I'm deploying I get the following error:

我的 Gemfile （这是我认为会导致此问题的原因）如下所示：

My Gemfile (which is what I assume is causing this problem) looks as follows:

source 'http://rubygems.org'

gem 'rails', '3.0.0'        
gem 'sqlite3-ruby', '1.2.5', :require => 'sqlite3'

我做错了什么？

What am I doing wrong?

推荐答案

Heroku不支持SQLite数据库。您需要在生产中使用PostgreSQL，因为我在这篇文章中还解释过。

Heroku doesn't support SQLite databases. You need to use PostgreSQL on production, as I also explained in this post.

group :production do
  gem "pg"
end

group :development, :test do
  gem "sqlite3", "~> 1.3.0"
end

实际上，建议尽可能使用开发/测试环境来生产。因此，我建议您将所有环境切换到PostgreSQL。

Actually, it's recommended to use in development/test an environment as close as possible to production. Therefore, I suggest you to switch all your environments to PostgreSQL.

# replace gem "sqlite3" with
gem "pg"

这篇关于使用SQLite 3将RoR应用程序部署到Heroku失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！