Pagination sucks
Pagination sucks for SEO. Chronological archives work way better. In this article I'll tell you why and how.
SEO blog
You Know, for Search
For the two people that read this: the blog contains (usually) short articles that can be regarded as my 'public bookmarks'. Topically unrelated to each other, but useful stuff that I need in my daily work as an SEO.
Merge CSVs in Mac OS X Terminal
Save yourself some time, and merge .csv files with one easy command in Terminal.
Auto split CSV file in chunks with Mac OS X Terminal
And add an extension to them also, so Mac OS X knows how (with which program) to handle them.
MySQL extract domain name
Using this search & replace, you can easily extract a domain name from a string in MySQL
MySQL word count function
A simple 'User defined' MySQL function that you can use to count the number of words in a text string.
MySQL split string
How to split a string in MySQL? Use this function.