bhtucker

bhtucker

bhtucker

import psycopg2
from contextlib import closing

"""
Demonstrate that contextmanagers for closing and committing don't play well together without autocommit

Only the noclosing function can run without error
"""

bhtucker

"""
Upsert gist

Requires at least postgres 9.5 and sqlalchemy 1.1

Initial state:

[]
Initial upsert:

bhtucker

bhtucker

"""
Implementation of the example from https://inst.eecs.berkeley.edu/~cs61c/fa14/projs/02/
"""
import operator

class Puzzle(object):
    """General game representation"""
    def solution(self):
        return Position(0)

bhtucker

"""
Demo of using Hogwild algorthim for parallel learning with shared memory
Uses sklearn's LogisticRegression for accuracy comparison

Output
('initial accuracy:', 0.45333333333333331)
worker 25974 score 0.93
worker 25975 score 0.92
worker 25976 score 0.88
worker 25974 score 0.94

bhtucker

bhtucker

create materialized view ladder as (
with
	match_points as (
		select 
			case ... end as aff_points,
			case ... end as neg_points,
			aff_id,
			neg_id
		),

bhtucker