No Sql Approach

No SQL, exactly as its name. its the database that dont use the SQL syntax. the method apply when the database need to retrieve huge data in one single output.

the specification to use no sql is, there are not booking system, they are real time system that based on notification... when talked about notification. in your mind is Facebook. thats correct!!

Facebook used NoSQL database to retrieve huge comment, picture, sound, music and file system for the user. notification are included.

so what exactly NoSQL? the database that dont depend on relational object of one system.

1. its a database that dont run sql
2. its a coding that request huge amount of data from server
3. its a server that put all the data together thus eliminated the traditional database

Who used it this days? 

1. facebook
2. twitter
3. google
4. yahoo
5. amazon 

It is many NoSQL database out there? the answer is YES. not single NoSQL can done so many things at once. here is the list

• Column Families
• Document Store
• Turple Store / Key-Value Store
• Graph
• Multimodel Database
• Object Database
• Grid and Cloud Database Solution
• XML Database
• MultiDimensional Database
• MultiValue Database

so u need to know how to retrieve this database value based on what attributed you need to called. for myself, i need to learn more on how to cross platform the xml to the api NoSQL server..

see ya soon

How to Setup WebServer using XAMPP part 2

ok, we done searching IP address and downloading the XAMPP software. now we proceed on how to Port Forward in router to allow incoming connection from the internet to you local webserver..

example being done in router D-Link DIR-615

1) open your browser. regardless firefox, chrome or safari. and type default gateway number. for example 192.168.1.1 and then press enter. it should be like below.

2) type in the username and password in the box to proceed. please remember that, if you dont know what type o f your router, you can check at their box. the router box have instruction and manual configuration including default username and password for your router. if you done key in the required box, it should be like this.

3) please select Advanced tab. and you will see the port forwarding box. please enter the IP adress that you copy in the previous post. it should be like this

port 80 is the port we use the web browser to navigate internet. thats why we need to port forward the port. 

4) fill in the blank box with your ip and port. and then click save at the bottom of the page. and last part, we need to install the XAMPP..

5) install XAMPP, leave all option default. click next to the end of installation and it should be like this.

6) click start Apache and start MySql. it should appear green box with "running" written on it. just like below.

7) and you are done! you can use your local pc/ laptop to host website or system regardless internet or intranet.

for the internet connection you need to read dyndns.com manual. blieve me. it worked.

How to Setup WebServer using XAMPP

Hi, today i will show you how to setup your own webserver. i dont want to talk too much because my motto is straight to the point.

1. The first step is to download XAMPP software. you can download it >>[here]<< . if done downloading it, please proceed to the next step.

2. install the XAMPP. if you dont know how to setup XAMPP, please refer to my previous post on how to setup own private cloud. after install the software, running the apache and mysql within the xampp software.

3. port forward your router. down below have an example provide from me to you...from how to know what your ip addres to port forward your own router.

Scan your IP Address

first of all, scan ur ip address. How?

windows xp
1. hold down windows logo button and press R button. it will pop up a window. 
2. type in this window "cmd" without bracket and press enter.

3. it will pop up a black window screen just like below.....

4. type ipconfig and press enter.
5. search for "Local Area Network" connection. it should be like this, if home user : 192.168.xxx.xxx. for example....

6. done. you got your own router ip address. router ip address is by the name default gateway.

ok, we proceed to part 2

How to request google map using coordinate

Getting tired of searching something on Google map? so here are the solution:

1. using Google maps starred icon. zoom your desired location until you see star icon and click it.
2. using method url overriding. for example :  javascript:void(prompt('',gApplication.getMap().getCenter()));
3. Using my kind of method : copy code below and past at url. change the latitude and longitude first.

 http://maps.google.com.my/maps/place?q=<put your coordinate here, must be pair, saparate by comma, ignore the "<" and ">", ok?>

for example:

http://maps.google.com.my/maps/place?q=3.107094,101.608255

The tweak of the day, bye2,enjoy.

How to know latitude and longitude of the map

The paper with region drawing cant be called map without border. this same happening with digitalis maps.

Google maps are essential for user to know the the location name but for advance user, it will certainly need a code to do that.

im gonna show how to tackle google maps functionality on latitude and longitude. there are 3 methods to get latitude and longitude out of the maps.



first method is using override functionality using java script. below is the example to override the url browser.

» Click to show Spoiler - click again to hide... «

javascript:void(prompt('',gApplication.getMap().getCenter()));
if you use this code, pls paste at your url and make sure that code is full. the google chrome will dropped the word javascript at the front of the code. the rest browser i dont know yet.

A little dialog box will pop up displaying the coordinates which can be copied and pasted for use elsewhere. This code can be bookmarked and then used in the future by selecting the bookmark.

second method is using google maps itself. open google maps, and track where you are. 

Right click here you wanna know the coordinates on the maps. you will see something similar like above picture. then click what's new.

and thats you coordinates in the google search box. i hope your enjoy exploiting new 'toys' here.

last method that im developing is this small system. click here to proceed. <----its not an ad.trust me.

How to rip Dynamic Flash Template

What you need:

• Sample dynamic flash template from TM website
• Sothink SWF Decompiler
• Macromedia Flash
• Yourself

browse or search your favorite dynamic flash template in TM website. If you got one... click the "view" link and new window will open with dynamic flash.. loading...

If the movie fully loaded, click View -> Source in your browser to bring the source code of the current page and in the source code, search for "IFRAME" and you will see the iframe page. In this example were going to try the 7045 dynamic template.

get the URL (ex. http://images.templatemonster.com/screenshots/7000/7045.html) then paste it to your browser... easy eh? wait! don't be to excited... erase the .html and change it to swf then press enter then you'll see the flash movie again icon_smile.gif.

copy the URL and download that SWF file.. use your favorite download manager.. mine I used flashget icon_smile.gif NOTE: dont close the browser we may need that later on.

open your So think SWF decompiler... click "Quick Open" then browse where you download your SWF/movie file. Click Export FLA to export your SWF to FLA, in short, save it as FLA icon_smile.gif

Open your Macromedia Flash and open the saved FLA file. press Control+Enter or publish the file... then wallah! the output window will come up with "Error opening URL blah blah blah..." dont panic, that error will help you where to get the remaining files.

Copy the first error, example: "7045_main.html" then go back to your browser and replace the 7045.swf to 7045_main.html press enter and you'll see a lot of text... nonsense text icon_lol.gif that text are your contents...

NOTE: when you save the remaining files dont forget to save with underscore sign (_) in the front on the file without the TM item number (e.g. 7045) if it is html save it as "_main.html" and same with the image save it as "_works1.jpg" save them where you save the FLA and SWF files. Continue browsing the file inside Flash application so you can track the remaining files... do the same until you finish downloading all the remaining the files.

i credit this writing to its author: BAISAN