I am here ... I wrote a track record for time. 628 minutes
Hello friends! A couple of weeks ago, I thought: “Is it possible to use Google Sheets (Google Sheets) as a simple and secure data storage?”. Oh, and I have long wanted to write a track of time.
And that's what happened:
Like you, I have a bunch of ideas. Some ideas are stuck in the head for a long time. The easiest way to get rid of the idea is to sit down and start writing it.
')
I have long wanted to get rid of the idea to track my time :). But I was too lazy to spend time writing boring things (data storage, authentication).
It turns out Google Sheets has a very friendly API, good documentation and simple hello world . For the first evening it turned out to integrate their example with the template for vue.js.
The site immediately started working with a primitive interface:
I went to sleep satisfied, and the next day I started using the site, noticing where the sharpest corners were. I grind sharp corners at night, after work, and the experiment continued the next day.
Over several nights, I reduced the number of known bugs, boundary cases, and clicks to record time to a satisfactory minimum. And the whole project took about 10.5 hours.
As a framework for managing data, I chose vue.js , and took the styles from materialize-css . Vue seems to me simpler than react, and without magic angular.
The next step I laid out the site for free hosting with a free https certificate: www.netlify.com (since all are open source). I found netlify on a tip from John-David Dalton - he hosts the documentation for lodash from them, and responded very warmly. Really comfortable! A couple of clicks and everything works.
This is personal! It would be unpleasant for me if someone watched my time records, therefore I purposefully avoid analytics and third-party servers. After downloading the site, all data go directly to Google, through their API.
I hope this little story of a small project will inspire you to implement your idea! And such a simple tool like Google Sheets will be in your store. All code is available here: github.com/anvaka/time
And that's what happened:
Code + Site
Like you, I have a bunch of ideas. Some ideas are stuck in the head for a long time. The easiest way to get rid of the idea is to sit down and start writing it.
')
I have long wanted to get rid of the idea to track my time :). But I was too lazy to spend time writing boring things (data storage, authentication).
It turns out Google Sheets has a very friendly API, good documentation and simple hello world . For the first evening it turned out to integrate their example with the template for vue.js.
The site immediately started working with a primitive interface:
git checkout 62687e46d3c768f50400bc3dc95a1f699c64b626 I went to sleep satisfied, and the next day I started using the site, noticing where the sharpest corners were. I grind sharp corners at night, after work, and the experiment continued the next day.
Over several nights, I reduced the number of known bugs, boundary cases, and clicks to record time to a satisfactory minimum. And the whole project took about 10.5 hours.
In the screenshot above, the site is called “sheetime”. I had doubts about the adequacy of the name, but after the comments of a colleague about a large toilet association, they disappeared. Had to rename to just "time"
Instruments
As a framework for managing data, I chose vue.js , and took the styles from materialize-css . Vue seems to me simpler than react, and without magic angular.
The next step I laid out the site for free hosting with a free https certificate: www.netlify.com (since all are open source). I found netlify on a tip from John-David Dalton - he hosts the documentation for lodash from them, and responded very warmly. Really comfortable! A couple of clicks and everything works.
This is personal! It would be unpleasant for me if someone watched my time records, therefore I purposefully avoid analytics and third-party servers. After downloading the site, all data go directly to Google, through their API.
Good luck!
I hope this little story of a small project will inspire you to implement your idea! And such a simple tool like Google Sheets will be in your store. All code is available here: github.com/anvaka/time
Source: https://habr.com/ru/post/311860/
All Articles