If you have root access to your server it only takes 5 mins to download and install the db, it's a monster in size but other than that no issues.
Basically all I want to do is have user enter "City: when registering. This will load the correct State / Province / Area and Country automatically. I'm forcing them to be honest. So they can't enter that they live in Los Angeles, Alberta, Africa. ( a non existent place) From: Shinya Koizumi [mailto:sh.koiz...@gmail.com] Sent: Monday, January 31, 2011 6:43 PM To: cake-php@googlegroups.com Subject: Re: Has anyone used Geonames without webservice? I think it's difficult to download all the stuff in local and how do you maintain? I think google map api is your best choice. What you can do is save the unique query( keyword and resolved lat,lon ) in database so that for popular places you don't always have to go to web service . On Mon, Jan 31, 2011 at 12:32 PM, Dave Maharaj <m...@davemaharaj.com> wrote: Just wondering is anyone has used the geonames database with cake but with own database, not thru webservices? I know it's a monster database in size but I do not like the idea of using a service that's not on my own server. If it goes down then it affects my site so just curious if anyone has implemented it? I have the db setup and basic model / controller to test out queries, but my way takes much longer than the webservices version so just curious if anyone has had any success? Thanks, Dave -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com <mailto:cake-php%2bunsubscr...@googlegroups.com> For more options, visit this group at http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php