Android Question How to work with a hosted free SQL db (phpMyAdmin available)

[walt61]

Hi gang,

I'm writing an app (a lists manager) for which users can store their data in a local SQLite db, but would also like to offer the possibility of having them sign up for a free SQL db (I mention phpMyAdmin as I saw that being mentioned in some posts on the forum) like www.freesqldatabase.com or www.freemysqlhosting.net (but to name a few) and then create the necessary tables in the app if necessary, and allow concurrent access for multiple users. They would then enter the URL, user ID, and password (I presume) in the app's preferences.

In other words, the app can work standalone, but can (if possible) also work with a shared db (a friend said 'wow that would be handy if I could share the data with my hubby so that we know who has taken care of what').

How would I be able to use such a hosted SQL db in my app? I've trawled the forum but didn't find an obvious solution. Any pointers would be greatly appreciated!

Thanks,

walt61

 

[JTmartins]

Have you checked
This
and
This

JM

 

[walt61]

Thanks a lot JM, I did come across those and would definitely go down that road if I were to use one db for the app. In this case however it would be the app's users who would sign up for a hosted db, and I think it would be too complicated for the average user to setup server side php scripts. I was hoping there would be some way of connecting to such a db without requiring any end user actions besides signing up for one and providing the login info. I should probably rethink this and at least consider making the setup as easy as possible for the end user - back to the drawing board

 

[JTmartins]

I see your point. You want to have an online DB, than you can then share with others.

I noticed that FreeSqlDatabases mentions that it allows remote connections, meaning that you can connect your app directly to the remote server.

In that case, maybe you can choose this road : https://www.b4x.com/android/forum/t...c-connect-to-any-remote-db.31540/#post-183818

 

[walt61]

Thanks again for the hint, I'll definitely check that out !

 

[JTmartins]

Actually I was looking for this one.

If you search the forum for Mysql there may be some examples of remote connections...although the security is close to none...it may serve your purposes.

 

[walt61]

Wow that one (or similar ones) looks spot on, thanks a million! I'll check for others too and look at the security side of things; I've been developing for 34 years (yeah dino time ) but this stuff is uncharted territory - which is what's interesting about it, of course

 

[DonManfred]

There are also chargeable alternatives like the MSMySQL or MsMariaDB Connectors.

Also note RDC and jRDC. These are suggested by Erel.

 

[walt61]

Thanks for the tips Don, I'll have a look at those too!