Monday, February 9, 2009

SQL join statement using 3 tables

FROM ingredients i, vendors v, items mi, madewith mw
WHERE i.vendorid = v.vendorid
AND i.ingredientid = mw.ingredientid
AND mw.itemid = mi.itemid
AND companyname = 'Veggies_R_Us' ;

Friday, November 28, 2008

adsense script


Tuesday, October 7, 2008

Who Needs a DSLR?

If I could shoot a picturesque sunset in Boracay using a point and shoot digital camera.

Fujifilm Finepix s5800
aperture : F/9.8
shutter speed: 1/512 sec.
focal length : 81mm
ISO 64

or this preset macro settings.

Fujifilm Finepix s5800
aperture : F/3.5
shutter speed: 1/91 sec.
focal length : 9mm
ISO 64

and another one taken from a park in Tayabas.

Panasonic DMC LS-1
focal length : 6mm
ISO 100

Sunday, October 5, 2008

Risk Management in Systems/Software Development

I have been commissioned by the City of Tayabas to manage the computerization of various systems of the local government unit. Part of managing the project is constant reporting to the project champion and I have been asked to deal with the risks that may occur.

Since risks in software development is inevitable, I have here basic guidelines that you might consider of using.

First thing to do is to assess. Enumerate the risks according to the probability of occurence. Rank them from the most to least dangerous taking into consideration of its possibility to happen.

Second is to control. Make another list on how to mitigate and probably control these risks. There must be a sound strategy. Come up with a technique appropriate to the identified risks and implement it accordingly.

Common risks are as follows;

1. Technical personnel shortfalls and uncooperative users.
2. Schedules and budgets.
3. Continuing stream of requirements changes. This is the old requirements creeping syndrome.
4. Developing incorrect user interfaces, functions and properties.
5. Gold plating. This is where the project team add functionalities and features to the product which is not called for.

I will be posting thourough discussions on this topic in website.

JOIN in SQL Data Manipulation Language

JOIN is a predicate in SQL's data manipulation language. This is primarily used in combining tables or relations to derive a new table.

We combine tables to create a query that will require information from more than one table.

Example of simple join query:

SELECT url.urlid, name, companyname
FROM url, company
WHERE url.urlid = company.companyurlid AND company.companyurldesc LIKE ''

I will post more on this topic later.

Friday, September 26, 2008


I came across to the official website of the city of Tayabas in Quezon province and I wonder why inspite of too many nice places in Tayabas, it is hardly known as a prime tourist destination. The Pahiyas in Lucban festival is almost synonymous to Quezon province but Tayabas with Spanish old bridges and churches doesn't seem to be at par with Lucban. I visited Graceland Country Club and I was amazed in the place that I never imagined of such place existed in Quezon.

Good thing that finally, they have information loaded website. Find time to visit the official website of Tayabas and know more about the place.

Kudos to the people of Tayabas.

Monday, September 22, 2008

Network 101

What is you IP address?

Since you are using the Internet at this point, you are at the least using two IP addresses. If you are into a small network (home or small office) you might get the following;

1. The local IP you probably obtained from the DHCP server which is another feature of your DSL MODEM (so it may be a DSL MODEM/Router/DHCP server). If you have a separate router it may also be a DHCP server. It usually has this 192.168.x.x IP address which is commonly used range of IP for small networks. This is also true in most wireless broadband provider (e.g. Smart bro, etc. ) Type ipconfig on your command prompt to display your local IP.

2. The public IP your DSL MODEM obtained from your ISP. This is public and can be viewed "publictly". To see your public IP, copy paste this and voila, it will display the IP obtained. In some cases though and especialy if your office has a web server, you might have static(fixed) public IP which was given by your ISP. In this case it is not obtained, meaning you will get the same public IP all the time.

I will explain this further on my future post. For the meantime, I will go visit the City of Tayabas.