Akihiro Okuno choplin

choplin / projecteuler1.sql

Created May 19, 2011 12:38

Solution of Project Euler #1 with PostgreSQL

choplin / test_postgres_cube.sql

Created June 7, 2011 15:26

	CREATE TABLE t (
	id int
	,p cube
	);

	CREATE INDEX _idx_p ON t USING gist (p);

	INSERT INTO t VALUES (1, '(1,2,3)');

	EXPLAIN SELECT * FROM t WHERE p <@ '(0,0,0),(3,3,3)';

choplin / graph_traversal.sql

Created June 7, 2011 18:19

Better sql for "Neo4j v.s. MySQL" in http://www.slideshare.net/slidarko/graph-windycitydb2010

	DROP TABLE IF EXISTS t;
	CREATE TABLE t (
	id int PRIMARY KEY
	,adj int[]
	);

	CREATE INDEX _idx_adj on t USING gin (adj);

	INSERT INTO t VALUES
	(1, ARRAY[2,3,4,5])

choplin / mongo-sample.html

Created June 11, 2011 08:51

MongoDB JP 第４回勉強会のサンプルコード


	<html>
	<head>
	<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js"></script>
	<script type="text/javascript">
	$(function(){
	checkTweet();
	$('#input').submit(function(){
	var name = $('#name').val();
	var tweet = $('#tweet').val();

choplin / quickrun_config.vim

Created July 7, 2011 16:44

vim-quickrun config for psql

choplin / sieve_of_eratosthenes.sql

Created July 8, 2011 17:37

Implementation of Sieve of Eratosthenes by SQL(PostgreSQL)

	CREATE OR REPLACE FUNCTION sieve_of_eratosthenes(int) RETURNS SETOF int AS $$
	WITH RECURSIVE
	--数列を用意
	t1(n) AS (
	SELECT generate_series(2, $1)
	),
	t2 (n, i) AS (
	--初期化:2で割り切れない集合を作成
	SELECT
	n

choplin / surroud_fold_marker.vim

Created July 18, 2011 18:20

using surround.vim custom mapping (surrounding with fold marker)

	let g:surround_custom_mapping.vim= {
	\'z': "\"{{{ \r \"}}}"
	\ }

choplin / gist:1261347

Created October 4, 2011 10:54

how to use _addSpecial command via c++ driver

	BSONObjBuilder b;
	b.append( "query", BSONObj() ); // append original BSON object of query
	b.append( "$maxScan", 1 ); // append special parameter

	auto_ptr<DBClientCursor> cursor = c.query( ns, Query(b.obj()) );

	while( cursor->more() ){
	BSONObj p = cursor->next();
	cout << p.toString() << endl;
	}

choplin / gist:1272045

Created October 8, 2011 08:57

choplin / vim-vcs-api-log

Created October 30, 2011 06:44

vcs.vim api-log plugin