Luiz Fonseca luizfonseca

After spending many hours trying to get FreeTDS and unixodbc to run on a Mac OS X 10.8 system with the python module, pyodbc, I eventually came to this recipe, which is remarkably simple thanks to homebrew. I also found unixodbc was unnecessary and I couldn't get it to play well with FreeTDS, so this install does not include unixodbc. See also http://www.acloudtree.com/how-to-install-freetds-and-unixodbc-on-osx-using-homebrew-for-use-with-ruby-php-and-perl/ and http://www.cerebralmastication.com/2013/01/installing-debugging-odbc-on-mac-os-x/.

Prerequisites: Be sure you have XCode and the Commandline Tools for XCode installed from Apple. Also install homebrew followed with brew update and brew doctor.

Install FreeTDS:

brew install freetds

Test your install:

Change your database RDS instance security group to allow your machine to access it.
- Add your ip to the security group to acces the instance via Postgres.
Make a copy of the database using pg_dump
- $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
- you will be asked for postgressql password.
- a dump file(.sql) will be created
Restore that dump file to your local database.
- but you might need to drop the database and create it first
- $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>

the database is restored

Elixir tips

Editor

Atom editor.
atom-elixir package.

Style guide

The Elixir style guide.

	#!/bin/sh

	version="1.4.15"
	priority="10415"
	libevent="/usr/local/libevent/2.0.20-stable/"
	supervisordir="/etc/supervisord.d"

	# create user
	sudo groupadd memcached
	sudo useradd -r -g memcached -s /sbin/nologin -M -d /var/run/memcached memcached

	# TL;DR: YOU SHOULD DELETE THIS FILE
	#
	# This file was generated by Cucumber-Rails and is only here to get you a head start
	# These step definitions are thin wrappers around the Capybara/Webrat API that lets you
	# visit pages, interact with widgets and make assertions about page content.
	#
	# If you use these step definitions as basis for your features you will quickly end up
	# with features that are:
	#
	# * Hard to maintain


	public class SomeFragment extends Fragment {

	MapView mapView;
	GoogleMap map;

	@Override
	public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
	View v = inflater.inflate(R.layout.some_layout, container, false);

	# Original Rails controller and action
	class EmployeesController < ApplicationController
	def create
	@employee = Employee.new(employee_params)

	if @employee.save
	redirect_to @employee, notice: "Employee #{@employee.name} created"
	else
	render :new
	end

	export RUBY_HEAP_MIN_SLOTS=1250000
	export RUBY_HEAP_SLOTS_INCREMENT=100000
	export RUBY_HEAP_SLOTS_GROWTH_FACTOR=1
	export RUBY_GC_MALLOC_LIMIT=30000000
	export RUBY_HEAP_FREE_MIN=12500

	###########Bibliotecas########
	#se nao tiver instalada, e necessario usar o comando
	#install.packages("nome_da_biblioteca")
	library(tm)
	library(wordcloud)
	library(RColorBrewer)

	######################################
	#seta o folder de trabalho. é preciso passar o caminho completo até a pasta onde estao os dados
	setwd("/home/caminho/para/psta_local/dos_dados")