In a previous post we had seen on how to access the Amazon Product Advertising API. In this post we will see how to add a function to get the ‘Top Sellers’ list for a particular category.

As mentioned in this post, Amazon uses a hierarchy of nodes to organize its various items. Each node represents a collection of items. Browse node IDs are positive integers that uniquely identify product collections. You can get a top seller list for a particular category or sub-category by passing a browsenode id for that particular category.
Read More


Search is an integral of all websites. Most of the current WordPress an other sites use a built-in search capability or rely on Google custom search. However, many a times you will want to add your own search engine which you can yourself control. This can be particularity useful if you have a small intranet. In this post we will see how to integrate a small PHP search engine into any website to add custom search capabilities.
Read More


Most data in any web application is usually sourced from a database. Usually some data transformation is required before we can visualize the required data. Most programmers however wanting to display visualizations or charts shy away from the task as there are a number of intermediate steps required to display the visualization. Morris charts however makes the task easier. We only need to directly pass the MySQL queried rows to the Morris charts javascript and we are done. Morris Charts is one of my favorite tools to display dashboard visualization on the web.
Read More

MySQL transactions in NodeJS

by: Sameer Posted in: nodejs |  

1 Feb 2015

In a previous post we saw how to access and query MySQL from NodeJS. In this post we will see how we can use MySQL transactions in NodeJS. We will be using the same library as used before, so if you have not installed it go ahead and install it. The library supports simple transaction at the connection level.
Read More

SQL like query on CSV and other tabular data

by: Sameer Posted in: data |  

29 Jan 2015

CSV files are ubiquitous in the programming world and most data interchange is done using the CSV format. One problem however is that you cannot quickly check for certain rows depending on a particular field criteria. As an example, say you need to find all the rows from a CSV file that has a particular value in a field. The most probable path would be to import the CSV in a spreadsheet and then process it to find the particular information.

In this post we will look into a command-line tool that allows you to query CSV data with SQL like syntax. q – Text as Data is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). You can look at q as a meta-tool which provides access to all the data-related tools that SQL provides (e.g. expressions, ordering, grouping, aggregation etc.), but on tabular data files.
Read More


Currently my favorite IDE for NodeJS is NetBeans. Although there are other excellent IDEs available, nothing beats a free one. Also, as I regularly use NetBeans for PHP it is natural to also use the same for NodeJS as it becomes easier to manage multiple projects in a single IDE. In this post I describe steps to install NodeJS development environment in NetBeans.
Read More


Creating responsive design from scratch is usually a tedious task for beginners. If you are new to responsive design then selecting a appropriate framework is an essential step in your design process. The following post give some pros and cons for a few selected frameworks to help you decide on a responsive framework for your new project.
Read More


Gone are the days when designing a site entailed starting from scratch with html and css. Now we have tools that take away the grunt work out of designing boilerplate code and other miscellaneous work, and lets you focus on what really matters, the end product. Below are a few good tools that will help you in designing and prototyping web and mobile products, whether working as a team or as a lone ranger.
Read More

Using a mobile accelerometer to enhance web app UI

by: Sameer Posted in: design,mobile |  Comments Off

13 Jan 2015

A accelerometer is one of the important sensors in mobiles. This sensor along with a gyroscope is essentially used by most mobiles games to detect motion in 3 dimensions whenever a mobile is moved or shaken. Although common with mobiles applications, web applications seldom use the features provided by these sensors. With some ingenuity we can use these sensors to enhance the user experience of a web app on a mobile device without much effort.
Read More

Integrating Googles new reCAPTCHA in PHP

by: Sameer Posted in: security |  

16 Dec 2014
google new-recaptcha

For the past several years Google’s reCAPTCHA has helped verify that a user is not a bot by forcing you to decipher warped text. reCAPTCHA’s method of protecting websites from spam has always been a kind of burden on the end user who has to solve the captcha to prove that he is human and not a bot.
Read More

Sign up for fresh content in your email