Skip to content

Instantly share code, notes, and snippets.

View erikdubbelboer's full-sized avatar

Erik Dubbelboer erikdubbelboer

View GitHub Profile
var mysql = require('mysql'); // npm install mysql@2.0.0-alpha7
var client = mysql.createConnection({
"host" : "127.0.0.1",
"port" : 3306,
"user" : "user",
"password": "password",
"database": ""
});

Keybase proof

I hereby claim:

  • I am erikdubbelboer on github.
  • I am erikdubbelboer (https://keybase.io/erikdubbelboer) on keybase.
  • I have a public key whose fingerprint is A88D 9578 C2CB C1D2 9F33 B036 50EB FD5E DAB6 324F

To claim this, I am signing this object:

@erikdubbelboer
erikdubbelboer / gist:f20ef392607203fb591e
Created August 29, 2014 18:50
Sort a csv in python using limited memory
import os
import csv
import json
import heapq
def sortCSV(infile, column, reverse, cast):
outfiles = []
if reverse:
@erikdubbelboer
erikdubbelboer / binlogfix.sh
Created March 16, 2015 06:44
Run binlogfix on all tags without taking away too much cpu from normal jobs
#!/bin/bash
renice -n 19 $$ >&2
for tag in `ddfs ls | grep -- -[ico]1- | sort -k 3n -t '-'`; do
while true; do
if [[ `ps ax | grep python | wc -l` -lt 20 ]]; then
break
fi
sleep 2
@erikdubbelboer
erikdubbelboer / client.go
Created March 22, 2015 07:52
Testing UDP packet loss
package main
import (
"encoding/binary"
"log"
"net"
"time"
)
func main() {
@erikdubbelboer
erikdubbelboer / memory.go
Created April 6, 2015 13:40
Get memory usage in Go
func memory() string {
runtime.GC()
var m runtime.MemStats
runtime.ReadMemStats(&m)
units := []string{
"B", "KB", "MB", "GB", "TB", "PB", "EB", "ZB", "YB",
}
@erikdubbelboer
erikdubbelboer / proxy.py
Last active August 29, 2015 14:23
Atomx api proxy
try:
from BaseHTTPServer import HTTPServer, BaseHTTPRequestHandler
from SocketServer import ThreadingMixIn
import urllib2
except ImportError:
from http.server import HTTPServer, BaseHTTPRequestHandler
from socketserver import ThreadingMixIn
from urllib import request
@erikdubbelboer
erikdubbelboer / chromebug.html
Created May 27, 2011 11:08
Element doesn't render after setting float: none (can still click and hover over the element)
<!DOCTYPE html>
<html lang=nl>
<head>
<meta charset=utf-8>
<title>Chrome float bug</title>
<style>
.tabs ul {
list-style-type: none;
}
#! /bin/sh
### BEGIN INIT INFO
# Provides: redis-server
# Required-Start: $syslog
# Required-Stop: $syslog
# Should-Start: $local_fs
# Should-Stop: $local_fs
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: redis-server - Persistent key-value db
@erikdubbelboer
erikdubbelboer / gist:1106441
Created July 26, 2011 10:18
Nodejs base64 crypto bug?
var crypto = require('crypto');
var origtoken = '128073137281613|2.AQDnAjjO73ESnmhJ.3611.1311634811.2-3306278|i3L2dgZ7rg6m2vKt0GzjhhKbzTQ';
var algo = 'des-ecb'; // openssl list-cipher-commands to list available algos
var key = 'appelsap';
var base = 'base64'; // changing this to 'hex' makes it work
var tokencrypt = crypto.createCipher(algo, key);