@Satoshi,
This is one (your 2nd link)is a site i had come across in my
searching but i didn't realise sql3 came with ruby.
suppose i've been blinkered but thought someone might've
done some dbi sqlite3 samples somewhere where i've not
encountered todate.
will have to dive in and stop being hesitant in trying
things out.
cheers,
dave.
----- Original Message Follows -----
> Hi Dave et all,
>
> _why already answered:
> > Shoes comes with sqlite3/ruby.
>
> Yes, it's really cool! Try the following snippet. :)
>
> require 'sqlite3'
> Shoes.app do
> db = SQLite3::Database.new( "test.db" )
> db.execute( "create table t1 (t1key INTEGER PRIMARY KEY
> ,data TEXT,num double,timeEnter DATE)" )
> db.execute( "insert into t1 (data,num) values ('This is
> sample data',3)" )
> db.execute( "insert into t1 (data,num) values ('More
> sample data',6)" )
> db.execute( "insert into t1 (data,num) values ('And a
> little more',9)" )
> rows = db.execute( "select * from t1" )
> rows.each{|k, d, n| para "#{k} : #{d} : #{n}\n"}
> end
>
> References:
> http://sqlite-ruby.rubyforge.org/sqlite3/faq.html
>
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
>
> Hope it helps,
> Satoshi
>
> On Sun, Jun 7, 2009 at 11:21 PM, _why
> <[email protected]> wrote:
>
> > On Sun, Jun 07, 2009 at 10:51:32PM +1200, dave wrote:
> > > also any pointer on bindings (if no one can point me
> to a website)? >
> > Shoes comes with sqlite3/ruby. It is used for the image
> > cache and some small settings.
> > <http://sqlite-ruby.rubyforge.org/sqlite3/>
> >
> > _why
> >
>
