* Posts by David Harper 1

164 posts • joined 12 Jun 2009


WWW = Woeful, er, winternet wendering? CERN browser rebuilt after 30 years barely recognizes modern web

David Harper 1

Re: Not by hand

"Almost any word processor is preferable to Tex/Latex."

I'm guessing you don't write anything that contains mathematical equations, which is where TeX and LaTeX excel. (Pun very definitely intended.)

David Harper 1

Re: And the content has not improved since then.

Your limestone inscriptions won't survive acid rain. Baked clay tablets are the real long-term solution. Ancient Babylonian web pages are still readable after more than 2000 years. Now, where's my cuneiform-to-English dictionary ...

DNAaaahahaha: Twins' 23andMe, Ancestry, etc genetic tests vary wildly, surprising no one

David Harper 1


You're basically saying that every Ancestry/23andMe-type DNA analysis based on the product of PCR amplification is so full of errors introduced by the PCR process itself as to be useless. It's worth noting that the study which you cited by Zhou, Zhang and Ebright is from 1991, and focusses on a specific polymerase. The science of DNA-wrangling has moved on a LONG way since 1991.

Come mobile users, gather round and learn how to add up

David Harper 1

I hope the mobile network wasn't 3

Advertising 2+2=4 on the 3 network's web site would be a bit awkward :-)

Tape vendors feel the cold, clammy hand of AWS on their shoulders. Behind them grins the Glacier Deep Archive

David Harper 1

Re: Retrieval time

"the amount of time it takes isn't as important"

I'm guessing you've never had a pointy-haired boss screaming at you when someone accidentally dropped the company's mission-critical database, and you're the DBA who has to get the whole thing up and running again from the backup tape. Retrieval time seems pretty fscking important then :-)

What now, Larry? AWS boss insists Amazon will have dumped Oracle database by end of 2019

David Harper 1

Re: In Ten Years Oracle Will Be Wanged...

"we'll rip out that RDBMS, put in a nosql layer"

Because everyone knows that MongoDB is webscale.


David Harper 1

That's just not true

Everyone expected Oracle to kill off MySQL when it bought out Sun Microsystems ten years ago. I'm no fan of Oracle, but I will give them credit for this - they have invested money and people in keeping MySQL alive and improving it. They cleaned a lot of the cruft out of the source code they inherited ten years ago, then added a string of new features, which they gave away for free in the community edition. They are still adding neat new features. MySQL 8 is a huge step forward from MySQL 5.7.

The two main forks of MySQL, MariaDB and Percona Server, are both based on the Oracle source code, so even MySQL veterans like Monty Widenius and the folks at Percona recognise that Oracle has added value to MySQL.

And if you want to complain that Oracle keeps the super-useful features for the paid-for enterprise version of MySQL, I'd just point out that Percona and MariaDB do the same thing.

Behold, the world's most popular programming language – and it is...wait, er, YAML?!?

David Harper 1

The ghost of John Backus would like a quiet word

"Any language where the amount and flavour of whitespace is significant should be strangled at birth."

Except FORTRAN, of course.

Junior dev decides to clear space for brewing boss, doesn't know what 'LDF' is, sooo...

David Harper 1

It's not ancillary, it's a critical part of the database

The transaction log file is NOT an "ancillary" part of the database. It's a critical file, which is just as important as the data files, since the state of the database is represented by the combination of data files AND transaction log file. The transaction log file contains changes to the data that have been committed, but that may not have been applied to the data files yet.

GCSE computer science should be exam only, says Ofqual

David Harper 1

Practical programming exams? I was doing that 25 years ago.

Back in the early 1990s, I was teaching a graduate-level programming course at one of the colleges of the University of London. The end-of-course assessment was a set of programming exercises that the students completed under exam conditions on PCs running MS-DOS. They copied their work onto a 3.5-inch floppy that I gave them at the end of the exam. I allowed them to consult their printed course notes during the exam, so it wasn't purely a test of memory, and this was before the Interwebs, so they couldn't google the answers.

Has science gone too far? Now boffins dream of shining gigantic laser pointer into space to get aliens' attention

David Harper 1

Reminiscent of Liu Cixin's "The Three-Body Problem"

Liu Cixin's science fiction trilogy "The Three-Body Problem" was mentioned earlier. This starts out with humans signalling their existence via an amplified radio signal. It's a superbly-written series of novels.

British Airways: If you're feeling left out of our 380,000 passenger hack, then you may be one of another 185,000 victims

David Harper 1

Re: Close call?

