On Fri, Jul 08, 2011 at 09:01:03AM -0400, Mark Murphy wrote: > On Fri, Jul 8, 2011 at 8:55 AM, Jim Graham <[email protected]> wrote:
> Wow. You took that joke waaaaaaaaaaaaaaaay farther than I had > expected. :-) Seemed like the (fun) thing to do at the time. :-) > > Ah, ok. ?Yes, that makes sense now. ?I was picturing the in-memory > > copy while the app was running. ?That's fine...just a bit more code > > to run the first time around. > > If you don't need it to be SQLite, perhaps storing the data as an XML > resource and loading it into RAM at runtime may make more sense. I > don't know how big your data set is. For the grain database, it's currently at 128 entries (unless I find more data between now and the time I release the app, but then, I've already scoured all of the sources I know about, and those a professional brewer friend knows about, so....). Each of those entries is a specific grain. For example, Briess 2-row, Briess Caramel 20, Crisp Maris Otter, Gambrinus Pils, Weyermann Bohemian Pils, and so on. The brand+name combined is "name", and the columns in each row are: name color extract ppg usagemax flavor For example: "Briess 2-Row" 1.8 81 37.5111 100 "Mild, malty" "Briess Caramel 20" 20.0 73 33.8063 15 "Sweet, caramel, toffee" ALL of these are treated as strings. While it is true that I am learning SQLite for the Android as I'm doing this, that, IMHO, is a Good Thing. Besides, a database seems like the only non-kludgy solution for this stuff. It's how I built the Tcl/Tk version, using a very simple all-Tcl "database" (http://wiki.tcl.tk/3010) :from the wiki (http://wiki.tcl.tk/). As of either Tuesday or Wednesday, when I learned how to use the SQLite3 extension to Tcl, that makes a lot more sense than the all-Tcl version...and the database is a fraction of the size with SQLite3, too. Later, --jim -- 73 DE N5IAL (/4) MiSTie #49997 < Running FreeBSD 7.0 > [email protected] ICBM/Hurr.: 30.44406N 86.59909W Point Lobos Photography Set 1 (Photo-posters): http://jdgapps.com "Now what *you* need is a proper pint of porter poured in a proper pewter porter pot.." --Peter Dalgaard in alt.sysadmin.recovery -- You received this message because you are subscribed to the Google Groups "Android Developers" 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-developers?hl=en
