SQLite virtual tables
My overview of Google AI’s overview of the SQLite docs:
The SQLite CREATE VIRTUAL TABLE statement creates an interface to an external data source or a custom computation engine that acts and looks like a normal table, but does not store information inside the SQLite database.
Instead of reading raw bytes from the disk, when you query a virtual table, SQLite forwards the request to an underlying module (written in C or another language (?)). This module dynamically generates the rows or processes actions on the fly.
Tags: