* Posts by Charlie Clark

12169 publicly visible posts • joined 16 Apr 2007

SAP proves, yet again, that Excel is utterly unkillable

Charlie Clark Silver badge

Re: Excel excels

And lack of precision: use text if you want more than 15 digits…

Beer gut-ted: As many as '70 million pints' spoiled during coronavirus pandemic must be destroyed in Britain

Charlie Clark Silver badge

And the filtering. But, of course, the beer was also generally weaker than what we now drink.

Charlie Clark Silver badge

It wasn't really that long ago when that was pretty common: fresh small beer was a lot safer than much of the water.

Charlie Clark Silver badge

Re: i need to get out more

So much beer is kept under pressure (CO2, etc.) now that it can't oxidise naturally nor does it provide a particularly good environment for the few microbes that can tolerate the alcohol.

Charlie Clark Silver badge

Unpasteurised milk

France's answer has been to relax safety rules governing the sale of raw milk. Keep your fingers crossed.

It's pretty common in the French countryside anyway. My old landlady used to get it regularly but would also cook it herself, though I couldn't get used to the taste. Once we got a handle on TB and if the cattle are kept properly, there isn't really a lot to worry about, which is why so much French cheese is made with unpasteurised milk. Yes, listeria is a risk, but again, this is down to how the cows are kept.

Charlie Clark Silver badge
Coffee/keyboard

Re: I wonder

Presumably the government thought about environmental considerations when writing those rules.

You owe me a new keyboard for that!

Charlie Clark Silver badge

Re: It's probably not actually "bad".

It's not light in general, it's UV that's causes changes in bottled beers. So the trend for clear glass for "lighter" beers, popular with the wimmin for the same reason that "light" cigarettes are, for taking to picnics is ironic. Then again most of those "light" beers are pretty tasteless anyway.

If you're appy and you know it: The Huawei P40 Pro conclusively proves that top-notch specs aren't everything

Charlie Clark Silver badge
Stop

Definition of lock-in

I pay for things with Google Pay. When I interview industry folk, the audio is immediately uploaded to Google Drive for safekeeping. I write most of my notes in Google Docs, and use Gmail to access my various email accounts. If I need to drive somewhere unfamiliar, I rely on Google Maps to lead the way.

Talk about putting all your eggs in one basket!

Vint Cerf suggests GDPR could hurt coronavirus vaccine development

Charlie Clark Silver badge

Re: Useless

People regularly do die in droves of the flu. Furthermore, considering how quickly it mutates, is difficult to develop lasting immunity against. This is why it is highly recommended that all medical staff have a full and up to date complement of vaccinations: even if it doesn't kill them, it makes them less likely to pass it on to others.

Covid-19 is a serious illness and in many cases fatal but the media frenzy has served to take people's attention from other equally serious illneses. Referrals for serious illnesses to hospitals are significantly down in many countries as a result of people being more scared of Covid-19 than anything else.

Charlie Clark Silver badge

Re: Useless

The importance of a coronavirus vaccine is equal to the importance of any other flu vaccine.

I agree with this.

Never forget that the mortality has been overrated for other purposes.

While there has been some overstatement, particularly in Italy in the early days, there has also been some understatement, particularly in care homes before mass testing became available. With so many patients having other conditions it's also difficult to call in some cases. But, never suspect a conspiracy when incompentence will do.

Charlie Clark Silver badge

And "malicious"?

Charlie Clark Silver badge
Stop

IMHO GDPR was to prevent malicious use of personal data.

Then you should freshen up on the law. Any use of personally identifiable data, apart from a few statutory exceptions, requires the explicit consent of the person involved. Malicious is open to interpretation which is why it's not mentioned in the law.

Charlie Clark Silver badge

Re: Other ways the world would be safer....

1) Locking people up at night.

Except that most acccidents happen in the home… Shoot everyone now and that will put a stop to that, and infections!

Charlie Clark Silver badge

Re: Run-away techies pipe dreams meet problem-o-phile reasoning

That's how you get messes like the GDPR.

GDPR isn't a mess. It is largely an update of existing laws with new sanctions. You want some examples of sloppy laws where tech had an input? DMCA, Safe Harbour.

Charlie Clark Silver badge

Re: Piper paying

