andreyshuster

 find ./ -name '*~' -exec rm '{}' \; -print -or -name ".*~" -exec rm {} \; -print

andreyshuster

 a=1; for file in *.jpg; do mv "$file" "${a}.jpg"; let a=a+1; done

andreyshuster

#!/usr/bin/env sh
history | awk '{CMD[$2]++;count++;}END { for (a in CMD)print CMD[a] " " CMD[a]/count*100 "% " a;}' | grep -v "./" | column -c3 -s " " -t | sort -nr | nl | head -n 10

andreyshuster

Convert all ebooks in folder to mobi

for file in *.fb2; do ebook-convert "$file" "$file.mobi"; done

andreyshuster

Add all untracked files to .gitignore

git status -s | grep -e "^\?\?" | cut -c 4- >> .gitignore

andreyshuster

Find all folders older than certain date(Useful to find old projects)

find . -type d  -d 1 -not -newermt "2020-09-01 00:00:00"

andreyshuster

SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;

andreyshuster

list(zip(*original[::-1]))

andreyshuster

From PSQL console

$ psql <postgres connection string>
=> \o result-filename.txt
=> SELECT * from the table

Another variant (CSV export)

andreyshuster

> .mode csv
> .import file_name.csv table_name