Ask HN: Tools you have made for yourself?

Post by mikub » Sun, Jun 13, 2021, 4:35 AM UTC

Madeindjs wrote: post #245

mikub wrote: post #37

I am currently learning SQL/Python, I often just wanted to know the headers and how many rows are in a CSV file, so I just wrote a small Python script for it. import csv import readline readline.set_completer_delims(' \t\n=') readline.parse_and_bind("tab: complete") def csvOpen(file): with open(file, "r", newline='', encoding='utf-8-sig') as csvfile: reader = csv.reader(csvfile) i = next(reader) dRows = sum(1 for lin…

This can be done using two lines of Bash - `head -n 1 ` to get headers - `wc -l ` to count number of rows

Post by itsinthenews » Sun, Jun 13, 2021, 4:45 AM UTC

mattkevan wrote: post #269

This isn’t anywhere near as impressive as some of the examples here, but anyway: I run an Etsy store that sells artwork. One of the most time-consuming tasks was creating the mock-ups for product listings, so I wrote a shell script that used Imagemagick to automatically generate all the images. I was pretty pleased as I’d never written a Bash script before and it saves hours and hours of work. I also wrote a Ruby scr…

Post by maddynator » Sun, Jun 13, 2021, 4:51 AM UTC

Post by noduerme » Sun, Jun 13, 2021, 5:19 AM UTC

Post by raaa » Sun, Jun 13, 2021, 6:11 AM UTC

tasuki wrote: post #215

philovivero wrote: post #74

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…