* Posts by Charlie Clark

12172 publicly visible posts • joined 16 Apr 2007

Not LibreOffice too? Beloved open-source suite latest to fall victim to the curse of Catalina

Charlie Clark Silver badge
Flame

I expect there are a few very important things that can only be done on Apple

In many situations it's one or two very important things, which is why people stay. I've yet to see comparable desktop apps for Linux, not least because GTK refuses to die and take Poettering with it.

If I do move, it will probably be to something running on Android. Samsung's Dex is a little rough around the edges but I can see where it could go.

Charlie Clark Silver badge

Lots of reasons not to switch to Catalina, not least lots of perfectly good software becoming unusable including my printer and scanner drivers. Gee whizz, Apple, of course, I'll buy new hardware to use your latest dumbed down version. SWMBO's machine was also asked to leave the bus an update ago. I can understand the move to 64-bit but less the way it's been handled.

But I've also seen more serious problems particularly regarding logins and certificate management. The usual advice for any MacOS update is to wait at least a couple of patch versions (around the new year) while Apple continues fix all the stuff they've just fucked up. But basically with Catalina, just disable the notification that there is a new version.

Tesla has made a profit. Repeat, Tesla has made a profit – $143m in fact

Charlie Clark Silver badge

Leasing versus sales

Sales down, profits up. What does this tell us about the business model? And why is a car company selling solar panels? Apart from Musk bailing out another of his companies?

Tesla blamed the drop in revenue on a tripling of leased vehicles compared to the same period last year.

You know things are looking down when leasing rates spike: leasing is less cash now with the leasing company sharing the risk.

Chinese customers to unfold their Huawei Mate X on 15 November

Charlie Clark Silver badge

Let me guess your age. 25, and 10 stone in weight.

Wrong and wrong: I've had a mobile phone for about 25 years. Not sure what it has to do with the price of fish.

Charlie Clark Silver badge

£ 2000 is far more than I'd want to spend on the phone but I do at least find the idea of a foldable screen interesting. And I can imagine a heap of users going "this is exactly what I want".

Can't say I think the same when it comes to cars: people seem to prepared to spunk £ 2000 on the wheel rims alone.

Charlie Clark Silver badge

Re: Alternatively

Sticking your own OS on an SoC is not as easy as many people seem to think and I'm really not convinced it's necessary. AOSP with a good Terminal / SSH app should be sufficient for most sys admins.

Haxis of evil: Russia, China, Iran and North Korea are 'continuous threat' to UK, say spies

Charlie Clark Silver badge

Benjamin Franklin seemed to think that sacrificing freedom in the pursuit of security would lead to the loss of both. So, when it comes to snooping, there probably isn't much difference. And, when it comes down to standing up for individual freedoms, well, it's not as if we've got a stellar reputation there either, at least not where expect to make money.

Charlie Clark Silver badge

Cue Blackadder sketch about spies because of coure the guys and gals in GCHQ and the NSA are brave and tireless heroes, whereas the weasels working for the Chinese, Russians, Enemy-of-The-Week are filthy and underhand. It's not as if the US itself partial to industrial espionage

In the meantime, more and more Americans believe that evolution is a hoax and that vaccines are part of a conspiracy theory. I mean, do we really need the Russians and the Chinese to meddle when we seem to be doing such a good job of fucking stuff up ourselves?

We read the Brexit copyright notices so you don't have to… No more IP freely, ta very much

Charlie Clark Silver badge

Re: TL;DR

Sure, I blame the EU for mad cow disease. If the EU hadn't allowed Maggie to reduce standards before feeding processed sheep to cows then it would never have happened.

Luckily we can start looking forward to having our farmers compete with free marketeers such as the US. With out ballooning budget deficit we're well equipped to stand by our farmers…

What really gets me, BoJo is such a terrible speaker off-the-cuff and seems to have no grasp of policy or procedure why is this entitled bumbler and the rest of the B-team so popular?

Charlie Clark Silver badge
Facepalm

Re: TL;DR

For every non-EU person I decide to hire, I have to put together a justification document, listing the details of least three EU nationals considered for the post and reasons for rejection.

