[sqlite] how to show image

sqlite3_exec(db,"create table image (filename varchar(128) unique,img blob);",0,0,); and put image to my sqlite db: sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); I export the html use this command: sqlite3 -html film.db "select * from image;">my.html but I

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

> Running a single extractor on a VM runs near bare metal speeds. I can > run concurrent extractors up to the # of cores allocated to the VM and > sustain decent throughput. Once I go above this count the VM's get > crippled.. Pegged at 100% - Disk, RAM and LAN loads are miniscule. What

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

On 7 Jun 2012, at 12:59am, IQuant wrote: > Running a single extractor on a VM runs near bare metal speeds. I can > run concurrent extractors up to the # of cores allocated to the VM and > sustain decent throughput. Once I go above this count the VM's get > crippled..

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

Running a single extractor on a VM runs near bare metal speeds. I can run concurrent extractors up to the # of cores allocated to the VM and sustain decent throughput. Once I go above this count the VM's get crippled.. Pegged at 100% - Disk, RAM and LAN loads are miniscule. For a test we ran

Re: [sqlite] Displaying currently running SQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/06/12 09:27, Richard Hipp wrote: > .trace stdout > > That is a relatively recent addition so make sure your command-line > shell is up-to-date. Version 3.7.12.1. Or `.echo on' which has been in the shell for years :-) Roger -BEGIN PGP

[sqlite] [ANN] SQLiteAdmin Version 1.3.0 Released

I'm pleased to announce the availability of version 1.3.0 of SQLiteAdmin, an administration and data maintenance tool for SQLite databases. This update is free for existing customers. Version 1.3.0 includes the following enhancements: - Support for the creation and browsing of Full Text Search

Re: [sqlite] Displaying currently running SQL

On Wed, Jun 6, 2012 at 12:24 PM, Udi Karni wrote: > When pasting multiple SQL statements into the Shell - you can see them > running one by one. However - when you put them in a file and run them via > ".read" - the statements don't show on the screen. I have ".timer on" - so >

[sqlite] Displaying currently running SQL

When pasting multiple SQL statements into the Shell - you can see them running one by one. However - when you put them in a file and run them via ".read" - the statements don't show on the screen. I have ".timer on" - so all I see are the run times of each statement. Is there a "verbose" setting

Re: [sqlite] SQLite3.dll for OS x64

On Wed, Jun 6, 2012 at 8:33 AM, NOCaut wrote: > In the offical site i have not found dll for x64 OS. Where can I download > it? > > -- > Maybe try downloading the .ZIP archive for the appropriate .NET Framework (with "-static-binary-bundle-x64-" as part of its archive name -

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

On 06/06/2012 7:45 AM, Simon Slavin wrote: On 6 Jun 2012, at 12:00pm, IQuant wrote: We need to be able to run 1000's of extractors concurrently processing different tick tapes and symbol sets. aka service bureau. The Daily tick tapes are approx 20gb each.. 30TB repository

Re: [sqlite] Database Corruption - Table data being overwritten

That sounds like it might a corrupt index since the data doesn't show up in a dump. Does your select work if you drop the index? And have you done a "pragma integrity_check" ? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit

Re: [sqlite] Bug- Fail on diagram

On Tue, Jun 5, 2012 at 5:38 PM, Anony mouse wrote: > > Hello, > I'm using SQLite for android, i was reading and searching for a problem i > had with the multiple inserts. > > I was reading this official page (http://www.sqlite.org/lang_insert.html), > about the sintax

Re: [sqlite] Database Corruption - Table data being overwritten

On 6 Jun 2012, at 1:03pm, herb...@gdls.com wrote: > Even more bizarre, a .dump of "table1" will show: > INSERT INTO "table1" VALUES(28274, 6, 10308); > > But this query returns nothing: > SELECT * FROM table1 WHERE table1_id=28274; There should be (at least) two copies of that number in the

[sqlite] SQLite3.dll for OS x64

In the offical site i have not found dll for x64 OS. Where can I download it? -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite3-dll-for-OS-x64-tp62292.html Sent from the SQLite mailing list archive at Nabble.com. ___

[sqlite] Bug- Fail on diagram

Hello, I'm using SQLite for android, i was reading and searching for a problem i had with the multiple inserts. I was reading this official page (http://www.sqlite.org/lang_insert.html ), about the sintax on SQLite, there you say it's possible to put many rows on one insert, but when i search

Re: [sqlite] Views Optimization

Hi Richard, In fact, the real need is "common subexpression elimination". As you can see in attached email, we already had this discussion. To improve performances on SELECT in skrooge (see datamodel in test.sqlite), I created some tables (named vm_xxx) updated after each transaction through

[sqlite] Database Corruption - Table data being overwritten

Hello, I have run into a problem using SQLite in an embedded environment. Currently using version 3.7.5. (I know, I want to update, just have been locked in at this version for the time being) The power is routinely cut from the system, so I have JOURNAL_MODE = PERSIST because there were

Re: [sqlite] Database Corruption - Table data being overwritten

On Wed, Jun 6, 2012 at 8:03 AM, wrote: > Hello, > > I have run into a problem using SQLite in an embedded environment. > > Currently using version 3.7.5. (I know, I want to update, just have been > locked in at this version for the time being) > > The power is routinely cut

[sqlite] Database Corruption - Table data being overwritten

Hello, I have run into a problem using SQLite in an embedded environment. Currently using version 3.7.5. (I know, I want to update, just have been locked in at this version for the time being) The power is routinely cut from the system, so I have JOURNAL_MODE = PERSIST because there were

Re: [sqlite] Disk file size

On 6 Jun 2012, at 12:42pm, vallur raghava reddy wrote: > I have created a database "MyDb.db" and created a table MyTable using > the query *create table MyTable (id INTEGER PRIMARY KEY, value > CHARACTER(10))* and inserted 3000 records in the table.I executed

Re: [sqlite] Disk file size

Cleared space is not automatically reclaimed. You can run "vacuum" which wiill reclaim the space. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From:

Re: [sqlite] Disk file size

On Wed, Jun 6, 2012 at 7:42 AM, vallur raghava reddy wrote: > Hi, >     I have created a database "MyDb.db" and created a table MyTable using > the query *create table MyTable (id INTEGER PRIMARY KEY, value > CHARACTER(10))* and inserted 3000 records in the table.I

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

On 6 Jun 2012, at 12:00pm, IQuant wrote: > We need to be able to run 1000's of extractors concurrently processing > different tick tapes and symbol sets. aka service bureau. The Daily > tick tapes are approx 20gb each.. 30TB repository and growing. An > extraction run take

[sqlite] Disk file size

Hi, I have created a database "MyDb.db" and created a table MyTable using the query *create table MyTable (id INTEGER PRIMARY KEY, value CHARACTER(10))* and inserted 3000 records in the table.I executed query *select * from MyTable* it returned 3000 rows and was able to print all values. Now

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

No indexes... create db and table structure - process tick tapes inserting records - than create index. Windows 2008 R2 Servers ... We can throw hardware at this problem. We need to be able to run 1000's of extractors concurrently processing different tick tapes and symbol sets. aka service

Re: [sqlite] (no subject)

On Wed, Jun 6, 2012 at 1:08 AM, vallur raghava reddy < vallur.raghavare...@gmail.com> wrote: > Hi, > I have few queries regarding the SQLite. I have listed them below please go > through them and give your answers. Thanks > Say if I am working on a DB with 3 tables with 100 records each and each

[sqlite] how to show sqlite db image in html

sqlite3_exec(db,"create table image (filename varchar(128) unique,img blob);",0,0,); and put image to my sqlite db: sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); the problem is: how to show my image in the web? sqlite3 -html film.db "select * from film;">my.html is

Re: [sqlite] (no subject)

At 07:08 06/06/2012, you wrote: Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1.

Re: [sqlite] 100% CPU utilization sqlite running in VMWare

At 06:48 05/06/2012, you wrote: Have a market data extractor running tick tapes and saving data to sqlite db. All coded in C++ and previously ran fine and fast on bare metal. Processes tick tapes from NAS and saved to local sqlite db's on c drive. We moved program onto VMWare VM's... same nas