Rails Issues I've had setting up & running#



For whatever reason, getting sqlite to run via gem failed. Found the following to be a fix


gem 'sqlite3', '~> 1.3.6'#

gem 'sqlite3', git: "https://github.com/larskanis/sqlite3-ruby", branch: "add-gemspec"


process to remove gem's

bundle update gem uninstall sqlite3 gem install sqlite3 --platform=ruby

more commentary

` 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"] `

Instructions to compile sqlite3 on windows

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'

and yet more useful info, 'ridk' ruby installer developer kit

gem uninstall sqlite3 --all ridk exec pacman -S mingw-w64-x86_64-sqlite3 gem inst sqlite3 --platform ruby

Just edit Gemfile and add gem 'sqlite3', platform: :ruby


Im using rails 5.2.1p57, Windows 10 Just running following lines sloved the problem

gem uninstall sqlite3 and uninstall all installed versions. again execute following command

gem install sqlite3 --platform=ruby