QueryCal
Productivity
calendar analytics
SHOW HN2021
How HN took it
4 positive, 1 neutral or asking, 0 mixed, 1 critical, out of 6 comments about the project. Thread score +0.20.
Design: 2 for, 0 againstDocs: 1 for, 0 againstIdea: 1 for, 0 againstExecution: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Neat idea for measuring activity from calendars
From 2 comments
This is a really neat idea. I usually apply categories to my calendar invites so I can see quickly if I’m spending too much time (or not enough time) toward any type of activity.…
rubyfan on HNGood idea! As a suggestion, I think your website could use some extra documentation and examples. For example, could I create a panel in Grafana showing the busy vs. free ratio…
mechero on HN
SQLite-per-user design is appealing
From 2 comments
I love it and will give it a go! I'm also intrigued by your 'SQLite-per-user' structure and would be keen to hear how you get on with that long-term. For instance, how will you…
simonhamp on HNSounds ideal. I really like the isolation of separate DB files per user. In more complex systems though it feels like it's going to require quite a bit of orchestration. The big…
simonhamp on HN
Objections
Demo button did not work on Firefox
From 1 comment
Clicking "Demo" on Ubuntu/Firefox 86.0 does nothing :(
waltteri on HN
Documentation and examples are lacking
From 2 comments
Good idea! As a suggestion, I think your website could use some extra documentation and examples. For example, could I create a panel in Grafana showing the busy vs. free ratio…
mechero on HNAbsolutely! A starting point would be something like this to calculate total busy time per day: SELECT sum(end - start) from events group by JULIANDAY(start) Some extra…
bradleyjkemp on HN
Outlook users cannot easily connect calendar
From 1 comment
This is a really neat idea. I usually apply categories to my calendar invites so I can see quickly if I’m spending too much time (or not enough time) toward any type of activity.…
rubyfan on HN
Requests
Add more documentation and examples
From 1 comment
Good idea! As a suggestion, I think your website could use some extra documentation and examples. For example, could I create a panel in Grafana showing the busy vs. free ratio…
mechero on HN
Support Outlook or OAuth calendar plugins
From 2 comments
This is a really neat idea. I usually apply categories to my calendar invites so I can see quickly if I’m spending too much time (or not enough time) toward any type of activity.…
rubyfan on HNDoes your company let you share your calendar privately via an iCal URL? That's the only method of adding your calendar to QueryCal at the moment anyway but is also more likely…
bradleyjkemp on HN
Live queries via SQLite virtual tables
From 1 comment
This looks awesome! Seems like a great idea - I'm curious - do you download the full calendar first into a SQLite DB file and then let a user execute queries? SQLite has a…
patrickdevivo on HN
Questions
How will schema migrations be handled?
From 1 comment
I love it and will give it a go! I'm also intrigued by your 'SQLite-per-user' structure and would be keen to hear how you get on with that long-term. For instance, how will you…
simonhamp on HN
Is the full calendar downloaded into SQLite first?
From 1 comment
This looks awesome! Seems like a great idea - I'm curious - do you download the full calendar first into a SQLite DB file and then let a user execute queries? SQLite has a…
patrickdevivo on HN
Alternatives named
Go MySQL implementation (go-mysql-server)
From 2 comments
Hey HN, I built this project because last year I did a terrible job of actually taking time off work and needed a way to see just how overdue I was to take a day off. Because so…
bradleyjkemp on HNInteresting, hadn't seen the virtual table feature of SQLite. I'd have to do some benchmarking but that could be worth switching to in future for perhaps getting fresher data.…
bradleyjkemp on HN