Hi Mark & Bob, Thanks very much for your expert suggestions.
:) On Tue, Feb 16, 2010 at 12:33 PM, Bob Kerns <r...@acm.org> wrote: > Never say never -- it would be appropriate for a mySQLAdmin tool, say, > talking over wifi. > > Anyway, my answer to Mr. L. Newbie's question, is: > > 1. You could probably find and/or port such a thing. MySQL's Connector/ > J is pure Java. It might rely on some standard J2SE stuff that's not > present on Android, in which case you'd have to come up with > substitutes. > > 2. GET/POST is *not* the only way -- but it is the best way, the tried > and true way, and what most other people are doing. Google > "RESTful" (I'm surprised it's that easy to get a good search result, > but it is). The alternative would be to use SOAP, but I wouldn't do > that unless you already know why you want to do that (such as > compatibility with an existing service or environment). > > This will also drive the design of your application in a direction > which is more mobile-friendly. It's not really a matter of mobile vs > LAN -- really, I don't recommend the use of direct database > connections except between tightly-coupled components -- such as > between your web service, and its back-end database server. Doing > direct SQL poses everything from security risks to temptations to > depend on aspects of your data model which shouldn't be exposed, > leading to massive compatibility problems, and the need to update all > clients at the same time....the list of reasons goes on and on. > > On Feb 15, 3:55 pm, Mark Murphy <mmur...@commonsware.com> wrote: > > linux newbie wrote: > > > 1. Is there mysql-connector/jdbc for android? > > > > It doesn't matter -- you shouldn't use it even if it exists. > > > > As I've now written for the third time in the past 36 hours or so > > (previous two on StackOverflow): > > > > "Never never never use a database driver across an Internet connection, > > for any database, for any platform, for any client, anywhere. That goes > > double for mobile. Database drivers are designed for LAN operations and > > are not designed for flaky/intermittent connections or high latency." > > > > -- > > Mark Murphy (a Commons Guy)http://commonsware.com| > http://twitter.com/commonsguy > > > > Android Consulting/App Development:http://commonsware.com/consulting > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to android-developers@googlegroups.com > To unsubscribe from this group, send email to > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
