This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
# | |
# Check that the ssh-agent is running, and if not, kick it off | |
# | |
if [[ -z $SSH_AUTH_SOCK ]]; then | |
SOCKETFILE="${HOME}/.ssh/ssh-agent.socket" | |
else | |
SOCKETFILE=${SSH_AUTH_SOCK} | |
fi |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# built after/while reading: http://en.gentoo-wiki.com/wiki/Screen | |
defscrollback 500 | |
screen -t work 0 | |
screen -t work 9 | |
screen -t work 8 | |
screen -t work 7 | |
screen -t work 6 | |
screen -t work 5 | |
screen -t work 4 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
A Complaint About Skytools: | |
Greetings, | |
I don't know what the problem is, but I'd like to lodge an official complaint | |
about SkyTools: | |
everything is just working, and has been working for months now. | |
What have you people done to my software? Surely you have the time to |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
begin; | |
select count(*) | |
from actions | |
where item_type='Story' | |
and item_published_at is not null; | |
select count(distinct(item_id)) | |
from actions | |
where item_type='Story' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Returns the current ID of a table's sequence. | |
def last_insert_id(table, sequence_name) #:nodoc: | |
Integer(select_value("SELECT currval('#{sequence_name}')")) | |
end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
outsidein_production=# select p.coordinates && r.shape from places p, regions r where p.id=13963 and r.id=322; | |
?column? | |
---------- | |
t | |
(1 row) | |
outsidein_production=# select p.coordinates && r.shape from places p, regions r where p.id=13963 and r.id=28545; | |
?column? | |
---------- | |
t |