what didn't show up was that i also did a 'select * from poi;' and got no returned record set. i was trying to explicitly specify the database and table in dotted, object-oriented fashion. that, too, didn't work.

sqlite> .schema
CREATE TABLE category (cat_id integer PRIMARY KEY,label text, desc text, enabled integer);
CREATE TABLE poi (poi_id integer PRIMARY KEY, lat real, lon real, label text, desc text, cat_id integer);
sqlite>