1 ‐ Welcome to Tips'n'tools!
Welcome to the Tips'n'tools wiki! It's kind of rock'n'roll but with references of tools and stuff to read, save and share with colleagues 🤘
Few years ago (before the reboot of this repository because of leak of sensitive data and dirty Git history) I decided to keep in a spreadsheet some useful links to blogs publications and cool tools. In fact we shared such tips in Google+ space in a previous company, but when I left I lost of course the access. It was also possible to share data in internal solutions like Jive, but it was not effective enough to find posted content. And when you change your computer or your web browser, you saw too late you lost your bookmarks. Thus I decided to store data in an ODS file, quite simple, only one sheet for hyperlinks of tools and publications. Then I splitted to two sheets. Then I thought it could be nice also to keep records of devices with CPU, GPU, SoC, RAM, screen sizes etc. Then I made the thing for SoC. And... the spreadsheet became bigger and bigger.
So I decided to make export of sheets to CSV files and make a Shell script to process them to look for data. In fact it was more effective compared to one big file to crawl.
However a CLI tool is nice but I like also GUI, so I decided to make a Shell routine which will process the CSV files to HTML chunks so as to merge them in one web page. It was nice until there were plenty of items in that big lonely page.
So I decided to make a kind of PWA/SPA so as to load from somewhere the data, then display them and make possible to define queries to filter the results. A Ruby servlet calling the Shell scripts has been implemented (in kind of REST fashion) and will provide JSON data. The PWA will keep the results in the web browser database making them available offline.
I use this tool daily. In fact it helps me to keep records of interesting data (like devices and SoC specifications) and also keep tracks of blog publications, web sites and useful tools. I fill a spreadsheet (matching a template), export to CSV, then run the routine to update the data and refresh the PWA.
Of course it is not perfect at all. I can't bear web development, I implemented this solution in my leasure time and choose Shell and Ruby so as to be effective and provide solutions early. Shell is great for files processing!
Some ideas for the future:
- Improve the PWA with minimification of CSS, JS and HTML contents (https://github.com/pylapp/Tips-tools/issues/31)
- Improvement of a11y (https://github.com/pylapp/Tips-tools/issues/30)
- Move from Ruby to other programming language, maybe PHP, or at least make it easie to configure
- Improve scripts to make them stronger, more protected and runnable in any GNU/Linux distros and macOS
- Implement kind of routine to manage spreadsheet file to export its sheets to CSV files
- Maybe use an embeded database?
All the sources (Shell, JavaScript, CSS, HTML, Ruby, etc.) are under MIT license. The ODS template and any HTML, CSS and JSON generated files are under Creative Commons With Attribution.
If you want to support this project, feel free to submit issues and pull requests!
You can also feed the developer by using some of the tools bellow or other mediums 🫶
