Many-table joins in MySQL 5.6

MySQL Performance Blog

I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset was fitting in memory but the query took several seconds to run. Long story short: the query was a join involving 21 tables, running on MySQL 5.1. But…

6 March 2014

Getty Images Makes 35 Million Images Free For Non-Commercial Use

Slashdot

kc123 writes "In an effort to deal with copyright infringement Getty Images is launching a new embedding feature that will make more than 35 million images freely available to anyone for non-commercial usage. Anyone will be able to visit Getty Images'…

6 March 2014

Imagining a Node Blogging System for Geeks

inessential.com

I’ve written three blogging systems. At UserLand I wrote Manila, which powered editthispage.com and a few other sites way back in the ’90s and early ’00s. I’ve written two more just for my own use. The first, PHP/MySQL-based, powered this site for seven…

6 March 2014

Github Pull Request Triage tool

Planet Mozilla

Last week I built a little tools called github-pr-triage. It's a single page app that sits on top of the wonderful GitHub API v3. Its goal is to try to get an overview of what needs to happen next to open pull requests. Or rather, what needs to happen…

6 March 2014

Mario Lang: Personal mail server

Planet Debian

I used to use Fetchmail and Gnus with its mail splitting capabilites and nnml backend to handle my private mail setup for many years. This worked pretty fine since I am used to accessing my home server through SSH. I have Gnus running inside of a GNU…

4 March 2014

How to avoid common (but deadly) MySQL development mistakes

MySQL Performance Blog

MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. And it’s true that some of a developer’s time is wasted when his or her method of optimizing involves trying every…

28 February 2014

DBA 101: Sometimes forgotten functionality in the MySQL client

MySQL Performance Blog

The MySQL client has some functionalities some of us never use. Why would you use them and what is the added value of this? Every DBA and developer has had a moment when he or she needs to connect to a MySQL database using the command line tool. Therefore…

27 February 2014

Yes, You Too Can Be an Evil Network Overlord With OpenBSD

Slashdot

badger.foo writes "Have you ever wanted to know what's really going on in your network? Some free tools with surprising origins can help you to an almost frightening degree. Peter Hansteen shares some monitoring insights, anecdotes and practical advice in…

27 February 2014

Video of my YUIConf talk about open web app development

Planet Mozilla

The YUIConf folks have just posted their recording of a talk I gave there last year. I had planned to talk generally about the Firefox Marketplace, how it differs from other app stores, and how those differences create an overall … Continue reading →

27 February 2014