W walt61 Well-Known Member Licensed User Longtime User Mar 4, 2016 #1 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
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 Active Member Licensed User Longtime User Mar 4, 2016 #2 Have you checked This and This JM Upvote 0
W walt61 Well-Known Member Licensed User Longtime User Mar 5, 2016 #3 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 Upvote 0
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 Active Member Licensed User Longtime User Mar 5, 2016 #4 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 Upvote 0
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
W walt61 Well-Known Member Licensed User Longtime User Mar 5, 2016 #5 Thanks again for the hint, I'll definitely check that out ! Upvote 0
JTmartins Active Member Licensed User Longtime User Mar 5, 2016 #6 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. Upvote 0
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.
W walt61 Well-Known Member Licensed User Longtime User Mar 5, 2016 #7 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 Upvote 0
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 Expert Licensed User Longtime User Mar 5, 2016 #8 There are also chargeable alternatives like the MSMySQL or MsMariaDB Connectors. Also note RDC and jRDC. These are suggested by Erel. Last edited: Mar 5, 2016 Upvote 0
There are also chargeable alternatives like the MSMySQL or MsMariaDB Connectors. Also note RDC and jRDC. These are suggested by Erel.
W walt61 Well-Known Member Licensed User Longtime User Mar 6, 2016 #9 Thanks for the tips Don, I'll have a look at those too! Upvote 0
