noma4i

  def point_in_polygon?(polygonPoints)
    return false if self.latitude.blank? or self.longitude.blank?
    polygonPoints.each do |point|
      point[0] = point[0].to_f
      point[1] = point[1].to_f
    end

    contains_point = false
    i = -1
    j = polygonPoints.size - 1

noma4i

Install with Homebrew

brew install redis

Set up launchctl to auto start redis

$ ln -sfv /usr/local/opt/redis/*.plist ~/Library/LaunchAgents

/usr/local/opt/redis/ is a symlink to /usr/local/Cellar/redis/x.y.z (e.g., 2.8.7)

noma4i

0.- Stop graphite-web

/etc/init.d/apache2 stop

1.- Backup SQLite db

export GRAPHITE_ROOT=/opt/graphite
PYTHONPATH=$GRAPHITE_ROOT/webapp django-admin.py dumpdata  --settings=graphite.settings -e contenttypes --natural > sqlite_graphite_dump.json

noma4i

require 'mina/bundler'
require 'mina/git'
require 'mina/rbenv'

set :domain, 'your_domain.com'
set :deploy_to, '/home/deployer/app_name'
set :repository, '[email protected]:user_name/app_name'
set :branch,  ENV["brunch"] || 'master'

set :app_name, "app_name"

noma4i

FROM rails:4.2.3

MAINTAINER Renato Filho <[email protected]>

ENV HOME /home/app
ENV RAILS_ENV development

RUN useradd -m -s /bin/bash app

RUN gem install -N bundler

noma4i

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), 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(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

noma4i

--
-- Read only 
--

-- Create a group
CREATE ROLE postgres_ro_group;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO postgres_ro_group;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres_ro_group;

noma4i

The code here is a tech demo showing how to switch between databases in Rails 5, in a thread-safe manner.

BACKGROUND: HOW NOT TO CHANGE DATABASES

The simple way to switch databases is:

ActiveRecord::Base.establish_connection :user_shard1
puts User.find(1) # this is executed on the database keyed on "user_shard1" in database.yml
ActiveRecord::Base.establish_connection :development

noma4i

require 'nokogiri'
require 'open-uri'

# Get a Nokogiri::HTML:Document for the page we're interested in...

doc = Nokogiri::HTML(open('http://www.google.com/search?q=tenderlove'))

# Do funky things with it using Nokogiri::XML::Node methods...

####

noma4i

require 'net/dns/resolver'

# Custom Domain
#
#   Require net-dns gem
#
#   A Rack middleware to to resolve the custom domain to original subdomain 
#   for your multi telent application.
#
#   It's all transperant to your application, it performs cname lookup and