This is a tough one to answer because there is so much context to consider. SQLite, or any database, could easily solve the problem you mention (storing values that can change without needing to recompile your program).
Whether it's more efficient is another question. If you think you'll have many more than 10 entries (likes thousands or millions), or the 10 entries change very often (once a minute??) and you could automate entering them, a simple app using a database like SQLite would be a decent way to go. Does this need to get put on a website? Is the app going to be mailed around? (in which case a spreadsheet might be just as easy). If you'd like to use this as an excuse to learn more about databases, this project would be a perfect opportunity. It's surprising how often databases, especially a small and simple one like SQLite come in handy. Compared to using Excel: > coding efficiency - no coding needed to use Excel, so Excel wins > processing speed - your app would almost certainly start up and run quicker > than Excel > memory usage - your app would definitely use less memory than Excel, but does > this really matter with only 10 entries? That's my best shot. Doug -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carl Gross Sent: Tuesday, April 16, 2013 3:28 AM To: [email protected] Subject: [sqlite] Beginning database question Hi All, I'm an amateur programmer who has never worked with databases before. I *think* that getting started with SQLite may help with some of my projects, but I'm having trouble determining exactly how. I'm hoping someone in this list may be able to point me in the right direction. My simplified situation is this. There are 10 discrete heights' and 10 discrete weights,' and each height/weight combination corresponds to one of two 'teams.' All of this information is hardcoded into my program. My program asks a user to enter his own height and weight, and the program will output the user's corresponding team based on the hardcoded data. My SQLite question is: Can using SQLite instead of Microsoft Excel be beneficial in terms of coding efficiency, processing speed, memory usage, or any other aspect? If so, how? Sorry for the long, broad, vague question. I'm not looking for someone to tell me how to do something. I'm looking for someone to assure me that SQLite (rather than a simple spreadsheet) is right for me, and to hopefully steer me towards some documentation that may be beneficial to me. Thanks, Carl _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
