Geekery
111 Geekery articles in total, showing 11 to 20
-
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_ …
- Published:
-
Why sum and product types?
When reasoning about functional types it sometimes helps to take a step away from the compiler and delvelop some informal intuitions about why things work the way that they do.When I read about algebraic data types they seemed rather complex notions. Algebraic data types, I discovered from wikiped …
- Published:
-
Solved: iceweasel on xmonad won’t play HTML5 video fullscreen
New problem this, and it took some google-fu to find out a solution. I recently upgraded Iceweasel (the unbranded Firefox) on my Debian Jessie to the latest beta. I use xmonad as my windowmanager.After the upgrade it was impossible to make HTML5 video go fullscreen. In fact F11 had stopped working …
- Published:
-
Tip: Jitsi main screen blank on xmonad
I was just having a very headscratchy problem running Jitsi on debian on top of my xmonad windowmanager. I am adding this super quick tip in case anyone else encounters the same issue.When running jitsi, the main interface screen is completely blank. A big grey nothing. After a …
- Published:
-
SSH: to change port or not to change port
There are strong opinions on whether to run your SSH daemon on ports other than the default 22. On the pro side, the argument is that most automated tools only check port 22, so you reduce your exposure to random script kiddies by not running it there. That’s just security by obscurity say t …
- Published:
-
OpenTech 2015: My Highlights
This year, it was 10 years since the first OpenTech event. I’ve been to a fair number of the events and I rate it as one of the best tech conferences going. It is cheap (a fiver for the day), has reasonably good politics and a good percentage of the speakers are women -- unfortunately a rare t …
- Published:
-
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 …
- Published:
-
Why is Math.max() less than Math.min()?
A while back I wrote a post called Javascript: the Weird parts primarily for my own amusement. It listed some of my personal favourite wtfjs-type Javascript idiosyncracies. In this post I want to look in more depth at one of those idiosyncracies. I want to investigate exactly why Math.max() is les …
- Published:
-
Magento tip: Number of products in category, subcategories of a store
I had need today of counting the total number of products in a category and all its subcategories in one of the magento stores that New Internationalist runs. It took a little while to write the code so I am putting it out there in case anyone else has the same problem. Most probably my future self. …
- Published:
-
Video: Guy Steele’s Growing a Language Talk
I recently chanced across a truly wonderful talk by Guy Steele, one of the creators of the Scheme programming language. He gave the talk at the 1998 ACM OOPSLA conference, but it touches on some timeless themes in communicating with computers.The talk focusses on the need for us to build languages …
- Published: