Simple SQLite example

main.c

#include <sqlite3.h>
#include <stdio.h>

int main(int argc, char *argv[])
{
  sqlite3 *db;
  sqlite3_stmt *sql;
  int rv;

  rv=sqlite3_open("parts.db",&db);
  if (rv!=SQLITE_OK)
    {
      fprintf(stderr,"Can't open database: %s!",sqlite3_errmsg(db));
      sqlite3_close(db);
      return 1;
    }
  rv=sqlite3_prepare_v2(db, "SELECT * from full", -1, &sql, NULL);
  if (rv!=SQLITE_OK)
    {
      fprintf(stderr,"Prepare failed: %s\n",sqlite3_errmsg(db));
      sqlite3_close(db);
      return 2;
    }
  do
    {
      rv=sqlite3_step(sql);
      if (rv==SQLITE_ROW)
	{
	  printf("%s,",sqlite3_column_text(sql,0));
	  printf("%s\n",sqlite3_column_text(sql,2));
	}
    }
  while (rv==SQLITE_ROW); 
  sqlite3_finalize(sql);
  sqlite3_close(db);
  return 0;
}