Documentation Source Text

Check-in [e4f8c1c60f]
Login

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

Overview
Comment:Update the speed-size-graph to include timeline graphs. Output the chronology.json file when building.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: e4f8c1c60f865969fb6cf1a0bd0590e66c7bbd15ff1560a17d59896db0a9aa4d
User & Date: drh 2020-01-15 13:20:37.075
Context
2020-01-17
19:03
Add documentation for SQLITE_OMIT_GENERATED_COLUMNS (check-in: df79d373f6 user: drh tags: trunk)
2020-01-15
13:20
Update the speed-size-graph to include timeline graphs. Output the chronology.json file when building. (check-in: e4f8c1c60f user: drh tags: trunk)
02:44
Update the speed-and-size chart. (check-in: 09b9c916d4 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to misc/speed-size-graph.ods.

cannot compute difference between binary files

Changes to pages/chronology.in.
8
9
10
11
12
13
14



15
16
17
18
19
20
21
<tr><th class='sort desc'>Date<th class='sort none'>Version
</thead>
<tbody>
<tcl>
set nRelease 0
set mxDate {1970-01-01}
set mnDate {2999-12-31}



# The following data was originally generated on 2016-09-03 using an
# SQL query against the Fossil repository:
#
#    SELECT
#      (SELECT substr(uuid,1,10) FROM blob WHERE rid=objid),
#      date(mtime),
#      coalesce(ecomment,comment)







>
>
>







8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<tr><th class='sort desc'>Date<th class='sort none'>Version
</thead>
<tbody>
<tcl>
set nRelease 0
set mxDate {1970-01-01}
set mnDate {2999-12-31}
set jsonSep \[
set jsonChronology [open chronology.json wb]
puts -nonewline $jsonChronology "chronology = "
# The following data was originally generated on 2016-09-03 using an
# SQL query against the Fossil repository:
#
#    SELECT
#      (SELECT substr(uuid,1,10) FROM blob WHERE rid=objid),
#      date(mtime),
#      coalesce(ecomment,comment)
348
349
350
351
352
353
354

355
356

357
358
359
360
361
362
363
364








365


366
367
368
369
370
371
372
  hd_puts "<tr>"
  if {[regexp {\d\d\d\d-\d\d-\d\d} $date]} {
    set url https://www.sqlite.org/src/timeline
    append url ?c=$uuid&y=ci
    hd_puts "<td width='100' align='center'><a href='$url'>$date</a></td>\n"
    if {$date>$mxDate} {set mxDate $date}
    if {$date<$mnDate} {set mnDate $date}

  } else {
    hd_puts "<td width='100' align='center'>$date</td>\n"

  }
  incr nRelease
  hd_puts "<td width='100' align='center' data-sortkey='$vnum'>"
  if {[info exists "glink(version $vers)"]} {
    hd_resolve "\[version $vers|$vers\]</td></tr>\n"
  } else {
    hd_puts "$vers</td></tr>\n"
  }








}


</tcl>
</tbody>
</table>
<tcl>
hd_puts {<script>
function SortableTable(tableEl,columnTypes,initSort){
  this.tbody = tableEl.getElementsByTagName('tbody');







>


>








>
>
>
>
>
>
>
>

>
>







351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
  hd_puts "<tr>"
  if {[regexp {\d\d\d\d-\d\d-\d\d} $date]} {
    set url https://www.sqlite.org/src/timeline
    append url ?c=$uuid&y=ci
    hd_puts "<td width='100' align='center'><a href='$url'>$date</a></td>\n"
    if {$date>$mxDate} {set mxDate $date}
    if {$date<$mnDate} {set mnDate $date}
    set jJulianDay [db one {SELECT julianday($date)}]
  } else {
    hd_puts "<td width='100' align='center'>$date</td>\n"
    set jJulianDay [db one {SELECT julianday('now')}]
  }
  incr nRelease
  hd_puts "<td width='100' align='center' data-sortkey='$vnum'>"
  if {[info exists "glink(version $vers)"]} {
    hd_resolve "\[version $vers|$vers\]</td></tr>\n"
  } else {
    hd_puts "$vers</td></tr>\n"
  }
  set jYear [db one {SELECT strftime('%Y',$jJulianDay)}]
  set jYearFrac [db one {
     SELECT round(($jJulianDay-julianDay($jJulianDay,'start of year'))/365.24,4)
  }]
  set jDate [expr {$jYear+$jYearFrac}]
  puts -nonewline $jsonChronology \
    "$jsonSep{\"hash\":\"$uuid\",\"vers\":\"$vers\",\"date\":$jDate}"
  set jsonSep ",\n"
}
puts $jsonChronology \]\;
close $jsonChronology
</tcl>
</tbody>
</table>
<tcl>
hd_puts {<script>
function SortableTable(tableEl,columnTypes,initSort){
  this.tbody = tableEl.getElementsByTagName('tbody');