On 2020/01/15 1:24 PM, Richard Hipp wrote:
On 1/15/20, Dominique Devienne <ddevie...@gmail.com> wrote:
I like Lua's way to graphically visualize releases at
https://www.lua.org/versions.html


Please send javascript that will generate such a graph, either as SVG
or as an HTML Canvas.

(1) For improved display on mobile, consider making the graph vertical
instead of horizontal.

(2) Assume the data is a JSON array of pairs.  The first element of
each pair is the release name (ex: "3.30.0") and the second element is
the time as a fractional year (ex: "2019.7775").

We'd like to submit this layout as an option:
https://sqlitespeed.com/sqlite_releases.html

Shown alongside the current list in simple form. Tried a few layouts, not all work as well (SQLite releases are much more dense than Lua), finally settled on the above, but left some options open.

It comes with some config structure in this form:

      var options = {
        parentId: 'versionHistoryGraph',
        width: 200,
        yearWidth: 100,
        heightPerYear: 300,
        heightPerVersion: 14, // needs to match the style for .version
        lineColor: "#222222",
        yearBackground: "#EEEEEE",
        data: [["1.0",2000.6298197581566],["1.0.1",2000.6325576089437],["1.0.3",2000.6435090120922],["1.0.4",2000.659936116815],["1.0.5",2000.7064795801962],["1.0.8",2000.7502851927902],["1.0.9",2000.7749258498745],["1.0.10",2000.7804015514487],["1.0.12",2000.7968286561716],["1.0.14",2000.802304357746],["1.0.13",2000.802304357746],["1.0.15",2000.8132557608944],

...

["3.30.0",2019.7584987451517],["3.30.1",2019.7749258498745]]
      };

Note: The Release-Date array must be given Ascending, else an additional sort step in Java is needed, but I think SQLite is better at that.


I will send the full script directly via e-mail (not sure if the forum will allow the size), but it can of course also be directly copied from the above html.

Official statement:
We have solely created the content of that html page and this e-mail, for the purpose of using it in the sqlite public pages, or as they see fit, but it is free to all, and herewith donated to the public domain.


Cheers,
Davey Van Nes, Ryan Smith





_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to