Log in

No account? Create an account
entries friends calendar profile My Website Previous Previous Next Next
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: , ,
Current Location: Remedy Tea, Capitol Hill, Seattle WA

1 comment or Leave a comment
awfief From: awfief Date: December 27th, 2007 10:29 pm (UTC) (Link)
MySQL doesn't actually use the tables unless you specify, and you can specify other data sources, iirc. Or rather, you can specify MySQL to use the tz tables, *or* you can say "use the system defaults".
1 comment or Leave a comment