Skip to content

Instantly share code, notes, and snippets.

View metaskills's full-sized avatar
🐙
Being Inkcellent to Each Other

Ken Collins metaskills

🐙
Being Inkcellent to Each Other
354 followers · 14 following
View GitHub Profile
@metaskills
metaskills / gist:540999
Created August 20, 2010 19:50
# encoding: utf-8
require 'odbc'
require 'odbc_utf8'
GC.disable
module ODBC
class Statement
def finished?
@sstephenson
sstephenson / sam.el
Created August 29, 2010 20:57
(global-set-key (kbd "M-s") 'save-buffer)
(global-set-key (kbd "M-z") 'undo)
(global-set-key (kbd "<escape>") 'hippie-expand)
(set-face-font 'default "-apple-inconsolata-medium-r-normal--13-0-72-72-m-0-iso10646-1")
(add-to-list 'default-frame-alist '(width . 100))
(add-to-list 'default-frame-alist '(height . 45))
(setq-default tab-width 2)
@metaskills
metaskills / gist:559402
Created August 31, 2010 17:35
Setting Up A Local Port Repo:
http://journal.bitshaker.com/articles/2007/10/20/install-old-versions-of-ports-using-macports/
http://trac.macports.org/wiki/howto/InstallingOlderPort
1) Add this to /opt/local/etc/macports/sources.conf
file:///Users/kencollins/Repositories/ports [nosync]
2) mkdir /Users/kencollins/Repositories/ports
@metaskills
metaskills / gist:562465
Created September 2, 2010 15:55
Topic.columns_hash['written_on'].sql_type # => "datetime"
Topic.columns_hash['bonus_time'].sql_type # => "time"
Topic.columns_hash['last_read'].sql_type # => "date"
Topic.count # => 4
data = Topic.connection.send(:select,"SELECT `topics`.* FROM `topics`")
row = data[0]
row['written_on'] # => 2003-07-16 10:28:11 UTC
row['written_on'].class # => Time
@metaskills
metaskills / gist:605209
Created September 30, 2010 19:53
# result = @client.execute('SELECT 1 AS [one]')
# result.cancel
# result.cancel
write.c:136:tds_put_string converting 17 bytes of "SELECT 1 AS [one]"
write.c:164:tds_put_string wrote 34 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
@metaskills
metaskills / gist:621473
Created October 12, 2010 00:42
[datetime] => SYBDATETIME
61 1753-01-01T00:00:00.000 y:1753, m:1, d:1 h:0, m:0, s:0 MS:0 tz:1550134876
62 9999-12-31T23:59:59.997 y:9999, m:12, d:31 h:23, m:59, s:59 MS:997 tz:1550134876
63 2010-01-01T12:34:56.123 y:2010, m:1, d:1 h:12, m:34, s:56 MS:123 tz:1744847616
[smalldatetime] => SYBDATETIME4
231 1901-01-01T15:45:00.000Z days:365 minutes:945 (since 1/1/1900, since midnight)
232 2078-06-05T04:20:00.000Z days:65169 minutes:260 "
[datetime2_7] => SYBCHAR
71 0001-01-01T00:00:00.0000000Z 0001-01-01 00:00:00.0000000
@metaskills
metaskills / datedebug.rb
Created October 12, 2010 00:43
Time.utc(1999, 12, 30, 23, 45, 00, 123000).strftime("%L") # => "123"
Time.utc(1999, 12, 30, 23, 45, 00, 123000).strftime("%3N") # => "123" millisecond (3 digits)
Time.utc(1999, 12, 30, 23, 45, 00, 123000).strftime("%6N") # => "123000" microsecond (6 digits)
Time.utc(1999, 12, 30, 23, 45, 00, 123000).strftime("%9N") # => "123000000" nanosecond (9 digits)
Time.utc(1999, 12, 30, 23, 45, 00, 123000).to_f # => 946597500.123
Time.utc(1999, 12, 30, 23, 45, 00, 123000).usec # => 123000
require 'date'
require 'rational'
@ebryn
ebryn / query_mysql.rb
Created October 20, 2010 04:40
ejb-mbp2:activerecord-sqlserver-adapter ebryn$ ruby test/benchmark/query_sqlserver.rb
-- create_table(:test_benchmarks, {:force=>true})
-> 0.0715s
Query Sqlserver
===============
Author: Erik Bryn
Date: October 19, 2010
Summary: Benchmark SQL Server Queries
System Information
@metaskills
metaskills / gist:649413
Created October 27, 2010 16:39
# Using MacPort libs for all RVM rubie installs.
export CC='/usr/bin/gcc-4.2'
export CFLAGS='-O2 -arch x86_64'
export LDFLAGS='-L/opt/local/lib'
export CPPFLAGS='-I/opt/local/include'
rvm install saidrubie -C --with-opt-dir=/opt/local
@cowboy
cowboy / HEY-YOU.md
Last active April 9, 2024 15:54
jQuery Tiny Pub/Sub: A really, really, REALLY tiny pub/sub implementation for jQuery.