>>I wouldn't use SQLite for most in memory data that never needs to be >>stored on disk > >Even this depends entirely on your context. Of course if only a simple
>lookup in a table is more or less all you ever need, there is little >point in SQLite. But if or when your requirements get more complex and >things shift away from what basic data structures can do, SQLite can be >something worst considering. Yes. The operative word in my statement was "most". In other words, the vast majority of the time, data and structure needs are simple. Most data doesn't need to be stored and accessed in a way that makes SQL useful. Occasionally memory databases/tables are valuable, but it is the exception rather than the rule. I just don't want anyone saying "but this one dude told me to replace all my structs with SQLite memory tables." >For instance, if the language you use doesn't offer native support for >flexible data structure and fancy access to such data, you can feel >much more comfortable using memory DB(s) than a collection of >third-party libraries, not always consistent between each other, to >achieve the same effect as SQLite can offer in minutes. I think the best plan in this case would be to get a real language (the exception being if the language in question is assembly, in which case you didn't want SQLite anyway). >I use AutoIt (a very complete Basic-like scripting language for >Windows) to develop most applications I need. It doesn't offer >structures, nor unions, nor objects nor, say, associative arrays. But >it only takes a dozen lines of code to have associative arrays >available using an SQLite memory database, with more flexibility in >usage than most AA implementations rigidly built into many fashionable >languages. I would go crazy if I had to use a language without any structures, objects, or arrays. How could a man LIVE without arrays? Heck, even assembly language has arrays and/or structures (allocate your memory, and use offsets). John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users