September 2011
3 posts
Watch Clojure episodes on blip.tv →
PostgreSQL: Documentation: Manuals: PostgreSQL... →
Window Functions for Average Price in SQL
If you’ve got a table of historical pricing information (Prices) where each item has a has an ID (not as in row primary key, but as in ISBN style ID) you can get the average price using a PostgreSQL window function.
SELECT DISTINCT ON (“id”) “id”, avg(“price”) OVER (PARTITION BY “id”) FROM “Prices”;
This works by grouping all the...
July 2011
8 posts
SymPy →
Symbolic math library for python
TheNewBoston – Free Educational Video Tutorials on... →
Short video tutorials on a wide range of topics
25 Apache Performance Tuning Tips at SysAdmin Tips... →
Functional Programming with Collections — Building... →
Data Driven Programming in Haskell (Part 1) |... →
Examples/How-to’s | easyXDM →
how to make easy json cross domain requests (ex disqus)
nicolas33/offlineimap at master - GitHub →
The Blackstag Blog Post # 5 -> Guide to... →
June 2011
2 posts
Khan Academy →
1 tag
Cool python trick
Neat introspection trick in python, found here
import sys
def caller_lineno(): return sys._getframe(1).f_lineno
def caller_filename(): return sys._getframe(1).f_code.co_filename
February 2011
11 posts
MIT OpenCourseWare | Electrical Engineering and... →
Why do I need a personal VPN? | WiTopia.Net →
Statistical Data Mining Tutorials →
smallfsm.js at master from greim's smallfsm -... →
Web Development - Tuts+ Marketplace →
Web Typography Tutorial – Lesson 1 | Webmonkey |... →
Pandoc - About pandoc →
JavaScript Garden →
PyBrain →
Videos from Strange Loop 2010, 14th-15th October... →
YouTube - Introduction to Monads - Adam Smyczek →
January 2011
5 posts
Clever Algorithms →
NOSQL Databases →
LSI / LSA: Latent Semantic Indexing and Analysis,... →
DebuggingTutorial - winpdb - A tutorial for... →
Python vs. Ruby: A Battle to The Death →
December 2010
18 posts
Vector space model - Wikipedia, the free... →
pylint.vim - compiler plugin for python style... →
pyflakes.vim - PyFlakes on-the-fly Python code... →
Functional Programming HOWTO →
figleaf -- Python code coverage analysis →
Anatomy of a Python C Module · SuperJared.com →
from distutils.core import setup, Extension
pylint (analyzes Python source code looking for... →
The Tree Slider - GitHub →
GitHub shows how to change URLs and manage history / back button without causing the browser to do the normal window.location freakout
CompSci 101 - Big-O notation →
Python Unit Testing Framework →
Installation and quick start — nose v0.11.2... →
25.2. doctest — Test interactive Python examples —... →
twill: a simple scripting language for Web... →
Tools of the Modern Python Hacker: Virtualenv,... →
Attachment Tags | Web Design WordPress Function... →
MIT OpenCourseWare | Electrical Engineering and... →
Structure and Interpretation of Computer Programs →
FrontPage - Roundup Wiki →
November 2010
38 posts
Best Free Open Source Programming Ebooks →
Conrad Barski talking about "Common Lisp" and... →
Scala Language Tour on Vimeo →