LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)

ruby-talk
1

Hi All,

I did as below :-

(arup~>~)$ sqlite3 blog
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

I installed the gem also :-

(arup~>~)$ gem list | grep sequel
sequel (4.10.0)
(arup~>~)$

Now my code :-

require 'sequel'

DB = Sequel.connect('sqlite://blog.db')

DB.create_table :items do
primary_key :id
String :name
Float :price
end

items = DB[:items] # Create a dataset

# Populate the table
items.insert(:name => 'abc', :price => rand * 100)
items.insert(:name => 'def', :price => rand * 100)
items.insert(:name => 'ghi', :price => rand * 100)

# Print out the number of records
puts "Item count: #{items.count}"

# ~> /home/kirti/.rvm/rubies/ruby-2.0.0-p353/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require': LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)

Can anyone tell me how to fix this ?

2

Code works, you need to install sqlite3 gem (which might be a little tricky if sqlite3 libs are not in your library paths).

Panagiotis (atmosx) Atmatzidis

email: atma@convalesco.org
URL: http://www.convalesco.org
GnuPG ID: 0x1A7BFEC5
gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5

"As you set out for Ithaca, hope the voyage is a long one, full of adventure, full of discovery [...]" - C. P. Cavafy

···

On 5 Μαϊ 2014, at 18:32 , Arup Rakshit <aruprakshit@rocketmail.com> wrote:

Hi All,

I did as below :-

(arup~>~)$ sqlite3 blog
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
>

I installed the gem also :-

(arup~>~)$ gem list | grep sequel
sequel (4.10.0)
(arup~>~)$

Now my code :-

require 'sequel'

DB = Sequel.connect('sqlite://blog.db')

DB.create_table :items do
  primary_key :id
  String :name
  Float :price
end

items = DB[:items] # Create a dataset

# Populate the table
items.insert(:name => 'abc', :price => rand * 100)
items.insert(:name => 'def', :price => rand * 100)
items.insert(:name => 'ghi', :price => rand * 100)

# Print out the number of records
puts "Item count: #{items.count}"

# ~> /home/kirti/.rvm/rubies/ruby-2.0.0-p353/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require': LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)

Can anyone tell me how to fix this ?

3

Hello,

Thanks for your reply.

I am actualy wanted to use this - http://sequel.jeremyevans.net/rdoc/files/README_rdoc.html.

Regards,
Arup Rakshit

Hi All,

I did as below :-

(arup~>~)$ sqlite3 blog
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements

terminated with a ";"

I installed the gem also :-

(arup~>~)$ gem list | grep sequel
sequel (4.10.0)
(arup~>~)$

Now my code

:-

require 'sequel'

DB = Sequel.connect('sqlite://blog.db')

DB.create_table :items do
primary_key :id
String :name
Float :price
end

items = DB[:items] # Create a dataset

# Populate the table
items.insert(:name => 'abc', :price => rand * 100)
items.insert(:name => 'def', :price => rand *

100)

items.insert(:name => 'ghi', :price => rand * 100)

# Print out the number of records
puts "Item count: #{items.count}"

# ~> /home/kirti/.rvm/rubies/ruby-2.0.0-p353/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:55:in `require': LoadError: cannot load such file -- sqlite3 (Sequel::AdapterNotFound)

Can anyone tell me how to fix this ?

Code works, you need to install sqlite3 gem (which might be a little tricky if sqlite3 libs are not in your library paths).

Panagiotis (atmosx) Atmatzidis

email:atma@convalesco.org
URL:http://www.convalesco.org
GnuPG ID: 0x1A7BFEC5
gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5

"As you set out for Ithaca, hope the voyage is a long one, full of adventure, full of discovery [...]" - C. P. Cavafy

···

On Monday, 5 May 2014 10:31 PM, Panagiotis Atmatzidis <atma@convalesco.org> wrote:
On 5 Μαϊ 2014, at 18:32 , Arup Rakshit <aruprakshit@rocketmail.com> wrote:

4

The sequel gem depends on the sqlite3 gem (or other adapters like mysql2, pg...) for connecting to the database. You need both.

Andrew Vit

···

On 14-05-05, 10:33, Arup Rakshit wrote:

Hello,

Thanks for your reply.

I am actualy wanted to use this -
http://sequel.jeremyevans.net/rdoc/files/README_rdoc.html.