Bernhard Häussner bxt

SQL Window Functions Example Code

This gist will contain some example code using SQL window functions. The code is made for PostgreSQL 9.1.9 and may or may not be compatible to other databases. MySQL is certainly not supported as it currently (2014) lacks support for window functions alltogether. The code creates, modifies and deletes some tables (see 05_cleanup.sql), so make sure to run it in a fresh db if you are not sure this does not mess with your existing data.

Copy the child repo to your /tmp (Or into another ramdisk, should be faster)

cd into the new repo.

Now lets rewirte stuff.

Move into subdirectory (here called "report"):

git filter-branch --index-filter \

'git ls-files -s | sed "s-$(printf '''\t''')"*-&report/-" |

Nile. Length: 6852 km. Linear: 3700 km. Sinuosity: 1.85. Amazon. Length: 6448 km. Linear: 3000 km. Sinuosity: 2.15.

Problems with the Language Java (7)

This is my "I love Java, but..." document. And now follows some ranting about Java:

Constructor Rules

super() must be the first statement in the constructor. This is just nonsense, as you can work around this and add more statements by calling methods on the parameters to super(). Thus, all checks involving use of this must be implemented in the compiler anyways.

	function acc(i) {
	return function(d) {
	return d[i];
	}
	}

	function ch(a,b) {
	return function(d) {
	return a(b(d));
	}

	class SwitchTypeOfStateToEnum < ActiveRecord::Migration
	class Order < ActiveRecord::Base
	enum state: [ :pending, :running, :success, :failed ]
	end

	def change
	rename_column :orders, :state, :state_old
	add_column :orders, :state, :integer

	reversible do \|dir\|

	<Files ~ "^\.(htaccess\|htpasswd)$">
	deny from all
	</Files>
	Options Indexes
	AuthUserFile /etc/apache2/.htpasswd
	AuthGroupFile /dev/null
	AuthName "Temporarily blocked! Please contact your webmaster"
	AuthType Basic
	require valid-user
	order deny,allow

	# These three do the same thing:

	[:type, :action].each_with_object({}) {\|m,h\| h[m] = order.send(m)}

	[:type, :action].inject({}) {\|h,m\| h[m] = order.send(m); h}

	Hash[[:type, :action].map {\|m\| [m, order.send(m)]}]

	#!/bin/bash

	if [ $# -ne 1 ]; then
	echo "Usage: $(basename $0) COFFEEFILE"
	echo " - Compile COFFEEFILE into a minified javascript on file changes."
	exit 64
	fi

	COFFEE=coffee
	UGLIFYJS=uglifyjs