Monthly Archives: December 2009

SQL Pagination Without OFFSET

Just thought I’d look up how people paginate efficiently in SQLite since, apparently, OFFSET is just an alias for “discard N first results”. The recommended solution is to use a WHERE clause to mimic offset using the same column index … Continue reading

Posted in Web Wandering & Opinion | Leave a comment

Functional Programming Concepts for the Lay Programmer – Part 1

Update: Part 2 is finally available. Despite the growing interest in functional programming, most people (myself included) seem to have a lot of trouble grasping the core concepts and constructs. (Probably because the early adopters are all, to some extent, … Continue reading

Posted in Geek Stuff | 1 Comment