This is not an EU requirement but devolved to national governments who never ceded control. If I look at the software engineers in the companies round (Huawei, E-ON, Trivago) here they are teeming with non-EU nationals. This is also why Kensington and Chelsea is teeming with foreign oligarchs: the UK says you're very welcome if you spend more than £ 1 million on property.

The last time I sent someone non-white

And yet you put your faith in people who crow in parliament over how much better Eton is than Winchester? As Rees-Mogg did earlier this year.

For many, though certainly not for all, racism was one of the reasons to vote to leave the EU, viz. at least one poster suggesting a horde of a million Turks eager to move to the UK.

Charlie Clark Silver badge

Re: TL; DR

people who talk with unusual accents

Do we get to deport anyone who speaks Mockney? If so, count me in!

Like Visual Studio Code and your data lives in SQL Server? Microsoft has something for you

Charlie Clark Silver badge

Valentina Data Studio

Over the last few months I've been very impressed with Valentina Data Studio for general database work.

Mark Hurd is dead

Charlie Clark Silver badge

Re: More accurate

To be fair, he was just one of several CEOs that nearly ruined the company. But as long as shareholders give boards such an easy time this will continue.

UK culture sec hints at replacing TV licence fee, defends encryption ban proposals and her boss in Hacker House inquiry

Charlie Clark Silver badge

Re: Yes please...

Threatening to use a gun, whether you have one or not, is an offence in itself.

If you have the means to receive the BBC's content then you are, by law, required to pay the licence fee. You might not like it, and arguments about plurality obviously don't interest you, but it's still the law.

Charlie Clark Silver badge

It also tells you what a bargain the licence fee is: lots of original production, local news in TV and radio.

A subscription fee is, by definition, not compatible with a universal service such as that which the BBC is required by law to provide. The licence fee feels like a tax but provides some degree of independence from government interference by going straight to the broadcaster.

Of course, all the populist arguments are about how shit and biased the BBC is. This is because they are designed to ignore the millions of people who depend on the service for one thing or another.

I'd much rather have a debate about possibly narrowing the remit for the service and possibly taking some of the money away from sport by defining more events of "national importance". Footballers, test cricketers, Formula 1 drivers already have more enough money. We can also discuss how to check for bias and mitigate against in ways other than giving nutjobs a right to vent – they're doing this anyway without any checks all over the interwebs – and also how much the BBC pissed on that pet project BBC Sounds. Apparently IPlayer Radio within the UK is no longer available: get yerselves the international version for buzzword free enjoyment.

Fancy yourself as a bit of a Ramblin' Man or Woman? Maybe brush up on your cartography

Charlie Clark Silver badge

Re: Huh!

I've not had much of this to be honest, but it's probably worth noting that Google Play Store at least allows developers to run open betas, which are really useful for major changes. Something the OSMand takes full advantage of.

We're free in 3... 2... 1! Amazon unhooks its last Oracle database, nothing breaks and life goes on

Charlie Clark Silver badge

There's lots of PR in demonstrating that Amazon pays the same as anyone else and chooses AWS because it's the "best" solution. But beyond that, and any accounting niceties, it also suits Bezos management style as a stick to beat suppliers and internal departments.

Charlie Clark Silver badge

Re: Unlike Aurora

SQL Server is still playing catch up with Oracle and DB2, which is why it can afford to / has to be cheaper. To some it's still the "new kid on the block" but if you look at the cost of licences for other MS "enterprise" products, they have a distinctly "Oracle" feeling about them.

Charlie Clark Silver badge

Re: Informix to Postgres ...

500,000 USD to 1,000,000USD

Equates to around 2 to 4 top-notch DBAs for a year so you were saving money from the start. Of course, a full analysis would cover what compromises (say reports), if any, you had to make and whether you got any additional benefits.

Most of the work I automated with python (Hey, I'm a lazy programmer / DBA - what can I say ...)

But that's the best kind. The beancounters love automation but they often don't understand the kind of people it takes to get it.

Charlie Clark Silver badge

Re: Informix to Postgres ...

Web pages from Postgres tables for FLASK.

You know you really want to be using Pyramid. Has some lovely fine-grained controls for the DB connection… ;-)

Charlie Clark Silver badge

Re: I like Postgres, a nice easy step from "Horr-acle"

Performance doing what precisely? Postgres is generally considered to have excellent support for concurrency but is acknowledged to have not the best write performance, though changes in the last few releases have seen significant improvements there.

