Posts in category dev - page 14

25 Oct 2016

Identical SQL Queries != Identical Results

Dev MySQL SysAdmin

You would expect identical SQL queries, running against the same database at the same time to give the same results, right? Well, it turns out that such an impossibility can occur. Alas, this wasn’t some easter egg or heisenbug hidden in MySQL, the issue turned out to be perfectly sane. This is how the confusion unfolded…

26 Jul 2016

Neat uses for CSS’s awesome viewport units

CSS Dev

CSS offers various units for sizing elements. The popular choices are px, %, pt, em and more recently rem. There are two other units that have quickly become favourites of mine, vw and vh. These are relative units, but unlike say em and rem which are relative to the font size of the current and root element respectively, vw and vh are relative to the viewport. A single viewport unit is equivalent to 1% of the viewport width (vw) or height (vh).

23 Apr 2016

The tilde CSS selector, use carefully!

CSS Dev

A couple of the recent projects I’ve worked on have both had similar stylesheet problems. They have both misused the tilde selector, which has gone unnoticed and been the cause of numerous bouts of CSS bloat. You may well have come across this selector before. After all it’s a selector that’s been in the CSS spec for a long time, even IE7 supports it. Its purpose is to select all matching adjacent siblings.

05 Apr 2016

Using an Event Loop for Multiple HTTP Requests

Dev Mojolicious

A project I worked on in some of my spare time back in Summer 2015 was to look for unusual HTTP headers. Things like X-Clacks-Overhead:GNU Terry Pratchett, or ancient use of PICS-label headers. I recently revisited the project and put it online as popular-headers.

18 Mar 2016

Markdown on WordPress

Dev WordPress

Markdown is an easy to use markup language for formatting text. It has proved to be very popular with developers. The syntax is small, quick to learn and very readable. The format is fairly well supported by online tools. Thinking of just a few examples off-hand: GitHub, MediaWiki and Trello. When you are writing a lot of text, particular web content, markdown makes it easy to see and focus on the content, rather than a mess of HTML tags.

12 13 14 15 16