451–458 of 458 posts
I've created Python Script for adding GPS coordinates to my photos. First version was using Google Takeout JSON file. Then later I've added Android App support (GPS Logger) and recently I've added support for hardware GPS watch that I've purchased on AliExpress. The code was little bit of a mess, I've improved it a bit after someone asked if can see the code. I've also added a License and README. * https://github.com…
https://github.com/roveo/vertica-query-paste This is a small script made to do one thing: take an SQL query from the clipboard and output a CSV file with results. As a data analyst, part of my job was sending results of ad-hoc queries to a bunch of people on slack. The data warehouse was quite slow, so I had to: - write a query in DataGrip (or any SQL client) - execute it - wait for results - remember that there was…
I wrote an in-terminal histogram tool[0] because... that's when/where I always need histograms. [0] https://github.com/wizzat/distribution
This is the best thing since sliced bread, but it doesn't work for me on a recent Ubuntu. Tried with both Python 2 and 3. Compare: $ sudo du -sb /etc/* | sort | uniq | sort -rn | head -10 2897355 /etc/brltty 436966 /etc/java-11-openjdk 402728 /etc/ssl 251196 /etc/apparmor.d 244732 /etc/ImageMagick-6 219185 /etc/X11 170093 /etc/fonts 144084 /etc/java-8-openjdk 131407 /etc/init.d 117524 /etc/systemd With: $ sudo du -sb…
Tool to generate a random order of a popular food delivery service in The Netherlands. Wanted to discover new local restaurants instead of eating the same 3 things always. http://thuisbezorgdroulette.nl/
Then I realized most of my invoices come by email, so I used Zapier and Gmail rules to find invoices and put them in a folder in Google Drive, which saved me more work.
This was very useful to never forget to fill something in the accounting anymore, but escalated quickly... Later on, I wrote a bunch of scripts that read invoices from Google Drive, extract the necessary information and place it in the spreadsheet for my accountant, rename the files to a standardized format and complete the Asana tasks automatically.
And there are more scripts, for example some services do not send you the invoice via email, but you can log in and download it, or the invoice information might be displayed on screen and if you want to keep it you need to print them out as PDF, so I wrote scripts for this.
All of this became an amorphous collection of scripts that are tailor-made for me and probably would be of no use to anybody else, but definitely made my life simpler. I know there are a bunch of SaaS services now that do this for you, but when I started they were not there and the ones I tried need more manual work than the solution I have today.
One little detail I noticed of my design and was totally accidental: since I made the scripts in steps and used Asana to keep track of which statement entries still needed attention, the "UI" is still Asana and the tasks can still be done manually. Therefore, my scripts do not need to cover all cases, which is great because it's not an all-or-nothing solution.
The way it works is you enter some "categories", then when you have time you research one of the providers, add that yaml file, and that's it. Automatically deploys and updates everything. No database or complicated things, just simple feature comparisons.
For anyone interested, you can see a version of it at https://www.srvrlss.io
I wrote a URL handler on MacOS where I can configure rules to define which browser will actually open the URL. Rules can be configured based on a URL regex or currently open Slack workspace. You can target different browsers, including profile (Chrome) or container (Firefox). I hope to open source this at some point.
Is it available for download/use by others? This seems to solve a particular problem for me