iver

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

iver

#
# CORS header support
#
# One way to use this is by placing it into a file called "global/cors.conf"
# under your Nginx configuration directory and placing the following
# statement inside your **location** block(s):
#
#   include global/cors.conf;
#
# As of Nginx 1.7.5, add_header supports an "always" parameter which

iver

spacemacs-keybindings

Ref: https://gist.github.com/rnwolf/e09ae9ad6d3ac759767d129d52cab1f1

Key Binding	Description
SPC	< space >
RET	< return >
C	< ctrl >
M	< alt >, M stands for Meta

iver

type below:

brew update
brew install redis

To have launchd start redis now and restart at login:

brew services start redis

iver

PSQL

Magic words:

$ psql -U postgres

or

$ sudo -u postgres psql

iver

pipeline:
  build:
    image: alpine
    commands:
      - echo "do something :v"
  slack:
    image: plugins/slack
    channel: dev__builds
    webhook: https://hooks.slack.com/services/...
    

iver

How to convert existing phoenix app to an umbrella app.
https://elixir-lang.slack.com/archives/phoenix/p1472921051000134


chrismccord [10:14 PM]  
@alanpeabody yes, it's straightforward

[10:14]  
1) mix new my_umbrella --umbrella

iver

Sorry if I don't put only the code here but the instructions says:

When writing this code, you can use any language you're comfortable with. 

* The code must be well tested ...
* ... documented if necessary
* ... treat the quality of the code as if it was ready to ship to production.

So, I think the best way to do that is using a git repository.

iver

Useful Spacemacs commands

• SPC q q - quit
• SPC w / - split window vertically
• SPC w - - split window horizontally
• SPC 1 - switch to window 1
• SPC 2 - switch to window 2
• SPC w c - delete current window
• SPC TAB - switch to previous buffer
• SPC b b - switch buffers

iver

NOTES: After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work. The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0."

Database files have to be updated before starting the server, here are the steps that had to be followed:

• Need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default

brew unlink postgresql
brew install postgresql@9.6
brew unlink postgresql@9.6