Technical Insights

Public and Private Keys over SSH

I found a very good explanation of how to set up public key authentication over ssh. I’m always looking for it when I need it, and it always takes forever. …

Paging Through Data 2.0

For a long time, whenever I wanted to do paging to browse through a table, I used to run 2 queries. The first would get the results, and the second would be an almost identical query, with a count() …

Calling a function from within preg_replace

Regular expressions are awesome. However, sometimes doing everything in them is extremely difficult, or impossible. Luckily, we can flex the power of preg_replace’s ’e’ option to …

Pretty URLs using Multiviews

I saw a post on digg.com about how it’s nice to have “pretty urls” that are easy to tell people. While i’m not sure anyone would remember rustyrazorblade.com slash some …

Can you use a stored procedure in a subquery? I don't think so. (MySQL)

I do not think you can use the result of a stored procedure in an ad-hoc subquery.

On my social network, LetsGetNuts.com, I have a Friend table. This is the structure:

mysql> describe Friend; …

'Post-Digging: askhaddad.com'

Glad I was able to think of something interesting enough for the digg community to vote up so highly, but I was a little surprised to see that question submission has completely stopped.  I’ve …

askhaddad.com

I’ve created an experiment, askhaddad.com. I answer all questions in the order they are received, unless they are blatent spam or nonsense.

Askhaddad.com is an anti-social q&a; site - there …

'MySQL: Number + NULL

Maybe not breaking news, but I think it’s interesting enough of a point, and I didn’t really find anything about the topic when I googled it. If you do any addition, subtraction, …

MySQL Triggers Tutorial

If you’ve worked with any of the commerical databases other than MySQL, you may have already had some experience with triggers.

I’m glad that the MySQL developers finally managed to …