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

mtigas

Client-side SSL

For excessively paranoid client authentication.

---

Updated Apr 5 2019:

because this is a gist from 2011 that people stumble into and maybe you should AES instead of 3DES in the year of our lord 2019.

some other notes:

jed

            DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE
                    Version 2, December 2004

 Copyright (C) 2011 Jed Schmidt <http://jed.is>

 Everyone is permitted to copy and distribute verbatim or modified
 copies of this license document, and changing it is allowed as long
 as the name is changed.

            DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE

willurd

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

springmeyer

'use strict';

var path = require('path');
var fontnik = require('../');
var Benchmark = require('benchmark');

var opensans = path.resolve(__dirname + '/../fonts/open-sans/OpenSans-Regular.ttf');

var suite = new Benchmark.Suite();

magnetikonline

AWS Elastic Beanstalk deploy user restricted IAM policy

An IAM user policy document to give minimal rights for deploying an Elastic Beanstalk application.

Where:

• REGION: AWS region.
• ACCOUNT_ID: AWS account ID.
• APPLICATION_NAME: Desired target Elastic Beanstalk application name(space).
• IAM_INSTANCE_PROFILE_ROLE: The instance profile (IAM role) Elastic Beanstalk EC2 instaces will run under.

sam-github

echo-server-epoll
echo-server-poll
talk
talk.dSYM

64

// Generated by https://gist.github.com/64/8ac13019f4faa491018aab6b5c265141
extern crate libc;
use libc::c_int;

pub const AEPHK_F_AEP_CTRL: c_int = 100;
pub const AEPHK_F_AEP_FINISH: c_int = 101;
pub const AEPHK_F_AEP_GET_CONNECTION: c_int = 102;
pub const AEPHK_F_AEP_INIT: c_int = 103;
pub const AEPHK_F_AEP_MOD_EXP: c_int = 104;
pub const AEPHK_F_AEP_MOD_EXP_CRT: c_int = 105;