It was malicious code in a third-party JavaScript library. The most likely explanation is careless web developers at BA's outsourced IT division who used the third-party libraries in the first place. Never attribute to malice what can be adequately explained by incompetence.

Unexpected MySQL database meltdown fingered in GitHub's 24-hour website wobble

David Harper 1

No MySQL replication slaves for failover?

Any competent DBA will tell you that you should be running multiple replication slaves of any mission-critical MySQL database server, and they should be using different back-end storage systems than the master. These replication slaves can provide read-only copies for load-balancing, and can also be promoted to become a read/write master in the event that the master suffers a hardware failure.

Someone at GitHub/Microsoft evidently didn't get beyond chapter 1 of the "How to be a production MySQL DBA" notes.

New theory: The space alien origins of vital bio-blueprints for dinosaurs. And cats. And humans. And everything else

David Harper 1

Re: Assumption: There is a god and he* created everything.

"Quite some manners, that. Dude needs a mom, I'd say."

Or a supply of socks.

First Boeing 777 (aged 24) makes its last flight – to a museum

David Harper 1

Re: Still have the book

The wing deformation test on the first prototype was both spectacular and reassuring. They clamped the undercarriage down, then put a hydraulic jack under one wing tip. The wing was at around 45 degrees to the horizontal before it finally failed.

It was also reassuring to know that the 777 could fly for a couple of hours on a single engine, especially when my wife and I were on a Chicago to London flight that was suddenly diverted to Bangor, Maine after the captain had to shut down one engine. Having seen the documentary, we weren't in the least worried about making a safe landing.

Automated payment machines do NOT work the same all over the world – as I found out

David Harper 1

Just what I needed on a Friday afternoon

Hats off to Mr Dabbs for "I miei capezzoli esplodono di gioia.". I copied it into Google Translate, and my monitor now has a fine coating of coffee all over it.

Brit ISPs get their marker pens out: Speed advertising's about to change

David Harper 1

Re: Hmmm...

That's definitely NOT my experience. Like you, I pay Virgin Media for what they call their 70 MB/s tier. I have a cron script on a Linux box which measures my download speed every hour, and whilst the speed is indeed close to 70 in the wee small hours of the morning, it drops below 40 between 4 p.m. and 11 p.m. most evenings, and sometimes it's as low as 20. I've managed to get a refund on my monthly bills a few times after posting graphs of the download speed to the Virgin community forum, but not recently. I guess they don't give a sh*t any more.

Astroboffins spy the most greedy black hole yet gobbling a Sun a day

David Harper 1

Proper units, please

"It has a voracious appetite and gobbles a mass equivalent to twice that of our Sun every two days to sustain itself."

That's 12 milliJupiters per second, just to put things in proper perspective.

Australian prisoner-tracking system brought down by 3PAR defects

David Harper 1

Well thanks a lot

I won't be able to see NSFW now without think it stands for New South F***ing Wales.

Take-off crash 'n' burn didn't kill the Concorde, it was just too bloody expensive to maintain

David Harper 1

Watch the Channel 5 documentary

Channel 5 showed a two-part documentary late last year which included interviews with some of the aviation engineers who were involved in developing Concorde and solving the many technological challenges. It's well worth watching and it highlights what an engineering marvel Concorde was.

The Imperial War Museum at Duxford has the Concorde which was used for testing in extreme conditions. You can walk through the interior. The front half is fitted with seats to show what passengers would have experienced, whilst the back half still has all of the test and monitoring equipment in place.

Windrush immigration papers scandal is a big fat GDPR fail for UK.gov

David Harper 1

Re: History will be history!

Indeed. The government retains census records going back to 1841, and makes them publicly (and now digitally) available once they are more than 100 years old. What were once records collected to allow government to monitor the population are now a priceless resource for historians and genealogists.

The Agile and the Continuous: Database Drift ... Neat film title but something to avoid

David Harper 1

Crossing the Fence 2

Like Bill M, I've been on both sides of the fence, as well as straddling it for a while when I managed a cluster of MySQL databases for my development team before the in-house 100%-Oracle DBA team would admit that MySQL was actually a database system.

During my developer days, I worked alongside some bright young things who were evangelising Ruby-on-Rails. According to them, ActiveRecord was the dog's bollocks. You never had to write a line of SQL, and it automatically ensured the referential integrity of the database without the need for anything as 1970s as foreign key constraints. Imagine their surprise when the production database started to show inconsistencies such as phantom relationships and missing entities. When I was asked to add foreign key constraints, I ran a consistency check on the existing data and found a huge mess. I left the team to become a DBA soon afterwards.

