Next Release? Visual release timeline?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Next Release? Visual release timeline?

Dominique Devienne
I like Lua's way to graphically visualize releases at
https://www.lua.org/versions.html

Makes it very easy to get a sense of the frequency. Any chance SQLite
would do that, perhaps with "major" (excluding the leading 3.)
releases on one side, and minor ones on the other?

It's been a quarter since the last release, which seems to be longuish
from a cursory glance
at the recent release history. Could it be related to all the
fuzzer-found issues around window functions? Just curious.

Thanks, --DD
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Next Release? Visual release timeline?

Richard Hipp-3
On 1/15/20, Dominique Devienne <[hidden email]> wrote:
> I like Lua's way to graphically visualize releases at
> https://www.lua.org/versions.html
>
> Makes it very easy to get a sense of the frequency. Any chance SQLite
> would do that, perhaps with "major" (excluding the leading 3.)
> releases on one side, and minor ones on the other?

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").

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Next Release? Visual release timeline?

R Smith-2
On 2020/01/15 1:24 PM, Richard Hipp wrote:

> On 1/15/20, Dominique Devienne <[hidden email]> 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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Next Release? Visual release timeline?

Dominique Devienne
On Wed, Jan 15, 2020 at 4:54 PM R Smith <[hidden email]> wrote:
> On 2020/01/15 1:24 PM, Richard Hipp wrote:
> >> (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").

Note that Richard replied to me private with a JSON array of this form:

chronology = [{"hash":"xxxxxxxxxx","vers":"3.31.0","date":2020.0398},
{"hash":"18db032d05","vers":"3.30.1","date":2019.7748},
{"hash":"c20a353364","vers":"3.30.0","date":2019.7557},
{"hash":"fc82b73eaa","vers":"3.29.0","date":2019.5202},
{"hash":"884b4b7e50","vers":"3.28.0","date":2019.2875},
{"hash":"bd49a8271d","vers":"3.27.2","date":2019.1506},
...]

So with a little gymnastic to recover the date, and given the hashes,
all the currently "hardcoded" <td><tr> elements can also be generated
from this JSON array.

Of course, some people disable JavaScript, so "server-side" rendering
might be preferred.

> 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.

Interesting, thanks for the submission. --DD
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users