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
>
