Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniers k...@designdrumm.com wrote: I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Karl / Andrés Thanks for your replies. iMy appears to be only a client and I can already access servers with php on the iPhone web browser. I would like MySQL on my iPhone. There was a way to make a jailbroke iPhone a MySQL server, but I'm not sure it is available any longer. My immediate desire is to sync the iPhone's native contacts and, perhaps, the calendar with our online server over the internet. Preferably syncs would be pushed. With a Google Gmail account, you can already do just exactly that. Once set up, if you update your Gmail contacts, a minute or two later your iPhone contacts will be sync'd. It's supposed to work with the Google calendar, too, but I haven't tried it. It appears that Google is using a MS Exchange Server or similar. The setup in the iPhone uses the Exchange server settings. See http://www.google.com/mobile/sync/ The solution I'm looking for would be server side -- if not completely, in part. Again, it would be best to sync directly to the iPhone, but if the server would sync with the Google calendar and Google sync'd with the iPhone, that would be an acceptable 2nd choice. Thanks again for your reply! - Ron On 10/23/2010 5:47 AM, Andrés G. Montañez wrote Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniersk...@designdrumm.com wrote: I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Hi Ron, watchout with the jailbrake becaous it will void your warranty over the iphone. If you want to sync the phone's contact with something, you really should check the iphone API and build an iphone application which hooks and listens for contact's change and then notify the changes to your server. I know building an iphone app is a pain, but I think its the right way to do it, if not the only. Is this need for a hobbie or you need to implement this for a public application? Cheers. On 23 October 2010 13:57, listread listr...@cze.com wrote: Karl / Andrés Thanks for your replies. iMy appears to be only a client and I can already access servers with php on the iPhone web browser. I would like MySQL on my iPhone. There was a way to make a jailbroke iPhone a MySQL server, but I'm not sure it is available any longer. My immediate desire is to sync the iPhone's native contacts and, perhaps, the calendar with our online server over the internet. Preferably syncs would be pushed. With a Google Gmail account, you can already do just exactly that. Once set up, if you update your Gmail contacts, a minute or two later your iPhone contacts will be sync'd. It's supposed to work with the Google calendar, too, but I haven't tried it. It appears that Google is using a MS Exchange Server or similar. The setup in the iPhone uses the Exchange server settings. See http://www.google.com/mobile/sync/ The solution I'm looking for would be server side -- if not completely, in part. Again, it would be best to sync directly to the iPhone, but if the server would sync with the Google calendar and Google sync'd with the iPhone, that would be an acceptable 2nd choice. Thanks again for your reply! - Ron On 10/23/2010 5:47 AM, Andrés G. Montañez wrote Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniersk...@designdrumm.com wrote: I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Andrés, It would be tempting to build an app for this, but we don't have a single Mac in the place. Maybe syncing with Google is the way to go? That would keep the iPhone out of the equation. (This is not intended for the market.) Thanks, - Ron On 10/23/2010 2:16 PM, Andrés G. Montañez wrote: Hi Ron, watchout with the jailbrake becaous it will void your warranty over the iphone. If you want to sync the phone's contact with something, you really should check the iphone API and build an iphone application which hooks and listens for contact's change and then notify the changes to your server. I know building an iphone app is a pain, but I think its the right way to do it, if not the only. Is this need for a hobbie or you need to implement this for a public application? Cheers. On 23 October 2010 13:57, listreadlistr...@cze.com wrote: Karl / Andrés Thanks for your replies. iMy appears to be only a client and I can already access servers with php on the iPhone web browser. I would like MySQL on my iPhone. There was a way to make a jailbroke iPhone a MySQL server, but I'm not sure it is available any longer. My immediate desire is to sync the iPhone's native contacts and, perhaps, the calendar with our online server over the internet. Preferably syncs would be pushed. With a Google Gmail account, you can already do just exactly that. Once set up, if you update your Gmail contacts, a minute or two later your iPhone contacts will be sync'd. It's supposed to work with the Google calendar, too, but I haven't tried it. It appears that Google is using a MS Exchange Server or similar. The setup in the iPhone uses the Exchange server settings. See http://www.google.com/mobile/sync/ The solution I'm looking for would be server side -- if not completely, in part. Again, it would be best to sync directly to the iPhone, but if the server would sync with the Google calendar and Google sync'd with the iPhone, that would be an acceptable 2nd choice. Thanks again for your reply! - Ron On 10/23/2010 5:47 AM, Andrés G. Montañez wrote Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniersk...@designdrumm.comwrote: I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Hi Ron, yes,you should try to use Google as a gateway; the Google API is very well documented, I think all you need is just the user account (and password) and then through the API you should access all data. Cheers. On 23 October 2010 19:10, listread listr...@cze.com wrote: Andrés, It would be tempting to build an app for this, but we don't have a single Mac in the place. Maybe syncing with Google is the way to go? That would keep the iPhone out of the equation. (This is not intended for the market.) Thanks, - Ron On 10/23/2010 2:16 PM, Andrés G. Montañez wrote: Hi Ron, watchout with the jailbrake becaous it will void your warranty over the iphone. If you want to sync the phone's contact with something, you really should check the iphone API and build an iphone application which hooks and listens for contact's change and then notify the changes to your server. I know building an iphone app is a pain, but I think its the right way to do it, if not the only. Is this need for a hobbie or you need to implement this for a public application? Cheers. On 23 October 2010 13:57, listreadlistr...@cze.com wrote: Karl / Andrés Thanks for your replies. iMy appears to be only a client and I can already access servers with php on the iPhone web browser. I would like MySQL on my iPhone. There was a way to make a jailbroke iPhone a MySQL server, but I'm not sure it is available any longer. My immediate desire is to sync the iPhone's native contacts and, perhaps, the calendar with our online server over the internet. Preferably syncs would be pushed. With a Google Gmail account, you can already do just exactly that. Once set up, if you update your Gmail contacts, a minute or two later your iPhone contacts will be sync'd. It's supposed to work with the Google calendar, too, but I haven't tried it. It appears that Google is using a MS Exchange Server or similar. The setup in the iPhone uses the Exchange server settings. See http://www.google.com/mobile/sync/ The solution I'm looking for would be server side -- if not completely, in part. Again, it would be best to sync directly to the iPhone, but if the server would sync with the Google calendar and Google sync'd with the iPhone, that would be an acceptable 2nd choice. Thanks again for your reply! - Ron On 10/23/2010 5:47 AM, Andrés G. Montañez wrote Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniersk...@designdrumm.com wrote: I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Hi Ron, I personally don't believe in syncing peoples personal contacts to anyones server. Especially google. If that is what that API does. But your call. You should be able to connect to the contact sync right on the phone with your app and not need a server to do this. On the jailbreaking note, didn't the US government deem it not illegal to jailbreak your phone? I know there are a lot of us. Me included. Its just a better experience, IMO. Nothing to be said about how apple will treat it, but I know they have been adopting a lot of things that jailbroken apps created back in the day in the iOS now like, copy an paste and tether. lol If you don't believe me, look up clippy. :) I had copy an paste in iOS 2.1 and could use my tether app for connecting my computer then too. Tether is something that hasn't been in the approved apps till iOS 3 or 4. It was actually frowned upon by Apple. Its only a matter of time, I think, before they allow JB apps in iTunes anyway. search for CYDIA, CYCONTACT, iSQL(I think thats the name), and LockCalendar. They do all that your talking about already. They are jailbroken apps. But for instance, I have modified my LockCalendar app with my own graphics. Pretty cool. You may be able to find info on how to build your app from them, not that yours would be necessarily a jailbroken app, but the code to build them would be the same for the most part. HTH, Best, Karl On Oct 23, 2010, at 4:17 PM, Andrés G. Montañez wrote: Hi Ron, yes,you should try to use Google as a gateway; the Google API is very well documented, I think all you need is just the user account (and password) and then through the API you should access all data. Cheers. On 23 October 2010 19:10, listread listr...@cze.com wrote: Andrés, It would be tempting to build an app for this, but we don't have a single Mac in the place. Maybe syncing with Google is the way to go? That would keep the iPhone out of the equation. (This is not intended for the market.) Thanks, - Ron On 10/23/2010 2:16 PM, Andrés G. Montañez wrote: Hi Ron, watchout with the jailbrake becaous it will void your warranty over the iphone. If you want to sync the phone's contact with something, you really should check the iphone API and build an iphone application which hooks and listens for contact's change and then notify the changes to your server. I know building an iphone app is a pain, but I think its the right way to do it, if not the only. Is this need for a hobbie or you need to implement this for a public application? Cheers. On 23 October 2010 13:57, listreadlistr...@cze.com wrote: Karl / Andrés Thanks for your replies. iMy appears to be only a client and I can already access servers with php on the iPhone web browser. I would like MySQL on my iPhone. There was a way to make a jailbroke iPhone a MySQL server, but I'm not sure it is available any longer. My immediate desire is to sync the iPhone's native contacts and, perhaps, the calendar with our online server over the internet. Preferably syncs would be pushed. With a Google Gmail account, you can already do just exactly that. Once set up, if you update your Gmail contacts, a minute or two later your iPhone contacts will be sync'd. It's supposed to work with the Google calendar, too, but I haven't tried it. It appears that Google is using a MS Exchange Server or similar. The setup in the iPhone uses the Exchange server settings. See http://www.google.com/mobile/sync/ The solution I'm looking for would be server side -- if not completely, in part. Again, it would be best to sync directly to the iPhone, but if the server would sync with the Google calendar and Google sync'd with the iPhone, that would be an acceptable 2nd choice. Thanks again for your reply! - Ron On 10/23/2010 5:47 AM, Andrés G. Montañez wrote Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniersk...@designdrumm.com wrote: I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com --
[PHP-DB] How to Sync MySQL with iPhone or Google Contacts
Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts
I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM, listread wrote: Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php