The Aproneer

So my friend Sam recently started a new recipe blog, and I felt compelled to share it with you. It’s called ‘The Aproneer‘ (very unsurprisingly given the title of the blog post).

A few of the recipes I’ve tried and liked so far:

And yes, I realize this is a shameless plug. But the recipes are genuinely tasty, and well-written to boot. I recommend a follow (via RSS or social media)!

My New Workstation Build

In the past couple of weeks, I’ve built and tested my new workstation PC. My previous workstation was a Dell Precision T5600 (built circa 2012) with a 6-core Xeon, 24GB of RAM, AMD V5900 GPU, and 120GB SSD. The performance was still fine despite it being nearly a decade old, but it had two issues: It was looooooouuuud, and very power-hungry (200w at idle). So, it was time to be replaced.

Many moons ago I used to work in a computer store, so I’m used to building my own machines. Why didn’t I last time? Because I needed something in a hurry, and somebody had their old workstation for sale on Gumtree, and it seemed like a good deal (and for the most part, it was).

My requirements for the new build were as follows:

  • Silence at idle is a must. The fans can be audible, but not annoying, under load.
  • 16GB of RAM at least, with the capability of holding at least 32GB in the future.
  • On that note, it should be somewhat future-proof. I should be able to upgrade the motherboard, case, and storage independently of each other (something I couldn’t do with the Dell).
  • It has to look good sitting on my desk (completely subjective, I know).
  • At least 8 threads for compiling software with, but the option of replacing the CPU in the future.
  • Support for three 1920×1080 DisplayPort monitors.

And the parts I have chosen to make all this happen?

  • Case: Fractal Design Era ITX
  • PSU: Corsair SF450
  • Motherboard: ASUS ROG Strix B460-I
  • CPU: Intel Core i3 10100
  • RAM: G.Skill Ripjaws V 16GB (1x16GB) 3200MHz
  • SSD: Western Digital Black SN750 500GB

All up, the cost of the parts was around $1000 AUD.

One thing I found quite annoying picking the parts for this machine was that the vast majority of available performance parts were gaming-oriented. RGB lights plastered on everything and designed to look like something that has fallen off an army truck (which ironically does everything they can to avoid having RGB lights). In addition, most of the reviews online, both written and YouTube videos, were written from the stance of a gamer.

Take for example the Fractal Design Era case. Gamers hate this case as it has terrible cooling for the GPU. It’s a legitimate issue sure, but one only faced by gamers. If you don’t have a discrete graphics card in the system, then you don’t have this issue and the case is thermally fine. But the positive trade-off from that thermal design in the GPU area is that it’s an ITX case that looks like it belongs in a modern art museum. Look at it. It’s beautiful!

My other part choices are pretty standard. An i3 is more than enough (it’s got as much power as my old Xeon), 16GB of RAM is plenty (8GB would have been fine if not for Microsoft Teams), and 500GB of SSD boot drive (plus a re-used 4TB drive for storage) is fantastic and surprisingly cheap.

Did I meet my requirements? Yes. It’s silent. It only consumes around 25w at idle and around 150w under full load. I consider that a huge win. The new machine would pay for itself in 3 years with power savings alone. All the fans are zero-RPM enabled and will turn off under idle conditions.

It’s also future-proof. I’ve learned the hard way in my last two computer purchases (the Precision workstation mentioned above, and a Dell XPS 9350 laptop) that a lot of damage comes from tightly integrated components. If one thing breaks or is no longer up to the task, the whole thing has to go. The reason I bought the Precision was that the XPS only had 8GB of RAM, and I needed more so I could run SQL Server and Microsoft Teams at the same time (madness, I know). To mitigate the environmental impact, I bought the Precision second-hand, which raises a different set of issues. Now I had a powerful computer, but I also had a loud, power-hungry, and (yet again) non-modifiable system. This is one tiny peek into the world of throw-it-away consumable technology products.

