In my last article I wrote about accessing a PostgreSQL database in C/C++. In this article, I'm going to discuss performing the same functions in C against an SQLite database. Unlike Postgresql and ...

SQLite will assume an explicitly named integer primary key is just an alias for the rowid if the type is spelled out as "INTEGER" rather than "INT." I can simply change my create table statement as ...