To install Perl Image::Magick on Ubuntu

apt-get install perlmagick

Easy!

Reference

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

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)))