Jordan Brough Stuff I found online.

10/GUI

Looking at Twitter’s Historical Trend Data

I think trends are one of the most interesting by-products of the Twitter revolution. It is so interesting to capture the collective minds of the world and collapse them down to ten terms. @karmadude and I have begun experimenting with Twitter’s historical trend data using their search API. We have a lot [...]

Selecting a Random Row From a SQL Database

There are plenty of ways to select random records from a database, here are a few simple statements that don’t require any advanced logic.
Select a random row with MySQL:
[snippet=11412]
Select a random row with PostgreSQL:
[snippet=11414]
Select a random row with Microsoft SQL Server:
[snippet=11415]
Select a random row with IBM DB2
[snippet=11416]
Select a random record with Oracle:
[snippet=11417]
Have you got other [...]