Case Insensitive Sort with SQLObject
The key to case-insensitive search is to sort by the lowercase or uppercase of the sorting column.
SELECT * FROM songs ORDER BY lower(name)
from sqlobject.sqlbuilder import func
print list(Songs.select(orderBy=func.lower(Songs.q.name)))
Handy Google Analytics Regular Expression Tester
A lot of web analytics work has come my way at my job, so I’ve had to delve deeper into various useful resources like Google Analytics Conversion University. Conversion University doesn’t have a great tutorial on how the regular expression filter functions.
Regular expressions are hard enough to write with debugging, nearly impossible without. Thankfully, the Google Analytics Regular Expression Filter tester is a useful tool.
O'Reilly book has a great PhoneGap tutorial
The draft of a new O’Reilly book titled iPhone Apps with HTML, CSS, and JavaScript is in the works.
Chapter 7, titled “Going Native” contains a wonderful introduction to PhoneGap. This is an excellent starting point for those of you interested in using PhoneGap or simply understanding what PhoneGap is.