Yes, but what he says seems to imply that the EU's GDPR isn't a problem but that other legislation inspired by or derived from it may have unintended consequences. For instance, the German phone networks have been providing anonymised phone location data to the Robert Koch Institute to help their modelling for months now and this is okay within the bounds of GDPR, but this might not be possible in other countries.

Elsewhere it should be noted that Google and the other titans have been lobbying intensely to get hold of patient data. This is, in my opinion, an accident waiting to happen as.

As for off-premise commerce: it's been happening for decades with things like catalogues. Just took a bit longer to happen. And we could have had video conferences since the 1970s except that no one thought they were worth the price. Even now, where they are nearly free, it's hard to argue that the video part really adds much.

'iOS security is f**ked' says exploit broker Zerodium: Prices crash for taking a bite out of Apple's core tech

Charlie Clark Silver badge

Re: "Zerodium said for the first time that it would pay more for flaws in Android"

At least, not until someone does a Debian release for it,

You can get at least some form of Debian for Planet's offerings but it won't help you much in locking it down, because you'll make it more or less unusable as a "smartphone" if you do so. Dumb phones were easier to secure because they did less, but it's not as if they were immune to hacks.

Things might improve with hardware that can support the kind of microkernel and containers that should improve security. Though, in a sense that just moves the goalposts because code does repeatedly breakout of containers.

Charlie Clark Silver badge

Re: Here's an idea

Bugs traditionally refer to code not doing what it is supposed to do. For a simple example, consider a birthday calculator that does not take leap years into consideration: works well most of the time so not necessarily easy to spot.

Hacks are also known as exploits because they often exploit the side-effects of well-tested code doing what it should. This is very often related to permissions but also underlying flaws (memory, timing, etc.) and is difficult or almost impossible to avoid in modern OS with internet connectivity and multimedia. We're learning all the time how to provide advanced features such as GPU acceleration for video chat without compromising the hardware.

Charlie Clark Silver badge

Re: Here's an idea

How about paying people to find the bugs before release?

It's worth noting that not all exploits stem from bugs, quite often they come from finding different ways to use "good" code. This is why pen-testing is a separate discipline from both testing and QA. That said, there's no doubt that Apple's software management could and should be improved: less secrecy and some degree of peer reviewing would be possible. Maybe even their own Project Zero team?

Multi-part Android spyware lurked on Google Play Store for 4 years, posing as a bunch of legit-looking apps

Charlie Clark Silver badge

Re: So...

Not with a simple scan, no. But that's true of a lot of malware: scanning the code will not necessarily tell you how it behaves, you can only look for some tell tale signs. You need to run it in a sandbox to see what kind of connections it makes outgoing and incoming.

If you're going to spend $3tn, what's another billion? Congress urged to inject taxpayer dollars into open anti-Huawei 5G radio tech

Charlie Clark Silver badge

Or just doing a deal with the Chinese on getting backdoors into the hardware. That's what this is really about not any kind of industrial policy.

Charlie Clark Silver badge
Stop

Re: Only themselves to blame

This isn't really the US's fault, it's just the way the game is played in standards setting. The 3 main players in 5G aren't US companies after all,

You present the two statements in the wrong order. Because the US did not participate in GSM standard development, it shut itself out of future development. So, yes, it very much is the US' own fault. When Bell Labs and Nortel R&D, et al. were closed to save money the US effectively froze itself out of most of the development. At the same time, China saw the importance of being onboard and consequently through money at R&D.

Sadly, 111 in this story isn't binary. It's decimal. It's the number of security fixes emitted by Microsoft this week

Charlie Clark Silver badge
Coat

Re: Disappointment

I see no errors!

Fancy some post-weekend reading? How's this for a potboiler: The source code for UK, Australia's coronavirus contact-tracing apps

Charlie Clark Silver badge

Maybe a thought experiment will help. A small sample might help you trace contacts in a single classroom in a school but only there. But while you're doing this you will not see the gunmen raging through the rest of the school or that someone is handing out syringes and, as a result, any decisions you take will be based on very partial information.

More draconian, but probably more useful is keeping records of people in places where they spend some time: restaurants, medical practices, etc.

Charlie Clark Silver badge

20% is statistically too small to give you any reliable prediction. It will certainly help tracing infection chains but you will be missing so much other data that you're still in the realms of anecdotal evidence when it comes to transmission in the general population.

Charlie Clark Silver badge

