PostgreSQL based Project Wins Gold Award in ASEAN ICT Award 2013

November 2013 is a great month for Datatrans Informatika and Systran Electronics Zone. “Smartcard for Frequent Traveler” (SFFT), a PostgreSQL based project presented by the two companies (located at Batam, Indonesia) as a team has won Gold Award in ASEAN ICT Award 2013 under Public Sector Category. (http://www.aseanictaward.com/index.php/about-aicta/aicta-2013-finalist). The ceremony was held on beautiful evening, 14th November 2013, at Gardens by The Bay, Marina Bay, Singapore.

foto1
foto2

SFFT is an ICT project to help frequent traveler entering and exiting Indonesian territory more effiecienty via 8 international seaports spreaded in Riau Islands province. Instead of wasting time in long queue for showing passport pages to officer at immigration check point, traveler can simply insert smartcard into reader at automatic verification gate.

SFFT relies on PostgreSQL database server installed at the 8 remote nodes at 3 different islands. The nodes are inter-replicated cascadely by means of Slony. Its asynchronousity helps replication works over unreliable network connection.

map1

SFFT is an ajax-based web application. Hardwares were driven through efficient Mozilla’s Js-ctypes. The technology enables communication back and forth between javascript codes and dynamic linked library written in C. At the backend, SFFT has Java Servlets deployed on Tomcat web server. Data exchanges with PostgreSQL database server is run through JDBC. PgPool was there to reduce connection overhead. Extension codes based on gSOAP library has been developed for data exchanges between PostgreSQL and immigration SOAP/XML web service. Overall system design is as follows:

system

I would like to thank PostgreSQL. It was really beautiful evening at the heart of south east asia.

About these ads
1 comment
  1. Awesome! We so seldom here from folks in Southeast Asia … please post more!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: