Naoki Shibayama nashibao

nashibao / blog4.sql

Last active November 30, 2016 14:22

blog4.sql

	SELECT hoge FROM a
	JOIN
	(SELECT fuga FROM b GROUP BY fuga) AS c
	ON a.hoge = c.fuga

nashibao / cf.coffee

Created April 9, 2017 06:56

crossfilter sample code

	data = [{fld1: 'type1', fld2: 10},...]
	cf = crossfilter(data)

	# create dimension
	dim1 = cf.dimension (d) -> return d.fld1
	dim2 = cf.dimension (d) -> return d.fld2

	# create group
	group = dim2.group (fld2) -> return fld2 % 5

nashibao / cf_filter.coffee

Created April 16, 2017 01:31

crossfilter filter function

	dim.filter([100, 200]) # range
	dim.filter(120) # equal
	dim.filter((d) -> return d % 2) # function

nashibao / crossfilter_performance.coffee

Created September 2, 2017 07:42

	process = require('process')

	_start = Date.now()
	_title = ""
	_mem = 0
	tic = (title) ->
	_title = title
	_start = Date.now()
	console.log(_title, '..');
	_mem = process.memoryUsage().heapUsed