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. Continue reading
Blog
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.
Continue reading
Google Maps Mashup – Latest Earthquakes in the World
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
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.
Continue reading
C#: 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.