[sqlite] 'dump' from the C API

2007-10-07 Thread Keith Godfrey

Hello,
Does anyone know how to do a database dump from the C API? I'm linking 
to sqlite3.o (the amalgamated file) and was hoping to open a database 
and dump the contents to an sql file.


I know this can be done from the shell, but as of yet, I can't get the 
shell running on AIX.


Thanks in advance,
Keith



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] troubles w/ sqlite on AIX 5.3

2007-10-07 Thread Keith Godfrey

Greetings,

I need to compile and run a program on an AIX box and then get the data 
back onto a linux machine for processing. I'm using sqlite3 as an 
embedded database (excellent software, btw). Unfortunately, this "easy" 
task has proved a tad bit complicated.


Compiling the regular 3.5.1 source code gave me a fatal error.

./libtool --mode=link xlc -q32 -qarch=pwr4 -qlonglong -D_LARG_FILE=1 
-D_LARGE_FILES=1 -DUSE_TCL_STUBS=1 -O2 -DOS_UNIX=1 -DOS_WIN=0 
-DHAVE_USLEEP=1 -I. -I./src  -DNDEBUG   -DSQLITE_THREADSAFE=1 
-DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1  -o .


libtool: link: unable to infer tagged configuration
libtool: link: specify a tag with `--tag'
make: 1254-004 The error code from the last command is 1.

This error is from IBM's compiler 'xlc' - the errors from compiling w/ 
gcc are quite different and are at the end of the message (in short, gcc 
choked on the file tclsqlite.c). Might anybody have an idea on how to 
resolve this? I need the command line tool 'sqlite3' on AIX, hence the 
need to compile the source.


Somewhat relatedly, the amalgamation also has problems on AIX. It works 
running inside a simple program compiled w/ gcc, but I get an 
out-of-memory error when I run the same program compiled w/ 'xlc'. This 
can be fixed by turning off all optimization in xlc. This suggests it's 
an IBM bug, but it seems a bit weird.


Any ideas on resolving the general AIX build problem will be greatly 
appreciated.


Thanks in advance,
Keith

---
compile error of 3.5.1 using gcc:

/libtool --mode=compile --tag=CC gcc -g -O2 -I. -I./src -DNDEBUG   
-DSQLITE_THREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 
-DSQLITE_OMIT_LOAD_EXTENSION=1 -c ./src/tclsqlite.c
 gcc -g -O2 -I. -I./src -DNDEBUG -DSQLITE_THREADSAFE=1 
-DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -c 
./src/tclsqlite.c  -DPIC -o .libs/tclsqlite.o
src/tclsqlite.c:285: warning: initialization from incompatible pointer 
type

src/tclsqlite.c:295: warning: excess elements in struct initializer
src/tclsqlite.c:295: warning: (near initialization for 
`IncrblobChannelType')

src/tclsqlite.c: In function `DbUpdateHandler':
src/tclsqlite.c:580: warning: passing arg 3 of 
`Tcl_ListObjAppendElement' makes pointer from integer without a cast

src/tclsqlite.c: In function `tclSqlFunc':
src/tclsqlite.c:666: warning: passing arg 1 of `Tcl_NewByteArrayObj' 
discards qualifiers from pointer target type
src/tclsqlite.c:674: warning: assignment makes pointer from integer 
without a cast
src/tclsqlite.c:732: error: `Tcl_WideInt' undeclared (first use in 
this function)
src/tclsqlite.c:732: error: (Each undeclared identifier is reported 
only once

src/tclsqlite.c:732: error: for each function it appears in.)
src/tclsqlite.c:732: error: parse error before "v"
src/tclsqlite.c:733: error: `v' undeclared (first use in this function)
src/tclsqlite.c: In function `DbObjCmd':
src/tclsqlite.c:937: warning: passing arg 3 of `Tcl_GetIndexFromObj' 
from incompatible pointer type
src/tclsqlite.c:1589: warning: passing arg 2 of `Tcl_GetVar2Ex' 
discards qualifiers from pointer target type
src/tclsqlite.c:1613: error: `Tcl_WideInt' undeclared (first use in 
this function)

src/tclsqlite.c:1613: error: parse error before "v"
src/tclsqlite.c:1614: error: `v' undeclared (first use in this function)
src/tclsqlite.c:1663: warning: passing arg 1 of `Tcl_NewByteArrayObj' 
discards qualifiers from pointer target type
src/tclsqlite.c:1671: warning: assignment makes pointer from integer 
without a cast

src/tclsqlite.c:1951: error: parse error before "rowid"
src/tclsqlite.c:1956: error: `rowid' undeclared (first use in this 
function)
src/tclsqlite.c:2172: warning: passing arg 3 of `Tcl_GetIndexFromObj' 
from incompatible pointer type

src/tclsqlite.c: In function `DbMain':
src/tclsqlite.c:2345: warning: passing arg 2 of 
`Tcl_TranslateFileName' discards qualifiers from pointer target type
src/tclsqlite.c:2377: warning: passing arg 2 of `Tcl_CreateObjCommand' 
discards qualifiers from pointer target type

make: 1254-004 The error code from the last command is 1.







-
To unsubscribe, send email to [EMAIL PROTECTED]
-