PostgreSQL : query to find number of days different

In my previous post about “MySQL: finding number of days different”, there is example of how to get number of days different from 2 date.  However, the SQL command is not valid for postgreSQL.  PostgreSQL does not support for the query syntax TO_DAYS().  Fortunately, there is alternative method to get number of days different with other syntax for PostgreSQL. Read More


Apache, PHP and PostgreSQL Configuration

Installing and setup Apache, PHP and PostgreSQL are simple and straight forward.  However, the PostgreSQL library (libpg) or pgsql may not enabled or loaded even all Apache, PHP and PostgrSQL are properly installed.  There are a lot of information online, yet just doesn’t solve the problem that PostgreSQL libpg or pgsql is not loaded.  Some information online recommends some installation or setup packages for ALL in ONE that will install and setup Apache, PHP and PostgreSQL properly.  However, some (… like me) might dislike to use these installation packages that will also install some other files as well.  We will share on how to make all these three items; Apache, PHP and PostgreSQL to be setup and configured properly.
Read More


Google Maps Mashup – Latest Earthquakes in the World

Latest Earthquakes in the World - Past 7 days

After inspiring by some website on the topic of earthquakes, natural disasters, year 2012 and etc; pops up the idea of creating a Google Maps Mashup with jQuery that illustrates latest earthquakes in the world. With the information published by U.S. Geological Survey, we manage to obtain information of all earthquakes which magnitude 2.5 or greater in the United States and adjacent areas as well as magnitude  4.5 or greater in the rest of the world located by USGS. Visit our demo here.


10 Clean & Impressive Single Page Websites Design

Clean & Impressive Single Page Websites Design, vCard site.

Some may call it as single page or one page website; some may also call it as vCard site. This clean and simple web design is different from the one page web design that has been posted before. It has minimum content yet informative with impressive design. It has a name of “virtual card” or vCard site because it is normally used to deliver information of individual and contact.
Read More


C#: Standard Values Type Converter

Standard Values Type Converter

This post is to demo on how to implement a standard values type converter for a String property. With this type converter, the property will be shown on property browser as a drop-down list of standard defined values and also accept custom value that being keyed in by user.

Read More


10 Single Page Website Designs

Single Page Website Designs

Sometime putting less on your web design is more effective than having tone of pages. There are many websites contain one and only one Single Page and yet deliver its message effectively. Some of these website are really designed in a single page, but some are having multiple content sections in one “single page” design and make use of javascript or jQuery to navigate among these sections.
Read More


10 Online Store Design – Breaks the Traditional Look and Feel

Online Store Design - Breaks the Traditional Look and Feel

Do you fade up with the traditional and normal Online Store web design and its look and feel? Most of the look and feel of those online stores just don’t deliver their branding and images properly and correctly. In addition, most of those online stores are using original, standard and least modified template. They just give visitors an impression that they are just yet-another shopping cart design and yet-another traditional look and feel design. In this post, we would like to share some online store designs that breaks those traditional look and feel.

Read More


5 Twitter Widgets and Plug-ins for WordPress

Twitter Widgets and Plug-ins for WordPress
Looking for a Twitter widget and plug-in for your WordPress?  You may find a most suitable Twitter widget or plug-in to be integrated into your own WordPress blog here. These Twitter widgets and plug-ins are simple and easy to be installed and setup on your blog website.

Read More


Remoting: Singleton

Most of the information shows that whenever we need a singleton object of remoting, then we can make use of WellKnownObjectMode.Singleton. However, for some reason, I would like to maintain same object for both Remote Client and Local (Non-Remote).
Read More


Get content of an URL (useful for multi scheduled tasks)

I have a client’s API which located on different Domain. We are asked to access it by its URL with corresponding GET parameters. file_get_contents seems to be a simple way to make it works.
Read More