System.Data.SQLite

I have a 4mb database that I am using on a Pocket PC Application using SQL lite and VS Studio 2005. Does SQLite contain any ability to compress its data? This 4MB file could easily compress down to about 1MB, and for a pocket pc app, space is always at a premium.

Does SQLite support compression? Is there a way to reduce the file size?

For compressing columns like that I recommend a user-defined function.  You could easily implement  INFLATE() and DEFLATE() functions which could call SharpZipLib or something.

SQLite 3.4.0 also introduced the concept of streaming blobs, which will make this even cooler as soon as I get it incorporated into the .NET library.

Robert

 

Thank you for your answer, I assumed as much. I guess I want the best of both worlds, the ability to search into a column and have it be compressed :-)

Is it possible to use user-defined funciton with SQLite and .NET? I did not know this was possible.If so, where can I look to learn more?