Re: [sqlite] V2.8 or V3.0 for embedded devices?

[Markus Oliver Junginger]

Thanks for the answers so far; there have been some interesting 
suggestions ( for example, I didn't know about the SQLITE_OMIT).

Still, I would like to know more about my main concern - memory 
consumption. Somewhere I read V2.8 holds the first 240 bytes or so of 
each row in memory, while V3.0 holds more than 1000 bytes per row 
cached. If that's true, it would be something I worry about.

Btw, the database of our application can get beyond 30,000 rows with a 
file size of around 8 MB file.

Regards,
Markus