Selecting random rows with SQLite

A quick and easy way to select 100 rows randomly from a sqlite database:

SELECT * FROM UserRules 
ORDER BY Random() 
LIMIT 100
Advertisements

SQLite Python Tutorial

Found a great tutorial for getting started with sqlite. Versions of Python over 2.5 have sqlite included automatically, so no additional installations this time, for a change 🙂

Check out SQLite Python Tutorial at zetcode.com.