'Your computer has a virus' cold call con artists on the rise – Microsoft

David Harper 1

Re: Re "putting the phone down is almost always the right thing to do."

My wife regards this as an excellent sport, and she will happily spend 20 minutes playing along. My preferred approach involves making anatomically impossible suggestions, which generally results in a far shorter call.

Creaky NHS digital infrastructure risks holding back gene boffinry, say MPs

David Harper 1

Re: 200GB to store a genome? Surely not!

No, this is just plain DNA sequencing data, which is strings of A, C, G and T.

David Harper 1

200GB to store a genome? Surely not!

A human genome is 3.2 billion base pairs, and each base pair can be represented as a single letter from the set {A, C, G, T} so even if you use (a wasteful) one byte per base, that's still only 3.2 GB. If you encode a base in the most efficient way, as two bits, you can reduce the size to 800 MB. So where does 200GB come from?

(I work in bioinformatics and I've written large-scale applications that store entire genomes, so I have a bit of experience in this field.)

Cloudflare touts privacy-friendly public DNS service. Hmm, let's take a closer look at that

David Harper 1


You might want to read RFC 1918, specifically Section 3, which defines the three blocks of IP addresses that should be used for private/internal networks:

"3. Private Address Space

The Internet Assigned Numbers Authority (IANA) has reserved the

following three blocks of the IP address space for private internets: - (10/8 prefix) - (172.16/12 prefix) - (192.168/16 prefix)"

Developer recovered deleted data with his face – his Poker face

David Harper 1

The game was much more entertaining if you tweaked the parameters that set the strength of gravity and the wind speed. Hurling bananas into a hurricane in Moon gravity was fun.

Astro-boffinry world rocked to its very core: Shock as Andromeda found to be not much bigger than Milky Way

David Harper 1

Galaxy of restricted growth, if you don't mind.

It knows where the gravel pits and power lines are. So, Ordnance Survey, where should UK's driverless cars go?

David Harper 1

Re: Maps are useful, but things change

"Google shows the new Harwell Village bypass (the little road to the east of the A34), OS doesn't. The road isn't even open yet... yet Google already includes it."

You'd better hope that satnav systems are using the OS version, then, otherwise the workers building the bypass will get a nasty surprise when some clueless idiot follows his satnav's instructions to take the road that they are still building.

Virgin Media skulks in disused public toilets

David Harper 1

"Rather ironically, one of Bazalgette's descendants now runs a TV production company. One could easily draw parallels between that, the internet and the industrialised movement of civilisation's waste."

It's a VERY old joke: Joseph Bazalgette made a fortune pumping shit out of people's homes. His great-great-grandson made his by reversing the flow.

ICO probes universities accused of using private data to target donation campaigns

David Harper 1

This is nothing new.

This is nothing new. I was called at home one evening about 25 years ago by a student fundraiser from my alma mater, one of the colleges of the University of London. He started his begging pitch by asking if I knew how little money university lecturers were paid. I told him I did, since I was a lecturer at one of the other colleges of the University of London at the time. Needless to say, the call didn't go on much longer.

'Sticky runway' closes Canadian airport

David Harper 1

For those of you unfamiliar with the joke:


ICANN gives domain souks permission to tell it the answer to Whois privacy law debacle

David Harper 1

What's the problem?

I own a number of domains in .com, .co.uk and .eu, and my registrar hides my personal contact information for all of them.

Indeed, my registrar's default position for all new domain registrations is to hide the owner's contact details, replacing them with a forwarding postal address and an email address which forwards to my private email but which changes every few days to foil spammers. They can harvest the address, but in ten days time, it will no longer be valid.

Interstellar space rock screams through Solar System

David Harper 1

An eccentricity of 1.2 ...

... means that it was on a hyperbolic orbit. Mathematically, this means that it is not gravitationally bound to the Sun, and will escape from the Solar System in due course. The Voyager and Pioneer spacecraft are also on hyperbolic orbits, by design. None of these things came from outside the galaxy.

Legends of the scrawl: Ordnance Survey launches augmented reality tool for maps

David Harper 1

Re: True, but...

And others contain 33 kilovolts of electricity, which is going to really spoil your day if you're on the other end of the pneumatic drill which touches it.

(Based on a true story from east London about 25 years ago.)

Tell the public how much our tram tickets cost? Are you mad?

David Harper 1

"Anyone wanting to look up in advance how much their journey might cost can, er, inspect the Official Fares Tables 'by appointment at TfGM's Trading Office between the hours of 0900-1700'."

Presumably in a cellar, in the bottom of a locked filing cabinet, stuck in a disused lavatory with a sign on the door saying “Beware of the Leopard”?

(With apologies to the late great Douglas Adams.)

Boss visited the night shift and found a car in the data centre

David Harper 1

Re: Mini - not really

Impressive, but the gold medal still goes to the Cambridge University engineering students who managed in 1958 to hoist an Austin Seven car on the roof of the Senate House building one night. The full story is here, with a photograph of the car on the roof:


Software update turned my display and mouse upside-down, says user

David Harper 1

Re: Now it can be told...

"...switching the wallpaper to an image with the desktop icons on it"

Thank you, Hans, for the funniest thing I have read this week.

New coding language Fetlang's syntax designed to read like 'poorly written erotica'

David Harper 1

Re: Idiots in the IT field.. too many in the last few years...

"There's a great tradition of 'silly' little projects like these, everyone knows not to take it seriously."

Alas, some of these practical jokes do still occasionally get out of hand. Take Python, for example -- the language that brought back indentation as part of the syntax, just when old FORTRAN programmers like me thought that we'd seen the last of that kind of nonsense :-)

Smartphone SatNavs to get centimetre-perfect GNSS receivers in 2018

David Harper 1

Re: GPS is bad at measuring height

"The GPS measurement gives your location on a sphere, which the earth isn't."

No it doesn't. The default GPS reference geoid is the WGS84 ellipsoid, which is an oblate spheroid that closely matches global mean sea level. If your GPS receiver can pick up signals from more than three satellites, then it can calculate a full 3-D position consisting of latitude, longitude and height above the reference geoid. There are enough GPS satellites these days that a 3-D fix with good height-above-geoid accuracy is pretty easy to obtain, even with a mobile phone.

Cassini probe's death dive to send data at just 27 kilobits per second

David Harper 1

Re: Distance... @BahBoh

The Earth-Saturn distance doesn't change that much. Even allowing for the eccentricity of Saturn's orbit, the range is around 8 AU (opposition when Saturn is at perihelion) to 11 AU (conjunction when Saturn is at aphelion). Given that signal strength varies as the inverse square of the distance, the signal is roughly half as strong at 11 AU than it is at 8 AU. That's not a huge dynamic range, really.

The Reg chats to Ordnance Survey's chief data wrangler

David Harper 1

Re: Disagree - GPS is the future

Probably best to stay at home then. Under the sofa, just be on the safe side. Earthquakes, you know.

David Harper 1

Re: Disagree - GPS is the future

If you need GPS to tell you where you are when visibility is poor, you should probably stick to parts of the country that don't have footpaths adjacent to sheer drops that can kill you. I hear that Norfolk is nice and flat.

US vending machine firm plans employee chip implant scheme

David Harper 1

As an optional bonus

The local veterinary practice has offered to combine it with spay/neuter in a two-for-one promotional package.

NAO: Customs union IT system may not be ready before Brexit

David Harper 1

On the plus side

I look forward to the Public Accounts Committee's report, in around five years time, into the utter inability of HMRC's shiny new computer system to cope with the post-Brexit customs sh*tstorm. It should make grimly entertaining reading. And yet another useful case study for courses on why large IT projects fail.

O Rly? O'Reilly exits direct book sales

David Harper 1

Send an email to Tim O'Reilly to complain

His email address is up there at the O'Reilly web site: tim@oreilly.com

I assume that a flunky actually reads the emails, but if enough people email to complain, the flunky will surely tell Tim.

Remember, polite emails will work better than ranty ones. But if you tell Tim you're not signing up the the $400/year Safari subscription, and that from today, you'll buy Apress or Manning e-books instead, because they still sell non-DRM e-books, that's going to get smeone's attention too.

Switch on your smartphone camera and look how fertile I am

David Harper 1

Re: Would you like to buy

I refer the honourable gentleman to the article published by El Reg three weeks ago about the Dutch guys who programmed a drone to detect dog poo from its infra-red signature and direct a robot scooper-droid to collect the offending pile: https://www.theregister.co.uk/2017/03/29/drone_pooper_scooper/

Kubernetes, Prometheus, DevOps, Docker Swarm? Which workshop will you choose?

David Harper 1

No BOFH Workshop?

Admit it, you'd sign up for a BOFH Workshop. I know I would.


Biting the hand that feeds IT © 1998–2019