methane

from __future__ import print_function
import time

def query_10k(cur):
    t = time.time()
    for _ in range(10000):
        cur.execute("SELECT 1,2,3,4,5")
        res = cur.fetchall()
        assert len(res) == 1
        assert res[0] == (1,2,3,4,5)

sspecht

Eine kurze Dokumentation, wie man Postgres/Postgis unter Windows ohne Installation betreibt:

- PG-Binaries (ZIP) herunterladen und entpacken
  http://www.enterprisedb.com/products-services-training/pgbindownload

- Batch-Datei lt. Anhang bzw. lt. 
  http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html
  im Haupt-Verzeichnis speichern (das Verzeichnis, in dem /bin zu finden ist).

- Beim ERSTEN Start der run.bat muss die gekennzeichnete Zeile ausgeführt, danach aber wieder auskommentiert werden.

niyazpk

// Add / Update a key-value pair in the URL query parameters
function updateUrlParameter(uri, key, value) {
    // remove the hash part before operating on the uri
    var i = uri.indexOf('#');
    var hash = i === -1 ? ''  : uri.substr(i);
         uri = i === -1 ? uri : uri.substr(0, i);

    var re = new RegExp("([?&])" + key + "=.*?(&|$)", "i");
    var separator = uri.indexOf('?') !== -1 ? "&" : "?";
    if (uri.match(re)) {

mandiwise

// Reference: http://www.blackdogfoundry.com/blog/moving-repository-from-bitbucket-to-github/
// See also: http://www.paulund.co.uk/change-url-of-git-repository

$ cd $HOME/Code/repo-directory
$ git remote rename origin bitbucket
$ git remote add origin https://github.com/mandiwise/awesome-new-repo.git
$ git push origin master

$ git remote rm bitbucket

jpoehls

# http://caddyserver.com/download
	
http://localhost:8080 {
  startup php.cmd &
  fastcgi / 127.0.0.1:9123 php
}

anchetaWern

//Look for other responsivevoice instances
/*if (window.parent != null) {
    var iframes = window.parent.document.getElementsByTagName('iframe');
    for (var i = 0; i < iframes.length; i++) {
        //iframes[i].style.width = "300px"
    }
}*/

if (typeof responsiveVoice != 'undefined') {
    console.log('ResponsiveVoice already loaded');

protrolium

ffmpeg

Converting Audio into Different Formats / Sample Rates

Minimal example: transcode from MP3 to WMA:
ffmpeg -i input.mp3 output.wma

You can get the list of supported formats with:
ffmpeg -formats

You can get the list of installed codecs with:

nitaku

This experiment tries to define and show the concepts of intersection and difference between two word clouds.

Two distinct documents A and B (the first about infovis and datavis, and the other about Human-Computer Interaction) are each used to compute word frequencies. Each word in common between the two documents is then used to create the intersection set, in which each word is assigned the minimum value among its original weights (something reminiscent of a fuzzy intersection operation). The remaining words are used to create the difference sets. For each word in common, the set which had the greatest weight also retains that word with a weight subtracted of the intersection weight mentioned above. In pseudocode:

for each word in common between A and B
  let a_w be the weight of the word in A
  let b_w be the weight of the word in B
  put the word into the intersection set with weight = min(a_w, b_w)
  if a_w - min(a_w, b_w) > 0

put the word into the A \ B set with weigh

carlbergman

/**
 * Get values in range
 *
 * @param {String} rangeA1 The range in A1 notation
 *
 * @return {Array} array with non-filtered values
 */
function getValues (rangeA1) {

  // Get range

akaleeroy

Access phone storage over WiFi

Batch file to map your Android phone as network drive in Windows.

Requirements

• An Android phone
• WebDAV Server or WebDAV Server Ultimate
• WiFi router (PC and phone on the same network)