jaderabbit

split -l $[ $(wc -l filename|cut -d" " -f1) * percentage / 100 ] filename

jaderabbit

split
wc
grep
sed
tee

jaderabbit

DELETE FROM tablename
WHERE id IN (
    SELECT id
    FROM (SELECT id,
                 ROW_NUMBER() OVER (partition BY column1, column2, column3 ORDER BY id) AS rnum
          FROM tablename) t
    WHERE t.rnum > 1);

jaderabbit

1. You need Ubuntu 17 on a live usb. Ubuntu 16 does not appear to support the fancy CPUs

2. You need to switch from IDE mode to AHCI mode on the harddrive else, it won't find it.

   1. Run Command Prompt as Admin
   2. Invoke a Safe Mode boot with the command: bcdedit /set {current} safeboot minimal
   3. Restart the PC and enter your BIOS during bootup.
   4. Change from IDE to AHCI mode then Save & Exit.
   5. Windows 10 will launch in Safe Mode.
   6. Right click the Window icon and select to run the Command Prompt in Admin mode from among the various options.

3. Cancel Safe Mode booting with the command: bcdedit /deletevalue {current} safeboot

jaderabbit

sudo netstat -lpn

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04
Something like
swapoff -a
fallocate 4G /swapfile
mkswap /swapfile
swapon /swapfile

jaderabbit

sudo netstat -lpn

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04
Something like
swapoff -a
fallocate 4G /swapfile
mkswap /swapfile
swapon /swapfile

jaderabbit

JAVA_HOME=...
SPARK_HOME=...
SPARK_SCALA_VERSION=...

jaderabbit

psql -e \copy (select * from py_killer) to /tmp/eat_me_numpy.csv

jaderabbit

pg_restore -v -U dev -W -d kalories_galore -n public -O ./muffin.dmp

jaderabbit

grep -lr --exclude-dir=".git" -e "oldword" . | xargs sed -i "s/oldword/newword/g"