Skip to content

Instantly share code, notes, and snippets.

@yfuruyama
yfuruyama / fix2float.c
Created January 17, 2014 09:13
convert fixed point number to float point number
#include <stdio.h>
#include <math.h>
#define FIXED_BIT 12
float fix2float(unsigned short int n)
{
float ret = 0.0;
int integer_part;
int i;
@yfuruyama
yfuruyama / diff.py
Created February 19, 2014 15:44
diff
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import difflib
FILE1 = 'file1'
FILE2 = 'file2'
def main():
fh1 = open(FILE1, 'r')
@yfuruyama
yfuruyama / autocommit_performance.pl
Created April 13, 2014 15:29
Performance comparison between AutoCommit=on and AutoCommit=off with explicitly commit
#!/usr/bin/env perl
use strict;
use warnings;
use DBI;
use Time::HiRes qw(time);
# *** DDL ***
# CREATE TABLE `autocommit_test` (
@yfuruyama
yfuruyama / intrx.sql
Created April 17, 2014 14:44
[InnoDB] check if current thread is in transaction
DELIMITER //
CREATE PROCEDURE intrx()
BEGIN
SELECT COUNT(*) as in_trx FROM information_schema.innodb_trx WHERE trx_mysql_thread_id = (SELECT connection_id());
END;
//
DELIMITER ;
#!/usr/bin/env perl
use strict;
use warnings;
use Time::HiRes qw(time);
sub bench(&) {
my $start = time;
shift->();
DELIMITER //
CREATE PROCEDURE grouping(IN _sql varchar(128), IN _col varchar(32))
BEGIN
SET @sql =
CONCAT(
CONCAT(
CONCAT(
CONCAT(
'SELECT @in := GROUP_CONCAT(t.',
// Playground - noun: a place where people can play
import Cocoa
var str = "Hello, playground"
println(str)
var foo = 1
var bar = 2
var baz = foo + bar
# For more information on configuration, see:
# * Official English Documentation: http://nginx.org/en/docs/
# * Official Russian Documentation: http://nginx.org/ru/docs/
user nobody nobody;
worker_processes 1;
error_log /var/log/nginx/error.log;
#error_log /var/log/nginx/error.log notice;
#error_log /var/log/nginx/error.log info;
defmodule EchoServer do
def accept(port) do
{:ok, sock} = :gen_tcp.listen(port, [:binary, packet: :line, active: false, reuseaddr: true])
loop_accept(sock)
end
defp loop_accept(sock) do
{:ok, client} = :gen_tcp.accept(sock)
serve(client)
loop_accept(sock)
defmodule ChatServer do
def accept(port) do
{:ok, sock} = :gen_tcp.listen(port, [:binary, packet: :line, active: false, reuseaddr: true])
loop_accept(sock, [])
end
defp loop_accept(sock, queue) do
{:ok, client} = :gen_tcp.accept(sock)
queue = queue ++ [client]
case queue do