Skip to content

Instantly share code, notes, and snippets.

@EspadaV8
EspadaV8 / extract.sql
Created November 20, 2012 10:13
iOS6 SQLite to CSV
SELECT [0],
h.id,
m.date + 978307020000,
CASE m.is_from_me
WHEN 0 THEN 1
WHEN 1 THEN 2
END AS type,
NULL,
m.text,
NULL,
@EspadaV8
EspadaV8 / Readable.js
Created February 16, 2012 23:59
TuxRadar create HTML audio tag
(function() {
function getScript(url,success){
var script=document.createElement('script');
script.src=url;
var head=document.getElementsByTagName('head')[0],
done=false;
// Attach handlers for all browsers
script.onload = script.onreadystatechange = function() {
if ( !done && (!this.readyState
|| this.readyState == 'loaded'
@EspadaV8
EspadaV8 / install-latest-node.sh
Last active August 29, 2015 14:06
Install lastest node on debian
#!/bin/sh
aptitude install checkinstall build-essential
wget -N http://nodejs.org/dist/node-latest.tar.gz
tar xzvf node-latest.tar.gz
cd `ls -1|sort -r|head -1`
./configure
sudo fakeroot checkinstall -y --install=no --pkgversion $(echo $(pwd) | sed -n -re's/.+node-v(.+)$/\1/p') make -j$(($(nproc)+1)) install
sudo dpkg -i node_*