I wrote a tutorial on Session Initiation Protocol (SIP) some time back. I had to study it for a project and as any other new subject, it was confusing at the beginning. So I decided to help the beginners henceforth and created this short made easy tutorial on SIP. It has been in top 5 search results in Google, Bing/MSN and Yahoo when you search for "SIP beginners tutorial" for years now, and ranked #2 in the recent year for a more general term like "SIP tutorial". People have mentioned it in their blogs, websites and even referred to it in preparing technical documents. However, I am moving this tutorial to a new location since geocities is closing. Please visit/bookmark/link to the new site at siptutorial.net.
The original site was geocities.com/intro_to_multimedia.
SIP Made Easy - a Beginners' Tutorial
Thursday, July 9, 2009
4:30 PM | Labels: SIP, tutorial | 0 Comments
How to Conserve Cellphone Battery Power
Friday, September 5, 2008
How do I conserve my cell phone battery power?
You are on the go and you don't want to run out of your cellphone battery. Here are a few suggestions on how you can conserve your cell phone battery power. Hope the tips help you when you need it.
- Turn off the cell phone - Obvious! But people forget that. Turn it off when you don't need it or when you can't use it (eg on a flight, in the subway).
- Turn off extra features - Turning off is not always good because you might need it for the primary purpose, talking to someone. However, you can get rid of other services eg GPRS, EDGE, GPS, WiFi, Bluetooth. Repeat, turn off bluetooth. It saves you battery power and saves your phone from unauthorized access. And yes! Stop playing those games you play.
- Dim the backlight - The LCD screen is a major power consumer for your cellphone. Either dim or completely turn off your backlight depending on the visibility of the screen. You can find the option under setting->display of your phone.
- Turn off vibrator - It's useful but if you are running out of battery, better turn off your vibrate function.
- Airplane Mode - If you want to use features of a phone other than talking or if you are in a region with no/very low network put the phone in the 'airplane mode'. In other words, instruct it not to try connecting to a network. If the cellphone doesn't see a signal, it keeps searching for it and loses all battery charge doing basically nothing. Either turn it off or if you need the other features of the phone (eg organizer, notes, alarm), keep it detached from the network. You can generally find the option under your phone settings.
4:39 PM | Labels: gadget | 0 Comments
Import CSV to SQL using phpMyAdmin
Wednesday, August 20, 2008
How do I import a CSV file into a MySQL database using phpMyAdmin?
Writing sql code is not required. Just use the phpMyAdmin interface for uploading the csv file.
- I assume that you have created
- a mysql database and within it a table with appropriate fields
- a csv file with entries arranged in the same order as the fields in the mysql database table (eg Suppose you have a table with fields name, age, city. Your csv file might look like -
smith,12,washinton
willy,13,chicago
maria,11,tokyo) assuming you use ',' as field separator and '\n' as row separator - Go to phpMyAdmin (It should be located in your host account control panel under database section)
- Click on the mysql database instance you are interested in.
- Click on the table to which you want to import the data. (Remember this step, just clicking on the database is not good enough.)
- Click on the 'import' tab.
- This will open an interface as shown below -
- Click 'Browse' button to select the csv file on your system which you want to upload
- Choose 'CSV using LOAD DATA'
- Fields terminated by: ,
- Fields enclosed by: [delete default value, leave blank]
- Fields escaped by: [delete default value, leave blank]
- Lines terminated by: [leave default value]
- Column names: name,age,city
- Click the 'GO' button and you are done. phpMyAdmin will show you exactly what sql query was executed to upload the csv file into your mysql database table. You can now browse your database to check proper insertion of the csv file.
6:32 PM | Labels: mysql | 17 Comments
Subscribe to:
Posts (Atom)