wrong version of sqlite3 required for ruby on rails The Next CEO of Stack Overflowsqlite3-ruby install error on UbuntuSqlite3 gem for Rails 3.1I am unable to install sqlite3 on rails 3.2 Windowsrails bundle install sqlite3 failed in kali linuxGem::Ext::BuildError: ERROR: Failed to build gem native extension. - tharinduunable to install libxml-ruby 2.6 on mac osUnable to run Rails 4 server because of missing sqlit3/Unable to install sqlite3-1.3.10 on Windows 8How to install ruby on rails in windowsI am getting this error while executing cmd “rails new test_install” on my windowssqlite3 cannot be bundle in windows rails app

The Ultimate Number Sequence Puzzle

Aggressive Under-Indexing and no data for missing index

It is correct to match light sources with the same color temperature?

Physiological effects of huge anime eyes

Does higher Oxidation/ reduction potential translate to higher energy storage in battery?

Can you teleport closer to a creature you are Frightened of?

IC has pull-down resistors on SMBus lines?

Is there such a thing as a proper verb, like a proper noun?

What day is it again?

Is there an equivalent of cd - for cp or mv

Is there a reasonable and studied concept of reduction between regular languages?

How to use ReplaceAll on an expression that contains a rule

Towers in the ocean; How deep can they be built?

Is Nisuin Biblical or Rabbinic?

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

Players Circumventing the limitations of Wish

Is French Guiana a (hard) EU border?

Is it okay to majorly distort historical facts while writing a fiction story?

Is there a way to save my career from absolute disaster?

Why did early computer designers eschew integers?

Does Germany produce more waste than the US?

Reshaping json / reparing json inside shell script (remove trailing comma)

Raspberry pi 3 B with Ubuntu 18.04 server arm64: what chip

Ising model simulation



wrong version of sqlite3 required for ruby on rails



The Next CEO of Stack Overflowsqlite3-ruby install error on UbuntuSqlite3 gem for Rails 3.1I am unable to install sqlite3 on rails 3.2 Windowsrails bundle install sqlite3 failed in kali linuxGem::Ext::BuildError: ERROR: Failed to build gem native extension. - tharinduunable to install libxml-ruby 2.6 on mac osUnable to run Rails 4 server because of missing sqlit3/Unable to install sqlite3-1.3.10 on Windows 8How to install ruby on rails in windowsI am getting this error while executing cmd “rails new test_install” on my windowssqlite3 cannot be bundle in windows rails app










0















I am trying to do a new ruby on rails, everything goes perfectly until it want to install sqlite3 - I do have it installed and it is recognised when asking it in cmd, but the error asks for a different version. Tried to install that version, but no success.
I tried many other things from the internet, but just can't make it work.
I am a newbie trying to learn.



Installing sqlite3 1.4.0 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.



current directory:
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3
C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-12720-15tc5du.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can
be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to
C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out



An error occurred while installing sqlite3 (1.4.0), and Bundler cannot continue.
Make sure that gem install sqlite3 -v '1.4.0' --source 'https://rubygems.org/'
succeeds before bundling.



In Gemfile:
sqlite3



installing the required version



gem install sqlite3 -v 1.4.0
Temporarily enhancing PATH for MSYS/MINGW...
Installing required msys2 packages: mingw-w64-x86_64-sqlite3
Building native extensions. This could take a while...
ERROR: Error installing sqlite3:
ERROR: Failed to build gem native extension.



current directory: C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3


C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-5276-1djiqig.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out










share|improve this question






















  • You can really skip sqlite altogether and use rails with Postgres or MySql. The only reason rails defaults to sqlite is that its a relatively easy to setup (on Linux and OS-X) so that you can get it up and running quickly for development. You're not actually going to be deploying rails applications with Sqlite as it does not scale so it makes sense to develop and test on the database you are actually going to use.

    – max
    Mar 9 at 11:23











  • That said I would really recommend that you use virtualbox to setup a virtual machine running Linux as most rails tutorials assume that you are using a Posix compliant OS and you'll will struggle needlessly with setup issues on windows. Also you will most likely not be deploying to a windows server unless you really don't like your life. guides.railsgirls.com/virtual-machine

    – max
    Mar 9 at 11:27
















