You are talking about 3 different problems and you say you have been looking for a solution for 2 weeks. Tackle each problem separately.
1. Making your data smaller: This is not a problem with Android SDK, it's a general problem with SQLite and making databases smaller. Search the web. But some options are (a) redesign your schema to use smaller data types for your columns, and/or (b) look into actual "compression" where your data is actually altered. However, I don't think compression is supported out-of-the-box for SQLite, and if you compress your data, you will probably sacrifice speed any time you do queries on your data. 2. Access: How you access your database depends on where the data will be located. Does it really need to be bundled with the apk, or could you make it available over the web? 3. Including with apk file: You might be able to use a raw resource for this purpose, but I'll give others a chance to help you with this issue. What kind of app are you writing, and what kind of data is in the database? -- PJ On Nov 14, 7:08 pm, Averroes <[email protected]> wrote: > Hello there, > > I am developping an app where the main data source is a SQLite > database. > > First problem is the size. > Second problem is the access. > Third integrate to the apk the sqlite database (read-only) > > I know that SQLite has a way to compress the size of the database. > Is this feature available with android? > My database is about 40M and I think its to much. > > So is there some tweaking to improve size and access for our lovely > portable devices. > > I am little tired, it's late out there and have been about 2 weeks > looking for a solution. -- You received this message because you are subscribed to the Google Groups "Android Beginners" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en
