How do I install sqlite3 for Ruby on Windows?

by

Even though the question has been answered, I want to post my research to help others. I found a lot of information online, but being a Ruby newbie I had a tough time following all. The basic answer comes from the following post https://github.com/luislavena/sqlite3-ruby/issues/82 with instructions by “paulwis” on how to properly install sqlite3 for ruby 2.0.0-p0 and some comments on https://github.com/rails/rails/issues/10150 . So here it is:

  1. Install the Ruby Devkit for your setup (DevKit-mingw64-64-4.7.2-20130224-1432-sfx.exe for me since I use a x64 machine)
  2. Download and extract the autoconf package from Sqlite.org
  3. Run msys.bat (it is inside the ruby devkit root folder)
  4. cd into the path where you downloaded the sqlite source (for example: “cd /c/dev/sqlite3” for path “c:\dev\sqlite3” if you are new to MSYS/MINGW32)
  5. Run “./configure”
  6. Run “make”
  7. Run “make install”

  8. Get the sqlite3 gem again, this time specifying the platform and the path to the newly compiled binaries:

    gem install sqlite3 --platform=ruby -- --with-sqlite3-include=[path\to\sqlite3.h] --with-sqlite3-lib=[path\to\sqlite3.o]

    For example:

    gem install sqlite3 --platform=ruby -- --with-sqlite3-include=/c:/dev/sqlite3/ --with-sqlite3-lib=/c:/dev/sqlite3/.libs/

    (from the paths given in step 4)

  9. Check the Gemfile.lock of your rails app and make sure that it points to the correct sqlite3 version. Mine was “sqlite3 (1.3.7-x86-mingw32)” and manually changed it to “sqlite3 (1.3.7-x64-mingw32)”. Removing the platform also works: “sqlite3 (1.3.7)”.

Hope this helps someone.

More Related Contents:

  1. Boolean Validation
  2. Limitations in running Ruby/Rails on windows
  3. Error installing libv8: ERROR: Failed to build gem native extension
  4. Using Process.spawn as a replacement for Process.fork
  5. HEROKU – cannot run git push heroku master [duplicate]
  6. Why does installing Ruby on Rails generate error “size of array ‘ruby_check_sizeof_voidp’ is negative”?
  7. Why can’t I install the SQLite gem?
  8. sqlite3 gem fails to install
  9. Why won’t Heroku accept my Gemfile.lock in Windows?
  10. ImageMagick – “CORE_RL_magick_.dll not found” or how to install RMagick on windows with ruby 1.9.2
  11. Difference between attr_accessor and attr_accessible
  12. Learning Ruby on Rails
  13. Rails :dependent => :destroy VS :dependent => :delete_all
  14. Nokogiri installation fails -libxml2 is missing
  15. Get person’s age in Ruby
  16. Rails /lib modules and
  17. How do you configure WEBrick to use SSL in Rails?
  18. How to convert a ruby hash object to JSON?
  19. How to get request referer path?
  20. How to get a Date from date_select or select_date in Rails?
  21. Can I write PostgreSQL functions on Ruby on Rails?
  22. How can I use Ruby/Rails variables inside Sass?
  23. How to get Ruby / Homebrew / RVM to work on Yosemite?
  24. What is the difference between pluck and collect in Rails?
  25. Rails – Sort by join table data
  26. strong parameters permit all attributes for nested attributes
  27. Ruby: Create range of dates
  28. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]
  29. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  30. Unable to install MySQL2 gem on Windows 7

Leave a Comment