MySQL Tip: Using Bitwise Operations for Multivalued Attributes

Recently, I was working on an Application when I decided to use bitwise operations on a multi-valued attribute. I haven’t done any performance benchmarks, but I would think this should improve the performance on making Queries. Here’s an example: Suppose we want to store Users and their Interests. We should have the following 3 Tables: […]

Continue reading →

Android Volley Tutorial – Making HTTP GET, POST, PUT

Google released Android Volley Library around May/June 2013, which has been internally used by Google for some time. It is supposed to provide Fast Networking Operations and also takes care of Threads nicely. If you are unfamiliar with Volley, please see Google I/O 2013 Video Unfortunately, there is almost no documentation on Volley. So, I […]

Continue reading →

Android activity hide action bar

If the Action bar of an Android’s activity needs to be hidden through the manifest xml file (non Java Programming), then the easy way is to add the following attribute in Activity tag: android:theme=”@style/Theme.NoActionBar” However, if a custom Theme is created then it is convenient to create another style extending the custom theme and then […]

Continue reading →

Using OAuth 2.0 with Google API in Phonegap / ChildBrowser

This article explains how to implement OAuth 2 with Google API (gapi) on Phonegap using Childbrowser Plugin. We will authorize Google Tasks API from Phonegap and then retrieve a list of Tasks (of default list) from Google Server. Because the App is built using Phonegap, it can be deployed in iOS, Android, Blackberry, Windows Phone […]

Continue reading →

Check Database exist fails android sqlite3openv2

I developed an android application where I shipped an sqlite database with the application. The Sqlite is initially stored at assets folder, and then copied to the proper directory (/data/data/[package]/databases/[db-name]) upon launch. I had the following piece of code for checking the existence of a database. public boolean databaseExist() { SQLiteDatabase checkDB = null; try […]

Continue reading →

Good Javascript Practices

I decided to share some of the best practices of Javascript which I have learned from various blogs and books over the years. Although, I used Javascript back in 2003, I didn’t learn Javascript properly and just happened to use it for some fun webpages. However, as I revisited Javascript from 2007 onwards, I have […]

Continue reading →

ezMark: jQuery Checkbox & Radiobutton Plugin

ezMark is a jQuery Plugin that allows you to stylize Radio button and Checkbox easily. Its very small (minified version is ~1.5kb) compared to other similar scripts. It has been tested and works on all major browsers (IE 6/7/8, Firefox, Safari, Chrome) and it gracefully degrades. It has the following Method: $(‘selector’).ezMark( [options] ); Basic […]

Continue reading →