In my mind, the best way to minimise the environmental damage of our computer use is to make sure everything we buy follows the established standards. They last the longest and can be re-used by interchanging with other things. Take for example the ATX standard. You could buy an ATX case from 1998 and build a modern system in it. In fact, people do that. It has changed that little.

My goal is to have this case and power supply for the next 10 years, and this motherboard for the next 5. I can see a CPU, RAM, and SSD upgrade in the future, but the core platform should last a good long while.

Bring Back The Ferries!

Last weekend, a new bridge was constructed across the Tasman Highway near the Cenotaph in Hobart. This construction meant the highway was closed all weekend, making it much harder for Eastern Shore residents to travel into the city (they could, it just took much longer).

The Salamanca Markets were kind enough to sponsor a free ferry across the harbour from Bellerive to Brooke St Pier on the Hobart Waterfront (here’s their page giving details of the ferry service).

Given my enthusiasm for public transport, and given I was attending an event in the city in the afternoon, I thought I should check it out.

I also wanted to make sure that any person ‘investigating’ demand for a ferry service would know that it would be used. I need not have worried on that last point. I got chatting to a few people and apparently, there were hundreds of people lined up to cross into the city by 10 am in the morning. So great was demand that for a part of the day they put on two ferries rather than one!

I’m well aware that a sunny, calm Saturday afternoon probably results in greater demand than a cold winter morning. To that I say: ferries (at least this one) have a bar – with coffee in the morning and a beer at night, it beats the bus!

All I know is, Hobart has proven that we’re keen for it.

You Can’t Optimise For Tourism

There’s been a bit of discussion recently following the Dark Mofo festival in Hobart. The Lord Mayor of Hobart, Ron Christie, is warning of the dangers of Dark Mofo and the welcoming of tourists into Tasmania.

I personally think Dark Mofo is a great festival that gets sleepy Hobartians out of their beds on cold winter evenings. It (and other arts events) should be encouraged.

But it did make me think more generally about tourism in Tasmania and what is healthy and what isn’t for the state. My hypothesis is this: you can’t optimise a place for tourism, because to do so ruins the reason the tourists come.

I’d like to cite an example. Last year my partner and I went to Vietnam, and we visited a town called Sapa. Sapa was a little mountain resort village surrounded by beautiful mountains, with beautiful hiking trails all around. And then they started building more resorts and other infrastructure for the tourists. And now the only people there work in the tourism industry, and it’s not real any more. I remember looking at the town square and remarking, “it’s like Vietnamese Disneyland.” It wasn’t fun to look at ‘villagers’ who lived in apartments and went out into the village to sell trinkets to passing tourists. It was a complete waste of time going because I didn’t experience a Vietnamese village, which was the reason I went in the first place.

Hobart is a bit more than a mountain village, but it’s also surrounded by beautiful mountains with beautiful hiking trails. It has an identity it has built up over the last few decades as a “clean and green” place, where nature is just left to be. The influx of tourists has caused a lot of angst between people who want to optimise for tourism (such as building resorts on the East Coast of Tasmania, or building a cable car up Kunanyi [Mount Wellington]) and those who want to leave the natural places alone.

The problem with leaving these natural places alone is that the tourists are going to come anyway. You’re damned if you do put in the infrastructure and let the infrastructure ruin nature, and you’re damned if you don’t put in any infrastructure and the nature just gets trampled. In this way, Tasmania’s natural beauty is bound to suffer in the future (unless we put in place limits on the number of visitors). We just get to choose the method in which it happens.

Back in the city (if Hobart can yet be called that), it’s a different story. Tasmania’s economy has suffered in the last couple of decades as our older economies (farming, mining and forestry) have shrivelled up. Only high-end agriculture (have you tasted Tasmanian cheese? YUM) remains as a viable source of income for the state. Then MONA happened, and everything changed.

