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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: e4f8c1c60f865969fb6cf1a0bd0590e66c7bbd15ff1560a17d59896db0a9aa4d
User & Date: drh 2020-01-15 13:20:37
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
Hide Diffs Unified Diffs 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
...
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
<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)
................................................................................
  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');







>
>
>







 







>


>








>
>
>
|
>
>
>
>
>
>
>







8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
...
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
<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)
................................................................................
  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');