pgsql: restoring a db is not so straight forward
winning command psql -Uemail_warehouse emails < /home/warehouse_2021-10-12-15.19.54.sql you need to edit pg_hba.conf #local all all peer local all all […]
Category: uncategorized
james altucher: 742 - stoicism vs absurdism
concepts stoicism absurdism taoism budism
data aggregation concepts
apache spark databricks hadoop
alltime favorite songs (in no specific order)
cortez the killer (neil young), dave matthews with warren haynes on central park in my life (the beatles), dave matthews cover […]
mysql: populate column with autoincrement values
SET @my_increment := 0; UPDATE linkedin_companies_to_analyze SET id = @my_increment := @my_increment + 1 ORDER BY date_created;
python: execute function on remote file through ssh.
os.system('ssh USER@REMOTE_IP python3 /PATH/TO/REMOTE/FILE.py ARGUMENT') note than the argument i'm using is 1 (as a random character, you can […]
python: import remote file as module
the 'dumb' solution i found was to download the module from the remote server, importing and deleting. i'm doing this on […]