How to update a database used as a source of data by an Android app -


I have an app that uses large amounts of data that has been compiled outside the app (my On the main PC). The app is for my personal use so there are no difficulties in distributing data updates of other users. However, I want to update the data at present, whenever I am following a very complex and time consuming process, and I wonder if anyone can suggest ways to make it easier.

Whenever I want to add new data as follows:

  • I enter the data in a new CSV file which is the corresponding table in the database As a source,

  • I use the SQLite database browser to import data into an existing SQLite database (in this program to attach the imported data to the current table Does not have the ability, so whenever a table updates , Then I have to delete the existing table, then import the data from the CSV file into a new table, then manually edit the data type for all the fields in the table.)

  • I drag the icon to the database file on my project 'Assets folder' in Excel

  • I export from eclipse as an APK file.

  • I copy the APK file to my phone

  • (using the Astro File Manager) I have an older version of the app Uninstall and install new APK.

  • When the app is run, the code sets up the copies in the data folder of the data app from the 'property' folder, depending on the instance; This means that each byte of data takes two bytes in the internal memory of the phone; This is not a problem at present, but it can be because the amount of data increases; I wonder if there is a more memory-efficient method?

I should be very grateful for any guidance.

I have found that I can have an SQLite database on the SD card, which has many things for me (And reduces the amount of internal storage by my app.)

The first clue for an app to refer to a database on the SD card was that it is possible ( Contrary to the impression received from Android documents and Android documentation). / P>

Then I found here on the Stack Overflow which shows how easy the code can be.

With the help of advice on these pages, now my app has a very simple DBEHELLER code where the OpenDataBase () method reads as follows:

Public Zero Access Database () SQLException throws {
file dbfile = new file (DB_PATH + DB_NAME); MyDataBase = SQLiteDatabase.openOrCreateDatabase (dbfile, null); }

Now there is no need to include the database in the "property" of my project, nor does it need to be included in the APK file. And the great advantage is that the database can be updated without having to go anywhere near Eclipse, reinstalling the application alone


-

Comments

Post a Comment

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
Read more