The files shown here are the working files that I used to create the shopping list program used in the SQLite3 article at Linux Journal. While they should work for you too, they may take a little adjustment for your platform. Especially if you are working on Windows, you may need to adjust include and library paths in the Makefile.

Please be warned that this code worked for me, but there's no guarantee that it will work for you. In particular, you're accepting this code "as is" and realize that it may fail to compile entirely, work in ways other than what you or the author intended, or make your dog bite you and your spouse leave you. You're getting what you paid for.

The SQL for this example:

CREATE TABLE item (
  id integer primary key not null,
  user_id integer not null,
  externalkey varchar(40),
  description text
);

CREATE TABLE user (
  id integer primary key not null,
  name varchar(40) not null,
  password char(32) not null,
  email varchar(60) not null
);

CREATE INDEX item_user ON item (user_id);