Documentation Source Text

Check-in [45753832a8]
Login

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

Overview
Comment:Merge fixes from the 3.23 branch.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 45753832a87ede4c0ca0e40a0b28256efa4acc2fd18331f3986f53b9c303ae87
User & Date: drh 2018-05-18 18:02:52
Context
2018-05-19
14:21
Updates to the TH3 documentation. check-in: ac3ef1f6aa user: drh tags: trunk
2018-05-18
18:02
Merge fixes from the 3.23 branch. check-in: 45753832a8 user: drh tags: trunk
18:02
Update docs for the r-tree auxiliary columns. check-in: daa211f9cd 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
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/sqlar.in.

   117    117   Applications that already use SQLite for other purposes can easily
   118    118   add support for SQLite Archives using a small extension
   119    119   ([https://sqlite.org/src/file/ext/misc/sqlar.c]) to handle the compression
   120    120   and decompression of content.  Even this tiny extension can be omitted
   121    121   if the files in the archive are uncompressed.  In contrast, supporting
   122    122   ZIP Archives and/or Tarballs requires either separate libraries or
   123    123   lots of extra custom code, or sometimes both.
          124  +
          125  +<li><p>
          126  +An SQLite Archive can work around firewall-imposed censorship.
          127  +For example, certain file types that are considered "dangerous" 
          128  +(examples: DLLs) will be
          129  +[https://support.google.com/mail/answer/6590|blocked by Gmail]
          130  +and probably many other email services and firewall, even if those
          131  +files are wrapped inside a ZIP Archive or Tarball.
          132  +But these firewall usually do not care about SQLite Archives and
          133  +so content can be put inside an SQLite Archive to evade censorship.
   124    134   </ol>
   125    135   
   126    136   <h1>Disadvantages Of SQLite Archives</h1>
   127    137   
   128    138   <ol>
   129    139   <li><p>
   130    140   The SQLite Archive is a relatively new format.  It was first described in