Skip to content

Instantly share code, notes, and snippets.

@serverhorror
serverhorror / gist:b6f6e464846d05003699
Last active March 2, 2022 17:32
PostgreSQL 8.4 COPY Comand
COPY (
SELECT
datname,
pg_database_size(datname),
pg_size_pretty(pg_database_size(datname))
FROM
pg_catalog.pg_database
WHERE
datistemplate=false and
datallowconn=true and
class userpackages (packages) {
# magic to get a list of packages that users want
# maybe fill the foreman API with simple inputs from a web page
# the verification would be wether the package is available in configured repositories...
package { $packages:
ensure => latest,
}
}
@serverhorror
serverhorror / new-installation.R
Created August 20, 2014 17:16
R Upgrade of Packages between versions
# Install bioConductor in your new R installation
source("http://bioconductor.org/biocLite.R")
chooseBioCmirror()
biocLite()
# install missing R packages for bioConductor
load("installed_old.rda")
tmp <- installed.packages()
installedpkgs.new <- as.vector(tmp[is.na(tmp[,"Priority"]), 1])
missing <- setdiff(installedpkgs, installedpkgs.new)
easyblock = "MakeCp"
name = "vcflib"
version = "0.1-20150507"
homepage = "https://github.com/ekg/vcflib"
description = "a simple C++ library for parsing and manipulating VCF files, + many command-line utilities"
# You will need to git clone --recursive https://github.com/ekg/vcflib.git
# and then create an archive from that
sources = ['%(name)s-%(version)s.tar.gz']
$ time R --no-save --no-restore
R version 3.2.0 (2015-04-16) -- "Full of Ingredients"
Copyright (C) 2015 The R Foundation for Statistical Computing
Platform: x86_64-unknown-linux-gnu (64-bit)
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
FROM fedora:22
MAINTAINER Daniel Gerlach
COPY example_speedseq_install.sh ....
RUN example_spee.....
diff --git a/Makefile b/Makefile
index 0c59ef0..dd9570f 100644
--- a/Makefile
+++ b/Makefile
@@ -25,20 +25,6 @@ homer2 homer getMappableRegions makeTagDirectory getPeakTags makeUCSCfile getDif
$(COMPILER) analyzeHiC.o SeqTag.o Motif2.o Clustering.o Hashtable.o statistics.o $(LIBRARIES) $(DEBUG) -o analyzeHiC
$(COMPILER) getGenomeCorrelation.o SeqTag.o Motif2.o Clustering.o Hashtable.o statistics.o $(LIBRARIES) $(DEBUG) -o getGenomeTilingPeaks
$(COMPILER) homer2.o Motif2.o Hashtable.o statistics.o $(LIBRARIES) $(DEBUG) -o homer2
- cp findPeaks ../bin/
- cp mergePeaks ../bin/
# Go! Why don't you use my version?
## WRONG: go run -ldflags="-X commonFlagTest.version='my-uber-version'" cmd/flagtest/main.go -version
go run -ldflags="-X github.com/serverhorror/commonFlagTest.versionString='$(TZ=UTC date '+%FT%T.%N%:z')'" cmd/flagtest/main.go -version
loglevel= "DEBUG"
#defaultEntryPoints = ["http", "https"]
defaultEntryPoints = ["http"]
[web]
address = ":8181"
[entryPoints]
[entryPoints.http]
address = ":8080"
--- table.column is a primary key in table
--- othertable.column references table.column
waiting_locktype | relation
waiting_table | gene
waiting_query | explain SELECT * FROM table WHERE column LIKE 'value%'
| ;
waiting_mode | AccessShareLock
waiting_pid | 25971
other_locktype | relation