-
All your base conference
tl;dr The All Your Base database conference in Oxford was great. I went to it. I recently went along to the fantastic All Your Base database conference which happened in Oxford on 23 November 2012. If you don't get the reference, then you ahould read up on the all your base are belong to us me …
- On:
-
MySQL tip: Counting total number of rows even when LIMIT is set
Pagination is a pain in the arse, right? That's one of the lovely things about using an ORM or something to do it for you. But that isn't always possible, so at some point you'll need to use a LIMIT on your select. Now, MySQL has a nice little feature called SQL_CALC_FOUND_ROWS which puts the num …
- On:
-
SQL tip: Most Popular Pages This Week with Piwik
Just a quick update today. I want to make myself a little most popular pages this week for the front page of this site. Now, I am using the lovely Piwik Analytics tool to monitor the site. So I first looked at the Piwik API. That should be the way to do it right? Not quite. The Actions plugin can …
- On: