Find your sqlite3 gemspec file. One example is /usr/local/share/gem/specifications/sqlite3-1.3.7.gemspec

Windows: C:\Ruby21\lib\ruby\gems\2.1.0\specifications.

You should adjust according with your Rubygem path and sqlite3 version.Edit the file above and look for the following line

s.require_paths=["lib"]

change it to

s.require_paths= ["lib/sqlite3_native"]

Since pull request #229 has been merged, sqlite3 can be installed per git: key. It's possible to use sqlite3 easily through this addition in your Gemfile :

gem 'sqlite3', git: "https://github.com/sparklemotion/sqlite3-ruby"

This works on RubyInstaller-2.4 and newer. It automatically installs the required pacman package mingw-w64-x86_64-sqlite3 when you run bundler install.

There are some more hints for Rails on Windows in the RubyInstaller2 FAQ.

see：https://stackoverflow.com/a/39136421/6755206

fortunately, you don't have to switch to ruby 2.0
there is a solution to this issue, after endless trying...

https://github.com/hwding/sqlite3-ruby-win

Steps

Pre

• gem uninstall sqlite3 --all

Source

• Download the latest sqlite3-ruby, https://github.com/sparklemotion/sqlite3-ruby
• unzip the package

Build

• run command-line in the extracted dir
• make sure you have your C compiler installed and added to PATH
• gem install bundler
• bundle install
• rake native gem
• you'll find a dir named 'pkg' generated

Install

• enter dir 'pkg'
• gem install --local sqlite3-xxx.gem ('xxx' is version code)

Check

• irb
• require 'sqlite3'