Desenvolvimento, utilidades

Utilidades

FTP/SFTP

  Criar FTP/SFTP Mac
    http://osxdaily.com/2011/09/29/start-an-ftp-or-sftp-server-in-mac-os-x-lion/

  Habilitar ZSH Ubuntu
    apt-get install zsh
    echo "DEBIAN_PREVENT_KEYBOARD_CHANGES=yes" >> ~/.zshenv
    
  SSHFS Ubuntu
    Instalar: 
      sudo apt install sshfs
    Montar diretório remoto:
      sshfs user@ip:/ /path_mount_dir
   

CSV

• Remover coluna CSV

  cut -d, -f2,3 input.csv > out.csv // Remove a primeira coluna de um CSV e salva em out.csv

• Importar CSV para MySQL

LOAD DATA LOCAL INFILE '/path/file.csv' 
	INTO TABLE table_name    
    FIELDS TERMINATED BY '\t' ENCLOSED BY '\b' LINES TERMINATED BY '\n' IGNORE 1 LINES 
    (id, column1, column2);

HABILITAR DEBUG PELO CONSOLE

export XDEBUG_CONFIG="idekey=PHPSTORM remote_host=192.168.15.24"
export PHP_IDE_CONFIG="serverName=Homestead"

https://medium.com/@michalisantoniou6/set-up-xdebug-with-homestead-phpstorm-and-php7-85b5ac8f0c79