[tz] tz Digest, Vol 104, Issue 1

[Reece Stewart]

Stop sending me should your fucken dogs

On Fri., 1 May 2020, 10:00 pm , <tz-request at iana.org> wrote:

> Send tz mailing list submissions to
>         tz at iana.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://mm.icann.org/mailman/listinfo/tz
> or, via email, send a message with subject or body 'help' to
>         tz-request at iana.org
>
> You can reach the person managing the list at
>         tz-owner at iana.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of tz digest..."
>
>
> Today's Topics:
>
>    1. Database available in other formats (Sergio Bonfiglio)
>    2. Re: Database available in other formats (Paul Eggert)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 28 Apr 2020 17:12:55 +0200
> From: Sergio Bonfiglio <bonfiglio.sergio at gmail.com>
> To: tz at iana.org
> Subject: [tz] Database available in other formats
> Message-ID:
>         <
> CANCwfxiVBnHPUawqZxWEKU+W89PWxL0SNRUXAMLgX1iMTMUF7Q at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Dear Sirs,
>
> First thig first a big THANK YOU for your invaluable work.
> I was overwhelmed by the complexity of your database, because it requires
> also external pieces of code to be safely read.
> I was wondering if does exist the database in different formats that may be
> larger but more readable and easy usable.
> An SQL database could be really "for everyone", because can be queried by
> everything from everywhere by any language.
> If I may make a humble suggestion, a JD date in floating format that equips
> any record with the initial and final date of the rule/event could be of
> great help.
> With a single query, one could recall all the records that pertain a
> certain moment in time also with different and overlapping rules.
> Thanks for any reply and thank for your work that is making me sweat the
> classical " seven shirts".
> Stay well
>
> Sergio Bonfiglio
> ITALY
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mm.icann.org/pipermail/tz/attachments/20200428/1489fee1/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Thu, 30 Apr 2020 13:39:06 -0700
> From: Paul Eggert <eggert at cs.ucla.edu>
> To: Sergio Bonfiglio <bonfiglio.sergio at gmail.com>
> Cc: Time zone mailing list <tz at iana.org>
> Subject: Re: [tz] Database available in other formats
> Message-ID: <cb75d7d3-878d-5a5d-2a3a-69e54ef2583e at cs.ucla.edu>
> Content-Type: text/plain; charset=utf-8
>
> On 4/28/20 8:12 AM, Sergio Bonfiglio wrote:
>
> > I was overwhelmed by the complexity of your database, because it requires
> > also external pieces of code to be safely read.
>
> Yes, it's in its own .zi format. Typically I edit it with a text editor so
> I
> suppose that counts as an external piece of code. Most people either do
> that, or
> process it with the code supplied as part of tzdb, or use one of the
> already-written tz compilers
> <https://data.iana.org/time-zones/tz-link.html#compilers>. Perhaps one of
> those
> will work for you.
>
> > An SQL database could be really "for everyone", because can be queried by
> > everything from everywhere by any language.
>
> MariaDB, MySQL, and Oracle Database use tzdb in some form; perhaps they're
> already doing something along the lines of what you're asking for.
>
> > If I may make a humble suggestion, a JD date in floating format that
> equips
> > any record with the initial and final date of the rule/event could be of
> > great help.
>
> JD should be relatively easy to generate automatically from the existing
> format.
> I doubt whether the source data should have JD directly, though, as JD is
> inconvenient for humans and anyway the .zi format is now read by so many
> programs that any changes to it would need to be carefully considered and
> justified. But JD could be good for database queries, along the lines of
> your
> suggestion.
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> tz mailing list
> tz at iana.org
> https://mm.icann.org/mailman/listinfo/tz
>
> _______________________________________________
> By submitting your personal data, you consent to the processing of your
> personal data for purposes of subscribing to this mailing list accordance
> with the ICANN Privacy Policy (https://www.icann.org/privacy/policy) and
> the website Terms of Service (https://www.icann.org/privacy/tos). You can
> visit the Mailman link above to change your membership status or
> configuration, including unsubscribing, setting digest-style delivery or
> disabling delivery altogether (e.g., for a vacation), and so on.
>
> ------------------------------
>
> End of tz Digest, Vol 104, Issue 1
> **********************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mm.icann.org/pipermail/tz/attachments/20200502/a8af0655/attachment-0001.html>