0















I am trying to do a new ruby on rails, everything goes perfectly until it want to install sqlite3 - I do have it installed and it is recognised when asking it in cmd, but the error asks for a different version. Tried to install that version, but no success.
I tried many other things from the internet, but just can't make it work.
I am a newbie trying to learn.



Installing sqlite3 1.4.0 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.



current directory:
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3
C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-12720-15tc5du.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can
be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to
C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out



An error occurred while installing sqlite3 (1.4.0), and Bundler cannot continue.
Make sure that gem install sqlite3 -v '1.4.0' --source 'https://rubygems.org/'
succeeds before bundling.



In Gemfile:
sqlite3



installing the required version



gem install sqlite3 -v 1.4.0
Temporarily enhancing PATH for MSYS/MINGW...
Installing required msys2 packages: mingw-w64-x86_64-sqlite3
Building native extensions. This could take a while...
ERROR: Error installing sqlite3:
ERROR: Failed to build gem native extension.



current directory: C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3


C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-5276-1djiqig.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out










share|improve this question






















  • You can really skip sqlite altogether and use rails with Postgres or MySql. The only reason rails defaults to sqlite is that its a relatively easy to setup (on Linux and OS-X) so that you can get it up and running quickly for development. You're not actually going to be deploying rails applications with Sqlite as it does not scale so it makes sense to develop and test on the database you are actually going to use.

    – max
    Mar 9 at 11:23











  • That said I would really recommend that you use virtualbox to setup a virtual machine running Linux as most rails tutorials assume that you are using a Posix compliant OS and you'll will struggle needlessly with setup issues on windows. Also you will most likely not be deploying to a windows server unless you really don't like your life. guides.railsgirls.com/virtual-machine

    – max
    Mar 9 at 11:27














0












0








0








I am trying to do a new ruby on rails, everything goes perfectly until it want to install sqlite3 - I do have it installed and it is recognised when asking it in cmd, but the error asks for a different version. Tried to install that version, but no success.
I tried many other things from the internet, but just can't make it work.
I am a newbie trying to learn.



Installing sqlite3 1.4.0 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.



current directory:
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3
C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-12720-15tc5du.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can
be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to
C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out



An error occurred while installing sqlite3 (1.4.0), and Bundler cannot continue.
Make sure that gem install sqlite3 -v '1.4.0' --source 'https://rubygems.org/'
succeeds before bundling.



In Gemfile:
sqlite3



installing the required version



gem install sqlite3 -v 1.4.0
Temporarily enhancing PATH for MSYS/MINGW...
Installing required msys2 packages: mingw-w64-x86_64-sqlite3
Building native extensions. This could take a while...
ERROR: Error installing sqlite3:
ERROR: Failed to build gem native extension.



current directory: C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3


C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-5276-1djiqig.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out










share|improve this question














I am trying to do a new ruby on rails, everything goes perfectly until it want to install sqlite3 - I do have it installed and it is recognised when asking it in cmd, but the error asks for a different version. Tried to install that version, but no success.
I tried many other things from the internet, but just can't make it work.
I am a newbie trying to learn.



Installing sqlite3 1.4.0 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.



current directory:
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3
C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-12720-15tc5du.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can
be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in
C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to
C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out



An error occurred while installing sqlite3 (1.4.0), and Bundler cannot continue.
Make sure that gem install sqlite3 -v '1.4.0' --source 'https://rubygems.org/'
succeeds before bundling.



In Gemfile:
sqlite3



installing the required version



gem install sqlite3 -v 1.4.0
Temporarily enhancing PATH for MSYS/MINGW...
Installing required msys2 packages: mingw-w64-x86_64-sqlite3
Building native extensions. This could take a while...
ERROR: Error installing sqlite3:
ERROR: Failed to build gem native extension.



current directory: C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0/ext/sqlite3


