Mark Atwood (fallenpegasus) wrote,
Mark Atwood

Storage Engine Idea, tzdata

I recently ranted that Sun JRE installs /usr/java/jre*/lib/zi/, a nearly complete timezone database in it's own java-ish format, instead of using the Olson database in ZIC format in /usr/share/zoneinfo/.

It turns out that MySQL does the same thing, it installs a set of MyISAM tables with the TZ database.

It won't be too hard to write a read-only storage engine that reads the /usr/share/zoneinfo/ ZIC files, and presents tables that "look" just like the currently used tz tables, basically doing what mysql_tzinfo_to_sql does, only "live".
Tags: geek, mysql, timezone

  • Post a new comment


    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 1 comment