mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Virtual tables

The SQlite3 engine has ability to create Virtual Tables from code. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queries from and updates to a virtual table invoke callback methods on the virtual table object instead of reading and writing to the database file.

A dedicated mechanism has been added to the framework, beginning with revision 1.13, in order to easily add such virtual tables with pure Delphi code, just by inheriting some classes.

Feedback from blog article http://blog.synopse.info/post/2011/05/1 … -framework

Don't forget to consult the framework documentation.
It has been enhanced a lot those past weeks. A chapter is dedicated to Virtual Tables (see the SAD document, pages 59 to 71).