Skip to content

Instantly share code, notes, and snippets.

View yasu47b's full-sized avatar

yasu47b

6 followers · 9 following
View GitHub Profile
@yasu47b
yasu47b / README.md
Last active October 26, 2017 00:35
@yasu47b
yasu47b / iris.csv
Last active October 19, 2017 12:42
manipulate data with c3 and d3
sepal_length sepal_width petal_length petal_width class
5.1 3.5 1.4 0.2 Iris-setosa
4.9 3.0 1.4 0.2 Iris-setosa
4.7 3.2 1.3 0.2 Iris-setosa
4.6 3.1 1.5 0.2 Iris-setosa
5.0 3.6 1.4 0.2 Iris-setosa
5.4 3.9 1.7 0.4 Iris-setosa
4.6 3.4 1.4 0.3 Iris-setosa
5.0 3.4 1.5 0.2 Iris-setosa
4.4 2.9 1.4 0.2 Iris-setosa
@yasu47b
yasu47b / Perl文字コード.md
Created April 7, 2017 02:28

Unicode文字列の表示

\N{} を使う

perl -E 'say "\N{U+03a0}"'

pack を使う

@yasu47b
yasu47b / Postgresql関連.md
Created April 4, 2017 02:48

DBの実データサイズを調べる

SQLでデータベースのoidを確認し、データベースの実体が配置されているディレクトリの容量を調べる。

SQLによるoidの確認

select datid, datname from pg_stat_database

ディレクトリの容量を確認

@yasu47b
yasu47b / flatten.pl
Last active March 21, 2017 05:03
#!/usr/bin/env perl
use strict;
use warnings;
use v5.10;
my $arr = [[1,2,3],[4,5,[6,7,[8,9,[1,2,3]]]]];
my @arr = ([1,2,3],[4,5,[6,7,[8,9,[1,2,3]]]]);
sub flatten {
my $arg = @_ > 1 ? [@_] : shift;
@yasu47b
yasu47b / mojo_lite_excel_writer.pl
Last active March 16, 2017 05:10
Mojolciious Excel Writer sample
```
#!/usr/bin/env perl
use Mojolicious::Lite;
use Excel::Writer::XLSX;
use Cwd;
app->static->paths->[0] = getcwd;
# Documentation browser under "/perldoc"
plugin 'PODRenderer';
@yasu47b
yasu47b / How to extend LVM of Ubuntu in Virtualbox.md
Last active December 20, 2016 04:30

1. add disk or expand disk

1.1 add disk to VM from virtualbox manager

go 2.set LVM in VM

1.2 expand disk

set new partition

@yasu47b
yasu47b / sql_server.md
Created December 9, 2016 08:49

テーブル一覧を取得

select name from sysobjects where xtype = 'U
@yasu47b
yasu47b / zabbix 2.2 database.md
Last active December 1, 2016 09:14

登録テンプレートの確認

select * from hosts where status=3;
select hostid, host, name from hosts where status=3;

テンプレートのアイテムを確認

確認したいテンプレートのhostidが10105の場合

@yasu47b
yasu47b / DB2_EXPRESS.md
Last active November 25, 2016 02:55

Environment

  • CentOS 6.7
  • DB2 Express v10.5

Connection Setting

DB2 connection setting to allow external connection using TCP/IP.

# edit service file