Gavin Hackeling gavinmh

## psql.md

      
              1 file
            
          
              8 forks
            
          
              1 comment
            
          
              45 stars
            
          
                cimmanon
                / psql.md
            
            
              Created
              May 2, 2017 17:22
            
              
                PostgreSQL cheat sheet for MySQL users
              
          
    I use PostgreSQL via the psql client.  If you use a different client (eg. pgAdmin, etc.), I don't know how much will translate over.
One nice difference between psql and mysql (cli) is that if you press CTRL+C, it won't exit the client.
User administration

Login as superuser (via shell)

psql -U postgres

  
## pg-pong.py
""" Trains an agent with (stochastic) Policy Gradients on Pong. Uses OpenAI Gym. """
import numpy as np
import cPickle as pickle
import gym

# hyperparameters
H = 200 # number of hidden layer neurons
batch_size = 10 # every how many episodes to do a param update?
learning_rate = 1e-4
gamma = 0.99 # discount factor for reward

## naive_summarizer
# -*- coding: utf-8 *-*

'''
The following is a naive, unsupervised text summarizer.
It extracts N of the text's most salient sentences.
Salience is defined as the average of the tf-idf weights of the words in a sentence.
'''
from nltk import sent_tokenize, word_tokenize
from collections import Counter
from math import log10

## lda_gibbs.py
"""
(C) Mathieu Blondel - 2010
License: BSD 3 clause

Implementation of the collapsed Gibbs sampler for
Latent Dirichlet Allocation, as described in

Finding scientifc topics (Griffiths and Steyvers)
"""
	""" Trains an agent with (stochastic) Policy Gradients on Pong. Uses OpenAI Gym. """
	import numpy as np
	import cPickle as pickle
	import gym

	# hyperparameters
	H = 200 # number of hidden layer neurons
	batch_size = 10 # every how many episodes to do a param update?
	learning_rate = 1e-4
	gamma = 0.99 # discount factor for reward
	# -- coding: utf-8 -*

	'''
	The following is a naive, unsupervised text summarizer.
	It extracts N of the text's most salient sentences.
	Salience is defined as the average of the tf-idf weights of the words in a sentence.
	'''
	from nltk import sent_tokenize, word_tokenize
	from collections import Counter
	from math import log10
	"""
	(C) Mathieu Blondel - 2010
	License: BSD 3 clause

	Implementation of the collapsed Gibbs sampler for
	Latent Dirichlet Allocation, as described in

	Finding scientifc topics (Griffiths and Steyvers)
	"""