-
FLOSSUK Reviews: ES6 and MySQL/MariaDB
Back in May, FLOSSUK published a couple of reviews that I had written in their newsletter. Reviewing books is a pleasant way to expand one’s technical horizons, especially for a confirmed bibliophile like me.The books I reviewed were You don’t know JS: ES 6 and Beyond, by Kyle Simpson …
- On:
-
Tip: find which payment method was used for Magento orders with SQL
Today we wanted to work out which payment type had been used for a range of orders on the Ethical Shop. The quickest way I could think of was to dive into MariaDB/MySQL and issue a quesry on the sales_flat_order and sales_flat_order_payments tables for a range of orders. You can use the increment_ …
- On:
-
Tip: Use SQL to find percentage socia media growth from Thinkup
At New Internationalist we have been using a self hosted ThinkUp instance to track our social media work for the last several years. If you haven’t checked it out yet, you should definitely take a look. One thing that we occasionally need to look at is the amount by which our follower or li …
- On:
-
Making a secure elasticsearch on openshift with data from MySQL
As part of my role at New Internationalist I have a monthly reading day. This month I was researching Elasticsearch. This post summarizes the functional prototype setup I built to learn a little more about the elasticsearch technology. It also gave me a chance to have a play with RedHat’s O …
- On:
-
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: