SQL: Delete all Rows with “foo” in the String

Let’s say you’re building something cool and you try to share this amazing thing with a friend. Then that friend decides to blow your DB up with useless entries. Because that is what friends do. In such a scenario, you might end up with something like this: select count(*) from table; +———-+ | count(*) |…

Read More

Creating a Keystore for Android Apps on Windows

If you’re building Android apps for the Android or Amazon Playstore you will need to sign your apps with a certificate. To do this, you will need a Keystore file. There are a lot of instructions on how to do this on a Mac, but if you’re on a Windows machine it’s a labyrinth of…

Read More

Working with Merge Conflicts in Git

There are instances while working with a shared repo that your Pull Request will hit a conflict with the master repo and that will prevent your PR from being merged. The easiest way to resolve this is going to be via your terminal. Step 1 – Ensure you are working with the master repo (the…

Read More