KOWTS #3

Posted on

"To live with no regrets is to live happily."

Comments

Post a Comment

Feel free to ask, suggest and comment regarding this post/blog. You can also contact me through e-mail, just always use the contact page. Thank you for visiting this blog.

Popular posts from this blog

Facebook Page or Blog Creation?

Posted on
Image
"Which comes first, Facebook Page or Blog Creation?" This question bothers me. There are Facebook pages that I "like" in which it doesn't have a website but I'm sure that almost websites now has Facebook pages. As my personal view, having a 10k-100k likes in Facebook without a site is somehow a missed amount of opportunity and a potential penny. Not being greedy but at least you paid your effort in running your page. Anyway, just to answer the question I created a blog first then Facebook page coz I don't post too much in my Facebook page. I know it's lame! :P On the serious note... Primarily, the main function of social networking sites/media for me is to make your post (video, images, etc.) viral. It's like having a free ad service in every "like" and "retweet" as we call it. It helps you gain huge traffic. Just an advice regarding which path you'll take... If you begin with Facebook page... Share ...
Read more

Optimizing Near-real Time Module

Posted on
Image
Super-Related Post:  GEODJANGO + GEOSERVER + OPENLAYERS COMBO! The scenario is we have a python script that runs on a given interval that automatically loads shapefile into PostgreSQL with PostGIS database.This shapefile is from a simulation done by a computer and it is updated on a timely basis. Near-real Time module of the app performs INTERSECT query to generate statistics. This involves two tables on the database. Every query took more than 5 minutes which is unacceptable. No matter how I try to change(optimize) my query, it's still SLOOOOOOOOOOOOOOOOOOOOOOW! So, instead of directly performing INTERSECT query between two tables every time the user take request. I have this instead: I created a stats table where the results are inserted and stored on it. After loading the shapefile into the database, a PostgreSQl function will be called and perform the INTERSECT query then insert the new result to the stats table. The database server will just perform select quer...
Read more

Create a Gadget with Posts from a Specific Label

Posted on
Image
This is the scenario here, you want to have a gadget/widget containing the posts of a specific label. Let's say, you have 10 posts having an "ABC" label and you want to create a gadget containing those posts. Sounds confusing but it's simple to achieve using Feedburner and it's BuzzBoost service. Before proceeding, you may take a look on how to create a feed out of your blog posts here.
Read more