The Definitive Guide to SQLite

CHAPTER 6The Core C API

This chapter covers the part of the SQLite API used to work with databases. You already have a good idea of how the API works from Chapter 5. Now let's concentrate on the specifics.

Starting with a few trivial examples, we will take an in-depth tour through the C API and expand upon the examples, filling in various details with a variety of useful functions. As we go along, you should see the C equivalents of the model all fall into place, with some additional features you may not have seen before—features that primarily exist only in the C API. By the time we reach the end of this chapter, you should have seen every API function related to running commands, managing transactions, fetching records, handling errors, and ...