Documentation Source Text

Check-in [ef0b96b340]
Login

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

Overview
Comment:New advantage of SQLite Archives: Bypass firewall censorship.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | branch-3.23
Files: files | file ages | folders
SHA3-256: ef0b96b3405c311980501402dd0fd826c412a80acb8fbbcf6c173866913b419f
User & Date: drh 2018-05-17 10:02:33.398
Context
2018-05-18
18:02
Merge fixes from the 3.23 branch. (check-in: 45753832a8 user: drh tags: trunk)
2018-05-17
10:02
New advantage of SQLite Archives: Bypass firewall censorship. (Leaf check-in: ef0b96b340 user: drh tags: branch-3.23)
2018-04-30
22:39
More detail on synchronous=NORMAL. (check-in: 13c3dff046 user: drh tags: branch-3.23)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/sqlar.in.
︙︙
117
118
119
120
121
122
123










124
125
126
127
128
129
130

Applications that already use SQLite for other purposes can easily
add support for SQLite Archives using a small extension
([https://sqlite.org/src/file/ext/misc/sqlar.c]) to handle the compression
and decompression of content.  Even this tiny extension can be omitted
if the files in the archive are uncompressed.  In contrast, supporting
ZIP Archives and/or Tarballs requires either separate libraries or
lots of extra custom code, or sometimes both.










</ol>

<h1>Disadvantages Of SQLite Archives</h1>

<ol>
<li><p>
The SQLite Archive is a relatively new format.  It was first described in








>
>
>
>
>
>
>
>
>
>








117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140

Applications that already use SQLite for other purposes can easily
add support for SQLite Archives using a small extension
([https://sqlite.org/src/file/ext/misc/sqlar.c]) to handle the compression
and decompression of content.  Even this tiny extension can be omitted
if the files in the archive are uncompressed.  In contrast, supporting
ZIP Archives and/or Tarballs requires either separate libraries or
lots of extra custom code, or sometimes both.

<li><p>
An SQLite Archive can work around firewall-imposed censorship.
For example, certain file types that are considered "dangerous" 
(examples: DLLs) will be
[https://support.google.com/mail/answer/6590|blocked by Gmail]
and probably many other email services and firewall, even if those
files are wrapped inside a ZIP Archive or Tarball.
But these firewall usually do not care about SQLite Archives and
so content can be put inside an SQLite Archive to evade censorship.
</ol>

<h1>Disadvantages Of SQLite Archives</h1>

<ol>
<li><p>
The SQLite Archive is a relatively new format.  It was first described in
︙︙