Android App with SQL server

Question

I have a few questions regarding sql server in android.

Essentially, I am tring to create an app that communicates to a SQL server, runs queries, creates new tables, rows, etc. I have been doing a lot of research recently about getting a connection to a SQL server in android. I've seen the tutorial on using a php file and it seems that isn't quite what I am looking for.

My questions:

Is it possible to create an app like the one I described above?
Do I need to do it using a php file? (like the tutorials)
Is there another way to do what I am looking to do?
Should I create a webservice to do the database portion of it? If so, are there any tutorials out there about that?

I apologize for my noob-y questions. Thanks for your help

What type of server is it? MySQL, MSSQL, Oracle?

MrZander
– MrZander

2011-10-13 01:08:29 +00:00
Commented Oct 13, 2011 at 1:08 — MrZander
– MrZander, Commented Oct 13, 2011 at 1:08

user684934 · Accepted Answer · 2011-10-13 01:10:16Z

2

You should definitely create a webservice, because otherwise any malicious user who has access to your app (downloads it) could easily trash your DB. But allowing insertion and creation privileges to users seems like a bad idea already.

If your users need a personal db, why don't you use sqlite which is stored locally and has no access delays, and no internet connection requirements? Why do you want a single db that is completely exposed to everyone?

answered Oct 13, 2011 at 1:10

user684934

Sign up to request clarification or add additional context in comments.

Comments

Ramesh Sangili · Accepted Answer · 2012-12-19 19:35:46Z

0

It is not a good idea to communicate directly to SQL server from Android Phones. You might hit so many technical constraints when you keep going with the development. I am not sure about he end result as well. It would be great to go ahead with the service that way you might have lot of controls inside the application and design it efficiently... Just a thoughts :)

answered Dec 19, 2012 at 19:35

Ramesh Sangili

1,6183 gold badges18 silver badges32 bronze badges

Collectives™ on Stack Overflow

Android App with SQL server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related