herrbuerger

## postgres-cheatsheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                herrbuerger
                / postgres-cheatsheet.md
            
            
              Created
              December 8, 2016 15:25
                — forked from Kartones/postgres-cheatsheet.md
            
              
                PostgreSQL command line cheatsheet
              
          
    PSQL

Magic words:
psql -U postgres
If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).
Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

  
## _euclidean.c
#include <Python.h>
#include <numpy/arrayobject.h>
#include "euclidean.h"

/* Docstrings */
static char module_docstring[] =
    "This module provides an interface for calculating squared euclidean distance";
static char euclidean_docstring[] =
    "Calculate the squared euclidean distance of two 128-dimensional vectors";


## gist:35707b81f063b0c53aaa851b23d2f15d
### Keybase proof

I hereby claim:

  * I am herrbuerger on github.
  * I am herrbuerger (https://keybase.io/herrbuerger) on keybase.
  * I have a public key ASDehSwsfC_aKN2WUeEHyWdANSMW8ppk7RjIDs8tFXekTQo

To claim this, I am signing this object:

## README
0 - Read http://blog.databigbang.com/running-your-own-anonymous-rotating-proxies/
1 - Install monit, haproxy, tor and delegated.
2 - Setup your environment in the setup.rb file
3 - Just run > ruby setup.rb
4 - ...........
5 - PROFIT! > http://www.southparkstudios.com/clips/151040/the-underpants-business
	#include <Python.h>
	#include <numpy/arrayobject.h>
	#include "euclidean.h"

	/* Docstrings */
	static char module_docstring[] =
	"This module provides an interface for calculating squared euclidean distance";
	static char euclidean_docstring[] =
	"Calculate the squared euclidean distance of two 128-dimensional vectors";
	### Keybase proof

	I hereby claim:

	* I am herrbuerger on github.
	* I am herrbuerger (https://keybase.io/herrbuerger) on keybase.
	* I have a public key ASDehSwsfC_aKN2WUeEHyWdANSMW8ppk7RjIDs8tFXekTQo

	To claim this, I am signing this object:
	0 - Read http://blog.databigbang.com/running-your-own-anonymous-rotating-proxies/
	1 - Install monit, haproxy, tor and delegated.
	2 - Setup your environment in the setup.rb file
	3 - Just run > ruby setup.rb
	4 - ...........
	5 - PROFIT! > http://www.southparkstudios.com/clips/151040/the-underpants-business