5 PaaS solutions to host your NodeJS apps

So, you have put in all your best efforts into building an out-of-the-box Node.js application? If you’re contented with how the app has come up, it’s time to gear up for releasing it for the public. Well, numerous solutions can be chosen for hosting your Node.js application in the most refined manner. Through this post, I’ll be introducing you to five of the most recommended PaaS solutions which have made Node.js app hosting quite simple and efficient.
(more…)

Read More

Create a quick REST API using Slim framework

During a recent client project, I frequently needed to access a remote database table and update the same for certain fields. This was accomplished using phpMyAdmin on the server. However, it was getting tedious and was prone to accidental updates and deletes. Also, a couple of other developers also needed to make changes to certain fields on the remote database from their local server.

This is all a tedious process and prone to errors. One solution was to create a quick REST api wrapper around the remote database, using which developers could update the database table without any risk of corrupting the data and also with the added benefit of updating the table programmatically.
(more…)

Read More

Get the Top Seller items from Amazon using AWS

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.
(more…)

Read More

Add a custom search engine to your site using PHP and MySQL

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.
(more…)

Read More

Display line and area charts in PHP and MySQL

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.
(more…)

Read More

SQL like query on CSV and other tabular data

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.
(more…)

Read More