Re: Next Release? Visual release timeline?
R Smith <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 2020/01/15 1:24 PM, Richard Hipp wrote: > On 1/15/20, Dominique Devienne <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users