How to create a new database in ruby with sqlite3?

ruby-talk
1

Here is what I wrote on my Terminal. I tried different ways of writing
sqlite3 but each time I get an error message.

Would someone know how I should write this code?

1.9.3p362 :002 > require 'sqlite3'
=> true
1.9.3p362 :003 > $db=SQLite3::Datatbase.new("dbfile")
NameError: uninitialized constant SQLite3::Datatbase
  from
/Users/hakimbenbekhti/.rvm/gems/ruby-1.9.3-p362/gems/sqlite3-1.3.7/lib/sqlite3/version.rb:19:in
`const_missing'
  from (irb):3
  from /Users/hakimbenbekhti/.rvm/rubies/ruby-1.9.3-p362/bin/irb:16:in
`<main>'
1.9.3p362 :004 > $db = sqlite3::Database.new("dbfile")
NameError: undefined local variable or method `sqlite3' for main:Object
  from (irb):4
  from /Users/hakimbenbekhti/.rvm/rubies/ruby-1.9.3-p362/bin/irb:16:in
`<main>'
1.9.3p362 :005 > $db = Sqlite3::Database.new("dbfile")
NameError: uninitialized constant Sqlite3
  from (irb):5
  from /Users/hakimbenbekhti/.rvm/rubies/ruby-1.9.3-p362/bin/irb:16:in
`<main>'

···

--
Posted via http://www.ruby-forum.com/.

2

Quoting Hakim Benbekhti (lists@ruby-forum.com):

1.9.3p362 :003 > $db=SQLite3::Datatbase.new("dbfile")

What about writing 'Database' instead of 'Datatbase'?

Carlo

···

Subject: How to create a new database in ruby with sqlite3?
  Date: dom 24 feb 13 11:04:09 +0900

--
  * Se la Strada e la sua Virtu' non fossero state messe da parte,
* K * Carlo E. Prelz - fluido@fluido.as che bisogno ci sarebbe
  * di parlare tanto di amore e di rettitudine? (Chuang-Tzu)

3

Carlo E. Prelz wrote in post #1098778:

Subject: How to create a new database in ruby with sqlite3?
  Date: dom 24 feb 13 11:04:09 +0900

Quoting Hakim Benbekhti (lists@ruby-forum.com):

1.9.3p362 :003 > $db=SQLite3::Datatbase.new("dbfile")

What about writing 'Database' instead of 'Datatbase'?

Carlo

Yep, nothing more than that. How stupid...It will teach me to be more
patient and careful next time!
Thanks Carlo

···

--
Posted via http://www.ruby-forum.com/\.