if (err) { myLog("SQLITE error",err.stack); }

        db.execute("CREATE INDEX IF NOT EXISTS idx_created_at ON tweets ( created_at )", function(err) { if (err) { myLog("SQLITE error",err.stack); } });

    db.execute("CREATE TABLE IF NOT EXISTS tweet_refs ( id INTEGER PRIMARY KEY, from_id TEXT, to_id TEXT, ref_type TEXT )", function(err) { if (err) { myLog("SQLITE error",err.stack); } });

        function(err) { if (err) { myLog("SQLITE error",err.stack); } }

            if (err) { myLog("SQLITE error",err.stack); }

//    myLog("New tweets received");

}

function requestTwitter() {

    myLog("Requesting Twitter to track keyword(s): "+tracking_keyword);

    var req = https.request({

        host: "stream.twitter.com",

        path: "/1/statuses/filter.json",

        method: "POST",

        headers: {

            'Authorization': 'Basic ' + new Buffer( TWITTER_USER + ":" + TWITTER_PASS ).toString('base64'),

            'Content-Type': 'application/x-www-form-urlencoded'

        }

    }, function(res) {

        myLog('Reply from stream.twitter.com: ' + res.statusCode);

        myLog('Headers: ' + JSON.stringify(res.headers));

        res.setEncoding('utf8');

        res.on('data', callBackNewTweets);

        res.on('end', function() {

            myLog('End Twitter Connection — Trying to reconnect');

            requestTwitter();

        });

    });

    req.write('track=' + encodeURIComponent(tracking_keyword));

    req.socket.setTimeout(60000);

    req.socket.on('timeout', function() {

        myLog('TimeOut — Trying to reconnect');

        requestTwitter();

    });

    req.end();

        if (err) { myLog("SQLITE error",err.stack); }

        if (results[0].lastpos != lastpos) {

            lastpos = results[0].lastpos ? results[0].lastpos : 0;

//            myLog("Broadcasting last pos = ",lastpos);

            try {

                io.sockets.emit('tweetSummary', {

                    tweetcount : lastpos

                });

            } catch(err) {

                myLog("SOCKET.IO error while Broadcasting tweetSummary",err.stack);

            }

        }

    });

}

function getSendTweetPosByDate(date, socket) {

    db.execute("SELECT pos, created_at, ABS(created_at-" + date + ") AS dist FROM tweets ORDER BY dist ASC LIMIT 0,1", function (err, results) {

        if (err) { myLog("SQLITE error",err.stack); }

        if (results.length) {

            try {

                socket.emit('tweetPosByDate', {

                    tweetpos : results[0].pos,

                    date : results[0].created_at

                });

            } catch(err) {

                myLog("SOCKET.IO error while sending tweetPosByDate",err.stack);

            }

        }

function getSendLinkedTweets(pos, socket) {

    myLog("request for tweets linked to",pos);

    db.execute("SELECT A.pos pos_a, A.tweet_id id_a, A.json json_a, B.pos pos_b, B.tweet_id id_b, B.json json_b, ref_type FROM tweets A, tweets B, tweet_refs WHERE id_a = from_id AND id_b = to_id AND (pos_a = ? OR pos_b = ?)", [ pos, pos ], function(err, results) {

        if (err) { myLog("SQLITE error: ",err.stack); }

        var struct = {

            "tweetpos" : pos,

            "referencing" : [],

            "referenced_by" : []

        };

        for (var i in results) {

            if (results[i].pos_a == pos) {

                var tw = JSON.parse(results[i].json_b);

                tw.pos = results[i].pos_b;

                struct.referencing.push({

                    "tweet" : tw,

                    "ref_type" : results[i].ref_type

                });

            } else {

                var tw = JSON.parse(results[i].json_a);

                tw.pos = results[i].pos_a;

                struct.referenced_by.push({

                    "tweet" : tw,

                    "ref_type" : results[i].ref_type

                });

            }

        }

        try {

            socket.emit('linkedTweets', struct);

        } catch(err) {

            myLog("SOCKET.IO error while sending linkedTweets: ",err.stack);

        }

function getSendTweets(posList, socket) {

//    myLog("request for tweets ("+posList.join(',')+") from "+socket.id);

    db.execute("SELECT * FROM tweets WHERE pos IN ( " + posList.join(',') + " )", function (err, results) {

        if (err) { myLog("SQLITE error",err.stack); }

        try {

            socket.emit('tweets',

                results.map(function(line) {

                    var tw = JSON.parse(line.json);

                    tw.pos = line.pos;

                    return tw;

                })

            );

        } catch (err) {

            myLog("SOCKET.IO error while sending tweets",err.stack);

        }

    });

}

function getSendTimeline(data, socket) {

    myLog("request for timeline (",data.level, data.full,") from "+socket.id);

    var lvl = date_levels[data.level],

        + " FROM tweets GROUP BY tranche ORDER BY tranche DESC LIMIT 0," + ( data.full ? "50" : "1" );

        if (err) { myLog("SQLITE error",err.stack); }

        try {

            socket.emit('timeline', {

                "full" : data.full,

                "level" : data.level,

                "data" : tbl

            });

        } catch (err) {

            myLog("SOCKET.IO error while sending timeline",err.stack);

        }

        // Workaround for Unicode bug in socket.io.

        if (typeof object[key] == "string") {

            var tmp = '';

            for (var i = 0; i < object[key].length; i++) {

                tmp += ( object[key].charCodeAt(i) < 128 ? object[key].charAt(i) : "&#" + object[key].charCodeAt(i) + ";" );

            }

            object[key] = tmp;

        }