Google Image Search URL Extractor

Google Image Search URL Extractor
Background When building WindowsThemePack.com, I often need to download massive number of images as the pictures source for the Windows theme packs. Initially I just download the images manually from Google Image Search Result. But this is very time-consuming, so I went to search for quicker ways to download the images. To my surprise, there’s ...

Add image slider for your WordPress

Add image slider for your WordPress
Background Adding responsive image slider to your WordPress blog seems like an easy jobs thanks to those large selection of plugins. So far I’ve tried the following Responsive Slider – Image slider, by Huge-IT Ultimate Responsive Image Slider, by Weblizar Slider – Slideshow & Responsive Image Slider for WordPress, by Richteam While they all work well as expected, ...

How do you display WordPress posts in responsive grid, list layout

How do you display Wordpress posts in responsive grid, list layout
When designing my hobby website windowsthemepack.com, which offers free theme pack for Windows 7, 8 and 10. I need a plugin that display posts by category, in responsive grid, list layout without coding. I tried a few plugins such as Post Grid & List for WordPress – Content Views, by PT Guy This looks pretty good, however, it has ...

Customize the WPAdverts adverts_list to exclude category

Customize the WPAdverts adverts_list to exclude category
After installing the WPAdverts plugin, you can add the shortcode [adverts_list] to any page (usually homepage) to display all active post ads. Once you have some ads posted the page should look similar to the one below: Shortcode Parameters name: string (default “default”) – this is mainly for future use, the name basically should identify shortcode. ...

S3 bucket policy – Action does not apply to any resource in statement

S3 bucket policy – Action does not apply to any resource in statement
Background In this post, I will address a common question about how to write an AWS Identity and Access Management (IAM) policy to grant read-write access to an Amazon S3 bucket. Doing so helps you control who can access your data stored in S3. In my program, I tried to list the objects under a ...

MongoDB aggregation by multiple fields

MongoDB offers aggregations operations which process data records and return computed results. Aggregation operations group values from multiple documents together, and can perform a variety of operations on the grouped data to return a single result. MongoDB provides three ways to perform aggregation: the aggregation pipeline, the map-reduce function, single purpose aggregation methods. Today, let’s add ...

Solr MongoDB data import handler support delta delete nested object

Overview MongoDB’s full text search is pretty basic, much like what’s offered in relational databases, which might be sufficient for you. However, if you need more advanced search capability, Solr will come to your mind. However, there’s no official (supported/complete) solution to integrate MongoDB and Solr. Here I’m going to throw in some solutions Options Option ...

PostgreSQL yesterday, today, tomorrow, now

PostgreSQL example – yesterday, today, tomorrow, now select TIMESTAMP ‘yesterday’; 2016-05-05 00:00:00 select DATE ‘yesterday’; 2016-05-05 select TIME ‘allballs’; 00:00:00 You can use similar convenient method for today and tomorrow: select TIMESTAMP ‘today’, DATE ‘today’; select TIMESTAMP ‘tomorrow’, DATE ‘tomorrow’; select now(), TIMESTAMP ‘now’, DATE ‘now’; BTW: what is ‘allballs’? It’s used to denote midnight UTC, someone ...

java unmappable character for encoding

java unmappable character for encoding
Nowadays, many projects contain Java source code that is  UTF-8 encoded, which allows you to add special characters like €, Chinese, Korean, Japanese characters, etc into your Java source code. But this brings a problem when compiling the code in Windows platform. java unmappable character for encoding GBK (or CP1252) If you are using Gradle, ...

AWS SQS example AccessDenied AmazonServiceException

AWS SQS example AccessDenied AmazonServiceException
Background of SQS SQS (Simple Queue Service) is a fast, reliable, scalable, fully managed message queuing service offered by AWS. You may also heard of SNS, so what’s the difference between those two services offered by Amazon? In short, SNS (Simple Notification Service) is a Publish-Subscribe Service for Mobile and Enterprise Messaging. Messages are pushed to subscribers ...