Documentation Source Text

Check-in [43205871ea]
Login

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

Overview
Comment:Change references to www.hwaci.com to use HTTPS instead of HTTP
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 43205871ea1412920ac1d08c990e654b3e9ea1520f92b758d901d072d7bc692d
User & Date: drh 2017-06-05 11:04:50.417
Context
2017-06-06
15:03
Update the "35% faster than the filesystem" document to talk about write performance. (check-in: d6c152123c user: drh tags: trunk)
2017-06-05
11:04
Change references to www.hwaci.com to use HTTPS instead of HTTP (check-in: 43205871ea user: drh tags: trunk)
2017-06-02
11:27
Fix a typo in the session documentation. (check-in: acfc24126f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/consortium.in.
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132


<h2>How To Become A Consortium Member</h2>

<p>
Membership in the SQLite Consortium is via
<a href="consortium_agreement-20071201.html">contract</a> with
[http://www.hwaci.com/ | Hipp, Wyrick &amp; Company, Inc.].
Please call +1.704.948.4565 during US east-coast business hours
for additional information.
</p>



</body></html>







|







118
119
120
121
122
123
124
125
126
127
128
129
130
131
132


<h2>How To Become A Consortium Member</h2>

<p>
Membership in the SQLite Consortium is via
<a href="consortium_agreement-20071201.html">contract</a> with
[https://www.hwaci.com/ | Hipp, Wyrick &amp; Company, Inc.].
Please call +1.704.948.4565 during US east-coast business hours
for additional information.
</p>



</body></html>
Changes to pages/copyright.in.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
All of the code and documentation in SQLite has been dedicated to the
[http://en.wikipedia.org/wiki/Public_Domain|public domain]
by the authors.
All code authors, and representatives of the companies they work for,
have signed affidavits dedicating their contributions to
the public domain and originals of
those signed affidavits are stored in a firesafe at the main offices
of <a href="http://www.hwaci.com">Hwaci</a>.
Anyone is free to copy, modify, publish, use, compile, sell, or distribute
the original SQLite code, either in source code form or as a compiled binary,
for any purpose, commercial or non-commercial, and by any means.
</p>

<p>
The previous paragraph applies to the deliverable code and documentation







|







15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
All of the code and documentation in SQLite has been dedicated to the
[http://en.wikipedia.org/wiki/Public_Domain|public domain]
by the authors.
All code authors, and representatives of the companies they work for,
have signed affidavits dedicating their contributions to
the public domain and originals of
those signed affidavits are stored in a firesafe at the main offices
of <a href="https://www.hwaci.com">Hwaci</a>.
Anyone is free to copy, modify, publish, use, compile, sell, or distribute
the original SQLite code, either in source code form or as a compiled binary,
for any purpose, commercial or non-commercial, and by any means.
</p>

<p>
The previous paragraph applies to the deliverable code and documentation
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
internet.  Every line of code can be traced back to its original
author, and all of those authors have public domain dedications
on file.  So the SQLite code base is clean and is
uncontaminated with licensed code from other projects.
</p>

<div class="rightsidebar">
<form method="GET" action="http://www.hwaci.com/cgi-bin/license-step1">
<input type="submit" value="Buy An SQLite License">
</form>
</div>

<h2>Obtaining An License To Use SQLite</h2>

<p>







|







42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
internet.  Every line of code can be traced back to its original
author, and all of those authors have public domain dedications
on file.  So the SQLite code base is clean and is
uncontaminated with licensed code from other projects.
</p>

<div class="rightsidebar">
<form method="GET" action="https://www.hwaci.com/cgi-bin/license-step1">
<input type="submit" value="Buy An SQLite License">
</form>
</div>

<h2>Obtaining An License To Use SQLite</h2>

<p>
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
     SQLite. </li>
<li> Your legal department tells you that you have to purchase a license.
     </li>
</ul>

<p>
If you feel like you really need to purchase a license for SQLite,
<a href="http://www.hwaci.com/">Hwaci</a>, the company that employs 
all the developers of SQLite, will 
<a href="http://www.hwaci.com/cgi-bin/license-step1">sell you
one</a>.
All proceeds from the sale of SQLite licenses are used to fund
continuing improvement and support of SQLite.
</p>

<h2>Contributed Code</h2>








|

|







72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
     SQLite. </li>
<li> Your legal department tells you that you have to purchase a license.
     </li>
</ul>

<p>
If you feel like you really need to purchase a license for SQLite,
<a href="https://www.hwaci.com/">Hwaci</a>, the company that employs 
all the developers of SQLite, will 
<a href="https://www.hwaci.com/cgi-bin/license-step1">sell you
one</a>.
All proceeds from the sale of SQLite licenses are used to fund
continuing improvement and support of SQLite.
</p>

<h2>Contributed Code</h2>

Changes to pages/crew.in.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
</b> began the SQLite project on 2000-05-29
and continues to serve as the project architect.  Richard was born,
lives, and works in 
[http://en.wikipedia.org/wiki/Charlotte,_North_Carolina | Charlotte, North Carolina.]  He holds degrees from
[http://www.gatech.edu/ | Georgia Tech] (MSEE, 1984) and
[http://www.duke.edu/ | Duke University] (PhD, 1992) and is
the founder of the consulting firm
[http://www.hwaci.com/ | Hwaci].</p>

<br clear="both"></br>
<hr>

<img src="images/dan1.jpg" align="left" hspace="25" vspace="0">
<p>
<b>Dan Kennedy</b> is an Australian currently based in South-East Asia.







|







8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
</b> began the SQLite project on 2000-05-29
and continues to serve as the project architect.  Richard was born,
lives, and works in 
[http://en.wikipedia.org/wiki/Charlotte,_North_Carolina | Charlotte, North Carolina.]  He holds degrees from
[http://www.gatech.edu/ | Georgia Tech] (MSEE, 1984) and
[http://www.duke.edu/ | Duke University] (PhD, 1992) and is
the founder of the consulting firm
[https://www.hwaci.com/ | Hwaci].</p>

<br clear="both"></br>
<hr>

<img src="images/dan1.jpg" align="left" hspace="25" vspace="0">
<p>
<b>Dan Kennedy</b> is an Australian currently based in South-East Asia.
Changes to pages/prosupport.in.
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
} Free \
 {Archives http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/}\
 {Sign-up http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users}

support_entry 2 {Annual Maintenance Subscription} {
  Private, expert email advice from the developers of SQLite.
} {$1500/year} \
  {{More Info} http://www.hwaci.com/sw/sqlite/ams.html} \
  {{Buy Now!} http://www.hwaci.com/cgi-bin/sams-step1}

support_entry 3 {Technical Support} {
  High-priority email and phone support directly from the SQLite developers.
  Guaranteed response time available as an option.
} {$8K-$35K/year} \
  {{More Info} http://www.hwaci.com/sw/sqlite/tech.html} \
  {{Request A Quote} http://www.hwaci.com/sw/sqlite/contact.html}

support_entry 4 {SQLite Consortium Membership} {
  Premium enterprise support including on-site visits and
  access to all proprietary extensions and test suites.
} {$75K/year} \
  {{More Info} http://www.hwaci.com/sw/sqlite/member.html} \
  {{Request A Quote} http://www.hwaci.com/sw/sqlite/contact.html}

generate_support_html
</tcl>

<h2>Licenses
<font size=2>(<a href="#ext">details below</a>)</font></h2>

<tcl>
support_entry 5 {SQLite License} {
  Warranty of title and perpetual right-to-use for the SQLite source code. 
} {$6000 one time fee} \
  {{More Info} https://www.sqlite.org/copyright.html} \
  {{Buy Now!} http://www.hwaci.com/cgi-bin/license-step1}

support_entry 6 {SQLite Encryption Extension (SEE)} {
   A drop-in replacement for public-domain SQLite source code that has 
   the added ability to read/write AES-encrypted databases. 
} {$2000 one time fee} \
  {{More Info} http://www.hwaci.com/sw/sqlite/see.html} \
  {{Buy Now!} http://www.hwaci.com/cgi-bin/see-step1}

support_entry 7 {Compressed And Encrypted Read-Only Database (CEROD)} {
   A drop-in replacement for public-domain SQLite source code
   that has the added ability to read database that has been both 
   compressed and encrypted. 
} {$2000 one time fee} \
  {{More Info} http://www.hwaci.com/sw/sqlite/cerod.html} \
  {{Buy Now!} http://www.hwaci.com/cgi-bin/scerod-step1}

support_entry 8 {The ZIPVFS Read/Write Compressed Database Extension} {
   The ZIPVFS extension automatically compresses and encrypts
   your data as it is written to disk, and decompressed and decrypts
   it while reading.
} {$4000 one time fee} \
  {{More Info} http://www.hwaci.com/sw/sqlite/zipvfs.html} \
  {{Buy Now!} http://www.hwaci.com/cgi-bin/zipvfs-step1}

generate_support_html
</tcl>

<h2>Special Services
<font size=2>(<a href="#th3">details below</a>)</font></h2>

<tcl>
support_entry 9 {TH3 Testing Support} {
  The <a href="https://sqlite.org/th3.html">TH3 test harness</a>
  is an aviation-grade test suite for SQLite. SQLite developers 
  can run TH3 on specialized hardware and/or using specialized
  compile-time options, according to customer specification, 
  either remotely or on customer premises. Pricing for this 
  services is on a case-by-case basis depending on requirements.
} {call} \
  {{More Info} https://www.sqlite.org/th3.html} \
  {{Request A Quote} http://www.hwaci.com/sw/sqlite/contact.html}

generate_support_html
</tcl>

<a name="detail"></a>
<h2>Further Information</h2>








|
|





|
|





|
|












|





|
|






|
|






|
|

















|







57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
} Free \
 {Archives http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/}\
 {Sign-up http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users}

support_entry 2 {Annual Maintenance Subscription} {
  Private, expert email advice from the developers of SQLite.
} {$1500/year} \
  {{More Info} https://www.hwaci.com/sw/sqlite/ams.html} \
  {{Buy Now!} https://www.hwaci.com/cgi-bin/sams-step1}

support_entry 3 {Technical Support} {
  High-priority email and phone support directly from the SQLite developers.
  Guaranteed response time available as an option.
} {$8K-$35K/year} \
  {{More Info} https://www.hwaci.com/sw/sqlite/tech.html} \
  {{Request A Quote} https://www.hwaci.com/sw/sqlite/contact.html}

support_entry 4 {SQLite Consortium Membership} {
  Premium enterprise support including on-site visits and
  access to all proprietary extensions and test suites.
} {$75K/year} \
  {{More Info} https://www.hwaci.com/sw/sqlite/member.html} \
  {{Request A Quote} https://www.hwaci.com/sw/sqlite/contact.html}

generate_support_html
</tcl>

<h2>Licenses
<font size=2>(<a href="#ext">details below</a>)</font></h2>

<tcl>
support_entry 5 {SQLite License} {
  Warranty of title and perpetual right-to-use for the SQLite source code. 
} {$6000 one time fee} \
  {{More Info} https://www.sqlite.org/copyright.html} \
  {{Buy Now!} https://www.hwaci.com/cgi-bin/license-step1}

support_entry 6 {SQLite Encryption Extension (SEE)} {
   A drop-in replacement for public-domain SQLite source code that has 
   the added ability to read/write AES-encrypted databases. 
} {$2000 one time fee} \
  {{More Info} https://www.hwaci.com/sw/sqlite/see.html} \
  {{Buy Now!} https://www.hwaci.com/cgi-bin/see-step1}

support_entry 7 {Compressed And Encrypted Read-Only Database (CEROD)} {
   A drop-in replacement for public-domain SQLite source code
   that has the added ability to read database that has been both 
   compressed and encrypted. 
} {$2000 one time fee} \
  {{More Info} https://www.hwaci.com/sw/sqlite/cerod.html} \
  {{Buy Now!} https://www.hwaci.com/cgi-bin/scerod-step1}

support_entry 8 {The ZIPVFS Read/Write Compressed Database Extension} {
   The ZIPVFS extension automatically compresses and encrypts
   your data as it is written to disk, and decompressed and decrypts
   it while reading.
} {$4000 one time fee} \
  {{More Info} https://www.hwaci.com/sw/sqlite/zipvfs.html} \
  {{Buy Now!} https://www.hwaci.com/cgi-bin/zipvfs-step1}

generate_support_html
</tcl>

<h2>Special Services
<font size=2>(<a href="#th3">details below</a>)</font></h2>

<tcl>
support_entry 9 {TH3 Testing Support} {
  The <a href="https://sqlite.org/th3.html">TH3 test harness</a>
  is an aviation-grade test suite for SQLite. SQLite developers 
  can run TH3 on specialized hardware and/or using specialized
  compile-time options, according to customer specification, 
  either remotely or on customer premises. Pricing for this 
  services is on a case-by-case basis depending on requirements.
} {call} \
  {{More Info} https://www.sqlite.org/th3.html} \
  {{Request A Quote} https://www.hwaci.com/sw/sqlite/contact.html}

generate_support_html
</tcl>

<a name="detail"></a>
<h2>Further Information</h2>

160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
sign-up</a>, but you can simply send an email message to
<a href="mailto:sqlite-users@mailinglists.sqlite.org">sqlite-users@mailinglists.sqlite.org</a> and
your question will probably appear on the mailing list in about 24 hours.
(Questions from non-members are moderated, which is the reason for the
24-hour delay.)

<p>If you do not want to discuss your issues on a public and open forum, an
<a href="http://www.hwaci.com/sw/sqlite/ams.html">Annual Maintenance 
Subscription</a> or "AMS" might
serve your needs better.
An AMS entitles you to private email support directly from the developers of
SQLite.  The level of support with an AMS is similar to the support one
gets from the public mail list except that an AMS includes a unilateral 
promise of non-disclosure, so with an AMS you can discuss your issues
with the SQLite developers in private, without the whole world watching.
An AMS costs $1500 per year.</p>

<p>Users with more advanced support needs can opt for a
<a href="http://www.hwaci.com/sw/sqlite/tech.html">Technical Support
Agreement</a>.
Technical support agreements are customized to the needs of each
individual client, but generally include direct telephone support
and priority handling of issues and bugs.  Guaranteed response time
is available as an option.  The cost of
technical support varies but is generally
in the range of $8000 to $35000 per year.</p>

<p>If SQLite is "mission critical" to your company, then you may
want to becoming an 
<a href="http://www.hwaci.com/sw/sqlite/member.html">SQLite Consortium 
Member</a>.  The SQLite
Consortium is a collaboration of companies who sponsor ongoing development
of SQLite in exchange for enterprise-level technical support, on-site
visits from the SQLite developers, unlimited access to all licensed
products, and strong guarantees that SQLite will remain in the public
domain, free and independent, and will not come under the control of
a competitor.  The cost of consortium membership is $75000 per year.</p>

<a name="ext"></a>
<h2>Software Licenses</h2>

<p>The SQLite source code is in the 
<a href="https://www.sqlite.org/copyright.html">public domain</a>,
and is free for use
by anyone and for any purpose.  No license is required.  However, some
users desire a license so that they can have warranty of title, or just
because their company lawyers say they need one.  A
<a href="http://www.hwaci.com/cgi-bin/license-step1">perpetual license</a> 
and warranty
of title for the core SQLite source code is available for this purpose.</p>

<p>The 
<a href="http://www.hwaci.com/cgi-bin/see-step1">SQLite Encryption
Extension (SEE)</a>,
the <a href="http://www.hwaci.com/cgi-bin/zipvfs-step1">ZIPVFS Extension</a>,
and the <a href="http://www.hwaci.com/cgi-bin/scerod-step1">Compressed and
Encrypted ReadOnly Database (CEROD)</a> extension are enhanced versions 
of SQLite that handle encrypted
and/or compressed databases.  SEE can read and write encrypted databases.
SEE encrypts all database content, including metadata, so that the database
file appears as white noise.  ZIPVFS 
compresses the database on-the-fly using application-supplied 
compression and decompression functions.







|










|










|

















|




|

|
|







160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
sign-up</a>, but you can simply send an email message to
<a href="mailto:sqlite-users@mailinglists.sqlite.org">sqlite-users@mailinglists.sqlite.org</a> and
your question will probably appear on the mailing list in about 24 hours.
(Questions from non-members are moderated, which is the reason for the
24-hour delay.)

<p>If you do not want to discuss your issues on a public and open forum, an
<a href="https://www.hwaci.com/sw/sqlite/ams.html">Annual Maintenance 
Subscription</a> or "AMS" might
serve your needs better.
An AMS entitles you to private email support directly from the developers of
SQLite.  The level of support with an AMS is similar to the support one
gets from the public mail list except that an AMS includes a unilateral 
promise of non-disclosure, so with an AMS you can discuss your issues
with the SQLite developers in private, without the whole world watching.
An AMS costs $1500 per year.</p>

<p>Users with more advanced support needs can opt for a
<a href="https://www.hwaci.com/sw/sqlite/tech.html">Technical Support
Agreement</a>.
Technical support agreements are customized to the needs of each
individual client, but generally include direct telephone support
and priority handling of issues and bugs.  Guaranteed response time
is available as an option.  The cost of
technical support varies but is generally
in the range of $8000 to $35000 per year.</p>

<p>If SQLite is "mission critical" to your company, then you may
want to becoming an 
<a href="https://www.hwaci.com/sw/sqlite/member.html">SQLite Consortium 
Member</a>.  The SQLite
Consortium is a collaboration of companies who sponsor ongoing development
of SQLite in exchange for enterprise-level technical support, on-site
visits from the SQLite developers, unlimited access to all licensed
products, and strong guarantees that SQLite will remain in the public
domain, free and independent, and will not come under the control of
a competitor.  The cost of consortium membership is $75000 per year.</p>

<a name="ext"></a>
<h2>Software Licenses</h2>

<p>The SQLite source code is in the 
<a href="https://www.sqlite.org/copyright.html">public domain</a>,
and is free for use
by anyone and for any purpose.  No license is required.  However, some
users desire a license so that they can have warranty of title, or just
because their company lawyers say they need one.  A
<a href="https://www.hwaci.com/cgi-bin/license-step1">perpetual license</a> 
and warranty
of title for the core SQLite source code is available for this purpose.</p>

<p>The 
<a href="https://www.hwaci.com/cgi-bin/see-step1">SQLite Encryption
Extension (SEE)</a>,
the <a href="https://www.hwaci.com/cgi-bin/zipvfs-step1">ZIPVFS Extension</a>,
and the <a href="https://www.hwaci.com/cgi-bin/scerod-step1">Compressed and
Encrypted ReadOnly Database (CEROD)</a> extension are enhanced versions 
of SQLite that handle encrypted
and/or compressed databases.  SEE can read and write encrypted databases.
SEE encrypts all database content, including metadata, so that the database
file appears as white noise.  ZIPVFS 
compresses the database on-the-fly using application-supplied 
compression and decompression functions.
Changes to pages/support.in.
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77

<p>The core SQLite library found on this website is in the
<a href="copyright.html">public domain</a>.  But there also exist
proprietary, licensed extensions to SQLite.</p>

<ul>
<li><p>
The [http://www.hwaci.com/sw/sqlite/see.html | SQLite Encryption Extension (SEE)]
will read and write database file encrypted using
128-bit or 256-bit AES.</p></li>

<li><p>
The [http://www.hwaci.com/sw/sqlite/cerod.html | SQLite Compressed and Encrypted Read-Only Database (CEROD)]
extension will read a database file that is both compressed
and encrypted.</p></li>

<li><p>
The [http://www.hwaci.com/sw/sqlite/zipvfs.html | ZIPVFS]
extension will both read and write database files that is both compressed and optionally
encrypted using application-supplied compression and encryption routines.</p></li>

<li><p>
The [TH3 | Test Harness #3 (TH3)] is an alternative set of test
vectors for SQLite that verify the operation of SQLite in an
as-deployed configuration on embedded platforms with







|




|




|







53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77

<p>The core SQLite library found on this website is in the
<a href="copyright.html">public domain</a>.  But there also exist
proprietary, licensed extensions to SQLite.</p>

<ul>
<li><p>
The [https://www.hwaci.com/sw/sqlite/see.html | SQLite Encryption Extension (SEE)]
will read and write database file encrypted using
128-bit or 256-bit AES.</p></li>

<li><p>
The [https://www.hwaci.com/sw/sqlite/cerod.html | SQLite Compressed and Encrypted Read-Only Database (CEROD)]
extension will read a database file that is both compressed
and encrypted.</p></li>

<li><p>
The [https://www.hwaci.com/sw/sqlite/zipvfs.html | ZIPVFS]
extension will both read and write database files that is both compressed and optionally
encrypted using application-supplied compression and encryption routines.</p></li>

<li><p>
The [TH3 | Test Harness #3 (TH3)] is an alternative set of test
vectors for SQLite that verify the operation of SQLite in an
as-deployed configuration on embedded platforms with