Skip to main content

Posts

Modernizing Qwtlys Database Part 1

Its been years since I have last updated Qwtly and I was given the opportunity to play around and modernize the database for my application. I wanted to try the cloud offering of MongoDB called Atlas being that its free for a small database.  With this in mind and considering that Qwtly doesn't get traffic after I have disabled the add, edit and delete quote function along with the login, I don't see the application getting to that limit of 5GB anyway. Well, that is considering if I can even get this to work.  The first order of business was to see if we can import the MySQL export painlessly to MongoDB Atlas. I have searched for MongoDB tools, external tools, scripts, only to find old abandoned projects which would not be ideal given my situation. I have considered writing a PHP script to do it but that too would cost time. I was looking for something that consists of using existing tools or features I am familiar with along with some manual eyballing and checking. Luckily, I
Recent posts

OBS Black/Frozen Screen Issue

Recently I went back to streaming and tried to improve my setup and use Streamlabs OBS  (SLOBS), a variant of the popular Open Broadcaster Software (OBS) which includes a really nice app for iOS and Android which lets you control you broadcast. My only issue about SLOBS (and/or OBS) in general is when you stream some games, its a hit or miss experience. Most of the reported issues include a black screen (but with audio) or in my experience, frozen frames as I transition from one part of a game to another. I had the time to do some trial and error testing yesterday and listed below is the pre-requisites and some quick summary of my setup. Take note of the terminologies used throughout this post. Terminologies SLOBS/OBS - Streaming software, liberally used interchangeably in this post.  Source - This is where an input of OBS is coming from. This can be a webcam, computer screen, full screen application, a webpage, an image, etc. Display Capture - Captures your whole screen re

Self Signed SSL Certificates

Ever wondered how to enable SSL or HTTPS on your site? If you dont want to pay for commercial SSL certificates, you could create self signed certificates for your site by following the instructions here: https://www.digitalocean.com/community/articles/how-to-create-a-ssl-certificate-on-apache-for-ubuntu-12-04 The instructions in the site above will make your default site HTTPS enabled. If you prefer having a commercial SSL, save your certificate files and key files in your server and edit the location on the /etc/apache2/sites-enabled/default to point to the directory where you stored those files.

Report-a-Potty

In line with the nationwide Sanitation Hackathon organized by several organizations here in the philippines and abroad, I mentored for one of the GDG chapters here in Davao. After my presentation yesterday, I myself attempted to do a quick hack on how to help in the sanitation problems faced here and abroad. Using Google Maps Javascript API and a supposedly a little bit of PHP (but I became to busy to continue the rest of the application) I've created a webapp which does a simple basic thing: get your current location and report/tag it as an offender. This is in hoping that the corresponding establishments and local government units to improve the sanitation of their provided restroom facilities. Unfortunately, since im one of the mentors for the Davao participants, I wont be able to join the submission of entries. Its a nice proof of concept though :)  The source code could be viewed (since its all just a bunch of HTML and JavaScript. The app is available at htt

LTE and the Unlocked iPhone 5

So heres the deal, theres a new iPhone out there and its got the new blazing LTE. If you're planning to get one buying from countries which have unlocked options (Canada, Singapore, Hong Kong) doesnt necessarily merit that you'll get LTE compatibility wherever you go. In the iPhone 5 website, theres a little asterisk there. Pretty sneaky if you ask me, that they have created 2 different models probably using 2 different LTE chips. GSM model A1428*: UMTS/HSPA+/DC-HSDPA (850, 900, 1900, 2100 MHz); GSM/EDGE (850, 900, 1800, 1900 MHz); LTE (Bands 4 and 17)  GSM model A1429*: UMTS/HSPA+/DC-HSDPA (850, 900, 1900, 2100 MHz); GSM/EDGE (850, 900, 1800, 1900 MHz); LTE (Bands 1, 3, 5) - From: http://www.apple.com/iphone/specs.html So what does this mean? If you're planning to get an unlocked unit from other country, LTE speeds might not be compatible with yours. From Wikpedia , theres a working list of LTE bands per country. With me residing in the Philippines it seems t

Comparing Prepaid Data Plans from Globe, Smart and Sun

Recently I have been thinking about those minor differences when it comes to subscribing to a data plan here in the country. So far we're fortunate that we have lots of options but apparently, it takes some discerning as to what to subscribe to given the situation. I have been in several instances wherein, I was at the beach with friends for 3 days. I would be getting a better deal if I subscribed into an unlimited data for 3 days rather than 1 day and resubscribe every time. Thinking about my consumption, since I didnt bring my laptop then (hey, it was Boracay!) the only thing I do with my iPhone was to check my mail and check in to 4square. Maybe an MB based subscription might be better. On a recent trip, I was on the road going to the beach (again) but this time I have with me my laptop with the intention of squeezing in some work during the long travel time. I opted to subscribe for a 1 day unlimited since I knew for a fact that I would't be working on the way back. S

Data Disaster

Several years ago, I was issued a white Macbook for work which I typically use for everything. I have my work files there, I have my personal files there and it has been part of my life. A colleague  who was issued the same Macbook model woke up with an error with his Mac hard drive.  Photo credit from here As part of my work, I tried to recover whatever is recoverable in his drive. We had a Network Access Storage (NAS) which is seldom used but most of his files are in his Mac hard drive. Tough luck, after doing whatever I can to recover, I declared it dead. It was lucky that it was still under warranty but the files lost, or the time devoted to writing those files or creating those files will never be replaced.  Soon enough, despite that warning, mine gave out. Died. Same error. Despite that earlier warning, I didnt back up either to the NAS or to any other storage. If felt like my life has been wiped clean. Source codes, documents, pictures, my life. Its hard to accept l