Summary
With the information in this chapter, you should be able to write code that opens a database file and executes SQL commands against it. With that ability, and the right SQL commands, you should be able to create new databases, specify tables, insert data, and build complex queries. For a large number of applications, this is enough to service most of their database needs.
The next chapters look at more advanced features of the
SQLite C API. This includes the ability to define your own SQL functions.
That will enable you to extend the SQL used by SQLite with simple functions,
as well as aggregators (used with GROUP
BY) and sorting collations. Additional chapters will look at
how to implement virtual tables and other advanced features.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
