*** 61,63 **** --- 61,70 ---- could quickly seek to any part of the BLOB without reading the leading data first. It would also be faster and require less memory for the host application. + + **Database Meta Data in Virtual Tables** + + Currently SQLite's meta data resides in the form of ad-hoc PRAGMA commands. + The problem with this approach is that you cannot use a PRAGMA as a + sub-select in a complex SQL query to find meta-data relationships without + the use of writing custom (non-SQL) code.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|