Quick Tip: MySQL Workbench 6.3 (macOS Sierra) hangs on simple queries

Update: This issue is now fixed in MySQL Workbench 6.3.9

After upgrading MySQL Workbench 6.2 to 6.3, my Workbench displayed Mac’s spinning wheel of death almost all the time, even with the most simple query:

The queried table consists of 4 rows with 10 columns each and approx. 10 characters each. So it should be done in no time. Except if you’re using macOS Sierra and MySQL Workbench 6.3 you get the spinning wheel.

According to a user on SO, it’s a known bug and popped up with the introduction of a new security feature in Sierra: “Gatekeeper Path Randomization“.

As long as there is no bug-fixed version of MySQL Workbench, here is a workaround until MySQL releases a new version:

Continue reading “Quick Tip: MySQL Workbench 6.3 (macOS Sierra) hangs on simple queries”

Flash ESP8266-01 with Arduino Uno

Connect Arduino Uno and ESP8266 with a voltage divider

When I first got introduced to the world of the ESP8266, I had a real hard time to find a way to flash the firmware of the ESP8266-01 with an Arduino Uno. Many existing tutorials took essential information for granted or required additional hardware like a FTDI Serial TTL-232 USB cable, a USB-to-serial converter or a level shifter. Others were written specifically for breakout boards like the NodeMCU, SparkFun Thing or Adafruit Huzzah.

As I only had an Arduino and a barebone ESP8266-01 at my disposal, neither of these tutorials were viable. Eventually I managed to flash the ESP-01 firmware with pieces of information from Instructables, various blogs and youtube videos.

That’s why I wrote the missing step-by-step beginner tutorial on how to flash the ESP8266-01 firmware with an Arduino – it only requires an ESP8266, an Arduino, a USB cable and some wires to flash your ESP8266.

Continue reading “Flash ESP8266-01 with Arduino Uno”

Quick Tip: Install a specific Git Repository Branch/SHA Hash with Bower

The other day I had to hotfix ngQuill, a nice angular.js wrapper for the quill.js editor. A variable with an initial value prevented Copy & Paste events in our project and I couldn’t wait to get my pull request merged into the original github repository as we had to release a working version.

As a workaround I tried to do a bower install with the latest commit (or SHA hash) of my forked repository. As my fork is not published on bower, I used the entire URL to install the bower package and ended up with the following error:

The Fix: https:// VS. git://

Try to replace the prefix “https:” and instead use “git:” for the repository and it will work.

Branch works with git://

SHA Hash works with git://

Both won’t work with https://

If you used the --save-flag, your bower.json file has a new entry similar to this one:

If you know why it works with the prefix git and not with https, let me know in the comments.

Quick Tip: Release iOS 7 Apps with Xcode 8

Xcode 8 with iOS 7
Build iOS 7 Apps with Xcode 8

If you (like me) wanted all the new bells and whistles in Xcode 8 and realized too late, that the latest officially supported iOS Version of Xcode 8 is iOS 8 and you need support for the iPhone 4 or iPad mini (both run on iOS 7) in one app, here are the good news: You don’t have to go back to Xcode 7 – we built and released a working App for iOS 7 with Xcode 8.

Continue reading “Quick Tip: Release iOS 7 Apps with Xcode 8”