PHP and SQLite3 Simple DB Manager

Friday of August 26, 2016

Created another basic CRUD application, this time its for PHP and SQLite (https://github.com/joeyapa/Php-SQLite3-CRUD). The implementation needs a couple of improvements and basically it does the task it was intended to.

Jquery Form Generator Snippet

Wednesday of August 10, 2016

Simple jquery snippet to generate bootstrap form.

Jyoru Games Relaunched

Tuesday of June 07, 2016

Just relaunched jyoru.com to a different platform and server. The new server should be able to provide content much faster, better game response and improve loading time.

Tioman, Malaysia Weekend

Friday of May 27, 2016

There is no summer season in Singapore since it is constantly hot. Growing up in the Philippines we usually spend summer vacations in the beach during the months of (April - May), it became more like a tradition than regional preferences. This year we spent sometime with our kiddo to the nearest decent getaway here in Singapore.

Drupal blog database migration

Thursday of May 05, 2016

Doing blog migration from wordpress and drupal, below are the basic guidelines if you plan to use a brute migration. It is only advisable to do this for total blogs of less than a thousand.

1. Map tables and fields from database source to destination.

2. Generate the select query statement and make use 'AS' keyword to assign the target field

3. From your sql viewer export the queried data to a INSERT formmatted query.

4. Run the generated statements and wholah data has been migrated.

Kinda wierd writing this items, it is more like a reminder next time I try to do another brute migration.