ssokolow

-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6

SELECT foo, bar, baz, quux FROM table
 WHERE oid NOT IN ( SELECT oid FROM table
                    ORDER BY title ASC LIMIT 50 )
 ORDER BY title ASC LIMIT 10

mz2

#import <Foundation/Foundation.h>


@interface NSArray (UniqueObjects)

-(NSArray*) uniqueObjects;

-(NSArray*) uniqueObjectsSortedUsingSelector: (SEL)comparator;

-(NSArray*) uniqueObjectsSortedUsingFunction: (NSInteger (*)(id, id, void *)) comparator  

jlindsey

- (void)writeData:(NSData *)data toOutputStream:(NSOutputStream *)stream {	
	dispatch_async(dispatch_get_current_queue(), ^(void){
		BOOL sent = NO;
		
		do {
			if (outputStreamReady) {
				outputStreamReady = NO;
				
				uint8_t *readBytes = (uint8_t *)[data bytes];
				int data_len = [data length];

kch

#!/usr/bin/ruby
# encoding: UTF-8

require 'rubygems'
require 'fsevent'
require 'shellwords'

class Time
  def age_in_seconds(now = Time.now)
    now - self

rpavlik

#!/usr/bin/ruby
#
# This script fixes /usr/local only.
#
# 6th January 2010:
#   Modified the script to just fix, rather than install. - rpavlik
#
# 30th March 2010:
#   Added a check to make sure user is in the staff group. This was a problem
#   for me, and I think it was due to me migrating my account over several

mathiasbynens

// Original code from http://www.blog.highub.com/mobile-2/a-fix-for-iphone-viewport-scale-bug/

var metas = document.getElementsByTagName('meta');
var i;
if (navigator.userAgent.match(/iPhone/i)) {
	for (i=0; i<metas.length; i++) {
		if (metas[i].name == "viewport") {
			metas[i].content = "width=device-width, minimum-scale=1.0, maximum-scale=1.0";
		}
	}

frr149

#pragma mark - Transparent Modal View
-(void) presentTransparentModalViewController: (UIViewController *) aViewController 
                                     animated: (BOOL) isAnimated 
                                    withAlpha: (CGFloat) anAlpha{
    
    self.transparentModalViewController = aViewController;
    UIView *view = aViewController.view;
    
    view.opaque = NO;
    view.alpha = anAlpha;

robertjpayne

#import <Foundation/Foundation.h>

@interface NSManagedObjectArchiver : NSObject

/*
 * Takes a NSManagedObject and converts it to a NSData archive - it traverses all relationships ( including circular ) and archives it
 */
+ (NSData *)archivedDataWithRootObject:(NSManagedObject *)pObject;

@end

xjones

//
//  TransitionController.h
//
//  Created by XJones on 11/25/11.
//

#import <UIKit/UIKit.h>

@interface TransitionController : UIViewController

jeffmccune

#! /bin/bash
#
# This script repairs Mac OS X site_ruby and ruby symbolic links if they are broken.
# For more information on this problem please see: http://openradar.appspot.com/9202152
#

set -e
set -u

timestamp=$(date +%s)