> I have heard that there was a recent release that enabled rails to work with
> sqlite. Don't know if all the updated are in gems yet.

I believe that it supports the Ruby/SQLite 1.3.x bindings, not the
newer 2.1.x bindings.

Another question, is this even valid SQL-92?

UPDATE
    group = 'test'
WHERE
    id = 1

At a minimum, it seems that the update should be

UPDATE
    posts
SET
    group = 'test'
WHERE
    id = 1

Is the former some kind of weird shorthand?

-- 
Justin Rudd
http://seagecko.org/thoughts/