Correctly sort version numbers

zopsicle / crai

Cryogenic Raku Archive Index

https://crai.foldr.nl

1 stars 1 forks source link

Closed zopsicle closed 4 years ago

zopsicle commented 4 years ago

Currently we sort version numbers textually, but it should be done properly. Because of this, 3.4 is considered higher than 3.10.

This is difficult with SQLite, but there are two possible solutions:

Harness custom collations, but DBDish doesn’t support this right now.
Store normalized version numbers, e.g. 00030004 instead of 3.4 and 00030010 instead of 3.10.

AlexDaniel commented 4 years ago

zopsicle commented 4 years ago

Done! Using the normalization tactic.