January 2012 – Frankie Inguanez

Month: January 2012

MAMP, MySQL Workbench, WordPress installation and setup guide for MAC

Posted on 2012-01-31 by Frankie

Another task that I needed to do after buying my Mac was to get my Web toolkit working. Apache, MySQL and PHP are very conveniently managed by MAMP, WordPress is as straight forward as always. MySQL Workbench required some fine tuning but managed to fix it properly.

Decided to document everything as I went along and prepared a well documented guide with some of my personal recommendations. Hope you will find it useful and as always all feedback is welcome.

MAMP, MySQL Workbench and WordPress setup guide

Remote Access a system across different OS (A TeamViewer Guide)

Posted on 2012-01-30 by Frankie

One of my first tasks I wanted to be able to do after getting my Mac was to be able to remotely connect to my servers and a number of other trusted systems for support. I wanted to try a number of options and my first serious attempt was with TeamViewer.

My Laptop is a Mac, my Home-PC is Ubuntu Linux and my wife uses Windows XP. I installed version 7.0 of TeamViewer on each OS and got remote access in no time. Thought of creating a short guide on the subject even though the application is very self intuitive.

So here is the guide to getting remote access across different Operating Systems using TeamViewer: TeamViewer Guide

NTFS Read/Write support on Mac OSX Lion

Posted on 2012-01-19 by Frankie

One of the first problems I encountered on my Mac was how to manage some external drives using NTFS. After reading a number of blogs, postings and articles I found the one by Sergey Vasilyev to be the best. The following is a quick guide to getting NTFS read/write support on OSX Lion.

Tuxera MacFuse 2.2: Download Tuxera MacFuse 2.2 from here and install.
NTFS-3G: Download NTFS-3G from here and install.
fuse_wait: Update the fuse_wait script by downloading and installing the setup from here.

Next time you connect a storage device with NTFS you should be able to read/write from/to it.
Do note that there are a number of paid alternatives and a more detailed explanation can be found in the original blog of Sergey Vasilyev at http://blog.nolar.info/ntfs-3g-in-mac-os-x-lion-10-7-with-read-write-support/

ERD Modelling using Barker’s Notation

Posted on 2012-01-16 by Frankie

A key process in database development is obviously database modelling and the main diagrams used are ERD. A number of notations exist, some particular to evangelised by particular DBMS. Here I am documenting a short course/notes about ERD modelling using the Barker’s notation, which is greatly adopted by Oracle.

As usual here is the link, do feel free to comment!

Short notes on Barker’s ERD Notation