Certainly with only 100 rows you could write the SQL script containing the create table command and 100 insert commands and then use something like SQLite Expert to execute the script and create the DB. Or you could just write a straight Java application to execute the commands and create the DB. The SQLite file that results in all cases is "portable".
But for only 100 rows and 3 columns it's hardly worth messing with SQL -- you can just create an array containing the data and search that, or load up the data in a HashTable or some such. On Jul 15, 9:42 am, Rodney Lendore <[email protected]> wrote: > The database will in the end contain about 100 rows and 3 columns. But this > database will not be written to by the user simply read from to gain some > generic information, depending on which buttons a user clicks. > > Thanks > > On Mon, Jul 12, 2010 at 9:23 PM, Justin Anderson > <[email protected]>wrote: > > > Unless the database is going to be quite large, I would just create it in > > code the first time you start up the app... How large are you anticipating > > this database is going to be? > > > ---------------------------------------------------------------------- > > There are only 10 types of people in the world... > > Those who know binary and those who don't. > > ---------------------------------------------------------------------- > > > On Mon, Jul 12, 2010 at 1:56 PM, DanH <[email protected]> wrote: > > >> Certainly in Java code you can create it, or in C++, or with a stand- > >> alone PC tool such as SQLite Expert. SMOP. > > >> Dunno about /res. > > >> On Jul 8, 4:30 pm, Rodney Lendore <[email protected]> wrote: > >> > Hi, > > >> > I am trying to create a pre-populated sqlite database to be shipped with > >> my > >> > application. The database is to contain three columns. > > >> > | ID | Name | URL | > > >> > and possibly several hundred rows. Is there a way I can create this in > >> /res > >> > or java code smartly ? Forgive me I am fairly new to Java and have > >> little > >> > experience with SQL. > > >> > Thanks very much in advance for you help > > >> > Rodney > > >> -- > >> You received this message because you are subscribed to the Google > >> Groups "Android Beginners" group. > > >> NEW! Try asking and tagging your question on Stack Overflow at > >>http://stackoverflow.com/questions/tagged/android > > >> To unsubscribe from this group, send email to > >> [email protected]<android-beginners%[email protected]> > >> For more options, visit this group at > >>http://groups.google.com/group/android-beginners?hl=en > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Beginners" group. > > > NEW! Try asking and tagging your question on Stack Overflow at > >http://stackoverflow.com/questions/tagged/android > > > To unsubscribe from this group, send email to > > [email protected]<android-beginners%[email protected]> > > For more options, visit this group at > >http://groups.google.com/group/android-beginners?hl=en -- You received this message because you are subscribed to the Google Groups "Android Beginners" group. NEW! Try asking and tagging your question on Stack Overflow at http://stackoverflow.com/questions/tagged/android 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
