Abe Burnett abeburnett

## Installation.md

      
              3 files
            
          
              89 forks
            
          
              96 comments
            
          
              356 stars
            
          
                albertbori
                / Installation.md
            
            
              Last active
              April 19, 2024 00:16
            
              
                Automatically disable Wifi when an Ethernet connection (cable) is plugged in on a Mac
              
          
    Overview

This is a bash script that will automatically turn your wifi off if you connect your computer to an ethernet connection and turn wifi back on when you unplug your ethernet cable/adapter. If you decide to turn wifi on for whatever reason, it will remember that choice. This was improvised from this mac hint to work with Yosemite, and without hard-coding the adapter names. It's supposed to support growl, but I didn't check that part. I did, however, add OSX notification center support. Feel free to fork and fix any issues you encounter.
Most the credit for these changes go to Dave Holland.
Requirements


Mac OSX 10+
Administrator privileges


## change_primary_key.md

      
              1 file
            
          
              30 forks
            
          
              34 comments
            
          
              215 stars
            
          
                scaryguy
                / change_primary_key.md
            
            
              Last active
              April 8, 2024 14:23
            
              
                How to change PRIMARY KEY of an existing PostgreSQL table?
              
          
    -- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;
-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

  
## postgres cheatsheet.md

      
              1 file
            
          
              158 forks
            
          
              9 comments
            
          
              388 stars
            
          
                apolloclark
                / postgres cheatsheet.md
            
            
              Last active
              March 7, 2024 13:53
            
              
                postgres cheatsheet
              
          
    Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.
Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/
https://help.ubuntu.com/community/PostgreSQL

  
## application.html.slim
doctype html
html
  head
    title My App
    meta name="viewport" content="width=device-width, initial-scale=1.0"
    = stylesheet_link_tag    "application", media: 'all', 'data-turbolinks-track' => true
    = javascript_include_tag "application", 'data-turbolinks-track' => true
    = csrf_meta_tags

  body

## gettoken_local.py
import requests

consumer_key = "YOUR_CONSUMER_KEY"
consumer_secret = "YOUR_CUSTOMER_SECRET"
username = "YOUR_USER_NAME"
password = "YOUR_PASSWORD"

payload = {
    'grant_type': 'password',
    'client_id': consumer_key,

## gist:3440492
<!DOCTYPE html>
<html>
	<head>
            <meta http-equiv="Content-Type"
                  content="text/html; charset=utf-8" />

	    <script src="jquery-1.7.2.min.js" ></script>
	    <script src="handlebars-1.0.0.beta.6.js" ></script>
	    <script src="underscore-min.js" ></script>
	    <script src="backbone-min.js" ></script>

## sqlite_blob.r
#' ## Storing R Objects in a SQLite Database

#' Two packages we are using. The first is the ```RSQLite``` which will be used to create and manage an in-memory SQLite database. The second is ```igraph``` which I will use to create and visualize a random network. Some of the work I do is on network simulation. I often don't know the metrics I need from a simulated network when it's created, so I want to be able to store the networks that are created so that I can go back later and analyze them.
library(RSQLite)
library(igraph)

#' Create a database in memory.
con <- dbConnect(SQLite(), ":memory:")

#' The table has two columns, an *id* column and a column called *graph* which is a **blob** type. This type just stores binary data.

## inputrc
"\e[A": history-search-backward
"\e[B": history-search-forward
set show-all-if-ambiguous on
set completion-ignore-case on

## r_oracle_jdbc_example1.R
# Set JAVA_HOME, set max. memory, and load rJava library
Sys.setenv(JAVA_HOME='/path/to/java_home')
options(java.parameters="-Xmx2g")
library(rJava)

# Output Java version
.jinit()
print(.jcall("java/lang/System", "S", "getProperty", "java.version"))

# Load RJDBC library

## rails-postgres-backbone-bootstrap-bootswatch
- Check rails version
$ rails -v

- To update rails
$ gem update rails

- Creating a new rails app using postgresql
$ mkdir rails_projects
$ cd rails_projects
$ rails new myapp --database=postgresql
	doctype html
	html
	head
	title My App
	meta name="viewport" content="width=device-width, initial-scale=1.0"
	= stylesheet_link_tag "application", media: 'all', 'data-turbolinks-track' => true
	= javascript_include_tag "application", 'data-turbolinks-track' => true
	= csrf_meta_tags

	body
	import requests

	consumer_key = "YOUR_CONSUMER_KEY"
	consumer_secret = "YOUR_CUSTOMER_SECRET"
	username = "YOUR_USER_NAME"
	password = "YOUR_PASSWORD"

	payload = {
	'grant_type': 'password',
	'client_id': consumer_key,
	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="Content-Type"
	content="text/html; charset=utf-8" />

	<script src="jquery-1.7.2.min.js" ></script>
	<script src="handlebars-1.0.0.beta.6.js" ></script>
	<script src="underscore-min.js" ></script>
	<script src="backbone-min.js" ></script>
	#' ## Storing R Objects in a SQLite Database

	#' Two packages we are using. The first is the ```RSQLite``` which will be used to create and manage an in-memory SQLite database. The second is ```igraph``` which I will use to create and visualize a random network. Some of the work I do is on network simulation. I often don't know the metrics I need from a simulated network when it's created, so I want to be able to store the networks that are created so that I can go back later and analyze them.
	library(RSQLite)
	library(igraph)

	#' Create a database in memory.
	con <- dbConnect(SQLite(), ":memory:")

	#' The table has two columns, an id column and a column called graph which is a blob type. This type just stores binary data.
	"\e[A": history-search-backward
	"\e[B": history-search-forward
	set show-all-if-ambiguous on
	set completion-ignore-case on
	# Set JAVA_HOME, set max. memory, and load rJava library
	Sys.setenv(JAVA_HOME='/path/to/java_home')
	options(java.parameters="-Xmx2g")
	library(rJava)

	# Output Java version
	.jinit()
	print(.jcall("java/lang/System", "S", "getProperty", "java.version"))

	# Load RJDBC library
	- Check rails version
	$ rails -v

	- To update rails
	$ gem update rails

	- Creating a new rails app using postgresql
	$ mkdir rails_projects
	$ cd rails_projects
	$ rails new myapp --database=postgresql