Stats from the Past – Education Portal –

Looking back at the stats for a website ‘we’ used to operate a few years ago (circa 2006-2008). Here are some.

– Ran a engineering website – (no defuntct)  on a 200 MB shared hosting from (worst service ever).

– Moved to on a 5$ per month, revenues 100-200$ per month (that is more than 2000% growth)

– Growth hacking done by injecting the website on (Directorate of Technical Education – Mumbai) via their shitty Chat system that allowed <iframe> in chat messages :)

– Syllabuses stamped with link, backlinks still on google.

– Idea was to built a single platform for Engineering Students in India, and still is via (

– Google’s Orkut helped a lot.



PacktLib Plus – Ebooks

PacktPub has launched a special offer on annual PacktLib subscriptions. Until 4th November, customers can sign up to ‘PacktLib Plus‘ and get 5 free downloads in their first month of subscription.

What is PacktLib – It is a digital library that has all the PacktPub Books/ Ebooks titles in there for your reading pleasure.

Every device – Web, Mobile is supported. New published books are added as they are published.

Here is the official Press Release :

PacktLib provides full online access to over 2000 books and videos to give users the knowledge they need, when they need it. From innovative new solutions and effective learning services to cutting edge guides on emerging technologies, Packt’s extensive library has got it covered.

For a limited time only, Packt is offering 5 free eBook or Video downloads in the first month of a new annual subscription – up to $150 worth of extra content. That’s in addition to one free download a month for the rest of the year.

This special PacktLib Plus offer marks the release of the new and improved reading and watching platform, packed with new features. This deal expires on 4th November.


PacktPub Offer : All ebooks & videos for less than 10$ – the awesome place to buy books for your tech upbringing, is running a Level Up campaign that offers ebooks and videos for 10$ and less. Visit

The more books you buy the cheaper

  • Any 1 or 2 eBooks/Videos – $10 each
  • Any 3 to 5 eBooks/Videos – $8 each
  • Any 6 or more eBooks/Videos – $6 each

Have a look at for more details


Building a Web Application with PHP and MariaDB – Book Review

Building a Web Application with PHP and MariaDB
Building a Web Application with PHP & MariaDB

Another great book by PacktPub, covering MariaDB and PHP. The book starts with Database basics and quickly takes the reader to CRUD operations, REST API, PHP functions.

This is a reference guide, developers with knowledge of PHP, MariaDB (and/or MySQL) should get this book as a desktop guide and also for refreshing their knowledge, since a lot of things have been added to PHP 5+ and MariaDB, so syntax and best practices is what developers could learn from this book. For example, there is a new short array declaration in PHP 5.4 which allows squre brackets to be used to declare arrays.

 $arr2 = [1,2,3,4];

This is something I learned from the book as well. Chapter 3 of the book has more. I will not reveal it all :)

Chapter 4 gives a practical approach to building a PHP, MariaDB MVC application (Yes but don’t use it to build another Laravel clone please !! )

Chapter 8 is interesting, it covers REST API and XML Feeds, something Web and Mobile developers would love.

Overall the book is a great package for a LAMP guy/gal, but I feel for a reference guide there needs to be more content. But nevertheless a must have for PHP, MariaDB developers, this book certainly teaches you a few new tricks. Buy it from at

WooCommerce delete posts by taxonomy

Delete bulk products by taxonomy using the amazing WP_Query()

function delete_products()
$args = array(
'post_type' => 'product',
'tax_query' => array(
'relation' => 'AND',
'taxonomy' => '$taxonomy-name',
'field' => 'slug',
'terms' => "$taxonomy-value"
'posts_per_page' => 1000 // for some reason this is needed.


$loop = new WP_Query($args);

while ($loop->have_posts()) : $loop->the_post();
$product = new WC_Product(get_the_ID());


Woocommerce REST API – Fetch Products by Category

Patching the class-wc-api-products.php in woocommerce/includes/api file.

Replace the query_products($args) to

private function query_products( $args ) {
// set base query arguments
$query_args = array(
‘fields’      => ‘ids’,
‘post_type’   => ‘product’,
‘product_cat’ => $args[‘product_cat’],
‘post_status’ => ‘publish’,
‘meta_query’  => array(),

Use by the [filter] parameter in the API as filter[product_cat]=category-slug


PostGIS CookBook Review

The good folks at handed me a copy of “PostGIS CookBook” a comprehensive guide for GIS developers.

While i must say the book has some great recipes, LIDAR data processing is a good read, a small introduction to postgis and related technology would have been a good idea for newbie developers.

Nevertheless, the book offers great insights to PostGIS version 2.x, recipes like performing Routing on a OSM map, replication for PostGIS provide for great fodder to GIS developers.

If you are into location based services, travel, geo enabled services then this is not a recommended book but a MUST buy.

Buy it at