PRAGMA

PRAGMA is SQLite’s special command system for asking or changing database settings/metadata.

Examples:

PRAGMA page_count;
PRAGMA page_size;

These return:

page_count = number of pages in the SQLite database file

page_size = bytes per page

So this:

SELECT page_count * page_size
FROM pragma_page_count(), pragma_page_size();

calculates the approximate SQLite database file size in bytes.

SQLite exposes many PRAGMAs as table-like functions too, hence:

pragma_page_count()
pragma_page_size()

instead of:

PRAGMA page_count;
PRAGMA page_size;

In your command, PRAGMA is only used for the final “all DB” size row. The gabo.es-specific rows come from normal tables like resources, structural_blobs, blob_links, and blobs.

Do you like what you are reading? Subscribe to receive updates.

Unsubscribe anytime