Get The Most Recent Record In A Table By Date And User

July 28, 2014 Nic Raboy

I often find myself working with legacy database tables that don’t have primary keys or auto increment keys. In addition to this, I always find myself needing to get the latest record for a particular set of data in my database. It is never as easy as just calling a max in the where clause. A subquery is often needed to get the most recent record in a table.

Using An Oauth 2.0 Service With Ionic Framework

July 24, 2014 Nic Raboy

Many APIs such as Google, Twitter, and Facebook require Oauth in order to use. This can get tricky when it comes to mobile because authorization must happen externally in a web browser. To our advantage, we can handle Oauth 2.0 using the InAppBrowser plugin for Apache Cordova.

Basic instructions on using the InAppBrowser with Ionic Framework can be found in one of my earlier blog posts. If you’re looking to use Oauth in an Ionic 2 application, visit here, otherwise proceed with Ionic Framework 1.

EZ Analytics for Android Released

July 23, 2014 Nic Raboy

I am pleased to announce my first Unity3D plugin is now available for download. EZ Analytics for Android offers Unity3D developers a native solution for Google Analytics with as little as two lines of code.

Download Remote Files Without A Browser In Android

July 18, 2014 Nic Raboy

There is often a scenario where you need to download files from a server onto the Android device. This needs to be done without forcing the user to launch a web browser and have interaction as some of the downloaded data might be private. Let’s use the scenario where you’ve made a game and you have in-app purchases. You want to keep the size of the game small for everyone so you decide to put the purchase items on your server. When a user purchases an item then the item will be downloaded in the background. This is a perfect usage example.

For purposes of the tutorial we will be staying simple. We will be downloading a remote image in the background and then displaying it when it has finished downloading.

Launch External URLs with Ionic Framework

July 16, 2014 Nic Raboy

I recently found myself needing to launch external URLs with Ionic Framework. I needed to let my users contact me via my personal website or visit my Twitter page. This is not a task that ends well when trying to execute from an Ionic view. Luckily, with a little help from the Apache Cordova plugin InAppBrowser, I was able to accomplish the task with very little effort. The best part is that it works for iOS and Android with the same code set.

If you’re using Ionic 2, a special version of this article can be found here. Otherwise enjoy this writeup for Ionic Framework 1.

Handle User Sign-In With Ionic Framework

July 13, 2014 Nic Raboy

When making an API app or any app that requires authentication it is critical to have a solid sign-in process. A good way to handle user sign-in with Ionic Framework is to make use of the already included ui-router module. The idea behind this is to route between sign in and protected screens as necessary.

Count Records From A hasMany Relationship In Grails

July 9, 2014 Nic Raboy

Recently I was tasked with trying to determine a distinct count between two tables with a many-to-many and one-to-many relationship. More specifically I needed to find out how many users were signing into the system on any given day. This is not to be confused with how many logins a particular user had for any given day.