Can I connect to a MySQL database? - Android Q&A, Help & Troubleshooting

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.

Related

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

Need help... Total noob here

I have a very basic knowledge of C++. I studied it two years back and haven't practiced it since.
My college has an attendance page where students can log in and check their attendance. I want to develop an app that will log in to the attendance page and fetch the attendance of the students. I may also need to do some mathematical operations on this attendance data. Is it possible to make such an app? Is it too complex to make?
There's already an app (let's call this app 'A') that fetches and displays the attendance data but I want my app not just to simply fetch and display the attendance data, but to also perform certain mathematical operations using this data. If making an app that will log in to the attendance page and fetch the data is too complicated, is it possible to make an app that will use the data fetched by 'A' to perform mathematical functions?
Please help me out and bear with my curiosity. Thanks in advance
Depends on how app 'A' stores the data. If it is in a standard sqlite database or simple text file with a clear format then you can probably read it. If it uses some obscure file format then you might run into some trouble. Basically you will need to browse the file system of the phone and dig around for how app 'A' stores data.
Is it possible for you to let me know if I post the link to the app here? Then on the basis of the nature of the format, I'll ask my programmer friend to make the code.
Hello? Can someone please help me?
dakshay95 said:
I have a very basic knowledge of C++. I studied it two years back and haven't practiced it since.
My college has an attendance page where students can log in and check their attendance. I want to develop an app that will log in to the attendance page and fetch the attendance of the students. I may also need to do some mathematical operations on this attendance data. Is it possible to make such an app? Is it too complex to make?
There's already an app (let's call this app 'A') that fetches and displays the attendance data but I want my app not just to simply fetch and display the attendance data, but to also perform certain mathematical operations using this data. If making an app that will log in to the attendance page and fetch the data is too complicated, is it possible to make an app that will use the data fetched by 'A' to perform mathematical functions?
Please help me out and bear with my curiosity. Thanks in advance
Click to expand...
Click to collapse
Well, I too have a very little knowledge in C++. Only messed with Console so far, so I'am not familiar with C++ in many ways.
This is my Opinion - As long as you are able to login there, I guess you can download whole page or it's with your logic to fetch data. So as long as you can fetch the data you want messing with the data is so easy. Even I have little knowledge of what you are going to do. I'm not familiar with 'web', but I'm pretty sure that u can find examaples if you do a "google". Anyway why won't you use C#?
---------- Post added at 10:19 AM ---------- Previous post was at 10:15 AM ----------
It seems I didn't realize your question. Seems like that you want to do your mathematical functions from an app other than app 'A'. As @CellCB mentioned above, you have to find where does that app store the data and in which format. ofc you can't do it if it's encrypted or like that.

[Q&A] [Q] Connect to Remote Database?

Q&A for [Q] Connect to Remote Database?
Some developers prefer that questions remain separate from their main development thread to help keep things organized. Placing your question within this thread will increase its chances of being answered by a member of the community or by the developer.
Before posting, please use the forum search and read through the discussion thread for [Q] Connect to Remote Database?. If you can't find an answer, post it here, being sure to give as much information as possible (firmware version, steps to reproduce, logcat if available) so that you can get help.
Thanks for understanding and for helping to keep XDA neat and tidy!
Oracle Database 12c is Ideal For Your Project!!!
ktulu123 said:
Hey, Im developing a web app with java servlets that can access an oracle database through the tomcat server. I am also developing an android app that I want to use to be able to display the information that is stored on this database.
I am just wondering how I do this or is it even possible with oracle & tomcat? If not what other databse/server should i use? The data will also have gps coordinates to display the items on a map.
Fairly new to this type of application
Thanks a mill
Click to expand...
Click to collapse
Why Oracle Database 12c?
Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities delivering breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in three editions to fit your business needs and budget: Enterprise Edition, Standard Edition, and Standard Edition One.
New Oracle Database Utility,TyphoonDBMS 1.0 Beta (Free)
TyphoonDBMS is a complex and efficient Java-based software (free) solution that enables user to easily access and manage tables on Oracle Database Servers.
Typhoon is a comprehensive and reliable application that was developed to assist user in managing the contents of Oracle databases, enabling user to add, edit or remove tables without needing to resort to SQL statements to get the job done.
To gain access to the utility, user first need to create an account using a preferred set of credentials, which will then be required to enter every time user wish to work with Typhoon.
The program allows user to connect to a local or cloud server, by providing the necessary information, including name, version, driver and service ID. user can also input the network details, specifically the host and port number, along with the username and password, or even the database URL. Prior to saving the configuration, user can test the connection to make sure everything is in order.
Once user connect to the Oracle database, Typhoon allows user to view its contents, namely the tables that it comprises. user can browse through them, select a record and update it. Similarly, user can add a new one, as the tool enables user to ‘Insert Number Data’, ‘Insert Blob Data’, ‘Insert Clob Data’, ‘Insert String Data’ or ‘Insert Date Data’.
Moreover, user can create a new table by defining the number of columns that user need, assigning it a name, then filling out the columns and rows with the information user wish it to store. All of this can be done without having to resort to SQL statements or commands. Other options include the ability to drop tables from the database.
This Java-based utility also offers user a series of SQL ‘Syntax References’, (statements and functions) and which user can analyze in detail, to learn how to better work with them, and then use them for your own purposes.
Download & Blog
typhoondbms.wordpress.com/download/
download.cnet.com/Typhoon-DBMS/3000-10254_4-76273374.html
softpedia.com/get/Internet/Servers/Database-Utils/Typhoon.shtml

[Q] Help making Android App with MySQL DB (or other DB if you have suggestions)

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

Best APP for managing a database between Android and Windows 10.

I do not know if I am asking in the correct place, or the correct way. I am not a developer and so far attempts to use google to find the answer to my question has been in the form of developer answers which are useless to me since I am not writing a program. I am looking for one.
I am trying to build myself a database. On my desktop I can use Open Office Base to do this, but the database is only accessible on my desktop.
I have tried Momento database app and its desktop counterpart, but its limited to 3 tables only unless I buy a monthly subscription and it relys on an external web service to function.
I have looked at the Cellica program for syncing database, but it does not support the Open Office Base format, and Open Office can not export to MS Access format.
What I am looking for is the best free database program for my desktop which has an android app, which I can use to sync my database between my android tablet and my desktop over wi-fy when I'm at home.
If its good enough I may even consider a paid program, as long as there is no subscription fee.

Categories

Resources