Thanks for the explanation. Do you know from where i would be able to get some sample code of how to communicate to a MySQL service running on an apache2 web server?
Thanks for all your help. Hans On Sep 17, 3:58 pm, Mark Murphy <[EMAIL PROTECTED]> wrote: > Hans wrote: > > I guess SQLite is quite limited (since it would be working on a mobile > > device) > > If by "limited", you mean "a full SQL database engine with ACID > transactions, used by Mozilla, Adobe, Apple, Sun, and Google in their > products", then, yes, SQLite is "limited". > > > and if some other SDK with different methods is published this > > will not be compatible. > > Considering that SQLite is central to the implementation of Google > Gears, and that Google Gears is central to the implementation of Google > Chrome, and that Google Chrome is apparently coming to an Android near > you, I doubt SQLite is going anywhere. After all, Symbian also uses > SQLite, and it's rumored to be used in the iPhone flavor of OS X, so > it's been used in mobile devices before. > > > If i had to use the database through a web > > > service i am not sure which database would be simplest to set as a web > > service. Therefore please if anyone has some opinions to give me i > > will highly appreciate them. > > Comparing SQLite on the device to a Web service is akin to comparing a > bicycle and a snowplow. Yes, they are both means of transportation. No, > you probably would not use them for the same situations. > > Databases exposed via a Web service have tremendous flexibility, > bandwidth, and processing power compared to an on-device database. They > also require an Internet connection to the phone (which may cost the > user money) and have Internet-grade latency. On-device databases are > quick and cheap, but are limited by the capabilities of the phone and a > general desire not to drain the battery too fast. > > So, for example, trying to keep the entire delicious.com roster of > bookmarks on a device would be crazy. Keeping a single user's roster of > bookmarks on a device would be reasonable, syncing it periodically with > the "main" database on the server. > > -- > Mark Murphy (a Commons Guy)http://commonsware.com > Warescription: All titles, revisions, & ebook formats, just $35/year --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
