Re: [sqlite] command line does not accept arrow keys

2009-11-21 Thread Qianqian Fang
hi Jay Jay A. Kreibich wrote: > Yes. Readline support is not on by default. > > You need to compile it with -DHAVE_READLINE and add -lreadline > to the linker: > > $ cc -DHAVE_READLINE -o sqlite3 sqlite3.c shell.c -lreadline recompiling sqlite3 from source code with your command solved

Re: [sqlite] temp directory?

2009-11-21 Thread Artur Reilin
> You can try setting a temp or tmp or tempdir environment variable on the > server, however, as I said in the previous post, I am not sure if it > will work. > > Probably the safest and most robust way would be to have your code call > the pragma temp_store_directory directly after opening the