#HOW TO INSTALL SQLITE IN RAILS INSTALL#
#HOW TO INSTALL SQLITE IN RAILS CODE#

You need to take the DLL and put it somewhere, where Ruby would look for libraries when you execute a script, some possible locations would be, your windows system folder or the bin folder of your Ruby installation ( Note: as reader Luis Lavena noted in the comments below, the ruby installation bin folder is by far the best place to put the DLL).

sqlite3.exe вЂ“ this is the command line utility.

sqlite3.dll вЂ“ this is the actual database.

Once you unzip both of those you will have several files, the important ones are:

sqlite-3_6_16.zip вЂ“ this one is a command line utility that can be used to administer a SQLite databaseД«oth of those files are located on the downloads page вЂ“, under the вЂPrecompiled Binaries For WindowsвЂ™ section.

#HOW TO INSTALL SQLITE IN RAILS INSTALL#

sqlitedll-3_6_16.zip вЂ“ you can think of this one as actually being the SQLite database that you will install on your machine.You need to download two things from the SQLite website (well strictly speaking you only actually NEED one, but weвЂ™ll download both since the other one is useful): The information on the old What To Download And Where To Put ItДЇirst thing first, before we involve Ruby directly lets download set up everything we need.

#HOW TO INSTALL SQLITE IN RAILS CODE#

However when I tried to use it in my Ruby code I found that it wasnвЂ™t that straight forward getting everything to work, especially if youвЂ™re using Ruby on windows. SQLite is a great little embeddable database engine thatвЂ™s meant to be self-contained, easy to use and not require configuration.

How to install sqlite in rails