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 For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
