Connect Android App to Database.

[PampaZiya]

I would like to connect my android app to an online database.

 

Thing i, I always use parse but I want an online database that can create tables through SQL queries, not graphically.

 

I already have my database created on SQL Developer. Is there a way to make it online ? 

 

If so, how can I access it from my app?

 

 

Thanks a lot

[Mario Kreeft]

I recently faced the same task..

After trying some I decided on FireBase.

Easy to connect, tight security and nosql db so I can store JSON objects.

I create these from within a backoffice app that queries a local mysql database.

 

Cheers

Mario

[DevBlox]

Connecting an app straight to database seems very sketchy to me. IMO you should write a server-side API that does all the database work. You will then use json/xml protocols (whichever you want) to communicate with the API. This will also allow you to ensure backward compatibility between versions better.

[Mario Kreeft]

Agree, in a way that's how I do it, except I don't communicate directly with the server-side app but in this specific case use a firebase db to exchange data..

[PampaZiya]

3 hours ago, Mario Kreeft said:

I recently faced the same task..

After trying some I decided on FireBase.

Easy to connect, tight security and nosql db so I can store JSON objects.

I create these from within a backoffice app that queries a local mysql database.

 

Cheers

Mario

 

Could you explain how it queries to a local db ? The database I want to use is on my laptop. Can it actually use it through firebase?

[mathijs727]

On 3/24/2016 at 11:40 PM, PampaZiya said:

 

Could you explain how it queries to a local db ? The database I want to use is on my laptop. Can it actually use it through firebase?

Create a REST API that runs on your laptop and manages the database.

Your android app then talks with the REST API which is much safer.

There are tons of frameworks to do this in almost any language.

[PampaZiya]

5 hours ago, mathijs727 said:

Create a REST API that runs on your laptop and manages the database.

Your android app then talks with the REST API which is much safer.

There are tons of frameworks to do this in almost any language.

Thanks mate. I worked it out myself. Created a mysql database on CPanel, hosted by godaddy and wrote php to connect/query the database and called them from my App, worked beautifully and fast ^^ Thank you all for the kind help!