benders

// Finds unused indexes in a mysql database

SELECT
  t.TABLE_SCHEMA,
  t.TABLE_NAME,
  s.INDEX_NAME,
  s.COLUMN_NAME,
  s.SEQ_IN_INDEX,
  ( SELECT MAX(SEQ_IN_INDEX)
    FROM INFORMATION_SCHEMA.STATISTICS s2

djq

#!/bin/bash
#
# Install Postgres 9.1, PostGIS 2.0 and pgRouting on a clean Ubuntu 12.04 install (64 bit)
# updated to PostGIS 2.0.1

# basics
apt-get install python-software-properties
apt-add-repository ppa:sharpie/for-science  # To get GEOS 3.3.3

# install the following pacakages

bshamric

var fs = require('fs');

//this is the path that QTNetwork classes uses for caching files for it's http client
//the path should be the one that has 16 folders labeled 0,1,2,3,...,F
exports.cachePath = '/path/to/phantomjs/cache/data/folder';

//this is the extension used for files in the cache path
exports.cacheExtension = "d";

//the resources that are to be saved

jacobian

import sys
import collections
import gridfs
import io
import psycopg2
import pymongo
import random
import time

# For fairness use the same chunk size - 512k.

mikermcneil

module.exports = {
  
  /**
   *
   * Using raw socket.io functionality from a Sails.js controller
   *
   */ 
   
  index: function (req,res) {

zivc

(function(){
var log = console.log;

console.log = function(str) {
	var css = 'background: linear-gradient(to right, red, yellow, lime, aqua, blue, fuchsia, red); color: white; font-weight: bold;';
	var args = Array.prototype.slice.call(arguments);
	args[0] = '%c' + args[0];
	args.splice(1,0,css);
	
	var speech = new SpeechSynthesisUtterance();

bitifet

// Handy plv8 console object (debugging)
var console = (function(){
    var columns = 100;
    function logString(level, str) {
        var chunk = str.substring(0, columns);
        var overflow = str.substring(columns);
        plv8.elog(level, chunk);
        if (overflow.length) logString(level, " | "+overflow);
    };

bitifet

/* public.plv8_startup()
 *
 *      Allow to have multiple per-schema plv8_init functions.
 *
 *   USAGE:
 *
 *      1. Add the following line to the end of your postgresql.conf file:
 *
 *          plv8.start_proc = 'public.plv8_startup'
 *

OlegIlyenko

In this gist I would like to describe an idea for GraphQL subscriptions. It was inspired by conversations about subscriptions in the GraphQL slack channel and different GH issues, like #89 and #411.

Conceptual Model

At the moment GraphQL allows 2 types of queries:

• query
• mutation

Reference implementation also adds the third type: subscription. It does not have any semantics yet, so here I would like to propose one possible semantics interpretation and the reasoning behind it.

clungzta

OpenUPS2 Install Linux

Step 1

Plug the device in, check the device connection

$ lsusb | grep "d005"