Dag-Arne Alnes dagaa

Simple COPY examples

Two simple examples of quickly loading data into PostgreSQL with the COPY command.

First, loading data to a database on your own computer in localhost.sh
Second, loading data to a database hosted on the Internet in cloud.sh

Much more sophisticated stuff is possible. Refer to the official docs and consider adopting a wrapper like django-postgres-copy for more complicated tasks.

Awesome PHP Libraries

A list of amazingly awesome PHP libraries that you should be using:

Composer/Packagist - A package and dependency manager.
Symfony2 - A framework comprised of individual components.
Zend Framework 2 - Another framework of individual components.
Symfony2 Components - The components that make Symfony2.
[Laravel] (https://github.com/laravel/laravel) - A PHP Framework
[Yii] (https://github.com/yiisoft/yii) - A PHP Framework

	#Do not include this file until your production certificate is working
	#This config Forcing ssl will prevent lets encrypt from verifying your domain
	#https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/https-singleinstance.html
	Resources:
	sslSecurityGroupIngress:
	Type: AWS::EC2::SecurityGroupIngress
	Properties:
	GroupId: {"Fn::GetAtt" : ["AWSEBSecurityGroup", "GroupId"]}
	IpProtocol: tcp
	ToPort: 443

	// transform cropper dataURI output to a Blob which Dropzone accepts
	function dataURItoBlob(dataURI) {
	var byteString = atob(dataURI.split(',')[1]);
	var ab = new ArrayBuffer(byteString.length);
	var ia = new Uint8Array(ab);
	for (var i = 0; i < byteString.length; i++) {
	ia[i] = byteString.charCodeAt(i);
	}
	return new Blob([ab], { type: 'image/jpeg' });
	}

	# Built-in web server since PHP 5.4

	In the command line set the path to the document root or where the code lies.

	$ cd ~/public_html
	$ php -S localhost:8000
	-------------------------------------------------------------------------------------------

	# Remove duplicate values from the array

	// derived from http://en.wikipedia.org/wiki/Algorithms_for_calculating_variance#Parallel_algorithm

	function map() {
	emit(1, // Or put a GROUP BY key here
	{sum: this.value, // the field you want stats for
	min: this.value,
	max: this.value,
	count:1,
	diff: 0, // M2,n: sum((val-mean)^2)
	});

	# GravitronShiftr
	#
	# just a simple test of ShinyCocos2d
	# i could get used to this

	class DemoScene < Cocos2D::Scene
	include Cocos2D

	def initialize
	@layer = Layer.new

	var average = arr => arr.reduce( ( p, c ) => p + c, 0 ) / arr.length;

	average( [ 1, 2, 3, 4, 5, 6, 7, 8, 9 ] );

	// 5