Chapter 8. Additional Features and APIs

This chapter touches on a number of different areas, mostly having to do with features and interfaces that go beyond the basic database engine. The first section covers the SQLite time and date features, which are provided as a small set of scalar functions. We’ll also briefly look at some of the standard extensions that ship with SQLite, such as the ICU internationalization extension, the FTS3 text search module, and the R*Tree module. We’ll also be looking at some of the alternate interfaces available for SQLite in different scripting languages and other environments. Finally, we’ll wrap things up with a quick discussion on some of the things to watch out for when doing development on mobile or embedded systems.

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.