Show HN: Sync any Google Calendar you can access to your own MySQL database
1–10 of 21 posts
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#2This project grew out of our interest in understanding and optimizing time spent in meetings, but don't let that stop you from using it some other way. We're providing direct access to a MySQL database specifically so you can slice the data however you like, with any tool you please.
Questions? Feedback? All very very welcome!
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#3This project grew out of our interest in understanding and optimizing time spent in meetings, but don't let that stop you from using it some other way. We're providing direct access to a MySQL database specifically so you can slice the data however you like, with any tool you please. Questions? Feedback? All very very welcome!
Sqlite please. Or DB-agnostic SQL.
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#4This project grew out of our interest in understanding and optimizing time spent in meetings, but don't let that stop you from using it some other way. We're providing direct access to a MySQL database specifically so you can slice the data however you like, with any tool you please. Questions? Feedback? All very very welcome!
I've had a look at the database schema and data but there's no data for the recurrence_id field since google calendar can express an infinite set of recurrences how is this represented in the database structure?
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#5This project grew out of our interest in understanding and optimizing time spent in meetings, but don't let that stop you from using it some other way. We're providing direct access to a MySQL database specifically so you can slice the data however you like, with any tool you please. Questions? Feedback? All very very welcome!
I've had a look at the database schema and data but there's no data for the recurrence_id field since google calendar can express an infinite set of recurrences how is this represented in the database structure?
Right, naturally none of the rocket launches in the demo data set are recurring (perhaps one day...). In another calendar with recurring events, that ID will be a consistent string across all events that are part of the same series. It's pulled from the `recurringEventId` field in the Google Calendar API: https://developers.google.com/calendar/v3/reference/events#r...
At the moment, the tool just syncs events from one month in the past through one month in the future, so it will pick up a finite subset of a potentially infinite series of recurring events. In future iterations, we imagine users defining their own timeframe to sync.
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#6This project grew out of our interest in understanding and optimizing time spent in meetings, but don't let that stop you from using it some other way. We're providing direct access to a MySQL database specifically so you can slice the data however you like, with any tool you please. Questions? Feedback? All very very welcome!
Sqlite please. Or DB-agnostic SQL.
Agreed. Like PHP, MySQL really ought not be used in production systems.
(Also just because LAMP stacks are popular, it doesn't mean they're much more than toys)
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#7Earlier quoted context omitted.
Sqlite please. Or DB-agnostic SQL.
Agreed. Like PHP, MySQL really ought not be used in production systems. (Also just because LAMP stacks are popular, it doesn't mean they're much more than toys)
What?!? You do realize that MySQL is one of the most popular and battle tested databases on the internet?
Amazon literally just finished moving their entire e-commerce operations from Oracle to Aurora which is based on MySQL open source.
What in the world do you think is a production ready if not the database used by nearly every company in silicon valley and around 85% of the rest of the "production" web?
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#8We built something like this internally and it was more tricky than we expected. Calendars are hard as are Google's different authentication methods and APIs, especially for service accounts at a GSuite level.
I can't imagine using a third party service for this as calendar data is pretty confidential. Would probably have saved us a lot of time if this were an open source project though so we could use our own database.
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#9Earlier quoted context omitted.
Agreed. Like PHP, MySQL really ought not be used in production systems. (Also just because LAMP stacks are popular, it doesn't mean they're much more than toys)
What?!? You do realize that MySQL is one of the most popular and battle tested databases on the internet? Amazon literally just finished moving their entire e-commerce operations from Oracle to Aurora which is based on MySQL open source. What in the world do you think is a production ready if not the database used by nearly every company in silicon valley and around 85% of the rest of the "production" web?
Yes! Mind-blowing isn't it?
Aurora ... Is "compatible" with postgres and MySQL. Not based on it.
I can imagine the reason Amazon moved away from Oracle's flagship DB because of the licensing fees.
You've obviously not used MySQL instead of a proper database, that doesn't blow up with a few million records which MySQL can and will do. Often irretrievably.
Seriously, MySQL is a toy compared to postgress, oracle and MSSQL.
And looking at your recent comments, never been zapped by 240v A/C either.
Please refrain from making massively uninformed comments, it's just embarrassing.
Re: Show HN: Sync any Google Calendar you can access to your own MySQL database
#10I would love this if it was open source and I could self host it.