{FHSM} - Fumbling the web

May 02

Dependency based boot sequence

In older versions of debian you could use update-rc.d to remove auto-start services. Now insserv is used to change the boot sequence. To remove a service do:

sudo insserv -r <service>

Sep 10

Watch Clojure episodes on blip.tv

Sep 09

PostgreSQL: Documentation: Manuals: PostgreSQL 9.0: Window Functions

Sep 08

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 items by item ID and then calculating an average value of the prices. Normally this would return the “avg” column with the average price for that item in every row. By adding the distinct requirement you limit it to just one row per item ID. 

Jul 31

SymPy -

Symbolic math library for python

Jul 21

TheNewBoston – Free Educational Video Tutorials on Computer Programming and More! » Tutorials -

Short video tutorials on a wide range of topics

Jul 17

25 Apache Performance Tuning Tips at SysAdmin Tips and Tools

Jul 14

Functional Programming with Collections — Building Skills in Python

Jul 13

Data Driven Programming in Haskell (Part 1) | Entirely Subjective

Jul 10

Examples/How-to’s | easyXDM -

how to make easy json cross domain requests (ex disqus)