I created a small extension for sqlite3 today to allow order by debian version easily. This allows writing:
.load "./debversions.so";
SELECT * FROM packages ORDER BY version COLLAT debversion_compare;
And it will do the right ordering. Its available on launchpad.
August 17, 2011 at 12:19 am |
Excellent, I cannot wait to check it out