Portable MariaDB and Python (USB drive)

Schlüssel / Keys #apple #MacBook #MacBookPro #USB #Opener #Bottleopener #Prada #KeyringI’ve got a few projects rotating through the front burners, and one of them involves setting up a MariaDB instantiation on a USB key or drive or whatever you want to call it. And I want Python, at least for development. The nomenclature goes out the door when there’s more conflicted marketing than unconflicted engineering.

There’s some good stuff I found along the way that others might find useful. If you just want to get to the core of the solution, skip down to the ‘My Solution’ portion of this entry.

Stuff Found Along The Way.

I learned a few things along the way. For example, some people might be taken by this article on installing a web server on a USB key. Before you run off, you’ll might want to know about the Windows 10 Version of XAMPP available only on this German site (that I could find at the time of this writing).

A little rant here: Someone needs to do an AMP stack with Python. If I get bored enough and have enough time, maybe that will be something I fiddle with.

There is, of course, the ability to simply run a portable Linux install – I would historically go with Knoppix – but I opted out of doing that at this time because I just don’t want the overhead. No distro wars here, plenty of good distros here. In the end, when the time comes, I’ll research the new portable distros that have come out.

My Solution

It’s really simple. Just download MariaDB and drop the archive (zip, tar, whatever) onto your USB drive. Decompress it there. When you run it off the key, use the  “–no-defaults” option. If you’re running Windows, modify your shortcut with it.

“–no-defaults” keeps all paths relative. Bear that in mind if things get wonky. They haven’t for me, yet.

As far as Python,  WinPython is the answer for Windows. Runs right off the USB key. Read the documentation, someone wrote it for a reason.

Yeah, I know. Linux. Eventually, it will likely go that route, but for now it has to stay Windows 10 because of humans who use Windows 10.

Why I Never Cared About Certifications

fire (1)I have a special disdain for professional certifications in technology. Largely, they are indoctrinations designed to protect market-share.

An example that leaps to mind is a lukewarm intellect I encountered who – to his credit – worked really hard, and probably still is a certified Microsoft SQL Server guy. When a solution at the company we worked was best served by MySQL, he refused to touch it. It threatened him. He thought doing anything with MySQL would taint him. When it comes to professional certifications, he embodied what I’d seen over the span of two decades, where professional certifications were hammers and everything was a nail. Even zippers, which typically gives the result you would think.

I bring this up because, once again, I got a LinkedIn connection request from someone, I accepted, and they immediately started messaging me about ‘professional certifications’. I’m sort-of-kind-of-not-really-but-am retired. I didn’t want a professional certification when I was working – some employers did, but they learned to get along with me and not needing training papers laid out on the ground, as if I were a puppy.

There’s a little disdain in there.

When I started with technology, there weren’t certifications. You either knew things or you didn’t, you either learned things or you didn’t. I showed up for an interview at the first company I worked at in Texas dressed like a bad waiter.  With a briefcase, empty, but there for effect. My interviewer had ripped jeans. He asked me if I knew ‘C’ and ‘C++’. I said ‘yes’. I was hired. And I spent the weekend in the DeVry computer lab learning C and C++. Monday, I was coding for cash. It was 1989, I think.

And that’s how I worked over the years. I rode the waves of technology – leaving one engineering position in a multinational corporation to get into the Internet related technologies, working the ‘back end’ before we called it a back-end. From there, I rode waves – Content Management Systems, handwriting recognition, analyzing terabytes of data, and so on and so forth – moving on to the next interesting thing that was coming by long before they installed the bureaucracies of certifications. And when they started with the certifications, I moved on to something else. I even found myself writing guides – well received guides – for the certification site, “CramSession.com”, back in the day.

Don’t use the toilet at an interview unless you can demonstrate you’re certified on that. A note from your parents is not a certification, that’s just a reference.

So, I watch people who go out and get these certifications – a magical checklist of a roadmap that someone spread out ahead of them so that they could suckle their way up the food chain – or so they said. But when a company needed someone to get something working fast, as one former Director told me, I was the ‘team’ that came through, got results, and did things no one else could.

It’s what I do. I solve problems, not chase papers.

I still am. It’s who I had to be. It’s the unrestrained magic that Generation X had when we started that I managed to hold onto throughout. We grew up watching college dropouts begin to run the world. Bill Gates, The Woz (you might have heard of his partner, Steve Jobs). They thumbed their noses at the world and changed it… and promptly, with help from their peers and underlings, laid the foundation for something that they would have thumbed their noses at when they were kids. Full circle, like so many other things in life.

So do me a favor. Spare me the certification spam. I’ve written better documentation myself, and I have references.


