Chapter 10. General Database Administration
This chapter deals with SQLite administration topics. We will look at how the database parameters can be adjusted with the PRAGMA command and discuss ways to back up and restore your database. We will also examine some of the database internals that will help you to gain a better understanding of the SQLite engine.
The PRAGMA Command
The PRAGMA command provides an interface to modify the operation of the SQLite library and perform low-level operations to retrieve information about the connected database.
Fetching Database Information
This section describes the set of PRAGMA directives that allows you to find information about the currently attached databases.
PRAGMA database_list;
One row is returned for ...
Get 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.
