Skip to content

Instantly share code, notes, and snippets.

View coneybeare's full-sized avatar

Matt Coneybeare coneybeare

121 followers · 12 following
View GitHub Profile
@coneybeare
coneybeare / gist:4531485
Created January 14, 2013 16:55
Using index_logs_on_cloud_log_id_and_deleted_at index: 71.417871316 seconds
EXPLAIN for: SELECT `logs`.* FROM `logs` INNER JOIN `cloud_logs` ON `cloud_logs`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` ON `client_application_versions`.`id` = `cloud_logs`.`client_application_version_id` INNER JOIN `client_applications` ON `client_applications`.`id` = `client_application_versions`.`client_application_id` INNER JOIN `cloud_logs` `cloud_logs_logs_join` ON `cloud_logs_logs_join`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` `client_application_versions_logs` ON `client_application_versions_logs`.`id` = `cloud_logs_logs_join`.`client_application_version_id` WHERE (logs.deleted_at IS NULL) AND (client_applications.account_id = 3) AND (client_applications.id = 5) AND (client_application_versions.id = 15) ORDER BY timestamp DESC LIMIT 100 OFFSET 0
+----+-------------+----------------------------------+--------+----------------------------------------------------------
@coneybeare
coneybeare / gist:4493304
Created January 9, 2013 14:00
EXPLAIN for: SELECT `logs`.* FROM `logs` INNER JOIN `cloud_logs` ON `cloud_logs`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` ON `client_application_versions`.`id` = `cloud_logs`.`client_application_version_id` INNER JOIN `client_applications` ON `client_applications`.`id` = `client_application_versions`.`client_application_id` INNER JOIN `cloud_logs` `cloud_logs_logs_join` ON `cloud_logs_logs_join`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` `client_application_versions_logs` ON `client_application_versions_logs`.`id` = `cloud_logs_logs_join`.`client_application_version_id` WHERE (logs.deleted_at IS NULL) AND (client_applications.account_id = '3') AND (client_applications.id = '5') AND (client_application_versions.id = '15') ORDER BY timestamp DESC LIMIT 100 OFFSET 0
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------+---------------------------------------------------+--------
@coneybeare
coneybeare / New Tweetbot Tweet
Created October 25, 2012 14:13
Global service to create a new Tweetbot tweet
on run {input, parameters}
tell application "Tweetbot"
activate
tell application "System Events" to keystroke "n" using command down
end tell
return input
end run
@coneybeare
coneybeare / giantuser.html
Last active October 7, 2015 14:27
Sample Signature
<style type="text/css">
a.link{margin:0;padding:0;border:none;text-decoration:none;}
</style>
<br />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="format-detection" content="telephone=no">
<table width='320' id="sig" cellspacing='0' cellpadding='0' border-spacing='0' style="width:320px;margin:0;padding:0;">
<tr>
@coneybeare
coneybeare / BriefInfoFace.mxml
Created July 16, 2012 01:37
Imports in BriefInfoFace.mxml
<?xml version="1.0" encoding="utf-8"?>
<mx:Canvas xmlns:mx="http://www.adobe.com/2006/mxml" width="100%" resize="onResize()" clipContent="true" backgroundColor="#f4f4f4" maxHeight="500" xmlns:ns1="*" initialize="init()" verticalScrollPolicy="off" horizontalScrollPolicy="off" xmlns:Faces="Faces.*" xmlns:ui="ui.*"
showInAutomationHierarchy="true" xmlns:[REDACTED]="com.[REDACTED].*" xmlns:ui1="com.[REDACTED].ui.*">
<mx:Style source="skins/main.css" />
<mx:Script>
<![CDATA[
import mx.core.FlexGlobals;
import com.[REDACTED].InfoUpdater;
import com.[REDACTED].PlaylistItemType;
import com.[REDACTED].generator.ListImageGenerator;
@coneybeare
coneybeare / dir_stucture.txt
Created July 14, 2012 20:12
output of: $ find src
Results of running: $ find src
--------------------------------
src
src/.actionScriptProperties
src/.DS_Store
src/.flexProperties
src/.fxpProperties
src/.project
src/.settings
src/.settings/com.adobe.flexbuilder.project.prefs
@coneybeare
coneybeare / gist:2652796
Created May 10, 2012 12:38
Raw html
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="chrome=1,IE=9" />
<meta charset="utf-8">
<link href="http://cloudfront.giantuser.com/assets/application-fdb826aa1314de46086c7d455b772800.css" media="all" rel="stylesheet" type="text/css" />
</head>
@coneybeare
coneybeare / gist:2652790
Created May 10, 2012 12:37
With premailer applied
<!DOCTYPE html>
<html lang="en" style="font-size: 100%; -webkit-text-size-adjust: 100%; -ms-text-size-adjust: 100%; color: #cccccc;">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="chrome=1,IE=9" />
<meta charset="utf-8">
</head>
@coneybeare
coneybeare / gemfile
Created February 16, 2012 23:55
source 'http://rubygems.org'
##############################
# Rails and DB
##############################
# gem 'rack', '1.2.1'
gem 'rails', '3.2.0'
group :assets do
gem 'sass-rails', " ~> 3.2.3"
@coneybeare
coneybeare / gist:1467428
Created December 12, 2011 14:22
Old AudioQueue Sample Code
/*
File: AudioPlayer.m
Version: 1.0
*/
#include <AudioToolbox/AudioToolbox.h>
#import "AudioQueueObject.h"