SQLite
-
Anyone here using this? I have what is essentially a frozen database, (the live version is in SQLS2K) and I want a single program to be able to access it. I make heavy use of lookup tables (e.g. a text 'word' to a numeric ID, then look the ID up in a list to yield a list of matches), but my target machine is low on memory, so I don't really want to run MSDE on it, and I want the machine to work standalone. From what I've read, once I've created and populated the database, it should do what I want, but I'd welcome comments. (It's not quite readonly, since I save lists of results occasionally, and need to update one other table as well, but I can save those externally *as well* and then update the master later. Does this sound feasible? I have all the SQL concerned (except that the word lookup is generated on the fly depending on input, since the number of words varies...) Steve S Developer for hire