Documentation Source Text

Check-in [f96d1199e7]
Login

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

Overview
Comment:Experiment with a new look for the homepage and especially the layout of sponsor links.
Timelines: family | ancestors | descendants | both | new-sponsors-layout
Files: files | file ages | folders
SHA1: f96d1199e7c2db94c990d84506c394cebba2f6ca
User & Date: drh 2015-12-08 22:28:53
Context
2015-12-09
03:53
Further experiments with a new look for the sponsors on the homepage. check-in: 66f30d5788 user: drh tags: new-sponsors-layout
2015-12-08
22:28
Experiment with a new look for the homepage and especially the layout of sponsor links. check-in: f96d1199e7 user: drh tags: new-sponsors-layout
20:11
Add Facebook to the homepage. check-in: e8ddd92958 user: drh tags: branch-3.9
2015-12-03
22:34
Fix requirement mark errors in the cache_spill pragma docs. check-in: ecd3254d36 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Added images/foreignlogos/fb.gif.

cannot compute difference between binary files

Changes to pages/amalgamation.in.

128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146

<h3>4.1 Dependencies</h3>

<p>The build process makes extensive use of the 
[http://www.tcl-lang.org/|Tcl] scripting language.  You will need to have a
copy of TCL installed in order for the make targets above to work.
Easy-to-use installers can be obtained from [http://www.tcl-lang.org/].
May unix workstations of Tcl installed by default.

<p>The build process also uses [http://en.wikipedia.org/wiki/AWK|AWK].
AWK is almost always installed by default on unix-like workstations,
but it may need to be downloaded and installed on Windows development
platforms.  There are many versions of AWK available for Windows.
Use a search engine to find one.

<h3>4.2 See Also</h3>

<p>Additional notes on compiling SQLite can be found on the
[How To Compile SQLite] page.







|











128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146

<h3>4.1 Dependencies</h3>

<p>The build process makes extensive use of the 
[http://www.tcl-lang.org/|Tcl] scripting language.  You will need to have a
copy of TCL installed in order for the make targets above to work.
Easy-to-use installers can be obtained from [http://www.tcl-lang.org/].
Many unix workstations have Tcl installed by default.

<p>The build process also uses [http://en.wikipedia.org/wiki/AWK|AWK].
AWK is almost always installed by default on unix-like workstations,
but it may need to be downloaded and installed on Windows development
platforms.  There are many versions of AWK available for Windows.
Use a search engine to find one.

<h3>4.2 See Also</h3>

<p>Additional notes on compiling SQLite can be found on the
[How To Compile SQLite] page.

Changes to pages/index.in.

1
2
3
4
5
6
7
8
9
10
11
12
..
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
78
79
80
81
82
83
<title>SQLite Home Page</title>

<table border="0" width="100%">
<tr><td valign="top">
<h3>Welcome</h3>
<p>SQLite is a software library that implements a
<a href="selfcontained.html">self-contained</a>, 
<a href="serverless.html">serverless</a>,
<a href="zeroconf.html">zero-configuration</a>,
<a href="transactional.html">transactional</a>
SQL database engine.
SQLite is the [most widely deployed]
................................................................................
The source code for SQLite is in the
<a href="copyright.html">public domain</a>.
<a href="about.html">More...</a></p>

<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">\
    <a href="https://www.mozilla.com/">\
    <img src="images/foreignlogos/mozilla.gif" alt="mozilla.com" border="0">\
    </a></td><td>\
    <a href="https://www.mozilla.com/">Mozilla</a> - Working to preserve \
    choice and innovation on the internet.</td></tr>'

  sponsor[1] = '<tr><td align="center">\
    <a href="https://www.bloomberg.com/">\
   <img src="images/foreignlogos/bloomberg.gif" alt="bloomberg.com" border="0">\
    </a></td><td>\
    <a href="https://www.bloomberg.com/">Bloomberg</a> - \
    A world leader in financial-information technology.</td></tr>'

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

  sponsor[3] = '<tr><td align="center">\
    <a href="http://www.nds-association.org/">\
    <img src="images/foreignlogos/nds.png" alt="nds-association.org" border="0">\
    </a></td><td>\
    <a href="http://www.nds-association.org/">NDS</a> - The leading map standard \
    for automotive infotainment and autonomous driving.</td></tr>'

  sponsor[4] = '<tr><td align="center">\
    <a href="https://www.expensify.com/">\
    <img src="images/foreignlogos/expensify.png" width="225" height="32" \
     alt="expensify.org" border="0">\
    </a></td><td>\
    <a href="https://www.expensify.com/">Expensify</a> - \
    We power the most exciting companies in the world using SQLite. </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--
    }
  }

</script>
}</tcl>

</table>
</center>





|
<







 







|
|








|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>
>
>
>
>



>







1
2
3
4

5
6
7
8
9
10
11
..
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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
78
79
80
81
82
83
84
85
86
87
88
<title>SQLite Home Page</title>

<table border="0" width="100%">
<tr><td valign="top" width="66%">

<p>SQLite is a software library that implements a
<a href="selfcontained.html">self-contained</a>, 
<a href="serverless.html">serverless</a>,
<a href="zeroconf.html">zero-configuration</a>,
<a href="transactional.html">transactional</a>
SQL database engine.
SQLite is the [most widely deployed]
................................................................................
The source code for SQLite is in the
<a href="copyright.html">public domain</a>.
<a href="about.html">More...</a></p>

<hr style="color: #044a64" height="2">

<h3>Sponsors</h3>
<p>Substantial support for the continuing enhancement and maintenance
of SQLite comes from <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 sponsors = [{
    "name":"Mozilla",
    "url":"https://www.mozilla.com/",
    "image":"mozilla.gif",
    "blurb":"Working to preserve choice and innovation on the internet."
  },{
    "name":"Bloomberg",
    "url":"https://www.bloomberg.com/",
    "image":"bloomberg.gif",
    "blurb":"A world leader in financial-information technology."
  },{
    "name":"Bentley",
    "url":"https://www.bentley.com/",
    "image":"bentley.gif",
    "blurb":"Comprehensive software solutions for Sustaining Infrastructure."
  },{
    "name":"NDS",
    "url":"http://www.nds-association.org/",
    "image":"nds.png",
    "blurb":"The leading map standard for automotive infotainment and autonomous driving."
  },{
    "name":"Expensify",
    "url":"https://www.expensify.com/",
    "image":"expensify.png",
    "size":"width=\"225\" height=\"32\"",
    "blurb":"We power the most exciting companies in the world using SQLite."
  },{
    "name":"Facebook",
    "url":"https://www.facebook.com/",
    "image":"fb.gif",
    "blurb":"Giving people the power to share and make the world more open and connected."
  }];

  var count = sponsors.length
  var len = count
  var n = 0
  var htxt = "";
  while( count>0 ){
    i = Math.floor(Math.random()*len)
    if( sponsors[i]!=null ){
      if( sponsors[i].size==null ) sponsors[i].size = "";
      var x = ((++n)%2)==1;
      if( x ) htxt += "<tr>\n";
      htxt += "<td align='center'><span class='popup'>\n"+
         "<a href='"+sponsors[i].url+"'><img src='images/foreignlogos/"+sponsors[i].image+
         "' "+sponsors[i].size+" border='0'></a><div><b>"+sponsors[i].name+"</b> &mdash; "+
         sponsors[i].blurb+"</div></span></td>\n";
      sponsors[i] = null
      count--
    }
  }
  document.write(htxt)
</script>
}</tcl>

</table>
</center>


Changes to wrap.tcl.

442
443
444
445
446
447
448












449
450
451
452
453
454
455
    .toolbar a:visited { color: white; }
    .toolbar a:hover { color: #044a64; background: white; }
    
    .content    { margin: 5%; }
    .content dt { font-weight:bold; }
    .content dd { margin-bottom: 25px; margin-left:20%; }
    .content ul { padding:0px; padding-left: 15px; margin:0px; }












    
    /* Things for "fancyformat" documents start here. */
    .fancy img+p {font-style:italic}
    .fancy .codeblock i { color: darkblue; }
    .fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
    .fancy h2 { margin-left: 10px }
    .fancy h3 { margin-left: 20px }







>
>
>
>
>
>
>
>
>
>
>
>







442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
    .toolbar a:visited { color: white; }
    .toolbar a:hover { color: #044a64; background: white; }
    
    .content    { margin: 5%; }
    .content dt { font-weight:bold; }
    .content dd { margin-bottom: 25px; margin-left:20%; }
    .content ul { padding:0px; padding-left: 15px; margin:0px; }

    /* Homepage pop-up text */
    span.popup div {
      position: absolute;
      left: -9999px;
      background: #ffb;
      padding: 6px 6px 6px 6px;
      border: 2px solid black;
    }
    span.popup:hover div {
      left: 1%;
    }
    
    /* Things for "fancyformat" documents start here. */
    .fancy img+p {font-style:italic}
    .fancy .codeblock i { color: darkblue; }
    .fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
    .fancy h2 { margin-left: 10px }
    .fancy h3 { margin-left: 20px }