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