Virtual Tables

Jun 21, 2022

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queries and updates on a virtual table invoke callback methods of the virtual table object instead of reading and writing on the database file.

The virtual table mechanism allows an application to publish interfaces that are accessible from SQL statements as if they were tables. SQL statements can do almost anything to a virtual table that they can do to a real table, with the following exceptions:

List of the virtual tables that come with SQLite:

includes JSON, CSV, rtree, and lots of metadata about the sqlite database itself.

Protobuf virtual table:

Histogram virtual tables:

↑ up