But in any particular test (OLAP/OLTP) it's going to come more down to the ability of the DBA to configure the system correctly than any inherent DB features: if you don't know what they are or how to control them, they aren't going to help much.

Charlie Clark Silver badge

Re: I like Postgres, a nice easy step from "Horr-acle"

One who's witnessed more than one fuck up and managed to learn from it. No one starts out knowing how to do the stuff properly.

As opposed to someone equipped with sales manuals full of buzzwords…

Charlie Clark Silver badge

Re: Unlike Aurora

That's a nice AWS setup you've got there, would be a pity if something were to happen to it.

All the cloud vendors have a vested interest in making it easy to check in but difficult to leave their data hotels.

And their engagement with open source is often only as far as it serves their narrow, commercial requirements.

Charlie Clark Silver badge

Re: Informix to Postgres ...

The commas are a little confusing on the VM Ware licences.

Did you spend you spend all your time doing this? In which case it's presumably savings after the first year or so?

Oracle -> PG is tried and tested and EnterpriseDB means you can keep most of your "stored procedures" aka Oracle lock-in bombs.

Charlie Clark Silver badge

Re: I like Postgres, a nice easy step from "Horr-acle"

Welcome aboard! The familiarity is, of course, no really a coincidence as back in the mists of time they were both based on the same project at Berkeley.

And I think experienced Oracle DBAs are going to help make Postrges even better. In the last 10 years it's got so much better largely due to the input (both in source code and comments) of seasoned industry professionals.

Charlie Clark Silver badge

It shouldn't really be does as a black-ops project but it might have to start as such (cf. how YouTube convinced the internet to stop using Internet Explorer 6) with a proof of concept. I suspect that the vast majority of any company's databases does nothing special and could migrated to another system with a dump/load. The rest will, of course, take research, planning and costing but the savings can quickly become substantial once you stop having to buy licences for everyone in the company on all their devices.

If Oracle is required for "mission critical" stuff then work around it. Once you can demonstrate functional equivalance without the licensing costs for some projects, it should be possible to draw up a high-level analysis that quotes Amazon as having done the same thing already. Going to the "cloud" will probably be mentioned and any references to this new form of lock-in are likely to fall on deaf ears, because "cloud" sound a lot like "lower headcount" to a PHB.

Note, as soon as Oracle finds out that something like this is in the offing they'll launch the sales droids with FUD bombs to try and frighten people off, so you must have functional equivalence for backup/restore, etc. But, also, once you've moved one proper application you can also start asking for rebates.

At the end of the day, there should be nothing wrong in keeping some stuff in Oracle if it really is the best tool for the job. The problem is that Oracle needs to learn that that is what they have to provide and not Faustian contracts.

Blood money is fine with us, says GitLab: Vetting non-evil customers is 'time consuming, potentially distracting'

Charlie Clark Silver badge

Principles are easy as long as someone else is paying the bills

AFAIK GitLab is still being bankrolled by the VCs so having a warm and cuddly policy is just good PR that costs next to nothing. Expect it to have shelf-life of the time it takes to IPO or be bought.

Companies do, in general*, have the right to choose their customers with boycotts on Apartheid South Africa particularly well-documented, including the fact that the boycotts had negligible affect on the politics. But, if you do get into bed with the devil, make sure you don't get caught or fall foul of one of the arbitrary US sanctions: bombs to Saudia Arabia for dropping on Yemen are good; bombs to Iran for dropping on Yemen are, of course, bad. Greasing palms in Africa for mineral rights is always good.

* There are some exceptions when it comes to dealing with the general public.

Hands off our phones, says Google: Radar-gesture-sensing Pixel 4 just $999 with a 3-year lifespan – great value!

Charlie Clark Silver badge

Re: What a bunch of negative nellies!

I think you'll find that in our post-truth world we line up to spill bile on stuff.

TBH Google used the Nexus phones to trail Android's features while manufacturers were churning out crippled customised versions. They haven't needed to do this for a few years now with Samsung particularly, but others as well, producing top of the range devices, so the Pixels are pitched at a different crowd, which the price should make clear, which is, I assume Google Fanbois and Fangrrls. But, basically, it allows Google to test on-device AI.

Google unplugs AMP, hooks it into OpenJS Foundation after critics turn up the volume

