[sqlite] compression

Has anyone implemented compression for sqlite? If so can you give me some tips on where/how? At this point I am guessing it would need to be done at the page level - but other than that - I am sort of lost. -David - To

[sqlite] table schmea - easy way?

Hello all, Lets say I have created a table like this: CREATE TABLE mytable( id INTEGER PRIMARY KEY first text, second text, third text) How do I go about retrieving the specifics on that table at a later date? I know I can do: PRAGMA empty_result_callbacks=ON PRAGMA show_datatypes = ON