I know there are commands to clean it, I know there is an addon for sqlite (CEROD) that supports compression and I know there is an app called FuseCompress to make compressed partitions, but is there any other way to do it?

CEROD requires differents queries to be used, and FuseCompress doesn't seem that reliable from what I read on the net. Optimally it would need to be made on the fly.

Technically a database should be some sort of big text file, and lzma does wonders on it, I intend to make a huge database and sadly space is an issue here and I'm looking at the possibilities to make this seamless.

Thanks!

PS: Hopefully I posted in the right place. Feel free to move it to the appropriate place.