klenwell information services : CocktailNapkin2008

2008 Cocktail Napkin

Current Napkin

mysql: value in one table not another
SELECT somecol FROM a WHERE somecol NOT IN ( SELECT somecol FROM b )

CREATE TABLE db2.table LIKE db1.table; 
INSERT INTO db2.table SELECT * FROM db1.table;

in defense of public works projects
cakephp form "multiple models": Form Helper Data Validation Models bakery article teknoid tips
waves 11/5 in oside: 1 2 3
Sample cron.d file
http://forum.notebookreview.com/showthread.php?t=294364 order

HG: Add path to new repository:
# web server paths
# virtual/path (http:/domain/name = /real/path)
test     = /home/klenwell/root/tmp/hgtest
new_repo = /path/to/repo

style = gitweb
contact = admin@email.com
description = mercurial repositories
name = central repository

photos that actually make me want to travel again
python re:
    result = re.search(pattern, subject, re.S).groups()[0]
    return result
except Exception, e:
    return False

logrotate: http://linux.about.com/od/commands/l/blcmdl8_logrota.htm http://www.linux.com/articles/48390
For some twenty years, politicians of both parties have been using free-market rhetoric as a cover for favors to big campaign contributors.
linux autostop: ps aux | grep 'foo' | awk '{print $2}' | xargs kill -9
junk fees
js __file__
os for old machines
python nltk link grammar parser
2nd Amendment as Foreign Policy Issue
Against Darwinism
columbo 2.0
Google Lively (for sonnet monkeys?)
Handling Flash Crowds from your Garage
AVG alternatives: clamwin avast
linux kernel map
To Do: take a charge in the break room
BBC Spanish free language lessons
I'll have to check this out when I get home: http://icanhaslolpron.com
Google wiki
bad housing news: calculatedrisk sdhpi Case-Shiller
/. troll of the day and riposte
A[HREF*="myspace.com"]:after { content: " [BRAIN DAMAGE WARNING]"!important ; color: red } (source)
steampunk web (almost literally)
.hg extensions:
# Enable the 'glog' graphical log extension
hgext.graphlog =

# Enable CVS style variable substitution
hgext.keyword =

python dates and times (I'm always forgetting this crap):
import datetime, time
print datetime.datetime.now()    # current local datetime
print time.time()     # unix timestamp

simulation argument
a pythonic tribute to xkcd: xkcd = lambda x,k,c,d: (({k:False},d,c)[int(''.join([str(int(k in t)) for t in [c,d]]),2)])[k] or x
more django: modelforms forms
rent or buy: http://www.nytimes.com/2008/05/28/business/28leonhardt.html calculator
google ajaxlibs (/.)
pointers (to the point)
500 Fonts all at once
leave it to Jesus 666
django forms django newforms django form validation django form tests (examples) django forms wizard
scripps 05.23: 1 2 3
http://code.google.com/p/google-app-engine-samples/wiki/GoogleAppEngineSamples djangoforms model keys
lots of data (courtesy of my alma mater)
querying gapp
sessions: datastore class appcaching
words for groups of animals
klenwell @ google app engine links to good gapp tips
php debug
Project Alia
free as in beer beer
no plastic surgery!
on fonts: fontstruct the prophecy
stupid lambda tricks: in_dict_list = lambda dic, k, v: v in [d[k] for d in dic]
steampunk == tomorrowland 1998
google app engine scaling with gae a review python in gae gApp on ubuntu gApp example code
komodo js api
AI Winter is over
http://www.gnu.org/software/diction/ http://www.link.cs.cmu.edu/link/ overview tests wikipedia
pidgin (nice home page)
the sitcom (./) | Berners-Lee on Web
shoutcast streams see also vlc
/. life lessons: if arrested...
John McCain ad hominem
HTML entities
Simon-Ehrlich Wager Krugman
removing a file from a python repo without deleting use hg rm -A (e.g. hg rm -A dir/*)
oc baby names
komodo edit saving preference file
igoogle API
Yahoo Analytics (IndexTools)
cakephp cache benchmark

# cron.d file
# to activate, link to /etc/cron.d: ln -s <path>/fname.cron /etc/cron.d/link_name

# +---------------- minute (0 - 59)
# |  +------------- hour (0 - 23)
# |  |  +---------- day of month (1 - 31)
# |  |  |  +------- month (1 - 12)
# |  |  |  |  +---- day of week (0 - 6) (Sunday=0 or 7)
# |  |  |  |  |
# M  H DM MO DW        USER       SCRIPT

the commodities bubble
oss binary blobs
emacs: customize manual tour
a mighty daemon
simple text summarizer simple search engine
ny times: wall st. sleaze some guy who wrote a program to write 200,000 books
cakephp: shared core setup app-indy lib plugins
<a href="http://mushpup.org/">pw</a>: m{d/u}l11
python encoding: nutshell unicode tutorial
python on web: modpython zope google webapp
google app engine
vim: marks and jumps
PHP PCRE Issue: cause cause bugs.php.net a solution
Moby Project Roget's
unix cheat sheet
vostro 1400
rent v. buy bloomberg mortgage calculator
Garfield - Garfield = Existential Humor
Cool Dingbats: bittbox.com
Tivo for Radio: excellent tutorial streamripper (windows or linux)
OS Flash Dev: MTASC flashdevelop.org game dev
CakePhp config: multiple apps on single site admin subdomain
SSL on Debian Apache2: ilovett.com debian-administration.org
Goodbye Cruel Word: Hello, lyx!
Fun with apache logs: set-up parsing archiving logs scp man