That is only because of the measures taken to limit contact and reduce the rate of transmission.

As we do with flu: annual vaccination campaigns and residual immunity in the population.

Without these measures, we could expect to see a death rate somewhere between x10~x44 higher.

Based on what particular empirical evidence? Certainly not the case in Sweden, which has some of the least restrictive measures. At the moment we have some assumptions and some correlations.

Charlie Clark Silver badge

using contact-tracing app are seeing the results and are "flattening the curve"

Except they keep seeing new outbreaks (new one today in South Korea), which are to be expected in any kind of epidemic. It's a fallacy to expect any technological solution to the problem.

In mid-March, a close friend lost both her parents, ten hours apart, to COVID-19 in TWO (2) days after entering a NYC hospital.

Every death is one too many, but we're still looking at something comparable to a severe flu season.

Charlie Clark Silver badge

Re: Best option, cheapest option

You must have been watching Russia Today or something as other reports from Russia suggest that people who ask for the test don't necessarily get it. But the testing regime of most countries (Iceland seems a notable example) seems to be fundamentally flawed: testing resources are limited so priority is given to those with symptoms. This means it's always behind the curve and still only gives you snapshot of a particular moment in time. Research indicates that a large number of those infected develop little or now symptoms so your sample in skewed. So, over time the only really useful testing will be antibody testing, which is currently not reliable enough. Nobody is admitting it but I think policy is moving towards the Swedish model of letting the virus spread through the less vulnerable parts of the population during the good weather so that the potential wave in the autumn (combined with the flu) will be less devastating.

Fortunately, though pretty infectious, it looks like only around 60% immunity is required (as opposed to > 80% for measles) but this is unlikely to happen organically this year or the next, but in some key areas (such as hospitals) it could be possible, which should limit retransmission to some severely vulnerable groups.

Charlie Clark Silver badge

Re: Another problem for the solution?

Contract tracing requires employing and training people to do the work. This costs money, so even if there are several new centres opened to the relevant media fanfares, you can be sure that they will be funded only as long as anyone is looking (3 to 6 months normally).

Breaking virus lockdown rules, suing officials, threatening staff, raging on Twitter. Just Elon Musk things

Charlie Clark Silver badge

Re: Suprise

This is just a PR stunt to keep to grab the headlines.

Charlie Clark Silver badge

Re: Same as the Nebraska meat packing plants

Hey if you're prepared to keep a meat factory open riddled with Corona Virus

At least in terms of food safety this unlikely to be an issue: the virus cannot multiply in dead cells. The real issue are the working and living conditions of the people who work there.

Wanna be a developer? Your coworkers want to learn Go and like to watch, er, Friends and Big Bang Theory

Charlie Clark Silver badge

Re: Hmm

SQL is not Turing complete

I thought more recent revisions of it were? Not that I'd like to try and write anything like that with it…

SQL within your C program and pass the lot through a preprocessor that would convert the SQL into whatever instructions your database system required.

Converting to relational algebra would have been good. Instead the various vendors retrofitted some of their dafter ideas in SQL making it even more unwieldy but also unavaoidable.

Charlie Clark Silver badge

Re: Hmm

Yes, but that doesn't detract from the assertion that SQL is a programming language. It's not a particularly good one, but it is one.

Charlie Clark Silver badge

Re: Hmm

Not a lot apparently because HTML is also listed as a programming language.

There's a world out there with a hexagon vortex over its pole packed with hydrocarbon ice crystals. That planet is Saturn

Charlie Clark Silver badge

Re: silly names

Not really: eth, prop, but, et. al. tell you how many carbon atoms you have and -ane, -ene, -yne tells you the ratio of hydrogen atoms to them. Together they tell you a lot about the expected properties.

Charlie Clark Silver badge

Re: silly names

Thanks for the correction. I can still do the maths for the alkane (CxH2x+2), alkenes(CxH2x) and alkyne(CxHx-2) chains but do mix them up when converting back from the "old" style names!

Charlie Clark Silver badge

Future research

The scientists hope to study any changes in the hexacane’s structure to see how it evolves over time.

How? Cassini was allowed to burn up in Saturn's atmosphere and it's not as if we have anything else close enough to do the observations.

BTW. acetylene is properly known as ethene.

Microsoft doc formats are the bane of office suites on Linux, SoftMaker's Office 2021 beta may have a solution

