$ sudo su
$ apt-get update
$ apt-get install s3cmd automysqlbackup
$ s3cmd --configure
# enter access key and secret and other details
$ vim /etc/default/automysqlbackup
# Set these variables
# USERNAME
# PASSWORD
View ETL algorithm notes.txt
ironsource inventory reports CSV file for 2020-01-14 | |
can i process this file? | |
am i already processing an admob file? | |
am i processing a mopub config file? | |
download CSV file (FileImporter) | |
truncate stage table |
View select_dates_between_two_dates.sql
select * from | |
(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from | |
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, | |
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, | |
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, | |
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, | |
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v | |
where selected_date between '2018-07-01' and curdate() |
View finding_sidekiq_jobs.rb
# find them in a queue | |
queue = Sidekiq::Queue.new("default") | |
jobs = queue.map do |job| | |
if job.klass == '[JOB_CLASS]' | |
{job_id: job.jid, job_klass: job.klass, arguments: job.args} | |
end | |
end.compact | |
# the retry queue | |
retries = Sidekiq::RetrySet.new.select |
View unity_stuff.cs
// find a game object in the active scene | |
using System.Linq; | |
GameObject worldGameObject = | |
GameObject.FindGameObjectsWithTag("World").ToList().Find(o => o.scene == activeScene); | |
if (worldGameObject != null) | |
{ | |
Debug.Log("SetTrigger: SceneExit" + worldGameObject.name); | |
worldGameObject.GetComponent<Animator>().SetTrigger("SceneExit"); | |
} | |
else |
View handle_and_retry_errors.rb
def my_fun | |
vals = [] | |
(1..5).each do |i| | |
puts "my_fun i=#{i}" | |
begin | |
handle_catchable_errors do | |
vals << unsafe_fun(i) | |
end | |
rescue KnownError => e |
View wait_until_done.sh
#!/bin/bash | |
# | |
# USAGE: wait_until_done PID | |
# | |
# wait_until_done watches a process passed in as the first argument waits until | |
# it finishes | |
# | |
# Print the header comment from this file, ducking the shebang line, and stopping a the first line that doesn't start with a hash | |
function print_header_comment { |
View idea64.exe.vmoptions
-server | |
-Xms2g | |
-Xmx2g | |
-Xss16m | |
-XX:+UseConcMarkSweepGC | |
-XX:+CMSParallelRemarkEnabled | |
-XX:ConcGCThreads=4 | |
-XX:ReservedCodeCacheSize=128m | |
-XX:+AlwaysPreTouch | |
-XX:+TieredCompilation |
View IntelliJ_IDEA__Perf_Tuning.txt
-server | |
-Xms2048m | |
-Xmx2048m | |
-XX:NewSize=512m | |
-XX:MaxNewSize=512m | |
-XX:PermSize=512m | |
-XX:MaxPermSize=512m | |
-XX:+UseParNewGC | |
-XX:ParallelGCThreads=4 | |
-XX:MaxTenuringThreshold=1 |
View INSTALL.md
View ruby-vagrant-provision.sh
#!/usr/bin/env bash | |
sudo locale-gen en_US.UTF-8 | |
sudo update-locale LANG=en_US.UTF-8 | |
sudo update-locale LC_ALL=en_US.UTF-8 | |
curl -sL https://deb.nodesource.com/setup_5.x | sudo -E bash - | |
sudo apt-get install -y build-essential git curl libxslt1-dev libxml2-dev libssl-dev nodejs | |
ln -s /usr/bin/nodejs /usr/bin/node |
NewerOlder