SQLite

Check-in [84e9351bbd]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update zonefile README.md file to mention the frame cache.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | zonefile
Files: files | file ages | folders
SHA3-256: 84e9351bbd0a9bf9e1d64a441366a90276c231b44548cbc947f7fb2842f82490
User & Date: dan 2018-02-27 20:09:45.338
Context
2018-02-27
20:09
Update zonefile README.md file to mention the frame cache. (Leaf check-in: 84e9351bbd user: dan tags: zonefile)
19:50
Rationalize some code in zonefile.c. Fix other minor issues in the same. (check-in: f11beb16a8 user: dan tags: zonefile)
Changes
Unified Diff Ignore Whitespace Patch
Changes to ext/zonefile/README.md.
82
83
84
85
86
87
88
89
90
91

92





93
94
95
96
97
98
99
100
101
>         "encryptionType":"xor",
>         "encryptionKey":"e6e600bc063aad12f6387beab650c48a"
>       }'
>     );

### Using (Reading) Zonefile Files

To create a new zonefile table:

>     CREATE VIRTUAL TABLE z1 USING zonefile;







This creates two virtual tables in the database schema. One read-only table
named "z1", with a schema equivalent to:

>     CREATE TABLE z1(  -- this whole table is read-only
>       k INTEGER PRIMARY KEY,     -- key value
>       v BLOB,                    -- associated blob of data
>       fileid INTEGER,            -- file id (rowid value for z1_files)
>       sz INTEGER                 -- size of blob of data in bytes
>     );







|


>

>
>
>
>
>
|
|







82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
>         "encryptionType":"xor",
>         "encryptionKey":"e6e600bc063aad12f6387beab650c48a"
>       }'
>     );

### Using (Reading) Zonefile Files

To create a new zonefile table, one of the following:

>     CREATE VIRTUAL TABLE z1 USING zonefile;
>     CREATE VIRTUAL TABLE z1 USING zonefile(cachesize=N);

where <i>N</i> is any non-zero positive integer. If the zonefile is used
to access any files containing compressed or encrypted data, it maintains
an LRU cache of uncompressed frame data <i>N</i> frames in size. The
default value of <i>N</i> is 1.

Creating a "zonefile" virtual table actually creates two virtual tables in the
database schema. One read-only table named "z1", with a schema equivalent to:

>     CREATE TABLE z1(  -- this whole table is read-only
>       k INTEGER PRIMARY KEY,     -- key value
>       v BLOB,                    -- associated blob of data
>       fileid INTEGER,            -- file id (rowid value for z1_files)
>       sz INTEGER                 -- size of blob of data in bytes
>     );