Charlie Clark Silver badge

Testing

We copied the torture-test document to an Ubuntu system and tried opening it in both LibreOffice and TextMaker.

Why? Much better to round trip the documents and compare the markup with something like the OOXML Productivity Tool.

Charlie Clark Silver badge

Re: Seems like a losing battle, and there's an elephant in the room

Some of LO's problems with OOXML (Office OpenXML) are self-inflicted because it consistently produces files that do not comply with the specification. There is no need for this as the specification is freely available. It's inconsistent and often unclear but there is an ISO working group which maintains it and they are responsive to feedback.

As the specification doesn't cover visual represenation itself directly there are always going to be differences, not least because the file format does not equal the object representation within the applications.

Charlie Clark Silver badge

This is why PDF is still so popular as Postscript describes exactly how things should look.

The point of containers is they aren't VMs, yet Microsoft licenses SQL Server in containers as if they were VMs

Charlie Clark Silver badge

Re: Cloud is a joke

I think you're basically right and BSD and Solaris beards are still wanting to know what all the fuss is about, but did get a performance boost a few years ago through a kernel module, which gives them direct acess to the hypervisor on the silicon.

Charlie Clark Silver badge

Re: Cloud is a joke

While containers aren't a joke they are definitely overrated and often incorrectly used. The main reason behind them is being able to deploy specific services quickly, and in exactly the same way on multiple machines. Of course, this is almost identical to deploying VMs but the start up time and resources required for a container is less.

Charlie Clark Silver badge

Agreed, containers are merely "lightweight" VMs. Lightweight only refers to the way the virtualisation is implemented.

American tech goliaths decide innovation is the answer to Chinese 5G dominance, not bans, national security theater

Charlie Clark Silver badge

The key part is that they will make the best case they can for their client, even if he is a complete and utter crook.

Enough of them have been convicted in fraud cases to suggest this isn't always the case. And even less "ethical" is when they get involved in lobbying for legislation, which they increasingly help to draft with their clients' best interests in mind.

Charlie Clark Silver badge
Coat

Re: Open RAN

Here's Wishing…

Charlie Clark Silver badge

What happened to R&D?

But behind the threats has also sat an uncomfortable truth: Chinese companies dominate the market in large part because there aren’t many good alternatives: competing products are limited, more expensive and often inferior.

The US made it particularly easy for them: competing but incompatible wireless technologies (CDMA, iDEN, etc.) and vertical integration is the American way but it also stifles competition by making it difficult for users to switch, so less pressure to innovate. Meanwhile, much of the world was looking at how Europe, through the GSMA, promoted interoperability and through this competition. The US then decided that it was cheaper to have stuff made (and by extension) developed in China. The Chinese followed the GSM route (though also used CDMA, I think) to 3G then UMTS then LTE, for which it had a greater need.

O2 be a fly on the wall during BT and Vodafone's video calls: Telefónica's UK biz, Virgin Media officially merge

Charlie Clark Silver badge

The roundabout

A while back Telefonica offloaded its cable operations in Germany to Liberty Global which, in turn offloaded them to Vodafone. Only a matter of time before this happens in the UK?

Charlie Clark Silver badge

What about the Corona surcharge?

The iMac at 22: How the computer 'too odd to succeed' changed everything ... for Apple, at least

Charlie Clark Silver badge

The SGI boxes looked nothing like an iMac!

I never said they did! I loved the SGIs and the NeXTs, which were technically and aesthetically wonderful, but still aimed at "engineers". Apple targeted consumers but were also successful with businesses as a result by showing that a computer doesn't have to be a set of boring brown boxes with lots of cables. (Pleeeease don't look at my office!)

Charlie Clark Silver badge

Apple turned the computer into a consumer device. As such they were able to sell them to people who wouldn't have bought a computer otherwise. Removing stuff such as ports and floppy drives made them attractive to a lot people: SWMBO hates my electronic gadgets because of all the cables. SGI was in a completely different market but Apple, like Microsoft before them, managed to use the consumer product to drive business sales.

Personally, I never liked the IMac but putting the computer into the screen also made it a much more portable solution.

Nervous, Adobe? It took 16 years, but open-source vector graphics editor Inkscape now works properly on macOS

Charlie Clark Silver badge

I've found Photoline to be very useful when working with PDFs.