Install SQLite3 in Ubuntu

Posted May 11, 2007
Filed under: rails, ubuntu |
  1. Install Sqlite3 
    
sudo apt-get install sqlite3 libsqlite3-dev
sudo gem install sqlite3-ruby
  2. To create a data base, we only need to create a empty file. 
    
touch database_name_dev.db
touch database_name_test.db
touch database_name_prod.db
  3. Configure Ruby on Rails Modificar el archivo config/database.yml: 
    
development:
  adapter: sqlite3
  database: db/database_name_dev.db

test:
  adapter: sqlite3
  database: db/database_name_test.db

production:
  adapter: sqlite3
  database: db/database_name_prod.db

28 comments so far

  1. Nuno Caldeira on December 7, 2007

    very usefull.. thank you

    Reply
  2. Chris on June 1, 2008

    Just what I needed, thanks!

    Reply
  3. pat on July 1, 2009

    thanks! just used this, complete success!

    Reply
  4. kishore on July 15, 2009

    Thank you it solved my problem too..

    Reply
  5. XhtmlWeaver on October 2, 2009

    Very neat instruction for sqllite3 for ubuntu/debian. Great!

    Reply
  6. chamira on December 4, 2009

    thanks you for this, i needed to install libsqlite3-dev for the Ruby gem sqlite3-ruby to install correctly.

    Reply
  7. Dextersmart on January 7, 2010

    This was exactly what I needed. Thanks for the solution.

    Reply
  8. Dheeraj.k on April 18, 2010

    krishna@ubuntu:~$ sudo gem install sqlite3-ruby
    sudo: gem: command not found

    Reply
    • Lolcat on August 25, 2010

      (note i use ruby 1.8 therefore I use rubygems1.8)
      Firstly did you install ruby gems ?
      sudo apt-get install rubygems1.8
      Now lets find gems!
      sudo dpkg -L rubygems1.8 | grep /usr/bin
      … so we see its called gem1.8 and *not* gems , which explains command not found.
      Lets make a link from /usr/bin/gem1.8 to /usr/bin/gems
      sudo ln -s /usr/bin/gem1.8 /usr/bin/gems

      now finally run gems -v to check it is working.

      Reply
  9. RyanonRails on October 23, 2010

    Some people might needs to run apt-get install libsqlite3-ruby to get all of the dependencies.

    Reply
  10. SeanW on October 28, 2010

    Thanks RyanonRails!

    Your advice (+ the one to apt-get ruby-dev in order to install gems properly) saved my day. Later this week trying to install on Windows7.

    Reply
  11. someone on November 16, 2010

    Amazing, Thanks! xD

    Reply
  12. UnderTech09 on September 15, 2011

    ;need some help here…
    how to install libmysqlclient.so.15 in ubuntu?
    when i run my mysql with the server game, i got an error
    * error while loading shared libraries: libmysqlclient.so.15: cannot open share object file: no such file or directory.

    anyone can help up with this problem?
    thanks in advance..

    Reply
  13. Upender on November 18, 2011

    very thanks..

    Reply
  14. shirish herwade on December 23, 2011

    very useful

    Reply
  15. Asma on March 25, 2012

    sudo: gem: command not found 😦

    Reply
    • Pedro on April 24, 2012

      Yo need to install ruby gems, but only if you are planning to use ruby or ruby on rails

      Reply
  16. Robbie Done on April 24, 2012

    worked a treat 😀

    Reply
    • Pedro on April 24, 2012

      Great, nice to see that 5 years later is still useful.

      Reply
  17. webhostingtop3.com on July 30, 2013

    I’ll right away take hold of your rss feed as I can’t to find your email
    subscription link or newsletter service. Do you’ve any? Please allow me realize so that I may just subscribe. Thanks.

    Reply
  18. Mark on December 20, 2013

    Not so far I have found new cool tool to work with SQLite on ubuntu – Valentina Studio. Its free edition can do things more than many commercial tools!!
    I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview

    Reply
  19. rasoolsb on May 1, 2014

    Fabulous…. Moooooaaaahhhh 🙂

    Reply
  20. Johnb231 on August 18, 2014

    Howdy would you mind sharing which blog platform you’re working edcfbbekedce

    Reply
  21. How To Fix Gem Sqlite3 Dll Errors - Windows Vista, Windows 7 & 8 on October 20, 2014

    […] Install SQLite3 in Ubuntu | The Plan A – May 11, 2007 · Install Sqlite3 sudo apt-get install sqlite3 libsqlite3-dev sudo gem install sqlite3-ruby; To create a data base, we only need to create a empty file…. […]

    Reply
  22. Fix Sudo Gem Install Mysql Error Windows XP, Vista, 7, 8 [Solved] on December 12, 2014

    […] Install SQLite3 in Ubuntu | The Plan A – May 11, 2007 · krishna@ubuntu:~$ sudo gem install sqlite3-ruby sudo: gem: command not found… […]

    Reply
  23. sfhsn on June 14, 2015

    var __machform_url = ‘http://eu.nimbocraft.com/form/embed.php?id=11943’;
    var __machform_height = 941;

    Reply

Leave a comment

    • Design a site like this with WordPress.com
    Get started