Re: [sqlite] Reducing compiled size

For the record, I know that the documentation says the OMIT_* flags don't work with the regular amalgamation, but I have in fact used many of them and they seem to work. Two that only partially worked (a bug?) are SQLITE_OMIT_AUTOVACUUM and SQLITE_OMIT_AUTHORIZATION (I am not sure about that

Re: [sqlite] Reducing compiled size

Hi Richard, I'm using gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5). Also tried with VC9 which yields very similar sizes. $ gcc main.c sqlite3.c -lpthread -ldl $ size a.out textdata bss dec hex filename 51447536881168 519331 7eca3 a.out It looks like this could have

Re: [sqlite] Reducing compiled size

On Mon, Jul 25, 2011 at 10:39 AM, Dave Hope wrote: > Hi all, > > I read on the sqlite website that the compiled size can be reduced to > 275KiB ( http://www.sqlite.org/different.html#small ), however I'm > struggling to get it much below 500 KiB using the SQLITE_OMIT_* >

Re: [sqlite] Reducing compiled size

Thanks Stephan Sorry, you're quite right. I was actually using OPTS="" but omitted it when I pasted it into my e-mail. Thanks Dave On Mon, Jul 25, 2011 at 3:55 PM, Stephan Beal wrote: > On Mon, Jul 25, 2011 at 4:51 PM, Dave Hope wrote: > >> Hi Stephan, >>

Re: [sqlite] Reducing compiled size

On Mon, Jul 25, 2011 at 4:51 PM, Dave Hope wrote: > Hi Stephan, > > I initially added these to the Makefile, but looking at the mailing > list suggested otherwise: > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg37813.html That post says to use: make "OPTS=-..." So

Re: [sqlite] Reducing compiled size

Hi Stephan, I initially added these to the Makefile, but looking at the mailing list suggested otherwise: http://www.mail-archive.com/sqlite-users@sqlite.org/msg37813.html Thanks Dave On Mon, Jul 25, 2011 at 3:46 PM, Stephan Beal wrote: > On Mon, Jul 25, 2011 at 4:39

Re: [sqlite] Reducing compiled size

On Mon, Jul 25, 2011 at 4:39 PM, Dave Hope wrote: > make sqlite3.c "-DSQLITE_OMIT_ALTERTABLE -DSQLITE_OMIT_ANALYZE > Shouldn't that be: make sqlite3.c CPPFLAGS="..." ? Make doesn't understand -D (no, that's not a smiley). -- - stephan beal

[sqlite] Reducing compiled size

Hi all, I read on the sqlite website that the compiled size can be reduced to 275KiB ( http://www.sqlite.org/different.html#small ), however I'm struggling to get it much below 500 KiB using the SQLITE_OMIT_* options. I'm producing my own amalgamation, which I believe you can use the OMIT options