29 Apr '13, 6pm

Ah! When @jankowski uses hip-hop to explain databases!!! Kids, this is what we call "thinking outside the box"

What are database indexes? If you’re building web apps powered by a relational database, you should know. A database index is a data structure in the database which improves the speed of operations (typically row lookups) on a database table, or across tables. Think of it like the index of a book. If you’re reading a book about the Wu Tang Clan and you want to find all the Method Man references, it’d be a lot easier to flip to the index and find “Method Man”, then open up directly to all those pages numbers (as opposed to scanning every page of the book for the words “Method Man”), wouldn’t it? Well that’s basically how database indexes work. Assuming you have an indexed users.id column on your users table, when you query a database with… SELECT name FROM users WHERE id = 1 …the database can find that row very quickly, rather than having to scan through every row in the ta...

Full article: http://robots.thoughtbot.com/post/163627511/a-grand-piano...

Tweets

You Call Yourself an Explorer?

You Call Yourself an Explorer?

kyspeaks.com 29 Apr '13, 1am

You Call Yourself an Explorer? April 29, 2013 2 Comments Lara Croft, Indiana Jones, or even Columbus and Cheng Ho, these a...

@yeokyminy @kamilia4eva

@yeokyminy @kamilia4eva

gv.com.sg 30 Apr '13, 6am

When veteran 911 operator, Jordan (Halle Berry), takes a life-altering call from a teenage girl (Abigail Breslin) who has ...

Ah Boys To Men stars become "kopi kias" for charity

Ah Boys To Men stars become "kopi kias" for cha...

soshiok.com 27 Apr '13, 8am

Donning Toast Box's aprons, Ah Boys To Men stars Maxi Lim, Noah Yap and Tosh Zhang sold 45 coffee brew sets at the cafe's ...