Accessing SQLite in C

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 the supporting libraries, SQLite creates completely self-contained databases that aren’t dependant upon a client-server architecture. This feature makes SQLite ideal for use in applications that don’t require the complexity of a server, yet can benefit from the flexibility of the SQL language.

As in the previous article, we need a database to work with, and we’ll use the same database as we used last time…

Read More