sqlite - Virtual Tables

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 11,20 ****
  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 anything to a virtual table that they
! can do to a real table (subject to the read-only or write-only
! constraint) except that one cannot DROP a virtual table and
! the virtual table does not appear in the SQLITE_MASTER table.
  
  A virtual table might represent an in-memory data
  structures.  Or it might represent a view of data on disk
--- 11,19 ----
  The virtual table mechanism allows an application to
  publish interfaces that are accessible from SQL statements
  as if they were tables.
! SQL statements can in general do anything to a virtual table that they
! can do to a real table, though particular virtual table implementations
! might restrict what actions are allowed on a case by case basis.
  
  A virtual table might represent an in-memory data
  structures.  Or it might represent a view of data on disk