Every time Apple releases a new version of macOS, I have to go in and re-configure Apache with PHP the way I want it. So this time, I thought I’d automate the configuration changes with a single command.
I previously played around with MongoDB in a few containers. Recently, I tried IBM Db2 Community Edition and learnt a few new things about containers along the way. The challenge was rolling my own Db2 Data Server Manager container, working around the background process that the startup script kicks off.
Just sharing some Automator scripts I use for Touch Bar Quick Actions showcasing three different methods - using pre-defined Actions, using AppleScripts and using Shell scripts.
For a while now, I’ve been posting about compiling Wine on macOS, starting with Wine 1.9 in October 2016, then automating the compile for Wine 2.9 32-bit in May 2017. Now it’s July 2019, and this is probably my last post on the subject - a fully automated script to download and compile Wine 4.12.1 (released 7 July 2019) 32-bit and 64-bit on macOS.
I recently wanted to test a web app written in Node.js and exposed via fixed port. The instructions asked me to install Node.js locally, which I resist! So, here is how I built my Docker container to run the code.
I sometimes need to search a huge CSV file (13 MB), containing 21,000 rows and roundabout 40 columns, which Numbers takes half a minute to open. All I need to do is search and display the results of a few columns only... so I wrote a bash script to do this for me - and I was quite specific in that I wanted the results in color!
I got a new 2 TB external disk - "yay" - and wanted to use it for both on my Windows desktop and for Time Machine backups. Immediately thought to format it as exFAT but quickly came to realize Time Machine does not support exFAT! Fortunately, there is a workaround...
Recently I needed to analyze some JSON data. Now, I'm no data scientist, so I wanted to convert my JSON data to comma separated (CSV) and "flatten" the data... just so I could use the data in Excel.
And Merry Christmas and Happy New Year!
Microsoft PowerPoint 2016 for Mac (aka version 15) has a strange quirk - when I copy and paste images from Preview or most other applications, the image gets copied in Tagged Image File Format (TIFF). The image is practically uncompressed (or possibly minimally compressed), resulting in very, very huge PPTX files! Plus: Removing unwanted font references.
I recently had the "opportunity" to perform some text manipulation to get data from a huge log file into a spreadsheet. I had done this sort of work a long time ago as a developer, but had forgotten over the years. So I decided to compile a text manipulation cheat-sheet for macOS.
There are many open source packages that require the "AMP" stack comprising Apache, MySQL and PHP (hence "WAMP" for Windows-Apache-MySQL-PHP and "MAMP" for macOS-Apache-MySQL-PHP). Since macOS 10.12 Sierra already includes Apache 2.4 and PHP 5.6, here's how to add MySQL 5.7.
Some time ago, I posted about starting Apache automatically when macOS 10.12 Sierra starts, using the
launchctl command to add Apache to the
launchdLaunch Daemon/Agent Manager. For those familiar with Windows, this is akin to managing Windows Services.
Following up on my posts, Compiling Wine 1.9 from scratch on macOS with Retina mode and Creating a wine.app bundle manually, here's my script to automatically download and compile pre-requisite libraries, then download and compile Wine 2.9 32-bit, build the .app bundle, and even include a registry tweak to enable Retina Mode.
I recently downloaded an update to VLC, an open-source media player. The VLC download page, displayed it's SHA-256 checksum - here's how to quickly validate your download by comparing the checksum using the built-in macOS tools.
So I got a new MacBook for work and I didn't realize upon next reboot, the enterprise profile had mandated FileVault encrypt the start up disk, and Apple had recommended an upgrade to macOS Sierra at the same time! You can imagine triggering both simultaneously upon reboot didn't go well at all!
Want to extract files from a macOS installer package with a
Wine 1.9.22 development (dated Oct 28, 2016) has been released! See the release notes for changes. Alas, I encountered errors trying to compile it "on top" of the Wine 1.9.21 installation, following the steps from my post Compiling Wine from scratch. I spent a whole day searching for the problem, and resolved it as below.
So a couple of days ago, I documented how I compiled Wine 1.9.21 with Retina Mode from scratch on macOS Sierra. After that I though I might as well figure out how to bundle all these files into a
.appbundle, which Finder presents as if it were a single file.