Charlie Clark Silver badge

Re: My main problem with AMP

Giving it to a foundation is basically a euphemism for taking it out back… and waiting for the sound of gunshot.

Chemists bitten by Python scripts: How different OSes produced different results during test number-crunching

Charlie Clark Silver badge

Re: Fixing the symptom…

Except single-line functions are the spawn of the devil!

WeWork's Meetup slaps RSVP fees on events ‒ then tells everyone not to panic amid backlash

Charlie Clark Silver badge

Re: Liability?

Yes, upfront payment almost certainly formalises a contractual arrangement between parties. This may or may not be something you want to do, but refunds are certainly a complication and Meetup allows people to cancel whenever they want. We do charge for our local events (rooms and equipment it turn out aren't free) but I'd quite like to keep Meetup and PayPal out of the payment handling.

Charlie Clark Silver badge

Re: Good

It is a truly awful platform that unnecessarily removed Markdown support from event descriptions and still provides attendee lists as CSV files disgusised as XLS files, but it does have the reach. You can already opt to charge people for attending but this introduces additional complications. But something is needed because, frankly, the lots of people sign up to events and never turn up. This can lead to additional costs or exclusion of other people who would like to attend.

If they would only bother to maintain and continue to develop the platform, such as adding support for public nicknames but private real names, required for insurance or workplace security purposes in many cases, I wouldn't mind paying the fees as much. It would also be nice to be able to ban "no-show" easier: I currently have to mark them as such and then ban them individually.

First Python feature release under new governance model is here, complete with walrus operator (:=)

Charlie Clark Silver badge

This means they are a common optimisation method, and anything which makes them even faster is generally a good thing.

Premature optimisation is the root of all evil and a great way to waste time. I always advise people to write clear code and profile if they need more speed. Comprehensions don't necessarily loop much faster, not that Python's loops are that slow, but they do allocate less memory. That said, running nested loops through a JIT like PyPY or Cython will generally lead to C-style speeds.

Charlie Clark Silver badge

I'm not sure that the syntax change will stop people writing code to avoid nested if statements.

DSLs are probably the way to go for the small group of people (relatively) who need this.

Python has a history of introducing syntactic changes only to reverse them later (backticks, print >>, map, reduce, etc.). Some stuff stays because it is genuinely useful but this can take years of refinement before it becomes standard. My initial reaction to this change is that it is, unfortunately, yet more special use syntax forced on the rest of us. It certainly won't aid readability and the improvements are marginal. But let's see what the take up is in the next few years.

Charlie Clark Silver badge

Re: Yes, and...

The sort algorithm, which has since become a reference model, would suggest you don't know what you're talking about.

Charlie Clark Silver badge

In previous discussions that were similar Guido tended to follow the argument that to do nothing would cause the least problem. This is exactly the kind of the syntax that, because it's occasionally useful, it gets used all over the place where not only it isn't useful but in fact downright confusing, aka dangerous.

Seeing as it's backwards incompatible

Talk about a calculated RISC: If you think you can do a better job than Arm at designing CPUs, now's your chance

Charlie Clark Silver badge

Re: commercial lockout

What is good for RISC-V is Trump's attempts to freeze China out of the technology market. This would turn China into the centre of development for RISC-V and could quickly lead to Intel and ARM becoming also rans.

GNU means GNU's Not U: Stallman insists he's still Chief GNUisance while 18 maintainers want him out as leader

Charlie Clark Silver badge

Re: "The only way to do serious computing - servers, supercomputers, science?"

The BSD license counts as free software.

Not to the GPL purists it doesn't-

MacOS wakes to a bright Catalina sunrise – and broken Adobe apps

Charlie Clark Silver badge

Re: I'd love to know the rationale...

Less to maintain is the main reason. Means fixing fewer bugs twice. But also, with the move to turn the Mac into a glorified I-Pad, easier for cross-compiling.

Apple knows it can force people to migrate over time, even if they hold out a for year or two. Last year SWMBO's MacBook Pro went out of mainstream support.

MacOS 'Catalina' 10.15 comes packed with exclusive security fixes – gee, thanks, Apple

Charlie Clark Silver badge

Re: That's not very typical, I'd like to make that point.

Seems like par for the course to me. Apple has routinely only offered fixes in new versions, though this has usually been bug fixes and not security exploits. Catalina breaks a lot (if you're not 64-bit you're not coming in) and doesn't offer much for anyone who doesn't use IOS. I normally wait until January but am planning to skip this one entirely.

PostgreSQL puts the pedal to the metal with some smart indexing tweaks in version 12

Charlie Clark Silver badge

Doesn't "enterprise grade" mean licence fees so exorbitant that no one is going to admit to it being a mistake? I'm sure several Oracle DBAs just smile when they see someone talking up SQL Server, even though it is a fine database.

Charlie Clark Silver badge

Re: Can you configure a database as case insensitive now???

Searching and sorting are not the same so I'm not quite sure what the issue. In general, for columns you should normalise your data for whatever processing you're going to do. Case-sensitive sorts are almost always going to be fastest and you can define pro-table or pro-column collations and you can even do this pro query. See the docs for more information. The docs aren't perfect but that was the first page that popped up when I searched for collation, though as long as you don't use the LOCALE_C you shouldn't have too much trouble.

For searching, there are worlds of difference between using the builtin LIKE or REGEX and the text search extensions. If you do have data that is case sensitive but want to do case insensitive search (you have "JOBS", "jobs" and "job" in your data), then you really should normalise your data and/or query, or at least use a relevant index.

For full-text searches case sensitivity is the least of your worries!

Charlie Clark Silver badge

If I see something like query speed compared then I generally think, someone hasn't thought enough about their indices, or tried to use the analyzer. Now, while there is definitely scope for the Postgres analyzer tools to improve so that you know what to look for, that doesn't mean the database is slow. If something is "mission critical", be prepared to spend some money on external support to get the design right.

What do machine learning and "AI" have to do with a relational database? Please take your buzzwords with you and close the door on the way out.

Charlie Clark Silver badge

It sounds to me like you're describing MySQL. Postgres has always had excellent transactional and parallel features.

Charlie Clark Silver badge

You probably don't mean to say it, but your post implies that writing extensions for Postgres isn't easy. This is, of course, far from the truth.

Cosmo Communicator: More phone than the Gemini, more pocket computer than phone

Charlie Clark Silver badge

Re: why not bt keyboard

The advantage of the keyboard is that it puts the screen at a usable angle and keeps it close enough for you to use your fingers.

With a separate keyboard you need a stand for the phone and a dedicated battery for the keyboard which adds to the size and weight.

Charlie Clark Silver badge
Happy

Re: I'd love one

Let me guess, your house is already filled with similar gadgets that you didn't need but still wanted? Join the club!

Charlie Clark Silver badge

The whole Debian on the Gemini was a huge distraction for Planet for a few vocal users. Because the device uses a Mediatek SoC getting proper support on Linux was always going to be difficult. For those who want to go that route, Sailfish is the better option. But personally, I think Android with a good SSH client is sufficient for most sys admin work that I'm likely to want to do on the move.

Charlie Clark Silver badge

Re: Software

I might indeed switch to Sailfish at some point, but it's still not a ringing endorsement of Planet's approach. They could have gone with AOSP from the start, except that this doesn't get them the Gapps that many people consider essential.

Charlie Clark Silver badge

Re: Software

Unfortunately, the software is the Achilles heel of Planet's offerings. The hardware Gremlins have been resolved but firmware updates are few and far between and long-standing bugs just haven't been fixed. The device itself is immensely practical. You really need a table to use it properly but it does then let you do a lot of stuff: I was able to demonstrate PyDroid on it recently, albeit without using the native HDMI out, which for some reason refused to work. USB-C on one side is charging only, on the other output only. Sound is tinny but bearable. I only got a replacement Germay keyboard after Andrew Orlowski intervened. This is all okay for a device that you can always takes with you and works.

But the software side is poor:

  • Android 8.1.0 from Decemeber 2018
  • if WLAN is dropped, it will not reconnect but drain the battery in a couple of hours
  • keyboard will randomly go into CAPS
  • quite a few apps (IPlayer Radio) just crash
  • the custom version of K9 is quite frankly awful

Basically, looks like Gemini users have been frozen out so that the Cosmo can happen. I knew what I was getting into when I signed up, but still disappointing to see the after-sales service fail so badly.