Service for logs in 5 minutes

During development for mobile devices, there was a problem to observe and compare several performance characteristics and parameters on different devices. (iPad / Samasung Galaxy Note 10.1 / Nexus, etc.). It would be possible to simply write logs to a file, then put them together, but I want the information from the devices to arrive immediately after debugging into a single table, and not all devices are in the hands of the developers.

The only quick solution that came to mind was a small service at flask / bottle, but for this, you would have to raise the data warehouse. To be honest, even using cloud solutions on Azure / Heroku / AWS is a small handful of additional problems for such a simple task: passwords, paths, dependencies, etc. We also need to keep one small table with several parameters that come from the devices. In addition, this utility was required solely for ease of development, and not for productive use with thousands of users.

I constantly write down various hacks for everyday tasks into my knowledge base in Evernote, and recently found there a sample code from some open source project where the Google Docs form is being processed via post requests. And away we go.

Google Docs and its forms

It was necessary to track three parameters: read time, processing time and device name.
Create a form in Google Docs and write the fields we need there: read time, processing time, device. We get a link to the form: https://docs.google.com/forms/d/156UppB2Byfq-gdsDxr-DUU9_YBviBbt2Gelhx5W5MsI/viewform .
')
Then we do:

curl https://docs.google.com/forms/d/156UppB2Byfq-gdsDxr-DUU9_YBviBbt2Gelhx5W5MsI/viewform | grep --color entry 

Here we see three input parameters that can be passed through a POST request.

For example:

 curl -d "entry.1882636933=2.75&entry.454434040=11.43&entry.444705398=Galaxy Note 10.1" https://docs.google.com/forms/d/156UppB2Byfq-gdsDxr-DUU9_YBviBbt2Gelhx5W5MsI/formResponse 

Now in our form we make a connection with the table And we distribute the necessary rights to this table.

Result

"

Each query in the table receives a time stamp, which is a nice bonus. The resulting table with logs .

Answers in the table appear in real time and we can continue to do whatever we want with this information.

I think this is a very quick solution for small practical tasks.