C:/Ruby25-x64/bin/ruby.exe -r ./siteconf20190308-5276-1djiqig.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... no
checking for dlopen()... no
missing function dlopen
* extconf.rb failed *
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log file for more details. You may
need configuration options.



Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=$opt-dir/include
--with-opt-lib
--without-opt-lib=$opt-dir/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby25-x64/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=$sqlite3-dir/include
--with-sqlite3-lib
--without-sqlite3-lib=$sqlite3-dir/lib
--with-pthreadlib
--without-pthreadlib
--with-dllib
--without-dllib



To see why this extension failed to compile, please check the mkmf.log which can be found here:



C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/mkmf.log



extconf failed, exit code 1



Gem files will remain installed in C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/sqlite3-1.4.0 for inspection.
Results logged to C:/Ruby25-x64/lib/ruby/gems/2.5.0/extensions/x64-mingw32/2.5.0/sqlite3-1.4.0/gem_make.out







ruby-on-rails sqlite sqlite3






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 8 at 17:39









katalinkatalin

134




134












  • You can really skip sqlite altogether and use rails with Postgres or MySql. The only reason rails defaults to sqlite is that its a relatively easy to setup (on Linux and OS-X) so that you can get it up and running quickly for development. You're not actually going to be deploying rails applications with Sqlite as it does not scale so it makes sense to develop and test on the database you are actually going to use.

    – max
    Mar 9 at 11:23











  • That said I would really recommend that you use virtualbox to setup a virtual machine running Linux as most rails tutorials assume that you are using a Posix compliant OS and you'll will struggle needlessly with setup issues on windows. Also you will most likely not be deploying to a windows server unless you really don't like your life. guides.railsgirls.com/virtual-machine

    – max
    Mar 9 at 11:27


















  • You can really skip sqlite altogether and use rails with Postgres or MySql. The only reason rails defaults to sqlite is that its a relatively easy to setup (on Linux and OS-X) so that you can get it up and running quickly for development. You're not actually going to be deploying rails applications with Sqlite as it does not scale so it makes sense to develop and test on the database you are actually going to use.

    – max
    Mar 9 at 11:23











  • That said I would really recommend that you use virtualbox to setup a virtual machine running Linux as most rails tutorials assume that you are using a Posix compliant OS and you'll will struggle needlessly with setup issues on windows. Also you will most likely not be deploying to a windows server unless you really don't like your life. guides.railsgirls.com/virtual-machine

    – max
    Mar 9 at 11:27

















You can really skip sqlite altogether and use rails with Postgres or MySql. The only reason rails defaults to sqlite is that its a relatively easy to setup (on Linux and OS-X) so that you can get it up and running quickly for development. You're not actually going to be deploying rails applications with Sqlite as it does not scale so it makes sense to develop and test on the database you are actually going to use.

– max
Mar 9 at 11:23





You can really skip sqlite altogether and use rails with Postgres or MySql. The only reason rails defaults to sqlite is that its a relatively easy to setup (on Linux and OS-X) so that you can get it up and running quickly for development. You're not actually going to be deploying rails applications with Sqlite as it does not scale so it makes sense to develop and test on the database you are actually going to use.

– max
Mar 9 at 11:23













That said I would really recommend that you use virtualbox to setup a virtual machine running Linux as most rails tutorials assume that you are using a Posix compliant OS and you'll will struggle needlessly with setup issues on windows. Also you will most likely not be deploying to a windows server unless you really don't like your life. guides.railsgirls.com/virtual-machine

– max
Mar 9 at 11:27






That said I would really recommend that you use virtualbox to setup a virtual machine running Linux as most rails tutorials assume that you are using a Posix compliant OS and you'll will struggle needlessly with setup issues on windows. Also you will most likely not be deploying to a windows server unless you really don't like your life. guides.railsgirls.com/virtual-machine

– max
Mar 9 at 11:27













2 Answers
2






active

oldest

votes


















0














Seems like some issues with new sqlite 1.4.0 gem.
https://github.com/rails/rails/issues/35153



Use this version instead.
gem 'sqlite3', '~> 1.3.6'






