memcached is not persistent, redis is, therefore, redis is more persistent than memcached.
The framework the example app is built in provides a (poor) database library, and that is the method for building SQL queries (I've since moved on to PDO's parameterized queries).