New Updates Storage Engine Idea, Tzdata
Today, 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”.
(Link)
Loading ...
