Client/server database for android tutorial needed

Question

Hope everyone's doing great;

What is the best client/server application to use with database for android?

I know the implementation of database with Java very well. Should I use MySQL, Oracle or Access for example or should I use SQLite Database if I need to access it via server over internet?

I wasn't advised to use JDBC at all; In other way, I was advised to connect to the database via HTTP request. But isn't SQLite Database a local one only available on the host?

Any ideas or is there any good tutorial about it? I'm a bit confused..

Thanks in advance and best regards, Chris

Solution

You seems completely confused.

On the client side (Android app), you can use SQLite to store data locally. It might not be necessary at all actually. For instance, it can be used for offline features, search, etc.

On the server side (whatever server side technology you know or want to learn), you can use whatever language, whatever database on whatever server OS you want. This part is commonly called the back-end, which will store your data while your app communicate with it through HTTP.

Comments

[Odin]

I already checked this answer but didn't completely know where to begin actually.. Will check this tutorial and give my feedback.. Thanks a lot for your quick reply

[Odin]

lol actually I am! Ok, I got what you said thanks a lot. Is there any good tutorial about communication between the android app and HTTP? If it isn't via HTTP, can I connect the client and the server with a wireless ad-hoc or is it a stupid idea?

[galex]

I feel you are mixing two things, how to communicate and on what hardware, technology and protocol. Of course you can communicate with wireless ad-hoc but then one of your devices should run a http server (like apache) if you want to send it http requests. Have a look at en.wikipedia.org/wiki/Client%E2%80%93server_model

[Odin]

I know it's a late reply, I was searching in my previous questions and found this one unanswered.. I ended up installing "wampserver" on the server side and communicating with it via HTTP request along with JSON parser. And for the offline features i'm using SQLite database. Accepted your answer because it helped me a lot :)