Re: [sqlite] Viewer for blobs in hex?

2009-10-05 Thread Yan Bertrand
Hi all, And thanks for the suggestions. As a conclusion, I wanted to take a minute to mention that I have tried all that you suggested. My choice is to use SQliteSpy because it actually displays blobs in hex right away without having to double-clic on each record, and it is free. -

[sqlite] Viewer for blobs in hex?

2009-09-21 Thread Yan Bertrand
Hi all, I would like to display the contents of blobs in my table as hexadecimal. I have not found any easy way of doing this. I tried : - wxSQLitePlus, but it does not display blobs contents (or I could not make it do so) - SQLiteManager plugin (for Mozilla

[sqlite] Robustness proposal for sqlite3_clear_bindings()

2009-08-07 Thread Yan Bertrand
Hello all, I have just come accross a bug - which is essentially and most likely a bug in my program but results in a segfault in sqlite3 code. So I thought I would suggest a robustness change (not to correct my bug, but for other people not to see a segfault in the same

Re: [sqlite] Do people think of SQLite as a file or as a database

2009-07-16 Thread Yan Bertrand
Same here. For me the fact that it manages quick access to data through indexes - and uses SQL query language - makes it a database of its own right and merits. -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Michal Seliga

Re: [sqlite] SQLITE_OMIT_AUTOVACUUM seems to need small change inbtree.c

2009-07-09 Thread Yan Bertrand
On Wed, Jul 8, 2009 at 4:06 AM, Yan Bertrand<yan.bertr...@polestar.eu> wrote: >                Hello, > > > > I am compiling SQLite with options to reduce the size, and with hopes to > reduce the duration of some operations on portable devices. This > include

[sqlite] SQLITE_OMIT_AUTOVACUUM seems to need small change in btree.c

2009-07-08 Thread Yan Bertrand
Hello, I am compiling SQLite with options to reduce the size, and with hopes to reduce the duration of some operations on portable devices. This includes the use of the compilation switch SQLITE_OMIT_AUTOVACUUM. I noticed that btree.c will not compile withmy current