egatjens

Get results as JSON

select array_to_json(array_agg(row_to_json(t)))
    from (
        SELECT id, interaction_id, comment_id, created_at, state FROM ugc_permissions 
		WHERE EXTRACT(MONTH FROM created_at) IN (8,9)
		AND EXTRACT(YEAR FROM created_at) = 2017
		ORDER BY created_at ASC
    ) t

egatjens

Setup sendmail

Prefix all commands with 'sudo'

1. Install prerequisites

$ apt-get install sendmail mailutils

2. Configure hosts file correctly:

egatjens

Create bootable linux distro

diskutil list
diskutil unmountDisk /dev/disk#
sudo dd if=/path/to/linux_iso of=/dev/disk# bs=1m
# or for debian
$ sudo dd if=/path/to/linux_iso of=/dev/disk# bs=4M; sync 
# Wait till finished
# Ctrl + T for status updates.

egatjens

Homebrew, use multiple database versions

Install versions

brew install [email protected]
brew install postgresql@10

Commands

egatjens

Steps to configure Google Credentials for LiFT Google Integration

Navigate to https://console.cloud.google.com/apis/credentials

Create a project

1 - Fill in the name.

2 - Select the organization. i.e "myOrg.io"

egatjens

brew install wrk

wrk -t12 -c400 -d10s http://localhost:8081/reservations

• 12 is the number of threads we will use.
• 400 the number of concurrent connections

egatjens

Demystifying Docker Volumes for Mac and PC Users

1. Docker runs on a Linux kernel

Docker can be confusing to PC and Windows users because many tutorials on that topic assume you're using a Linux machine.

As a Linux user, you learn that Volumes are stored in a part of the host filesystem managed by Docker, and that is /var/lib/docker/volumes. When you're running Docker on a Windows or Mac OS machine, you will read the same documentation and instructions but feel frustrated as that path don't exist on your system. This simple note is my answer to that.

When you use Docker on a Windows PC, you're typically doing one of these two things:

• Run Linux containers in a full Linux VM (what Docker typically does today)