Skip to content

Instantly share code, notes, and snippets.

@bioinfornatics
bioinfornatics / bench_parquet_sqlite_raw.py
Last active Mar 19, 2020
bench parquet vs sqlite vs raw
View bench_parquet_sqlite_raw.py
#!/usr/bin/env python3
import sqlite3
import random
import string
from uuid import uuid4
from typing import List, Tuple
from statistics import mean
import pyarrow as pa
import pyarrow.parquet as pq
@bioinfornatics
bioinfornatics / bencher_sqlite_raw.py
Created Mar 17, 2020
bencher sqlite, raw text, others…
View bencher_sqlite_raw.py
#!/usr/bin/env python3
import sqlite3
import random
import string
from uuid import uuid4
from typing import List
from statistics import mean
def random_str():
str_length = random.randint(40,50)
@bioinfornatics
bioinfornatics / pyarrow_learning.py
Last active Mar 17, 2020
pyarrow write 2D list into table
View pyarrow_learning.py
#!/usr/bin/env python3
import pyarrow.parquet as pq
import pyarrow as pa
import random
import string
from uuid import uuid4
def random_str():
str_length = random.randint(40,50)
return ''.join(random.choice(string.ascii_lowercase) for _ in range(str_length))
View write_perf_db_txt.py
#!/usr/bin/env python3
import sqlite3
import random
import string
from uuid import uuid4
from typing import List
from statistics import mean
def random_str():
str_length = random.randint(40,50)
View CDSIM.5.2.user.js
// ==UserScript==
// @name CDSIM
// @description CENTER DRIVEN's Combat Simulator and Combat Stats Fork
// @author XDAAST.XDaast.daltondaast.KingCrimson | Thanks to Topper42, Eferz98, KRS_L, PythEch, MrHIDEn, Panavia2, Deyhak, CodeEcho, Matthias Fuchs, Enceladus, TheLuminary, Da Xue, Quor, WildKatana, Peluski17, Eistee
// @version 5.2
// @namespace http*://*.alliances.commandandconquer.com/*/index.aspx*
// @include http*://*.alliances.commandandconquer.com/*/index.aspx*
// @icon https://www.openmerchantaccount.com/img/cdCNCTALOGObigger.png
// @updateURL https://userscripts.org/scripts/source/173566.meta.js
// @downloadURL https://userscripts.org/scripts/source/173566.user.js
View computeMatrixDiag
#!/usrbin/env python
def getMaxRowLength( matrix ):
maxLen = 0
for i in matrix:
if len(i) > maxLen:
maxLen = len(i)
return maxLen
def computeDiag( matrix, i , j ):
View bench.pl
#!/usr/bin/env perl
use strict;
use warnings;
use 5.010;
use List::MoreUtils qw(uniq);
#use Data::Dumper::Names;
use Benchmark qw(:all) ;
sub test1 {
my @tab = (["12","25","2","18","9","25","18","30","30","12","30","30","18","12"],["154","12","56","8","22","88","74","12","56","32","88","88","56","12","12","56"]);
View test.pl
#!/usr/bin/env perl
use strict;
use warnings;
use 5.010;
use List::MoreUtils qw(uniq);
use Data::Dumper::Names;
my @tab = (["12","25","2","18","9","25","18","30","30","12","30","30","18","12"],["154","12","56","8","22","88","74","12","56","32","88","88","56","12","12","56"]);
print "=============Before=============\n";
View gist:2024722
$ diff runtime/phobos/std/regex.d ../phobos/std/regex.d
184c184
< $(WEB http://unicode.org/reports/tr18/, UTS 18). Specifically:
---
> $(WEB unicode.org/reports/tr18/, UTS 18). Specifically:
5560a5561,5564
> static if(direction == OneShot.Fwd)
> startPc = startPc;
> else
> startPc = cast(uint)re.ir.length-IRL!(IR.LookbehindEnd);
View gist:1974263
import std.string;
import std.stdio;
import std.range;
import std.lowercase;
mixin template delegates( alias instance, methods... ){
static if( methods.length > 0 ){
static if( hasmembers(instance, methods[0]) ){
alias ReturnType!(methods[0]) type; // function/method type returned for first method