MySql useful tips

mysql -u -p -e
"select
TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT,
IS_NULLABLE, DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH,
NUMERIC_PRECISION, NUMERIC_SCALE,
COLUMN_TYPE, COLUMN_KEY, EXTRA,
PRIVILEGES, COLUMN_COMMENT
from information_schema.columns
where
TABLE_SCHEMA = ''
order by TABLE_NAME, COLUMN_NAME "
> tbl


select TABLE_NAME, TABLE_ROWS from information_schema.TABLES where TABLE_SCHEMA = '' order by TABLE_ROWS ;

Address validation service

http://www.melissadata.com

1. Address Validation (Makes sure the suite number is input - else throws error)
2. ZIP, Geo code, phone,
   
3. List of streets in zip
4. real estate data
5. house numbers on street
6. Zip codes in radius
7. 
   

interesting lists / templates that can be converted to content

List of waerfalls in Tamilnadu
List of Forts in India
Pin Codes of Indian cities - map with GPS co-ordinates(?)
STD codes in India - With GPS
Railway Stations in India with GPS
Highways of Tamilnadu & India
Choleswara temples with gps location

List of spices (?) used in Tamil friends home(s) and what dish it is used, where to purchase, how much (tricky)
Tamilnadu transportation routes: example http://www.tn.gov.in/transport//routes/routes_salemghat.htm

bluetooth info

Here is the list of Bluetooth Chipset Vendors (2002 list)

1. Agere Systems
2. Alcatel
3. Atmel
4. CSR
5. Conexant
6. Ericsson ROK 101 007/8
7. GCT Semi
8. Infineon
9. Microtune / Transilica
10. Motorola
11. NewLogic
12. Oki
13. Parthus
14. Philips
15. Silicon Wave
16. Spirea
17. TI
18. Vaishali
19. XEMICS
20. Zarlink

Here are the Bluetooth stacks

1. Widcomm (Windows)
   
2. Microsoft Windows stack (Windows)
   
3. EtherMind stack (Windows)
   
4. Toshiba stack (Windows)
   
5. BlueSoleil (Windows)
   
6. BlueZ (Linux)

How about putting bluetooth 2.0 in a chip > dongle for security.

small cap voice

http://smallcapvoice.com/
100K per year for participant!! Good money infact.

IT PIO

http://www.it-pio.org/ an organization for

~ 100 people assembled in Cupertino for Aug 15th, 2009 celebrations.
Information Technology - People of Indian Origin

java download location

http://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/VerifyItem-Start/jdk-6u16-windows-i586.exe?BundledLineItemUUID=Z1RIBe.p_ooAAAEj2BJSexxh&OrderID=rxdIBe.pQlAAAAEjzhJSexxh&ProductID=bhJIBe.ptbMAAAEishcTvuC_&FileName=/jdk-6u16-windows-i586.exe

os / browser testing

Couple of aspects / challenges to solve

1. There are tones of possible OS/Browser/plugin configurations. Maintaining each of them can be costly and resource intensive
   
2. Supporting closed source stuff like Windows, Apple can be costly just for the price of OS alone
3. Open Source (Linux) has the challenge of variety -
   
4. Blackberry, iPhone OS, Symbian OS - nooo don't open that Pandora Box
5. How do we make Windows XP multiple concurrent users
6. How to remotely access the desktop with lowest network bandwidth cost
7. How to have no/minimal client side setup
8. How deal with variety in clients (Windows, Mac, Linux, IE, FireFox, Safari....) accessing our solution
   
9. How to ensure (and verifiable?!) privacy of customer installation
   