share|improve this answer






























    0














    Thank you all.
    After all I followed Max's proposal I changed to postgres and is working perfectly.






    share|improve this answer























      Your Answer






      StackExchange.ifUsing("editor", function ()
      StackExchange.using("externalEditor", function ()
      StackExchange.using("snippets", function ()
      StackExchange.snippets.init();
      );
      );
      , "code-snippets");

      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "1"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader:
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      ,
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













      draft saved

      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55068315%2fwrong-version-of-sqlite3-required-for-ruby-on-rails%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      0














      Seems like some issues with new sqlite 1.4.0 gem.
      https://github.com/rails/rails/issues/35153



      Use this version instead.
      gem 'sqlite3', '~> 1.3.6'






      share|improve this answer



























        0














        Seems like some issues with new sqlite 1.4.0 gem.
        https://github.com/rails/rails/issues/35153



        Use this version instead.
        gem 'sqlite3', '~> 1.3.6'






        share|improve this answer

























          0












          0








          0







          Seems like some issues with new sqlite 1.4.0 gem.
          https://github.com/rails/rails/issues/35153



          Use this version instead.
          gem 'sqlite3', '~> 1.3.6'






          share|improve this answer













          Seems like some issues with new sqlite 1.4.0 gem.
          https://github.com/rails/rails/issues/35153



          Use this version instead.
          gem 'sqlite3', '~> 1.3.6'







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Mar 9 at 20:33









          VoloshinVoloshin

          13




          13























              0














              Thank you all.
              After all I followed Max's proposal I changed to postgres and is working perfectly.






              share|improve this answer



























                0














                Thank you all.
                After all I followed Max's proposal I changed to postgres and is working perfectly.






                share|improve this answer

























                  0












                  0








                  0







                  Thank you all.
                  After all I followed Max's proposal I changed to postgres and is working perfectly.






                  share|improve this answer













                  Thank you all.
                  After all I followed Max's proposal I changed to postgres and is working perfectly.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Mar 14 at 20:17









                  katalinkatalin

                  134




                  134



























                      draft saved

                      draft discarded
















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid


                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.

                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55068315%2fwrong-version-of-sqlite3-required-for-ruby-on-rails%23new-answer', 'question_page');

                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      Can't initialize raids on a new ASUS Prime B360M-A motherboard2019 Community Moderator ElectionSimilar to RAID config yet more like mirroring solution?Can't get motherboard serial numberWhy does the BIOS entry point start with a WBINVD instruction?UEFI performance Asus Maximus V Extreme

                      Identity Server 4 is not redirecting to Angular app after login2019 Community Moderator ElectionIdentity Server 4 and dockerIdentityserver implicit flow unauthorized_clientIdentityServer Hybrid Flow - Access Token is null after user successful loginIdentity Server to MVC client : Page Redirect After loginLogin with Steam OpenId(oidc-client-js)Identity Server 4+.NET Core 2.0 + IdentityIdentityServer4 post-login redirect not working in Edge browserCall to IdentityServer4 generates System.NullReferenceException: Object reference not set to an instance of an objectIdentityServer4 without HTTPS not workingHow to get Authorization code from identity server without login form

                      2005 Ahvaz unrest Contents Background Causes Casualties Aftermath See also References Navigation menue"At Least 10 Are Killed by Bombs in Iran""Iran"Archived"Arab-Iranians in Iran to make April 15 'Day of Fury'"State of Mind, State of Order: Reactions to Ethnic Unrest in the Islamic Republic of Iran.10.1111/j.1754-9469.2008.00028.x"Iran hangs Arab separatists"Iran Overview from ArchivedConstitution of the Islamic Republic of Iran"Tehran puzzled by forged 'riots' letter""Iran and its minorities: Down in the second class""Iran: Handling Of Ahvaz Unrest Could End With Televised Confessions""Bombings Rock Iran Ahead of Election""Five die in Iran ethnic clashes""Iran: Need for restraint as anniversary of unrest in Khuzestan approaches"Archived"Iranian Sunni protesters killed in clashes with security forces"Archived