Profile cover photo
Profile photo
Paul Michael Labis
254 followers
254 followers
About
Paul Michael's posts

Post has attachment

Post has attachment
MySQL - Overlapping Date Range Filter
October 15, 2015 - I was bored so I went to play around with MySQL and solve some simple problem or exercise below to energize my playful mind. I have a table for bugs from a bug tracking
software; let’s call the table “bugs”....

Post has attachment
MySQL - Function to Capitalize First Letter of a Word
October 15, 2015 - I was bored so I went to play around with MySQL and solve some simple problem or exercise below to energize my playful mind. Write a function to capitalize the first letter of
a word in a given string. Example...

Post has attachment
MySQL - Rank Order by Votes
October 15 2015 - I was bored so I went to play around with MySQL and solve some simple problem or exercise below to energize my playful mind. Write a query to rank order the following table in MySQL by votes,
display the rank as one of the columns. CREATE...

Post has attachment
Cagayan de Oro - Software Freedom Day 2015
September 19, 2015 - A community organized event, Software Freedom Day, for the community in Cagayan de Oro City was held at Capitol University Laboratories. It has been a tradition that ITGx together with Capitol University to organize and celebrate SFD e...

Post has attachment
Information Technology Group X - Balingasag Tech Talk
August 25, 2015 - A technology event was held in Misamis Oriental Institute of Science and Technology (MOIST) organized by host school in partnership with Information Technology Group X (ITGx). Supported by Google Developers Group - CDO, DevCon, Google Busi...

Post has attachment
Fix Inverted Camera on Ubuntu Linux
I am running Lucid Lynx 64 bit OS version on my Asus i3 K52J Series laptop. Like everyone else, I like using Skype video/chat as well as Cheese camera for taking pictures and videos. Not until then when I had a problem using it. NOTE: Not advisable to do "e...

Post has attachment
Backup or Restore PostgreSQL Database
There is an easy way to create backup file and restore your current PostgreSQL database using the Linux terminal. I am not sure though if this is the easiest way. As of the moment I am writing this article, I used the following command to backup and restore...

Post has attachment
Encrypt and decrypt your files in Ubuntu using ccrypt
ccrypt is a utility for encrypting and decrypting files and streams. It was based on Rijndael cipher, which was chosen candidate by U.S. government's for Advance Encryption Standard. This cipher is believed to provide a very strong security. 1. Install CCry...

Post has attachment
Properties File with Arguments or Pameters
The goal on this tutorial is to be able to format a value on a properties file given its parameter or arguments. It is best describe as passing value as a parameter and inserting those values on the string retrieved from the properties file. To better under...
Wait while more posts are being loaded