News for hackers. Stuff that matters.
Re:Ask HN: Is there a powerful open-source Google Calendar r... by grinich on Friday March 31, 2017 @05:36PM (#14008531)
Here's a blog post we wrote on RRULEs that just highlights one part of why calendars are hard: https://nylas.com/blog/rrules/
Re:Ask HN: Is there a powerful open-source Google Calendar r... by shaklee3 on Saturday April 01, 2017 @01:09AM (#14010551)
There's a book called "Dreaming in Code" which actually details how hard this problem was for a real project that ultimately failed. Good book for anyone who wants to read an account of a writer who followed an entire software team through the lifecycle of a product.
Re:Ask HN: Is there a powerful open-source Google Calendar r... by fmoralesc on Saturday April 01, 2017 @07:11AM (#14011568)
I'll second this recommendation. For a shorter take on it, Joel Spolsky's review of the book[^1] is a nice read.

[^1]: https://www.joelonsoftware.com/2007/01/21/the-big-picture/

Re:Ask HN: Is there a powerful open-source Google Calendar r... by helge5 on Saturday April 01, 2017 @09:43AM (#14012066)
If you do any serious calendar development, you should join CalConnect. This is where all the calendaring guys meet, work on the related RFCs (CalDAV, iCalendar) and do interoperability testing: https://www.calconnect.org Absolutely worth it.
Re:Ask HN: Is there a powerful open-source Google Calendar r... by fjdlwlv on Saturday April 01, 2017 @10:55AM (#14012408)
Calendaring gals too.
Re:Ask HN: Is there a powerful open-source Google Calendar r... by FragenAntworten on Friday March 31, 2017 @11:37PM (#14010264)
The link to the rrule.js demo is broken; it has moved here: https://jakubroztocil.github.io/rrule/
Re:Ask HN: Is there a powerful open-source Google Calendar r... by taneq on Saturday April 01, 2017 @11:23AM (#14012541)
Dates are one of those "way way harder than you think they are" topics.
Re:Ask HN: Is there a powerful open-source Google Calendar r... by faizshah on Friday March 31, 2017 @06:30PM (#14008941)
I just started with with RRULEs using pg_rrule in postgres. How do you guys handle overrides and exceptions in your schema for the sync engine?
Re:Ask HN: Is there a powerful open-source Google Calendar r... by priyadarshy on Friday March 31, 2017 @07:06PM (#14009199)
there's a lot interesting possibilities for you can handle this. for our sync engine at sunsama we've tried a few different approaches.

currently, we store the "parent" recurring event as one document. then we store exception events as standalone one off calendar events that link back to the parent recurring event. unfortunately, we have to maintain two different types of exploded versions of recurring events (to handle notes on an instance).

eventually, we added a bunch of extra fields to the parent event like a pointer to the next upcoming instance of this event and denormalized full list of exceptions so that we can more easily handle application logic like sending out reminders, and letting you use arrows to navigate b/w instance s of recurring events.

so far with this approach of separating out the parents and children we've run into very few problems.

Re:Ask HN: Is there a powerful open-source Google Calendar r... by helge5 on Saturday April 01, 2017 @10:11AM (#14012186)
I think DAViCal also used to process RRULEs directly within PostgreSQL, may be worth a look: https://gitlab.com/davical-project/davical