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 -~----------~----~----~----~------~----~------~--~---
