Digging into Mobile Website Development

Looking into building out a mobile web experience. According to our Google Analytics stripped down mobile browsers outnumber smartphone browsers 6-to-1. Not surprising.

The NetFront Browser, typically found on Samsung phones, accounts for about 40% of our traffic. As such, I think this is the browser for which I want to optimize.

Resources:

Documentation – Designing Web Content for NetFront Browser
MobiForge.com – A Guide to Mobile Emulators
Access – ALP Development Suite for VMWare

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.