Re: [sqlite] Suppression of SQL Command when routing Output to File

Roger,     hadn't considered that. I was using .echo on, to see the contents of the tmp.txt file on the screen. Under v3.3.6 it showed me everything on screen INCLUDING the sql command being used, and the file simply contained the results. Now the current release shows me the contents of the

Re: [sqlite] Suppression of SQL Command when routing Output to File

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/11/11 20:00, Richard Timms wrote: > .echo on [...] > Now I get that, plus the actual sql statement itself. How do I suppress > the sql statement from appearing on the file? I don't understand your question. You turned echo on so you get the

[sqlite] Suppression of SQL Command when routing Output to File

All,     just upgraded from v.3.3.6 to current (a big jump), and found that a file that previously worked one way now works another. At the sqlite command prompt I type .read tmp.txt the contents of tmp.txt are as follows .echo on .separator '    ' .headers on .output sbs2011-11-17.txt select

Re: [sqlite] numbers in nvarchar fields (text? affinity)

On Thu, Nov 17, 2011 at 5:23 PM, Simon Slavin wrote: > > On 17 Nov 2011, at 9:44pm, Francis J. Monari, Esquire wrote: > > > * of those file identifiers having leading zeros, some leading zeros are > > being stripped off (handled like integers), and some leading zeros are >

Re: [sqlite] numbers in nvarchar fields (text? affinity)

On 17 Nov 2011, at 9:44pm, Francis J. Monari, Esquire wrote: > * of those file identifiers having leading zeros, some leading zeros are > being stripped off (handled like integers), and some leading zeros are > not (handled like text). Check to see that the affinity for that column is string,

Re: [sqlite] numbers in nvarchar fields (text? affinity)

On Thu, Nov 17, 2011 at 4:44 PM, Francis J. Monari, Esquire < monarifj@juno.com> wrote: > list, > > I experienced the following situation: > * field holding a file identifier (currently only numbers). > * the field type is nvarchar (text? affinity). > * some file identifiers have leading

[sqlite] numbers in nvarchar fields (text? affinity)

list, I experienced the following situation: * field holding a file identifier (currently only numbers). * the field type is nvarchar (text? affinity). * some file identifiers have leading zeros. * of those file identifiers having leading zeros, some leading zeros are being stripped off (handled

Re: [sqlite] disk I/O error

On Thu, Nov 17, 2011 at 3:04 PM, Tal Tabakman wrote: > Hi Guys, > in which cases can I get sqlite3 error "disk I/O error", is it only when > disk is full ? > any other reasons for getting this one ? > Lots of reasons. Use sqlite3_extended_errcode() to get a more detailed

[sqlite] disk I/O error

Hi Guys, in which cases can I get sqlite3 error "disk I/O error", is it only when disk is full ? any other reasons for getting this one ? cheers Tal ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Release 3.7.8 CREATE INDEX slower

On 11/17/2011 03:22 AM, Faught, Bill wrote: I have a table of 3M rows. I add all the rows to the table, then call CREATE INDEX. Release 3.7.8 is about 40% slower than the previous release doing the CREATE INDEX. Has anyone else experienced this? 3.7.8 builds indexes differently. It uses a

Re: [sqlite] sqlite database file over NFS

On 16 Nov 2011, at 6:10pm, Thierry wrote: > I plan to use a sqlite3 database over NFS: 2 clients use a shared Sqlite3 > database file. > > But sqlite FAQ alert about this use: "But use caution: this locking > mechanism might not work correctly if the database file is kept on an NFS >

Re: [sqlite] Release 3.7.8 CREATE INDEX slower

On 16 Nov 2011, at 8:22pm, Faught, Bill wrote: > I have a table of 3M rows. I add all the rows to the table, then call > CREATE INDEX. > > Release 3.7.8 is about 40% slower than the previous release doing the > CREATE INDEX. > > Has anyone else experienced this? Do you still have a copy of

[sqlite] sqlite database file over NFS

Hi, I plan to use a sqlite3 database over NFS: 2 clients use a shared Sqlite3 database file. But sqlite FAQ alert about this use: "But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is

[sqlite] Trivial documentation bug in eqp.html

Hi, The following text appears in section 1.1 of eqp.html: > For example, the following EXPLAIN QUERY PLAN command operates on a SELECT > statement that is implemented by performing a full-table scan on table t1: > > sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1; > 0|0|0|SCAN TABLE

[sqlite] Release 3.7.8 CREATE INDEX slower

I have a table of 3M rows. I add all the rows to the table, then call CREATE INDEX. Release 3.7.8 is about 40% slower than the previous release doing the CREATE INDEX. Has anyone else experienced this? ___ The contents of this e-mail

Re: [sqlite] Export Blob data from sqlite database to html

Is there some reason you can't just write your own code? You coulda' had it done by now. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From:

Re: [sqlite] Export Blob data from sqlite database to html

On 17 Nov 2011, at 2:26pm, si666 wrote: > I was wondering if there's a sql query i could run on the whole database > which would look at the value in the type field and then handle the data > field as either ascii or an image? There is no way to handle an image in SQL. The language handles

Re: [sqlite] Export Blob data from sqlite database to html

Thanks for the reply Pris; I have already tried a number of sqlite browsers without success. Using them I can export the tables but when I open the resulting html or csv they interpret the hex of the time stamps and jpegs as ascii which chucks out jiberish. I was wondering if there's a sql

Re: [sqlite] SQLITE3 Runs out of memory.

Loop for 61153 records start rowIndex at 0 sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB Where id = rowIndex") sqlite3_step() sqlite3_finialize() End Make that sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB") Do sqlite3_step() // handle errors somehow (busy, ...)

Re: [sqlite] SQLITE3 Runs out of memory.

That's obviously not your real code...would be nice to see that as your problem may elsewhere. But... #1 How much memory does your embedded device have AVAILABLE? #2 Try reducing the cache_size (if #1 is less than 10's of megabytes) -- default cache_size is 1MB which is right around

[sqlite] SQLITE3 Runs out of memory.

Hi, Before I start diving into the sqlite3 code, I was wondering if anyone had this sort of problem before and could possibly point out to me where I might find the problem. I am running 3.7.9 on a embedded project using a database with one table (structured (integer id, blobdata BLOB). Now

Re: [sqlite] Export Blob data from sqlite database to html

I'd agree with the SQLite Expert option (Windows)...it ships, or at least used to ship with sample data that presents a scenario like you're describing (ie, jpeg and text as BLOB), plus it allows visual assists, such as BLOB masking over a certain size of data in a column. Otherwise, you'd need

Re: [sqlite] Export Blob data from sqlite database to html

At 10:02 16/11/2011, you wrote: Basically my problem is exporting the database so the time stamps appear in hex the data blobs appear in either text (ascii) or as a jpeg image depending on the data in type field. I have tried numerous sqlite browsers without success. Looks like a job for

Re: [sqlite] Export Blob data from sqlite database to html

Maybe you can use a tool like sqlitebrowser to open up the database, then export tables you want to csv? Pris On Thu, Nov 17, 2011 at 3:10 AM, si666 wrote: > > I already have, they told me to go away... > > > luuk34 wrote: > > > > On 16-11-2011 10:02, si666 wrote: > >> I

Re: [sqlite] Export Blob data from sqlite database to html

I already have, they told me to go away... luuk34 wrote: > > On 16-11-2011 10:02, si666 wrote: >> I have a sqlite database from a iphone chat app which I would like to >> present >> in a human readable format either csv, html or other. > > you should ask the author of that iphone app ;) >