Documentation Source Text

Check-in [d433035324]
Login

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

Overview
Comment:Many small updates and tweaks to the site in an effort to keep all information current.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d433035324cd24956ef5ffa93a466b5389dd1d46
User & Date: drh 2012-04-20 12:52:38.502
Context
2012-05-11
17:01
Update the change history and news. And make some minor fixes to requirements text. (check-in: 9778992724 user: drh tags: trunk)
2012-04-20
12:52
Many small updates and tweaks to the site in an effort to keep all information current. (check-in: d433035324 user: drh tags: trunk)
12:16
Update the makefile so that it no longer tries to import the GIFs from the source repository. (check-in: 4da3e1833a user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/consortium.in.
101
102
103
104
105
106
107
108


109
110
111
112
113
114
115
Support requests, comments, and suggestions for future
changes to SQLite coming from consortium members take priority 
over requests from all other sources.
Consortium members go to the front of the line.
</p></li>

<li><p>
We will be happy to recognize consortium members on the SQLite website


with a logo and/or a brief acknowledgement of their contribution to the
project.  This is an opportunity for companies to build good will by
demonstrating that they are giving back to the community.  Or, members 
can remain anonymous.
</p></li>

</ul>







|
>
>







101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
Support requests, comments, and suggestions for future
changes to SQLite coming from consortium members take priority 
over requests from all other sources.
Consortium members go to the front of the line.
</p></li>

<li><p>
We will be happy to 
<a href="index.html#consortium_members">recognize consortium members</a>
 on the SQLite website
with a logo and/or a brief acknowledgement of their contribution to the
project.  This is an opportunity for companies to build good will by
demonstrating that they are giving back to the community.  Or, members 
can remain anonymous.
</p></li>

</ul>
Changes to pages/famous.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<title>Well-Known Users Of SQLite</title>

<h2>Well-Known Users of SQLite:</h2>

<p>
A few of the better-known users of SQLite are shown below
in alphabetical order.
There is no complete list of projects and companies
that use SQLite.
SQLite is in the 
<a href="copyright.html">public domain</a> and so many people use it
in their projects without ever telling us.
</p>

<table border="0" cellpadding="15">

<tr><td valign="top">
<a href="http://www.adobe.com/">










|







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<title>Well-Known Users Of SQLite</title>

<h2>Well-Known Users of SQLite:</h2>

<p>
A few of the better-known users of SQLite are shown below
in alphabetical order.
There is no complete list of projects and companies
that use SQLite.
SQLite is in the 
<a href="copyright.html">public domain</a> and so many groups use SQLite
in their projects without ever telling us.
</p>

<table border="0" cellpadding="15">

<tr><td valign="top">
<a href="http://www.adobe.com/">
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
</td><td>
There are 
[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27326.html | multiple]
[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27332.html|sightings]
of SQLite in the Skype client for Mac OS X and Windows.
</td></tr>

<tr><td valign="top">
<a href="http://www.sun.com/">
<img src="images/foreignlogos/sunmicro.gif" border="0"></a>
</td><td>
[http://www.sun.com/software/solaris/ | Solaris 10]
uses SQLite as the storage format for its Service Management Facility.
Thus, Sun has essentially replaced the traditional unix /etc/inittab
file with an SQLite database.
</td></tr>

<tr><td valign="top">
<a href="http://www.symbian.com/">
<img src="images/foreignlogos/symbian.gif" border="0"></a>
</td><td>
SQLite is an integral part of 
[http://www.symbian.com/ | Symbian's] operating system commonly 
found on high-end cellphones.
</td></tr>

<tr><td valign="top">
<a href="http://www.toshiba.com/">
<img src="images/foreignlogos/toshiba.gif" border="0"></a>
</td><td>
A representative of 
[http://www.toshiba.com/ | Toshiba] wrote to the SQLite developers 
and requested the US Export Control Number for SQLite. We infer from this 
that Toshiba is exporting something from the US that uses SQLite, but we 
do not know what that something is.
</td></tr>
</table>







<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<











185
186
187
188
189
190
191



















192
193
194
195
196
197
198
199
200
201
202
</td><td>
There are 
[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27326.html | multiple]
[http://www.mail-archive.com/sqlite-users%40sqlite.org/msg27332.html|sightings]
of SQLite in the Skype client for Mac OS X and Windows.
</td></tr>




















<tr><td valign="top">
<a href="http://www.toshiba.com/">
<img src="images/foreignlogos/toshiba.gif" border="0"></a>
</td><td>
A representative of 
[http://www.toshiba.com/ | Toshiba] wrote to the SQLite developers 
and requested the US Export Control Number for SQLite. We infer from this 
that Toshiba is exporting something from the US that uses SQLite, but we 
do not know what that something is.
</td></tr>
</table>
Changes to pages/features.in.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<li>Well-commented source code with
    [test coverage |100% branch test coverage].</li>
<li>Available as a 
    <a href="amalgamation.html">single ANSI-C source-code file</a> 
    that you can easily drop into another project.
<li><a href="selfcontained.html">Self-contained</a>:
    no external dependencies.</li>
<li>Cross-platform: Unix (Linux and Mac OS X), OS/2, and Windows
    (Win32 and WinCE)
    are supported out of the box.  Easy to port to other systems.
<li>Sources are in the <a href="copyright.html">public domain</a>.
    Use for any purpose.</li>
<li>Comes with a standalone <a href="sqlite.html">command-line interface</a>
    (CLI) client that can be used to administer SQLite databases.</li>
</ul>
</p>







|
|







27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<li>Well-commented source code with
    [test coverage |100% branch test coverage].</li>
<li>Available as a 
    <a href="amalgamation.html">single ANSI-C source-code file</a> 
    that you can easily drop into another project.
<li><a href="selfcontained.html">Self-contained</a>:
    no external dependencies.</li>
<li>Cross-platform: Unix (Linux, Mac OS-X, Android, iOS) and Windows
    (Win32, WinCE, WinRT)
    are supported out of the box.  Easy to port to other systems.
<li>Sources are in the <a href="copyright.html">public domain</a>.
    Use for any purpose.</li>
<li>Comes with a standalone <a href="sqlite.html">command-line interface</a>
    (CLI) client that can be used to administer SQLite databases.</li>
</ul>
</p>
Changes to pages/index.in.
18
19
20
21
22
23
24

25
26
27
28
29
30
31
<hr style="color: #044a64" height="2">

<h3>Sponsors</h3>
<p>Ongoing development and maintenance of SQLite is
sponsored in part by <a href="consortium.html">SQLite Consortium</a>
members, including:</p>


<center>
<table border="0" cellpadding="15">

<tcl>hd_puts {
<script language="JavaScript">
  var sponsor = new Array()
  sponsor[0] = '<tr><td align="center">\







>







18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<hr style="color: #044a64" height="2">

<h3>Sponsors</h3>
<p>Ongoing development and maintenance of SQLite is
sponsored in part by <a href="consortium.html">SQLite Consortium</a>
members, including:</p>

<a name="consortium_members"></a>
<center>
<table border="0" cellpadding="15">

<tcl>hd_puts {
<script language="JavaScript">
  var sponsor = new Array()
  sponsor[0] = '<tr><td align="center">\
54
55
56
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
    <a href="http://www.oracle.com/us/technologies/embedded/">\
    <img src="images/foreignlogos/oracle.gif" alt="oracle.com" border="0">\
    </a></td><td>\
    <a href="http://www.oracle.com/us/technologies/embedded/">Oracle</a> -\
    Software.  Hardware.  Complete.</td></tr>'

  sponsor[4] = '<tr><td align="center">\
    <a href="http://www.nokia.com/">\
    <img src="images/foreignlogos/nokia.gif" alt="nokia.com" border="0">\
    </a></td><td>\
    <a href="http://www.nokia.com/">Nokia</a> is the world leader in mobility,\
    driving the transformation and growth of the converging internet and\
    communications industries.</td></tr>'

  sponsor[5] = '<tr><td align="center">\
    <a href="http://www.bentley.com/">\
    <img src="images/foreignlogos/bentley.gif" alt="bentley.com" border="0">\
    </a></td><td>\
    <a href="http://www.bentley.com/">Bentley</a> - Comprehensive software \
    solutions for Sustaining Infrastructure.</td></tr>'

  count = 6
  while( count>0 ){
    i = Math.floor(Math.random()*6)
    if( sponsor[i]!=null ){
      document.write(sponsor[i])
      sponsor[i] = null
      count--
    }







<
<
<
<
<
<
<
<






|







55
56
57
58
59
60
61








62
63
64
65
66
67
68
69
70
71
72
73
74
75
    <a href="http://www.oracle.com/us/technologies/embedded/">\
    <img src="images/foreignlogos/oracle.gif" alt="oracle.com" border="0">\
    </a></td><td>\
    <a href="http://www.oracle.com/us/technologies/embedded/">Oracle</a> -\
    Software.  Hardware.  Complete.</td></tr>'

  sponsor[4] = '<tr><td align="center">\








    <a href="http://www.bentley.com/">\
    <img src="images/foreignlogos/bentley.gif" alt="bentley.com" border="0">\
    </a></td><td>\
    <a href="http://www.bentley.com/">Bentley</a> - Comprehensive software \
    solutions for Sustaining Infrastructure.</td></tr>'

  count = 5
  while( count>0 ){
    i = Math.floor(Math.random()*6)
    if( sponsor[i]!=null ){
      document.write(sponsor[i])
      sponsor[i] = null
      count--
    }
Changes to pages/selfcontained.in.
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
some additional C library support, but those functions can
be also be omitted from the build using compile-time options.
</p>

<p>
Communications between SQLite and the operating system and disk are
mediated through an interchangeable [VFS] layer.
VFS modules for Unix (Linux and Mac OS X), OS/2, and Windows (Win32 and WinCE)
are provided in the source tree.  It is a simple matter to devise an
alternative VFS for embedded devices.
</p>

<p>
For safe operation in multi-threaded environments, SQLite requires
the use of mutexes.  Appropriate mutex libraries are linked automatically







|







34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
some additional C library support, but those functions can
be also be omitted from the build using compile-time options.
</p>

<p>
Communications between SQLite and the operating system and disk are
mediated through an interchangeable [VFS] layer.
VFS modules for Unix and Windows
are provided in the source tree.  It is a simple matter to devise an
alternative VFS for embedded devices.
</p>

<p>
For safe operation in multi-threaded environments, SQLite requires
the use of mutexes.  Appropriate mutex libraries are linked automatically