Category Archives: Ideas

What interactive console commands never do

If you’ve ever used an interactive console task and screwed up some of the settings, the following kind of exchange should look familiar to you: [niko@localhost:~]$ animal-generator Welcome to the interactive stuff generator! Please give a latin name for an … Continue reading

Posted in Ideas, Usability | Leave a comment

Fetch random rows faster with recycled IDs

Say you need to quickly fetch a random row from a database table. What’s your approach? If you answered: SELECT * FROM tablename ORDER BY rand() LIMIT 1 …you’re probably in the majority, and in many cases right. However, the … Continue reading

Posted in Ideas, Optimization, SQL | Leave a comment