- #SIMPLE ANDROID APP WITH DATABASE FOR ANDROID#
- #SIMPLE ANDROID APP WITH DATABASE ANDROID#
- #SIMPLE ANDROID APP WITH DATABASE CODE#
You could store HTML formatted data in your database and display it in a WebView or a TextView (via Html#fromHtml()) - both can display formatted text.ĭatabases don't care what type of text you store, for transfer over the internets you may need to encode the text so it does not interfere with the transport formatting (XML, JSON. Is there a way I could preserve the formatting of my data ? There are even hosted database services like nextDb that do most of the work for you. There are tons of tutorials and books about creating such interfaces to databases. I'd suggest a simple REST interface to your database since it's pretty lightweight but does not expose your database directly to the web. Required performance depends on how much users you have / expect. Depends on your server hardware & software. The issue that I can see here is the slowness with multiple DB requests coming at the same time.Ī decent database server can handle thousands of requests. And you don't need to setup a database server & interface.
#SIMPLE ANDROID APP WITH DATABASE ANDROID#
Yes, Android has a nice built-in SQLite API but no remote database API. It is okay if it is only 2MB which would be enough to store lots of text-only receipes.Īlso I believe using SQLite would be easier as compared to using a remote DB. SQLite : This could be a good option but would be slow as it would need to access the file system.Īccessing a local database is pretty fast, 5ms or so if it's just a simple read only query on a small database.īut then there could be a limitation of the storage on different phonesĭepends on your definition of huge database. And if you want users to be able to add receipes for other users to see you'll need an external database anyways. Some remote database accessed via some HTTP interface where you can read / write the whole database. Network is way slower than accessing the filesystem. I hope I will get some good advice here from the experienced people who might have encountered similar situation.Ī local SQLite database that has the least recently used receipes so you don't need network all the time. I have been looking for this for sometime now but was not able to find concrete information.
I am just looking for hints/suggestions that would help me clear my thoughts and help me take a decision.
#SIMPLE ANDROID APP WITH DATABASE CODE#
Also this is not a homework for me and I am not looking for any ready made code solutions. I would be more than thankful if someone could share their knowledgeable and expert comments on the above scenario.
Can I use threads here in some way to queue multiple requests and handle them one by one ? Is there an efficient way to do this.Īlso I have one more question in terms of the formatting of my data once I pull it out from the above DB's. Also I believe using SQLite would be easier as compared to using a remote DB.Ģ) Remote Database : The issue that I can see here is the slowness with multiple DB requests coming at the same time. But then there could be a limitation of the storage on different phones. I could eliminate the slowness by performing DB data fetch tasks in the AsyncTask.
So far, as per what I have read in different forums, I believe that I have two options in terms of a database choice : 1) SQLite 2) Database on remote server (MySql/Postgre)įollowing are some of the thoughts that have been going on in my mind when it comes to taking a decision between the two :ġ) SQLite : This could be a good option but would be slow as it would need to access the file system.
I am currently trying to figure a good and efficient way of handling the data in my app. I am to deal with a lot of data in this process. The scope is very vast for me in terms of covering all the recipes from all over the world. I have decided upon the features of the app and the scope it will cover. I am currently trying to design a recipe application. I am new to Android Application Development and a new member at stackoverflow.
#SIMPLE ANDROID APP WITH DATABASE FOR ANDROID#
Best Database design option for Android application with huge data
0 kommentar(er)
