[Q] Help making Android App with MySQL DB (or other DB if you have suggestions) - Android Q&A, Help & Troubleshooting

Hi.
I am new to Android and am looking to solve a problem.
I want to create an Android app that has a login and that you can send messages back and forth with the people who use that app. Similar to the Facebook Messenger App. Also similar to Facebook, I want to users to be able to log in via a web-app in their browsers and view/exchange messages.
My idea was MySQL as the database that stores all of this information. The website will then be made with a PHP framework to access that MySQL data and similarly, I was thinking the Android App would read/write to that same MySQL Database.
I already proto-typed this and was able to create an android app that posts data to a process.php file I have sitting on a web server which then queries the MySQL database, and returns a JSON object back to the Android App for consumption. I followed this guide from Stack Overflow to accomplish this and it worked good. I also searched these forums and found this: http://forum.xda-developers.com/showthread.php?t=2325799 which seems to sort of do things the same way.
My question is:
1) Is this the right way to do things for an app I want to scale to 10,000 users? I want to ask the more experienced developers if this is how they would go about creating such an app. Is there a better way besides what I described? I am a noobie so this was the best way I could come up with from searching the internet.
Much Love,
MicroR

Related

Very Simple Database App

hello, I want to create my own database app. I often have to store my customers and clients data. I want to create an app that allow me to store clients data. Just a simple form type. For example Title, First name. last name, address and contact details and all. I should be able to edit details later on. I don't want many options.
Is there any easiest way to create app like this or any existing app that can allow me to do all this.
I am not a programmer or developer.
Please help me.
Thanks in Advance.

Self hosted SMS synchronization/sending server?

Hi all,
There are a lot of apps out there like MightyText, AirDroid, or DesktopSMS that allow you to send SMS messages from your PC. The problem with these services is that all the TOSs show that messages could be saved on their server. They also give pretty universal permission control to the application. While I'm sure these apps are "safe," I'm looking for a self-hosted solution, where I can host a website that my SMS/MMS content is synchronized to, and allows me to send SMS/MMS from the web browser (or companion app).
Is there something out there that does this? If not, I'm going to look into developing it myself.
Thanks!
Platform
I'm a developer and I had to create something for one project of mine and in time it became a whole project by himself.
I've created a self-hosted SMS marketing platform that it's integrated with more than 150 SMS providers you can bring your own device if you require it.
Have a look at selfhostedsms.com

Can I connect to a MySQL database?

I'm new to app development. I have spent some time building web sites using php and MySQL. I have a MySQL database that I would like to use the information from with an Android app I have in mind. Is this something I can do?
Best practice would be to create some interface on your server that has the MySQL database so that your app can call it. You can create PHP pages that you can call with your app and get back results in JSON or XML format and then process them in your app.
Android development is done with JAVA so you can do pretty much anything that you want including directly connecting to a MySQL database but I would really avoid that. Create yourself an interface.

Instant chat openfire+smack clarification

I'm going to add chat functionality to my app. After long searches I came to the conclusion that the best solution would be ejabberd/openfire + smack 4.1 for android, but I have some things that I can't wrap my ahead around. I don't know if I'm supposed to post a question like this here. Just comment if not and I'll delete it, but I don't know of any other place that I can ask.
Now I have a facebook login and some fields that post data to a server and that data is uploaded into mysql tables. I found multiple tutorials on how to make the openfire connection, but once I achieve that am I supposed to forget about my old implementation ? Is openfire just for instant messaging, or does it behave like a server in which I can add tables, query them, add data and etc. ?If so how? I mean in my current configuration I have php which handles all of that, but I couldn't find anything in openfire that would let me do such a thing.
When I configured openfire I saw that a lot of tables are created(ofuser, etc.), and I don't know what any of those are for, but I assume that I'm not supposed to mess with them.
Am I going to implement the auto-registration within the facebook login(user= fb id and password = token)?
Am I going to use openfire just to handle sending the messages, but store them on my current server in a table? It sounds that the phone would have to deal with too much- send the message to my server(to store it) and then to the openfire server?
I would also like to make an website for this app. Should I make it in such a way that when the message is submitted into the php form(to store it) somehow it's going to send it to the openfire to handle the downstream?
How should I implement this?
Any help is greatly appreciated! Thank you.:good:

Android User Accounts

Hey everyone, I wanted to get more information on how to create User Login in an app, say I wanted my users to login with there google or Facebook account and me able to upload photos, where would the accounts and photos be stored?
I know obviously on my own servers but could anyone point in the right direction more reading material would be great.
I'm just starting out in Android Dev, I'd like to get more information in creating these types of applications, thanks for your help. Appreciate it.
FNostromo said:
Hey everyone, I wanted to get more information on how to create User Login in an app, say I wanted my users to login with there google or Facebook account and me able to upload photos, where would the accounts and photos be stored?
I know obviously on my own servers but could anyone point in the right direction more reading material would be great.
I'm just starting out in Android Dev, I'd like to get more information in creating these types of applications, thanks for your help. Appreciate it.
Click to expand...
Click to collapse
Their are a few ways to look at it.
1: How is the login suppose to function?
2: Client side or Server side?
3: The main login files are normally stored sever side.
4: What programming language and or crm are you using?
5: What ever your using for the base operation login would be where you will seek the help for that enviroment.
6: If you are logging in to anything.. Then you would go through a program you made or a web page viewed.
7: Are you trying to Api through apps to jack the login information to login to multiple places? Or one place?
8: Your question is good ,but you need to specify exactly what you want to do ,and the outcome.
9: Are you programing an apk app?
10: Are you making a ROM or ?
11: If you want a user to fly across from Google or Facebook then you would basically intercept the Api of the login and act as if your the actual program. That type of thing is Api related.
12: Every program has it's own programming and api calls and functions... Also special folders Vendor specific.....
Sorta like hacking the vendors api...
That would evolve into security protocols being tampered with. That's why they don't give out that information. But you could sniff the packets via a computer and send and receive responses and also do some reverse engineering on the Api.
Deep level stuff.
Not something people will just answer.
The answer is in the question please tell us from beginning to end what it is you want to accomplish.

Categories

Resources