Skip to content

Instantly share code, notes, and snippets.

jonathan MERCIER bioinfornatics

Block or report user

Report or block bioinfornatics

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@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
You can’t perform that action at this time.