Almost overnight, MONA changed Hobart. Tourism went from being a small part of our economy to the saviour (willing to bet David Walsh would love being called that) that was going to fix Tasmania’s economic woes. And for almost the last decade, it has done just that. It’s brought in visitors to both the summer and winter festivals, to the museum, and to Tasmania generally. It’s made Tasmanians feel better about being Tasmanian, and it’s made the mainland states stop making fun of Tasmania and start taking notice.

But MONA alone cannot save Tasmania, because MONA is tourism, and if tourism is all you have left, the tourists will leave too. And there in lies the problem for Tasmania: we need to find a new economy, something our state can do well at, and something that is in demand in the world today.

This isn’t a problem for the state government to fix. Besides the fact that the government couldn’t govern it’s way out of paper bag (and the opposition isn’t much better), it’s not something the government has in it’s power to fix. Yes, the government could hand out subsidies to businesses or provide grants or some other thing. But it’s the people of this great state (and I think it is great, despite it’s problems) that have to step up and do this.

But what is something that Tasmania could do well at? Well, we’re too far away from literally everywhere else to ship anything, so volume manufacturing is out. No point making trinkets here. We could (and indeed do) manufacture high-end goods, such as furniture and clothing for rich pricks the discerning customer. But half the time these high-end goods only get sold to passing tourists. I believe the reason for this is that a sole operator in a shed just can’t sustain marketing their product to the world. The only place where we have managed to do this is whiskey. If a viable large-scale high-end manufacturing business could be built in Tasmania today, it would propel Tasmania into the future.

Tasmania is well placed to do technology, because Hobart’s lifestyle currently offers a great deal to well educated tech people. Commutes are short (relative to Melbourne or Sydney), and our network infrastructure is the best in Australia. The cost of living is cheap, so starting a startup requires less investment here than elsewhere. And we’ve had a few successes. Procreate, Biteable and Popup WiFi are going great guns. But there’s a limit to the success we can have unless we can deal with two huge factors conspiring against us.

The first of these is education. Our public school system sucks, and our university is a joke (why UTAS sucks as hard as it does is an entire article in itself). We have some of the lowest literacy and numeracy rates in the country. What does the technology industry need? Knowledge workers who know how to read, write, and add things up. Education is the future of Tasmania.

Secondly, whilst the cost of living is currently low, and the lifestyle is currently good, that’s changing rapidly. Housing prices are sky-rocketing and availability is plummeting, making Hobart a much harder place to move to unless you’re very rich. Our commutes are getting longer as we build houses (slowly) further and further from the CBD, meaning we’re spending longer stuck in traffic every day.

We’re scared to build high-rise buildings in and near the CBD because it might ruin what makes Hobart special, and might scare the tourists away. I’d argue that not building the high-rise buildings is even worse, because if Hobart becomes a sucky place to live for the locals (and sitting in traffic makes you miserable) then the locals will go away, and the tourists won’t be far behind them.

There are other ways to make Hobart better for the locals. Public transport infrastructure is a big one, as is Health infrastructure (more hospitals, basically). At this point, you could throw money at basically any non-tourism infrastructure project in the state and it would be a complete success (they’ll invest it in roads, you heard it here first).

If you want to make Tasmania great again (urghh, I feel sick even saying it), then tourism isn’t the answer. It can’t be. We need to invest in our local population, and we need to invest in the infrastructure that makes our local population smarter, healthier, and happier. Economic prosperity will follow.

End rant.

Retrieving A List Of Customer Emails From WooCommerce

Recently I had cause to retrieve a list of customer emails (which due to guest checkout functionality is not the same as a list of user emails) from a WooCommerce installation. A quick search suggested that the easiest way was to install a plugin to do the job. I hate installing plugins on WordPress unless absolutely necessary (as half of them, including this one, are very badly maintained and thus either a security risk, a performance risk, or both).

Instead, the SQL query to retrieve this information, as well as a count of how many orders each customer has made, took only a few minutes to prepare and run: