Using SQLite in Ruby on Rails

SQLite is a lightweight, embedded, and SQL database without configuration. It is very convenient to use only two files because it does not need to be installed. Sqlite3.dll, sqlite3.exe is about K in total, much smaller than mysql30 M. In addition to downloading the two files mentioned above in rails, you also need to install SQLite-Ruby. For local installation, refer to the Ruby on Rails local installation method. In Windows, the gem is sqlite3.ruby. 1.2.1.mswind32.gem. If it is a Remote Installation, you will be prompted to choose from. After installing rails, add the parameter-D sqlite3. Otherwise, MySQL is used by default, for example, rails demo-D sqlite3. If you need the SQLite management program, you can use the SQLite database browser, which is also a file and does not need to be installed. Add the directory where sqlite3.dlland sqlite3.exe are located to the & Path & environment variable.