Android :: Wordpress Database Access In Mobile Applications
May 9, 2009
I am new to wordpress and I want to create an interface for being able to access my database hosted on wordpress in my mobile applications - particularly iPhone and Android.As these do not directly access SQL databases and would need routines on the server-side for being able to do so, what would be the best way for me to go about writing these routines/web-service calls?Are there any wordpress plugins available for this? If not, what language should I use - php or something else?
I have a wordpress site with a responsive theme for mobile and I was wondering if it was possible to take that theme, place it to an app and it would recieve updates from the msql server. Sorta like how twitter and facebook mobile have the same design as the apps.
The idea is to allow developers to access a remote database provided by google.In android the developer will need a special permission to be set at the manifest file.This could allow applications to keep a backup of users application data without having to sign in ever, seamless.Users could than sign-in to their gmail and see a list of applications that are currently storing data on their gmail space.The user could be allowed to wipe the data or even block the application from storing data to it.This idea make the most sense since Android will be a platform were users will be constantly changing android phones as new better ones come out.
Q: How does Web Applications differ from SmartPhone Applications (Iphone, Windows Mobile, Android/Nexus Application) and in what specific aspects do they differ and in what degree ?
Also for example,
Q: Why we need mobile version of Web Application like gmail.com or bankofamerica.com specifically for smartphone devices where we can access same web applications on smartphone using internet connections ? In what aspect do they differ and why do we have those differences ?
Sorry if this is the wrong forum (i'm sure the thread will be moved if it is!)I am seriously considering getting the htc hero (g2 touch), but everything hinges on the availability of a mobile database app, such as Visual CE (which I currently use on my WM phone) or Handbase. Basically a customisable form-based data collection app which can be sync'ed with a desktop database. Does anyone know of such an app?PS one of the shortfalls of Android from a marketing perspective is that there is no definitive way to view all available applications - Android Market is limited when accessed via the web.
What's the most convenient way to share a database across applications? For example, I want my application's dbadapter to query the android's native contact database so when a contact on the phone is deleted, similarly that contact is removed from my application. Should i use an attach statement to attach the table? Or would the better/more secure approach be to create a custom contentprovider query onCreate of my app to verify all contacts in my application still reside on the Contacts.db.
I would like to ask you smart people if anyone has seen any documentation regarding web access to a database from within an Android application. I would like to create a (FREE) application where the users can share information (rants/complains) around the globe. Each user will be able to see a little globe in his phone with locations of other users and some specific information about them.
Architecturally, I am thinking "database in my GoDaddy host, exposing a web service", and the web service accessed from the Android application. But I see no documentation about accessing web services. I can also go XML, maybe, but I am not seeing what mechanisms exist in the Android for over-the-web XML access.
I have a feeling I am mis-understanding something big in the picture. Can someone point me to docs, or knows something about this topic? (the iPhone has a Lighter app where you can see people lighting around the globe. Mine is similar, but people would not be lighting, instead they will be "complaining/ranting").
I understand that to access a SQL database from Android I need to create a web service that will run on the SQL server and will process requests from the Android application, what I need to know is how to create this web service and how to access it from Android.
I am writing an application that initially will be developed as web (probably Silverlight) and Android application. I found on Android website that SQLite is supported, but I plan to release the same app for Windows Mobile, Palm Web OS and iPhone as well.Could you please advice me on which database would be the best to work with for all platforms?EDIT:Maybe I should add that I would want all applications (mobile/desktop) to connect to a main server when internet connection is detected and synchronize all data that's changed.
I am creating an android app that is basically a listing of information on Mushrooms. I get this information from an sqlite database. I have a global singleton with a services class inside it in which I use to access my db. Almost every activity accesses the db. Is it better to leave my db open all the time or open and close it as I need the data? If the best practice is to leave it open all the time, where do I need to make sure to close it and what is the worst case scenario if I left it open when the activity was destroyed?
I have a Windows web server already set up with a website (unlimited application pools) and I want to be able to access a database on that server via the Android app I'm developing. How can I do this? Can someone point me to a tutorial or give code example of how this cross-platform (Android/Java to ASP.NET/C#) communication can be done? (I'm trying to create a leader board or global scoreboard for my Android game on my server.)
I have four tabs (reports, review reports, map and settings). I have an sqlite database populated with report information. I wish to have the database accessible throughout the application. The reports tab successfully adds data to the database however using the same methodology crashes the application. The Android debugger points to the line where the database is called again.
In the reports tab the following code is used to launch the database...
In the onCreate() method of the Review Tab - Where I wish to review reports - I try to access to the database through the call calling the return report method
this.reportDatabase = new ReportDatabase(this);
However this fails to work. In the android debugger highlights that the problem belongs with the context being provided to it. I realise that the report database has already been accessed by the report tab and wonder if this is causing the issue. I am new to programming android, the application is designed to report on flamingos in Africa, any help would be greatly appreciated!
Following the suggestion of Seva Alekseyev I have adapted as follows...
I have adapted my ReportDatabase as...
reportDatabase = ReportDatabase.open(this);
As the call in both the report and review tab. Unfortunately this doesn't seem to work, the debugger stops on the same method. The full ReportDatabase.java file is here...
This method returns a double array and probably shouldn't be this hacky...
As i am being an Android developer, and android is supporting SQLite database, i would like to know that which are the other mobile platforms supports the SQLite Database so that i can make SQLite database common and can place it at one place,and thereafter i can make database transaction from different mobile platforms.
I would like to write a client application for Android that uses the Google App Engine as a database backend. My Android client would connect to the App Engine to save information, then it would connect later for reports. Is it possible to use the App Engine as a backend like this?
How to access my web application database in android emulator, i want list out my database values. These are in my web application. database name employees and table: employee_data. i want to get employee_data data on android emulator.
I'm searching information about how i can access a specific database that to not belong to me, and that is store in /data/data/com.... directory is it possible without root access? it it possible with root access, and how?
I am experiencing a problem where when the android device wake up from sleep, the Activity would take forever to get redrawn(and have to terminate it most of the time). I am not sure why, but when I comment out the code below where it retrieves an object from the database based on id stored in the bundle, the problem goes away.
Not sure why the db transaction is causing an issue.
secondly, is it better to store the object in bundle instead of storing its id and retrieving it from db in onCreate?
I have a general Android design question around data access. I have a number of activities in my application that need to access a SQLite database. In order to wrap up all data access logic in one place I have created a DatbaseHandler class that takes care of all data access logic. This class takes care of building up where clauses, calling the database and interrogating the resulting cursor to retrieve the query results and return them to the caller. The purpose of this class is to wrap all data access code in one place so that it can be easily managed and maintained as opposed to having data access logic scattered across all activities. Each activity that needs access to the database creates an instance of this DatabaseHandler class and passes it a reference of android.content.Context. The DatabaseHandler class then uses this Context object to call an underlying content provider as follows context_i.getContentResolver().query(...).
My data access logic (cursor handling logic to be specific) is not in the activity and so I cannot manage the cursors life cycle, therefore there is likely to be memory leaks.
My questions are as follows -
How can I (if its even possible) manage the cursors life cycle from outside an Activity? Should each activity even be creating an instance of this data handler class and passing an instance of Context to it? Perhaps my design approach is wrong and I should expose these data access functions as static methods that take an instance of the calling activity as a parameter. That way I could perform managed queries and let the activity take care of managing the cursors life cycle?
I use a sqlite database in my project. The stored data in it must not be available for the user to edit. As I've read here I saw that if you have root access you can alter sqlite database. The only solution would be to encrypt database content, but this would be time consuming for device. Any solution to prevent access to database ?
I am quite familiar with web programming (HTML, PHP, MySQL) and semi-familiar with Android Java programming, and would like to begin a project that combines the two together. Can someone point me into the right direction for how I would access/manipulate a web-based MySQL database from an android app?