Using SQLite

ruby-talk
1

Any pointers to articles on sample Ruby code using SQLite3 -- the usual
database DML and DDL stuff: creating and managing dbs and tables, and
inserting, updating, deleting records. Thanks.
gk

2

http://sqlite-ruby.rubyforge.org/sqlite3/faq.html is a very brief, example-oriented run-down of the features in sqlite3-ruby.

- Jamis

···

On Oct 23, 2005, at 11:47 AM, basi wrote:

Any pointers to articles on sample Ruby code using SQLite3 -- the usual
database DML and DDL stuff: creating and managing dbs and tables, and
inserting, updating, deleting records. Thanks.

3

Thank you. (How did I miss this page?)
gk.

4

Hello,

In the following, as soon as I hit Return (on the 003 line), the fxri
screen disappears. "Products" is a table in the database. Did I enter
the command properly? When I enter the select command in SQLiteSpy, it
works. Thanks.
gk

irb(main):001:0> require 'sqlite3'
=> false
irb(main):002:0> db =
SQLite3::Database.new("c:\work\depot\db\depot_development.db3")
=> #<SQLite3::Database:0x4037078
@driver=#<SQLite3::Driver::Native::Driver:0x4025f78 @callback_data={}>,
@statement_factory=SQLite3::Statement, @type_translation=false,
@handle=#<SWIG::TYPE_p_sqlite3:0x4025ed0>, @results_as_hash=false,
@closed=false, @translator=nil>
irb(main):003:0> count = db.get_first_value( "select count(*) from
products")

5

Thank you. (How did I miss this page?)

I missed it too.

···

On Oct 23, 2005, at 2:02 PM, basi wrote:

gk.

----
Bob Hutchison -- blogs at <http://www.recursive.ca/hutch/&gt;
Recursive Design Inc. -- <http://www.recursive.ca/&gt;
Raconteur -- <http://www.raconteur.info/&gt;

6

Thank you. (How did I miss this page?)

I missed it too.

... because it is in the usage section of the ruby doc and I wasn't ready, I thought, to look at those... What else is there in there? Tutorial? Examples? (not that the FAQ isn't a huge help and much appreciated, but, you know, I guess I'm greedy :slight_smile:

···

On Oct 23, 2005, at 2:21 PM, Bob Hutchison wrote:

On Oct 23, 2005, at 2:02 PM, basi wrote:

gk.

----
Bob Hutchison -- blogs at <http://www.recursive.ca/hutch/&gt;
Recursive Design Inc. -- <http://www.recursive.ca/&gt;
Raconteur -- <http://www.raconteur.info/&gt;

----
Bob Hutchison -- blogs at <http://www.recursive.ca/hutch/&gt;
Recursive Design Inc. -- <http://www.recursive.ca/&gt;
Raconteur -- <http://www.raconteur.info/&gt;