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 ;)

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 si.for...@gmail.com wrote: I already have, they told me to go away... luuk34 wrote: On 16-11-2011 10:02, si666 wrote: I have a sqlite

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

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

[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] 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

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, ...) Until

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] 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 only

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:

[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

[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 t1

[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 broken

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 the

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 filesystem.

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

[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] disk I/O error

On Thu, Nov 17, 2011 at 3:04 PM, Tal Tabakman tal.tabak...@gmail.comwrote: 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 error

[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] 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 zeros. * of

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, not

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

On Thu, Nov 17, 2011 at 5:23 PM, Simon Slavin slav...@bigfraud.org 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 not

[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] 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 sql

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