10. How to get the first 1-100 customers. The next 10,000 can be easy (as each of them want to do it on their own - wouldn't they)
11. How to price for casual one time user (read as freelance web site designers)
12. How to prevent folks using us as launch pad for attacks
    

What are the comparable technologies out there we can adopt

1. Virtual machines
2. VPN
3. WebEx (any solution from Citrix? I believe yes)
4. litmusapp.com
5. cloud computing
6. http://www.soti.net/
7. http://browsershots.org/
8. http://www.browsercam.com/
9. http://webworkerdaily.com/2008/01/07/is-your-html-good-enough-7-browser-testing-services/
10. http://tredosoft.com/Multiple_IE
11. http://www.xenocode.com/browsers/
12. xWindows - http://www.straightrunning.com/XmingNotes/
13. http://saucelabs.com/
    

How about I operate on one os/browser - but the same http response is rendered on different os on multiple screens in front of me...

older technologies

http://www.htlchennai.com/ci.htm
http://www.htlchennai.com/uci.htm
http://www.htlchennai.com/ntu.htm
http://www.htlchennai.com/se.htm
http://www.htlchennai.com/maxxl.htm
http://www.ptc.com/products/cadds5 - http://en.wikipedia.org/wiki/Computervision

old computing devices

1. Early calculator - http://www.voidware.com/calcs/fx39.htm quickly switched to the LCD version (due to un-affordability to buy batteries) http://www.voidware.com/calcs/fx82.htm
2. Early computer which processed Fortran 77 code : http://en.wikipedia.org/wiki/IBM_1620 actual input using http://en.wikipedia.org/wiki/Card_punch device.
3. My first geeky computer (Microprocessor Kit) http://en.wikipedia.org/wiki/Microprofessor_I

1. Storage was primarily RAM (Cassette recorder - expensive to own) - input the machine code every time powered up
2. 8 KB ROM (EPROM) that we would erase using UV light and reuse
1. Early desktop computer ran on Zilog's Z80 (64KB RAM) and 8 inch floppy drive with OS being CP/M (MS DOS first version had many resemblance to CP/M)
   

Social networking random info & links

1. Gartner Magic Quadrant for Social Software
2. Wikipedia on Magic Quadrant

1. altuslearning.com
2. amazee
3. bigtent.com
4. Center'd (fatdoor)
5. Collectivex
6. Crusher (website)
7. Daily strength
8. dopplr
9. Epinions.com
10. Evite
11. Facebook
12. fatwire.com
13. Findsmith
14. geocommons
15. groovr
16. grou.ps
17. Groupee
18. grouply
19. Gurgle
20. hi5
21. justbetweenfriends.com
22. last.fm
23. linkedin.com
24. MEETin
25. Meet-up
26. minglebox
27. Netlog
28. Ning
29. passitto
30. PatientsLikeMe
31. Peuplade
32. pingg
33. Quechup
34. selectminds.com
35. SoberCircle
36. Soceeco
37. socialcast.com
38. socialtext.com
39. Sonico.com
40. SparkPeople
41. Spongecell
42. swivel
43. the groupery
44. thepoint.com
45. Upcoming
46. upnext
47. visiblepath.com
48. vooeasy
49. Webjam
50. weogeo
51. wiggio.com

123Signup Event Management
Evite Event Management
Famundo Event Management
Jooners Event Management
Cingo Family Organization
Cozi Family Organization
Thefamily.com Family Organization
Club Spaces Group Management
ClubExpress Group Management
Clubmatic Group Management
ClubPoint Group Management
ClubRunner Group Management
Collective X Group Management
Findsmith Groups Group Management
Grou.ps Group Management
Grouply Group Management
Meet-up Group Management
Memberize (goClub) Group Management
Orgsites.com Group Management
Schoolpulse Group Management
The Groupery Group Management
Wild Apricot Group Management
Yahoo! Groups, Group Management
Emember NA
Minti Parent Social Networking
Mom Junction Parent Social Networking
MommyBuzz/MoxieMoms Parent Social Networking
MothersClick Parent Social Networking
Raising Them Parent Social Networking
CircleUp Polling
Café Mom/Club Mom Social Networking
Center'd Social Networking
DadDaily Social Networking
eons.com Social Networking
Facebook Social Networking
Got Kids Network Social Networking
Linked In Social Networking
Mamasource Social Networking
Maya’s mom Social Networking
MySpace Social Networking
Ning Social Networking
Webjam Social Networking
myelife.com
Soceeo Social Networking

www.123signup.com
http://preview.evite.com/party/invitations
www.famundo.com
www.jooners.com
www.cingo.com
www.cozi.com
http://www.myfamily.com
www.clubspaces.com
http://www.clubexpress.com/content.aspx?page_id=22&club_id=0&module_id=379
http://www.clubmatic.com/

www.clubrunner.ca
www.collectivex.com
http://www.mob.findsmithgroups.com/
http://grou.ps/introduction.php
http://www.grouply.com
www.meetup.com
* Home Page Link: http://www.memberize.com/clubportal/ClubStatic.cfm?clubID=2037&pubmenuoptID=21199
http://www.orgsites.com/wa/anna/
www.schoolpulse.com
https://web.thegroupery.com/
http://annatrial.onefireplace.org/
www.yahoo.com
www.emember.com.au
www.minti.com
www.momjunction.com
http://www.moxie-moms.com/index.php
http://www.mothersclick.com/user/Anna/homepage
http://www.raisingthem.com/index.php?page=my_home
http://www.circleup.com/my/cu/home/
http://www.cafemom.com/
www.center'd.com
Uses Ning
www.eons.com
www.facebook.com
http://www.gotkidsnetwork.com
email me if you need this info.
www.mamasource.com
http://www.mayasmom.com/
http://home.myspace.com/index.cfm?fuseaction=user
www.ning.com
http://www.webjam.com/webjam/home

http://annasplaygroup.soceeo.com/networks/

http://www.socialnetworkingwatch.com/company-index.html
http://www.web-strategist.com/blog/2007/02/12/list-of-white-label-social-networking-platforms/

http://www.ygroupsblog.com/
http://www.tabup.com/Signin.aspx
http://www.weebly.com/aboutus.html
http://www.rjenda.com/jsp/login.jsp
http://www.alumnisoftware.com/
http://blueleo.com/index.bl
http://www.bluekiwi-software.com/

Technology possibility on Tours

• Electronic Museum Guide Wiki article that has more info..
  
• Audio Tour
• City Audio Guide - possibility of $1.5B industry (Why not a Open Source Wiki for this industry?)
• Location awareness can help (GPS)
• How about fm receiver with user. The ultra low power transmitter transmits location based info over the fm channel (Would that save total cost of ownership of such system?)
• How about integrating with Google Street View as part of the multimedia tour guide
• We can get sms or tweaks for the tour info (short and sweet)!!
  

1. have seen this at Manalay Bay Shark Reef, Las Vegas
2. Empire State Building

(in both situations, there is a number at the location and a matching audio in the portable device).

• Cell Phone Tour
• 
  

Available products:

• http://www.tourmate.com/products.htm
• http://www.acoustiguide.com/tours/index.html
• http://www.vistagroupinternational.com/AuTour.html
• http://www.guideport.com/
• http://www.clockaudio.com/tabid/404/Default.aspx
• http://www.antennaaudio.com/content/category/1/7/20/lang,en_GB/
• http://www.audioconexus.com/venues/technology/
  

1. www.audioguide2go.com
2. http://en.wikipedia.org/wiki/Location_based_media
3. How to use the existing Tour guides (persons) to coexist and also enhance their delivery? Or should we look at the replacement model instead? What is the impact to tour bus operators (hop on hop off type).
4. What is the over lap with Maps, tour guide (book) and travel books industry?
5. How can this enhance/replace campus tour experience?
6. How does this impact Packaged Tours