Here is the list of some commonly used MySQL commands. It comes in handy when creating databases and troubleshooting issues related to character set and collation.

Stock4Q iOS App is available now. It’s the mobile version of Stock4Q webapp and has similar functionality for streaming stock quotes and portfolio management. The iPhone app makes REST API calls to www.stock4q.com server to login, retrieve, update portfolios and user profile using JSON. This way you can access the same portfolios on iPhone and in a web browser on any platform.

Stock4Q website is live now, providing streaming stock quotes and portfolio management. It provides live quotes in a browser using HTML5 and supports variable refresh rates. Stock4Q has single sign-on with Facebook, Google and Yahoo using OAuth 2.0 and allows you to import your Google portfolios into Stock4Q using Google Finance API. It tracks the gains/losses for each portfolio allowing you to set buy/sell triggers with traffic light highlighting. It has charts and stokes that visualize the trends for your portfolios over weeks, months and quarters.

Here’s a cheatsheet of some commonly used Mac OS commands. There are too many to list all of them, these just scratch the surface.

Collection of nice UI fonts that I’ve used in apps: Raleway, Source Sans Pro, Roboto, Lato

A quick summary of tips & tricks when debugging a webapp running in Tomcat. These come in handy if you’re running into memory issues and want to track down memory leaks.

HTML5 support is picking up in browsers, Safari and Chrome are definitely ahead of the pack with good support for CSS3 features like gradients, border-radius, transitions. Firefox4 is not bad either, just waiting for it to graduate from beta to production. I haven’t played too much with IE9, one of the problems I have with IE9 is that it overwrites my existing IE8 installation. I decided to update this website (original site written in custom PHP) to use CSS3 features and see how they work out in different browsers. I’m trying not to put any CSS hacks so this website will not render in its entirety on older browsers.

SfDash is an Adobe Flex 3.0 based application for creating, editing and viewing rich interactive dashboards for Salesforce.com data. It is a managed app and once deployed you can add SfDash tab to your personalized tabs. It supports interactive dashboards with drilldowns, intuitive wizard for dashboard item editing and highly customizable dashboard layout using drag and drop. This is version 1.0 of SfDash managed app.

Updated StockQ app to version 0.8. This version is compatible with Adobe AIR beta 3 runtime. Hopefully, this will be compatible with Adobe AIR 1.0 release as well. There is no change in feature set, only the packaging was changed to use the latest Adobe AIR SDK.

This is an updated version of the original ButtonMenu template. The original ButtonMenu template worked with JSPWiki version 2.0.54 and stopped working with some changes that were introduced in JSPWiki 2.1.x. ButtonMenu2 template has been created and tested against version 2.3.72-alpha. The ButtonMenu2 template skin overrides the style for unordered list (UL) tag inside the left menu so that all the list items appear as buttons. Hence, you can easily create buttons by adding list items to your left menu as shown in the above example. The ButtonMenu2 template skins are CSS based and use a standard layout for all the skins. The layout for the wiki pages is defined in the JSP files under templates/ButtonMenu2 directory. The JSP files have no styling information; all the styles are governed by the CSS files. All the pages in the wiki include the commonheader.jsp which embeds the link to the correct CSS file. There are 4 pre-packaged CSS files namely: jspwikiblue.css, jspwikicopper.css, jspwikicream.css and jspwikigray.css. The CSS files work fine both for IE and Firefox and there is no need for separate CSS implementations for different browsers. Just make sure that whenever you modify the CSS files you test it for both IE and Firefox. This template is released under a LGPL License.