Get SQLite error using heroku db:push when I'm using PostgreSQL as development db

Question

I was having problems pushing data from my development db to Heroku. I decided to switch to PostgreSQL as my development db and have updated database.yml and removed the sqlite gem from the gemfiles.

The app runs fine against PostgreSQL but when I try to run the command:

heroku db:push

I get an SQLite error which is puzzling because there is no reference to sqlite in my project:

 !    Taps Load Error: cannot load such file -- sqlite3
 !    You may need to install or update the taps gem to use db commands.
 !    On most systems this will be:
 !    
 !    sudo gem install taps

Here is my database.yml file:

development:
  adapter: postgresql
  encoding: unicode
  database: xxxx
  pool: 5
  timeout: 5000
  username: xxxx
  password: xxxx

test:
  adapter: postgresql
  encoding: unicode
  database: test
  pool: 5
  timeout: 5000
  username: xx
  password: xx

production:
  adapter: postgresql
  encoding: unicode
  database: test
  pool: 5
  timeout: 5000

I'm using RVM and I have created a new gemset without any luck.

I even tried this but got the same SQLite error:

heroku db:push postgres://xx:xx@localhost/xx

 !    Taps Load Error: cannot load such file -- sqlite3
 !    You may need to install or update the taps gem to use db commands.
 !    On most systems this will be:
 !    
 !    sudo gem install taps

I have also run bundle install and bundle update.

Johann

tekniklr · Accepted Answer · 2012-03-04 19:40:08Z

10

I was having the same problem and solved it by moving taps into a development group in my gemfile- taps requires sqlite, which is what was causing the problem.

group :development do
  gem 'taps', :require => false # has an sqlite dependency, which heroku hates
end

answered Mar 4, 2012 at 19:40

tekniklr

1232 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

gugguson Over a year ago

tried that, but get the same error (I ran bundle install and update and commited to heroku before pushing db ... get an sqlite error).

gugguson Over a year ago

Solved it - tekniklr answer put me on the correct track. The problem was that taps is using sqlite and that wasn't installed on the client machine (I think I manually removed it manually before). After I installed sqlite it worked fine.

dicato Over a year ago

I had the same problem. I thought it was a homebrew problem as I installed heroku manually in conjunction to using homebrew at some point to test something. 'gem install sqlite3' solved the problem.

Vanuan Over a year ago

taps doesn't have sqlite3 runtime dependency

tekniklr Over a year ago

It might not anymore, but 7 months ago it did :)

JjP · Accepted Answer · 2012-09-25 10:38:07Z

8

The solution is to add not only taps gem but also sqlite3 gem into the :development group. If you are using in your development sqlite3 already, then just adding taps gem will be enough. But I am using mysql on my development so to solve that problem I had to add both.

group :development do
  gem 'taps'
  gem 'sqlite3'
end

answered Sep 25, 2012 at 10:38

JjP

5995 silver badges5 bronze badges

Comments

n3o · Accepted Answer · 2013-06-24 23:05:21Z

4

gem install sqlite3

solved it for me.

answered Jun 24, 2013 at 23:05

n3o

2,8735 gold badges27 silver badges38 bronze badges

Comments

user · Accepted Answer · 2012-10-17 15:16:50Z

0

On my debian wheezy I needed to install:

aptitude install libsqlite3-dev

edited Oct 17, 2012 at 15:16

user

87.1k18 gold badges200 silver badges190 bronze badges

answered Oct 17, 2012 at 15:09

luke

1

Comments

Cheyne · Accepted Answer · 2013-07-06 18:39:37Z

0

gem install sqlite3

Is all you need. The error is coming locally, not from Heroku

answered Jul 6, 2013 at 18:39

Cheyne

2,1774 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

Get SQLite error using heroku db:push when I'm using PostgreSQL as development db

5 Answers 5

5 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related