[sqlite] temp file directory

hi, i found the way to open a temp file is different from other files (.db files or journal files) open temp file: open with the relative path. and then point to the fullpath while open other files: get the fullpath first, and then open. codes are cited as below: in pager.c

[sqlite] file structure-can i get the source codes with original structure?

hi, i can see the source file structure has been changed from 65 files before to only 2 files now. and this change bring me a problem when i try to integrate sqlite with other platforms. in my sqlite integration, i have to put my porting layer os_xxx into a seperate 'cpp' file and to include

[sqlite] file structure issue

hi, i can see the source file structure has been changed from 65 (sqliteint.h, os_common.h,. )files before to only 2 files (sqlite3.h)now. and this change bring me a problem when i try to integrate sqlite with other platforms. in my sqlite integration, i have to put my porting layer os_xxx

Re: [sqlite] file structure issue

Nuno and Vivien thanks for your replies. i will try that. wang On 5/23/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 5/23/07, weiyang wang <[EMAIL PROTECTED]> wrote: > does anyone know how can i get the source codes with the early file > structure? (65 seperate files)?

[sqlite] sqlite3_temp_directory in main.c

hi, i found the following line in main.c char *sqlite3_temp_directory = 0; which seems to remove the possibilities that the customer platform could specify sqlite3_temp_directory. i suggest that this line is removed. any comments? thanks in advance. wang

[sqlite] progress_handler: progress in percentage?

hi, i am looking into the sqlite3_progress_handler() and i am wondering the possiblity of representing progress in percentage. the period of progressing update is based on number of virtual machine opcodes, is there anyway that we can estimate the total amount of opcodes of one query during

Re: [sqlite] sqlite3_temp_directory in main.c

PRAGMA to overide the defult in runtime. i am looking forward to your opiniions. thanks again. wang On 6/6/07, Tom Briggs <[EMAIL PROTECTED]> wrote: Why not just use PRAGMA temp_store_directory, as the comments directly above that line suggest? > -Original Message- > F

Re: [sqlite] Re: progress_handler: progress in percentage?

thanks igor. i will find other ways to achieve the similar. On 6/6/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: weiyang wang wrote: > i am looking into the sqlite3_progress_handler() and i am wondering > the possiblity of representing progress in percentage. It's practicall

Re: [sqlite] sqlite3_temp_directory in main.c

l Message- > From: weiyang wang [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 06, 2007 11:17 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite3_temp_directory in main.c > > the concern here is to configure the default temp directory in library > compile

Re: [sqlite] PRAGMA cache_size = 0

the smallest cache_size is 512k, i guess. On 6/11/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote: What happens if I set the cache_size to 0? Will I be able to do any of update/delete/insert/select operations? When I set the cache_size to 0, is there any freeing up of memory by sqlite?

Re: [sqlite] PRAGMA cache_size = 0

correct my former message, the smallest is 10, (10 pages in ram) On 6/11/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote: What happens if I set the cache_size to 0? Will I be able to do any of update/delete/insert/select operations? When I set the cache_size to 0, is there any freeing up of

[sqlite] sqlite_omit_xx build failure

hi, i am trying to get a smaller sqlite lib by adding sqlite_omit_xx defines. but it failed at the compiler time. steps: 1, in 'Makefile.in', omit macro is added: TCC += -DSQLITE_OMIT_ALTERTABLE=1 2, run '(top)/configure' and 'make' in cygwin, 3, i got the fowllowing error:

Re: [sqlite] Re: sqlite_omit_xx build failure

wrote: "weiyang wang" <[EMAIL PROTECTED]> wrote: > hi, > > i am trying to get a smaller sqlite lib by adding sqlite_omit_xx defines. > but it failed at the compiler time. > > steps: > 1, in 'Makefile.in <http://makefile.in/>', omit macro is added: > &g

Re: [sqlite] Re: sqlite_omit_xx build failure

thanks. that is correct. i have just found this issue 5 mins ago. i am re-doing the compiling now. and . it works. thanks. have a nice day wang On 6/12/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: On Tue, 2007-06-12 at 09:56 +0200, weiyang wang wrote: > Hi Dr.H, > Yes, I

[sqlite] [bug]DSQLITE_OMIT_DISKIO link failure

Hi, With checking the source code build, i could see DSQLITE_OMIT_DISKIO does not work properly. the problem is that symbols, which are related to DSQLITE_OMIT_DISKIO in btree.c and attach.c, are not properly tied to DSQLITE_OMIT_DISKIO. so caused linker errors. best regards, wang

[sqlite] journal-off assert

hi, i am trying to integrate sqlite into mobile platform, and porting layer, like 'win_os.c' , have been created for that purpose. the integrated sqlite works well on our mobile platform with the default settings, but error come out when i try to tune the performance with 'pragma cache_size =

Re: [sqlite] journal-off assert

rlying file system and not of SQLite... best Martin - Ursprüngliche Mail Von: weiyang wang <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Gesendet: Donnerstag, den 24. August 2006, 09:52:37 Uhr Betreff: [sqlite] journal-off assert hi, i am trying to integrate sqlite into mob

[sqlite] memory footprint and leakage

hi, i am evaluating sqlite performance for mobile platform now. i found something discussable about memory footprint and leakage. the highest water line of memeory usage is 44611bytes (by malloc() ), and there seems a large memory leakage (34017bytes) in my testing scenario. 'cache_size' is

[sqlite] memory footprint and leakage_2

hi, i realized i missed some codes in sqlite3GenericRealloc() for the calculating. after modifying my codes, the testing results are: the highest water mark of memory usage is 16684 bytes, and 0 memory leakage. the same configuratiions as described in the early. 16684bytes, is it the right