Running The Biostar Racing P1

b20160823I had a problem. In my apartment here in South Oropouche, I had the need for a sort of media PC in the living room.

Sometimes I want to kick back and write on my old Chromebook while watching Netflix or a streaming news/space service on YouTube. Sometimes I want to write from my dining table – really, a patio table I have indoors because I like it. Sometimes, I want to listen to music while I’m working out in the living room. Sometimes, I want to have multimedia ability in the living room when I have visitors who aren’t in the bedroom (can I write that publicly?).

I’m in Trinidad and Tobago, so options are limited as far as what I can find locally. When I visited Pricesmart, I saw a Lenovo ‘Yoga Pad’ I almost got until I tried the keyboard (ugh!) and thought through what I actually wanted. They had a Haier Mini-PC that looked promising, but there were no boxes and a web search on my phone only showed a link to The Wizz whose site was down for maintenance.

I visited an Apple reseller and stared at the old and somewhat disappointing specs of the Apple Mini, which has become the one thing that Apple doesn’t seem to want to advance. And for the cost? Oh, Apple, your systems are so pretty, and OS-X is nice, but my word, your prices suck. Apple lovers, sorry, I see how you like spending your money but I can buy a lot of beer with the difference in price.

So I ended up at The Wizz in San Fernando, mainly to chase down the Haier and see what it looked like outside of a Pricesmart display that managed to tell everyone nothing. A gentleman helped me out, and dutifully trotted out the competition. That competition included the Biostar Racing P1, which I ended up with, as well as it’s little sibling, an Android version.

I’ll commend The Wizz here – over the years, on the rare occasions when I visited them, they have always been good – even over a decade ago when they were in some ways competition (I had a brief flirtation with wholesaling with one of their competitors). This was, hands down, my best experience with them. I picked up a keyboard, mouse and modest monitor for the system.

I got home. That’s when the troubles began.

Setting Up The Biostar Racing P1.

The box says that it’s Windows 10 compatible – and I mistakenly thought it actually came with Windows 10 on it. No such luck. Instead, it came with a CD for a system that – oh, this has got to take the cake – doesn’t have an optical drive. In fact, it’s so small, an optical drive couldn’t fit in it. So why on Earth would Biostar do this?

The documentation that comes with the system, a folded sheet of color printing, looks informative at a glance until you try to use it – they believe you know more than you do – and it’s actually not much better than their FAQ on installing Windows 10 on the Biostar Racing P1, dancing between informative and ‘WTF?’. It’s then I realized that my other systems also lacked optical drives – who uses those anymore? So here, I have a CD with no way to use it and cagey documentation on how to use the CD.

So I went with Linux. Lubuntu, Kubuntu – I went through quite a few distros in the course of an hour, using Rufus as noted in the FAQ, and every time there was no love for the AP6255 Wifi on the system. Oh, and the sound didn’t work. 3 hours in, I found myself scanning through kernel logs and considering hacking through all of it when I realized:

(1) I’m tired.
(2) I did not buy the machine to be a project, I bought it to be an appliance.
(3) I wasn’t committed to any course of action, I was committed to getting the results I wanted.

As it happened, a helpful cousin lent me a portable optical drive – so I (mistakenly) thought I’d install Windows from it. No joy – there is no Windows on that CD, I found, only drivers (not for Linux). At that point I realized I actually had to install Windows – I was tired – so I went to Microsoft and downloaded the ISO for Rufus to install via USB – that download took all night. I attempted to purchase a Windows 10 License, having figured out that it was necessary, but Microsoft gave me no joy. Amazon.com did. I punched in the product key during the installation on the Biostar Racing P1, and after an hour or so I used the borrowed optical drive to install the drivers.

It works, but honestly, this was annoying for me. Sure, I could have hacked through, sure, I could have done other things, but the documentation sucks and is a little misleading in my opinion. So, what do you need to know?

It’s a pain to get running, largely because no OS is pre-installed (to keep the price down, probably) and because the driver media is in a form that doesn’t come with the machine. You quite literally need another working machine to set the Biostar Racing P1 up, and if you don’t have an optical drive, you’ll have to navigate to Biostar to download the drivers, put them on a USB key, and hope you manage that without problems.

Now, using it once it’s all set up with Windows 10? Not bad. In fact, I wrote this entire entry using the system. Do I like it? Now that the annoyance of setting it up has passed, yes.

Would I suggest buying it for the casual user? Not unless you have a portable optical drive and access to a Windows 10 ISO as well as license. The lack of those two things is infuriating. It could easily be resolved by Biostar if they chose to install the OS at the factory – and honestly, they could toss a Linux distro on it themselves and save everyone some heartache. And money.