dkobia

#!/bin/bash

# Description: Recursively moves and replaces conflicted Dropbox files keeping the newer one of each pair

# Usage: <script-name> - Shows what files would be moved and replaced but does not do any replacements
         <script-name> replace - Performs file replacements

# Based on: http://mechanicalscribe.com/notes/fix-dropbox-conflicts-automatically/
# Thx, http://stackoverflow.com/questions/20723868/batch-rename-dropbox-conflict-files

dkobia

Useful Links / Sources

PrestoDB Selects Doc

Housekeeping

change column type

ALTER TABLE logs.trades CHANGE recentprice price int;

dkobia

DigitalOcean Rails/Ubuntu/NGINX (16.04) Setup

1. Setup
2. Swapfile
3. NGINX
4. ElasticSearch
5. RVM
6. Rails
7. Postgres
8. Capistrano

dkobia

.git
.gitignore
/doc
.yardoc
coverage
jsdoc
/tmp
/log
Dockerfile
Dockerfile.prod

dkobia

FROM ruby:2.3.1
RUN apt-get update -qq && apt-get install -y build-essential libpq-dev nodejs

# Configuring main directory
RUN mkdir -p /app_name
WORKDIR /app_name

# Setting env up
ENV RAILS_ENV='production'
ENV RAKE_ENV='production'

dkobia

# This is just a cheat sheet:

# On production
sudo -u postgres pg_dump database | gzip -9 > database.sql.gz

# On local
scp -C production:~/database.sql.gz
dropdb database && createdb database
gunzip < database.sql.gz | psql database

dkobia

How to setup AWS lambda function to talk to the internet and VPC

I'm going to walk you through the steps for setting up a AWS Lambda to talk to the internet and a VPC. Let's dive in.

So it might be really unintuitive at first but lambda functions have three states.

1. No VPC, where it can talk openly to the web, but can't talk to any of your AWS services.
2. VPC, the default setting where the lambda function can talk to your AWS services but can't talk to the web.
3. VPC with NAT, The best of both worlds, AWS services and web.

dkobia

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

dkobia

Set Up DynamoDB

• Get DynamoDB

$ wget http://dynamodb-local.s3-website-us-west-2.amazonaws.com/dynamodb_local_latest.tar.gz

• Unzip

$ gunzip dynamodb_local_latest.tar.gz

dkobia

Get ClamAV running on Mac OS X (using Homebrew)

The easiest way to get the ClamAV package is using Homebrew

$ brew install clamav

Before trying to start the clamd process, you'll need a copy of the ClamAV databases.

Create a freshclam.conf file and configure as so