Searching 10GB of data As A Service - lessons learned  Tags: programming, webdevelopment, databases.
The day before yesterday I launched a service where you can check whether you were included in the Adobe accounts hack. I had the file, it could be grepped for stuff in about 30 seconds, and I thought "hey, others might want to do this too". And so I started coding.

My parents would be home soon and we'd go out for dinner, but I wanted it done. With the Linkedin breach someone else put up the same service so it doesn't seem to be an uncommon thing to do. Since I didn't want anyone to steal my idea before I could get it done (and my work would be wasted), I was kind of on a schedule.

Fastest SELECT query  Tags: databases, webdevelopment, programming.
Just a quick post about some speedtests I did. I couldn't quickly find which way was the fastest.

TABLE t: col1, col2, col3, col4, col5 (a mix of integers and varchars)

SELECT * FROM t
Run 1: 3.722 miliseconds