From: unbewusst.sein@... (=?ISO-8859-1?Q?Une_B=E9v?= =?ISO-8859-1?Q?ue?=)
Date: 2008-07-05T19:21:44+09:00
Subject: Re: [ANN] amalgalite 0.2.0 Released

Jeremy Hinegardner <jeremy@hinegardner.org> wrote:

> Amalgalite embeds the SQLite database engine in a ruby extension.
> There is no need to install SQLite separately.
> Look in the examples/ directory for examples
> on:
> 
> * general usage
> * blob io
> * schema information

i've tested your online example "gem-db.rb", looks good at insertion,
however get :
>>> gem-db.rb

Opening database (version 0.2.0)
Establishing taps
Create schema
Inserting 99 rows of gem information...
Took 0.246415 seconds
Done Inserting
NoMethodError: undefined method 'columns' for nil:NilClass
method is_column_rowid?
in statement.rb at line 349
method result_meta
in statement.rb at line 333
method times
in statement.rb at line 320
method result_meta
in statement.rb at line 320
method next_row
in statement.rb at line 250
method all_rows
in statement.rb at line 298
method execute
in database.rb at line 252
at top level
in gem-db.rb at line 72


line 72 being :
authors_by_number = db.execute("SELECT author, count( name ) as num_gems
FROM gems GROUP BY author ORDER BY num_gems DESC")


notice i'm now able to read the Firefox 3 bookmarks file
("places.sqlite") having "LONGVARCHAR" (wasn't OK with version 0.1).
-- 
Une B�vue