==== 2008 Cocktail Napkin ====
[[SpecialCocktailNapkin Current Napkin]]

SpecialCakePhpModelTesting
mysql: value in one table not another
%%(mysql)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;%%
[[http://www.nytimes.com/2008/11/10/opinion/10krugman.html in defense of public works projects]]
cakephp form "multiple models": [[http://book.cakephp.org/view/189/Automagic-Form-Elements Form Helper]] [[http://book.cakephp.org/view/125/Data-Validation Data Validation]] [[http://book.cakephp.org/view/75/Saving-Your-Data Models]] [[http://bakery.cakephp.org/articles/view/improved-advance-validation-with-parameters bakery article]] [[http://teknoid.wordpress.com/2008/06/09/15-essential-cakephp-tips/ teknoid tips]]
waves 11/5 in oside: [[http://surfshot.s3.amazonaws.com/media/1/0/1043981-large.jpg 1]] [[http://surfshot.s3.amazonaws.com/media/1/0/1043975-large.jpg 2]] [[http://surfshot.s3.amazonaws.com/media/1/0/1043980-large.jpg 3]]
[[SpecialCrondSample Sample cron.d file]]
http://forum.notebookreview.com/showthread.php?t=294364 [[http://accessories.us.dell.com/sna/products/Motherboards/productdetail.aspx?c=us&l=en&s=bsd&cs=04&sku=TT359&mfgpid=192256&chassisid=8544#Overview order]]

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

[web]
style = gitweb
contact = admin@email.com
description = mercurial repositories
name = central repository
%%
http://bitchphd.blogspot.com/
[[http://www.nytimes.com/slideshow/2008/08/31/travel/0831-BIARRITZ_index.html photos that actually make me want to travel again]]
http://freakonomics.blogs.nytimes.com/2008/08/20/have-economic-debates-changed-since-1977/index.html?hp
http://garfield.nfshost.com/?s=lasagna&p=2
[[http://www.nytimes.com/2008/08/17/books/review/Donadio-t.html?8bu&emc=bu blurbs]]
python [[http://docs.python.org/lib/node46.html re]]:
%%(python)
try:
	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
[[http://www.newyorker.com/talk/comment/2008/07/28/080728taco_talk_cassidy 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: ""<tt>ps aux | grep 'foo' | awk '{print $2}' | xargs kill -9</tt>""
[[http://www.nytimes.com/2008/07/20/business/20debt.html?th&emc=th junk fees]]
[[http://www.faqts.com/knowledge_base/view.phtml/aid/30990/fid/53 js __file__]]
[[http://ask.slashdot.org/askslashdot/08/07/18/0046220.shtml os for old machines]]
[[http://nltk.sourceforge.net/index.php/Getting_Started python nltk]] [[http://www.abisource.org/projects/link-grammar/ link grammar parser]]
[[http://www.nytimes.com/2008/07/13/magazine/13officer-t.html?pagewanted=all 2nd Amendment as Foreign Policy Issue]]
[[http://judson.blogs.nytimes.com/2008/07/15/lets-get-rid-of-darwinism/index.html Against Darwinism]]
[[http://it.slashdot.org/comments.pl?sid=613269&cid=24182529 columbo 2.0]]
[[http://arstechnica.com/news.ars/post/20080708-hands-on-googles-lively-social-3d-world-is-20-percent-done.html Google Lively]] (for sonnet monkeys?)
[[http://tech.slashdot.org/article.pl?sid=08/07/08/0116238 Handling Flash Crowds from your Garage]]
AVG alternatives: [[http://www.clamwin.com/ clamwin]] [[http://www.avast.com/ avast]]
[[http://www.makelinux.net/kernel_map linux kernel map]]
To Do: take a charge in the break room
[[http://www.bbc.co.uk/languages/spanish/ BBC Spanish]] [[http://www.bravenewtraveler.com/2008/02/04/8-free-online-resources-for-learning-a-new-language/ free language lessons]]
I'll have to check this out when I get home: http://icanhaslolpron.com
[[http://sites.google.com/  Google wiki]]
http://www.worldcat.org/
bad housing news: [[http://calculatedrisk.blogspot.com/2008/03/real-case-shiller-house-price-index.html calculatedrisk]] [[http://sdhpi.blogspot.com/2008/05/is-this-bottom.html sdhpi]] [[http://en.wikipedia.org/wiki/Case-Shiller_index Case-Shiller]]
[[http://tech.slashdot.org/comments.pl?sid=592263&cid=23904759 /. troll of the day and riposte]]
""<tt>A[HREF*="myspace.com"]:after { content: " [BRAIN DAMAGE WARNING]"!important ; color: red }</tt>"" ([[http://tech.slashdot.org/comments.pl?sid=592263&cid=23904767 source]])
[[http://www.nytimes.com/2008/06/17/science/17mund.html steampunk web]] (almost literally)
.hg [[http://www.selenic.com/mercurial/wiki/index.cgi/UsingExtensions extensions]]: 
%%(python)
[extensions]
# Enable the 'glog' graphical log extension
hgext.graphlog = 

# Enable CVS style variable substitution
hgext.keyword =
%%
[[http://seehuhn.de/pages/pdate python dates and times]] (I'm always forgetting this crap):
%%(python)
import datetime, time
print datetime.datetime.now()    # current local datetime
print time.time()     # unix timestamp
%%
[[http://www.simulation-argument.com/classic.html simulation argument]]
a pythonic tribute to [[http://forums.xkcd.com/viewtopic.php?f=11&t=23249 xkcd]]: ""<code>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</code>""
more django: [[http://www.djangoproject.com/documentation/modelforms/ modelforms]] [[http://www.djangoproject.com/documentation/newforms/#modelmultiplechoicefield forms]]
rent or buy: http://www.nytimes.com/2008/05/28/business/28leonhardt.html [[http://www.nytimes.com/2007/04/10/business/2007_BUYRENT_GRAPHIC.html? calculator]]
[[http://en.wikipedia.org/wiki/Pitaya dragonfruit]]
[[http://code.google.com/apis/ajaxlibs/ google ajaxlibs]] ([[http://developers.slashdot.org/developers/08/05/28/144218.shtml /.]])
[[http://www.nytimes.com/2008/05/28/dining/28flavor.html flavor-tripping]]
[[http://home.netcom.com/~tjensen/ptr/ch1x.htm pointers]] (to the point)
[[http://www.fonts500.com/?page=1 500 Fonts]] [[http://thepiratebay.org/tor/3660252/500_Fonts_from_fonts500.com all at once]]
[[http://tech.slashdot.org/comments.pl?sid=565231&cid=23559299 leave it to Jesus 666]]
[[http://www.djangoproject.com/documentation/forms/ django forms]] [[http://www.djangoproject.com/documentation/newforms/ django newforms]] [[http://code.google.com/appengine/articles/djangoforms.html django form validation]] [[http://code.djangoproject.com/browser/django/trunk/tests/regressiontests/forms/widgets.py django form tests (examples)]] [[http://www.djangoproject.com/documentation/form_wizard/ django forms wizard]]
scripps 05.23: [[http://surfshot.s3.amazonaws.com/media/9/7/975364-large.jpg 1]] [[http://surfshot.s3.amazonaws.com/media/9/7/975363-large.jpg 2]] [[http://surfshot.s3.amazonaws.com/media/9/7/975370-large.jpg 3]]
http://code.google.com/p/google-app-engine-samples/wiki/GoogleAppEngineSamples [[http://groups.google.com/group/google-appengine/browse_frm/thread/d3673d0ec7ead0e2 djangoforms]] [[http://groups.google.com/group/google-appengine/browse_frm/thread/13d1f026d46bd35f model keys]]
[[http://archive.ics.uci.edu/ml/ lots of data]] (courtesy of my alma mater)
[[http://highscalability.com/how-i-learned-stop-worrying-and-love-using-lot-disk-space-scale querying gapp]]
http://img143.imageshack.us/img143/3660/fbooknb5.png
sessions: [[http://groups.google.com/group/google-appengine/browse_frm/thread/1c459b2ca7a6e643/2311877beffe0403?lnk=gst&q=session#2311877beffe0403 datastore]] [[http://groups.google.com/group/google-appengine/browse_frm/thread/f162c186c3e68f1a/1ea824e3bebd5801?lnk=gst&q=session#1ea824e3bebd5801 class]] [[http://code.google.com/appengine/docs/python/appcaching.html appcaching]]
[[http://entertainment.slashdot.org/comments.pl?sid=556912&cid=23461200 mythbuntu]]
[[http://www.rinkworks.com/words/collective.shtml words for groups of animals]]
[[http://kwap.appspot.com/ klenwell @ google app engine]] [[http://groups.google.com/group/google-appengine/browse_frm/thread/c9e8a906a88a8102 links to good gapp tips]]
[[http://us2.php.net/manual/en/function.debug-backtrace.php#72534 php debug]]
[[http://www.nytimes.com/2008/05/13/world/middleeast/13girls.html?_r=1&hp=&pagewanted=all Project Alia]]
[[http://entertainment.slashdot.org/entertainment/08/05/13/0316251.shtml free as in beer beer]]
[[http://www.msnbc.msn.com/id/23359042/from/ET/ no plastic surgery!]]
[[http://www.housingmaps.com/ housingmaps.com]]
on fonts: [[http://fontstruct.fontshop.com/ fontstruct]] [[http://www.sweeperscalendar.com/variorum/1129/ the prophecy]]
stupid lambda tricks: ""<code>in_dict_list = lambda dic, k, v: v in [d[k] for d in dic]</code>""
[[http://www.nytimes.com/2008/05/08/fashion/08PUNK.html?_r=1&oref=slogin steampunk]] ""=="" [[http://en.wikipedia.org/wiki/Tomorrowland#Tomorrowland_1998 tomorrowland 1998]]
[[http://code.google.com/appengine/docs/gettingstarted/ google app engine]] [[http://blog.wachob.com/2008/04/google-appengin.html scaling with gae]] [[http://perspectives.mvdirona.com/2008/04/21/GoogleApplicationEngine.aspx a review]] [[http://code.google.com/appengine/docs/python/purepython.html python in gae]] [[http://groups.google.com/group/google-appengine/browse_frm/thread/dc927ba00944027f gApp on ubuntu]] [[http://code.google.com/p/rietveld/source/browse gApp example code]]
[[http://aspn.activestate.com/ASPN/docs/Komodo/4.3/komodo-js-api.html komodo js api]]
[[http://en.wikipedia.org/wiki/AI_Winter AI Winter]] [[http://www.nytimes.com/2008/05/03/technology/03koller.html?th&emc=th is over]]
http://www.gnu.org/software/diction/ http://www.link.cs.cmu.edu/link/ [[http://alanhorkan.livejournal.com/16062.html overview]] [[http://papyr.com/hypertextbooks/grammar/gramchek.htm tests]] [[http://en.wikipedia.org/wiki/Grammar_checker wikipedia]]
[[http://pidgin.im/ pidgin]] (nice home page)
[[http://www.herecomeseverybody.org/2008/04/looking-for-the-mouse.html the sitcom]] [[http://tech.slashdot.org/tech/08/04/27/1422258.shtml (./)]] | [[http://tech.slashdot.org/article.pl?sid=08/04/30/1515229 Berners-Lee on Web]]
[[http://www.shoutcast.com/directory/index.phtml shoutcast streams]] see also [[http://lifehacker.com/384545/superior-alternatives-to-crappy-windows-software vlc]]
[[http://yro.slashdot.org/comments.pl?sid=537280&cid=23231314 /. life lessons: if arrested...]]
[[http://politics.slashdot.org/comments.pl?sid=228403&cid=18513137 John McCain ad hominem]]
[[http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references HTML entities]]
[[http://en.wikipedia.org/wiki/Simon-Ehrlich_wager Simon-Ehrlich Wager]] [[http://krugman.blogs.nytimes.com/2008/04/22/limits-to-growth-and-related-stuff/ Krugman]]
[[http://www.selenic.com/pipermail/mercurial/2007-April/012921.html removing a file from a python repo without deleting]] **use hg rm -A** (e.g. hg rm -A dir/*)
[[http://www.nytimes.com/2008/04/24/books/24garn.html?_r=1&th&emc=th&oref=slogin kleinzahler]]
[[http://www.ocfamily.com/t-FeatureStory_BabyNames_0408.aspx oc baby names]]
[[http://www.activestate.com/Products/komodo_ide/komodo_edit.mhtml komodo edit]] [[http://community.activestate.com/faq/komodo-file-locations saving preference file]]
[[http://code.google.com/apis/igoogle/ igoogle API]]
[[http://tech.slashdot.org/article.pl?sid=08/04/16/121225&from=rss Yahoo Analytics (IndexTools)]]
[[http://www.pseudocoder.com/archives/2007/02/27/cakephp-cache-performance/ cakephp cache benchmark]]

%%(bash)
# 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
%%

[[http://www.nytimes.com/2008/04/21/opinion/21krugman.html the commodities bubble]]
[[http://tech.slashdot.org/comments.pl?sid=526820&cid=23115228 oss binary blobs]]
emacs: [[http://www.google.com/search?q=customize+emacs+-scribd.com&hl=en&lr=&as_qdr=all&start=10&sa=N customize]] [[http://www.google.com/search?hl=en&lr=&as_qdr=all&q=+site:www.gnu.org+customize+emacs+-scribd.com manual]] [[http://www.gnu.org/software/emacs/tour/ tour]]
[[http://forums.xkcd.com/viewtopic.php?f=11&t=11935&st=0&sk=t&sd=a&start=440#p693630 a mighty daemon]]
[[http://w-shadow.com/blog/2008/04/12/simple-text-summarizer-in-php/ simple text summarizer]] [[http://www.symfony-project.org/askeet/1_0/21 simple search engine]]
ny times: [[http://www.nytimes.com/2008/04/13/business/13cash.html?th=&emc=th&pagewanted=all wall st. sleaze]] [[http://www.nytimes.com/2008/04/14/business/media/14link.html?th=&emc=th&pagewanted=all some guy who wrote a program to write 200,000 books]]
cakephp: [[http://book.cakephp.org/view/32/installation#advanced-installation-35 shared core setup]] [[http://bakery.cakephp.org/articles/view/maintaining-an-application-independant-code-library app-indy lib]] [[http://manual.cakephp.org/chapter/plugins plugins]]
[[http://bakery.cakephp.org/ <a href="http://mushpup.org/">pw</a>: m{d/u}l11]]
ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP [[http://dev.mysql.com/doc/refman/4.1/en/timestamp.html mysql.com]]
python encoding: [[http://mail.python.org/pipermail/python-list/2007-May/442985.html nutshell]] [[http://www.reportlab.com/i18n/python_unicode_tutorial.html unicode tutorial]]
python on web: [[http://www.modpython.org/ modpython]] [[http://www.zope.org/ zope]] [[http://code.google.com/appengine/docs/gettingstarted/ google webapp]]
[[http://code.google.com/appengine/docs/whatisgoogleappengine.html google app engine]]
vim: [[http://www.linux.com/articles/54159 marks and jumps]]
PHP PCRE Issue: [[http://us3.php.net/manual/en/ref.pcre.php#77790 cause]] [[http://www.phpinsider.com/smarty-forum/viewtopic.php?p=48604 cause]] [[http://bugs.php.net/bug.php?id=40846 bugs.php.net]] [[http://tracker.moodle.org/browse/MDL-11237?focusedCommentId=34538#action_34538 a solution]]
[[http://en.wikipedia.org/wiki/Moby_Project Moby Project]] [[http://www.nzdl.org/ELKB/download.html Roget's]]
[[http://cb.vu/unixtoolbox.xhtml unix cheat sheet]]
[[http://www.dell.com/content/products/productdetails.aspx/vostronb_1400?c=us&cs=04&l=en&s=bsd&~tab=bundlestab vostro 1400]]
[[http://www.interest.com/content/calculators/rentvsbuy.asp rent v. buy]] [[http://www.bloomberg.com/invest/calculators/mortgage.html bloomberg mortgage calculator]]
[[SpecialBCAA BCAA]]
[[http://garfieldminusgarfield.tumblr.com/ Garfield - Garfield = Existential Humor]]
Cool Dingbats: [[http://www.bittbox.com/fonts/dingbats-roundup-16-incredibly-detailed-useful-and-free-dingbat-fonts/ bittbox.com]]
Tivo for Radio: [[http://www.handcoding.com/archives/2005/03/20/ripping-npr-to-mp3-for-an-ipod/ excellent tutorial]] [[http://streamripper.sourceforge.net/ streamripper]] (windows or linux)
OS Flash Dev: [[http://www.mtasc.org/ MTASC]] [[http://www.flashdevelop.org/community/viewtopic.php?t=305 flashdevelop.org]] [[http://fgpwiki.corewatch.net/index.php/How_do_I_get_Started game dev]]
""CakePhp"" config: [[http://www.virtualapplicationserver.com/CakePHP_MultipleInstallNotes.html multiple apps on single site]] [[http://bakery.cakephp.org/articles/view/hosting-admin-urls-on-a-subdomain admin subdomain]]
SSL on Debian ""Apache2"": [[http://ilovett.com/blog/projects/installing-ssl-on-debian-apache2 ilovett.com]] [[http://www.debian-administration.org/articles/349 debian-administration.org]]
[[http://slashdot.org/article.pl?sid=08/01/06/1731247 Goodbye Cruel Word]]: Hello, [[http://www.lyx.org/ lyx]]!
Fun with apache logs: [[http://russell.dyerhouse.com/cgi-bin/article.cgi?article_id=82 set-up]] [[http://www.builderau.com.au/program/unix/soa/Managing-and-parsing-your-Apache-logs/0,339024638,320280756,00.htm parsing]] [[http://crazytoon.com/2007/05/31/apache-how-do-you-set-up-log-rotation-and-archiving-for-apache-logs/ archiving logs]] [[http://www.eos.ncsu.edu/remoteaccess/man/scp.html scp man]]