Nleyten@1100: timezones and rainbows
SVN commit 1100 reads "Added support for timezones in the database (including accessory tables and API functions)". Yeap, I spent some time adding proper support for timezones in the database. The idea is of course that while the timestamps for stories and comments are stored in universal time (UTC), users typically prefer to see their own local times. It should have been an easy addition, but it did take some time and effort because of the slightly messy way that timezones are handled by PostgreSQL. But anyway, it's done!
Between revisions and 1000 and 1100, lots of other more exciting stuff happened. A barebones but working version of Lambdium (called Lambdium-light) was born, and I made an unofficial release of a beta version in the Ocsigen mailing list. (Once it hits 1.0, I'll do a more formal announcement and explain the differences between Lambdium and Lambdium-light). I also implemented support for strong crypto to store user passwords in the database (passwords are salted and digested through a time-consuming hash function). The idea is of course to prevent the infamous "rainbow table" attack should the database ever be compromised.

Comments