Re: [sqlite] Compressed dump SQLite3 database

Hello! В сообщении от Monday 19 January 2009 20:22:33 [email protected] написал(а): > It is a requirement that the size of those copies being as small as > possible, without having to perform an external compression. You can using internal data compression. By compressing a few big fields you ca

Re: [sqlite] Compressed dump SQLite3 database

Hello, thank you and others for your answers. We are not allowed to use external libraries, because of industrial certification constraints. We can use SQLite because we can not do without database, but it's a big stuff to validate it according to those constraints, so we have to reduce as much as

Re: [sqlite] Compressed dump SQLite3 database

Hello! В сообщении от Tuesday 20 January 2009 12:24:41 [email protected] написал(а): > For now we are just wondering how to use SQlite facilities, and if it's > not sufficient, maybe we would think of the opportunity to developp a tiny > compression algorithm by ourselves, or not... There is no re

[sqlite] SQLite JDBC driver performance

[Apologies for posting this here, but the sqlitejdbc list appears to be defunct.] Hello. I'm noticing fairly severe performance difference between running a complex query from the sqlite 3.6.7 command line and from within the sqlite jdbc driver version 0.54 available at [1]. Sqlite command li

Re: [sqlite] .dump and transactions

On Monday, 12. January 2009 14:20:40 Thomas Jarosch wrote: > If an open transaction would block the dump of the database, > then the second command line tool should busy wait until a timeout occurs > or atleast return an error message. I finally tracked this down by testing sqlite 3.6.10 on my wor

Re: [sqlite] Recover deleted records

Hi Alex I can't answer your specific questions, but I presume you've already studied the file format document (most recently mentioned by Roger Binn's recent post): http://www.sqlite.org/fileformat.html ___ sqlite-users mailing list sqlite-users@s

[sqlite] About Sqlite cache metch times and read() call times

Hi all, I add some debug information in sqlite3.c, and test Sqlite cache metch times, unmetch times and read() called times in Linux, I found that page unmetch times in cache is bigger than read() called times. Then I found in Btree.c getAndInitPage() function called sqlite3PageLookup,

Re: [sqlite] Compressed dump SQLite3 database

A compression program like gzip is not a l"library", it is a free standing, open source program. It has no secrets. [email protected] wrote: > Hello, thank you and others for your answers. > > We are not allowed to use external libraries, because of industrial > certification constraints. We can

Re: [sqlite] segmentation violation in fulltest on Mac OS X

Am 19.01.2009 um 18:42 schrieb D. Richard Hipp: > > On Jan 19, 2009, at 3:50 AM, Jens Miltner wrote: > >> Hello, >> >> I just upgraded to sqlite 3.6.10 and keep getting a segmentation >> violation when running the full tests on Mac OS X: >> The last test completed is consistently thread001.1.3. >

Re: [sqlite] 'UPDATE shop_orders SET comments=comments||? WHERE oid=?', ('test', '1')

if comments is null then comments||? is also null, try this: comments=coalesce(comments,'')||? -Original Message- From: [email protected] [mailto:[email protected]] On Behalf Of Gert Cuykens Sent: Sunday, January 18, 2009 10:15 AM To: [email protected]

Re: [sqlite] Recover deleted records

Griggs, Donald wrote: > Hi Alex > > I can't answer your specific questions, but I presume you've already > studied the file format document (most recently mentioned by Roger > Binn's recent post): > > http://www.sqlite.org/fileformat.html > Yes I did read through that, but I didn't see what

Re: [sqlite] Recover deleted records

On 21/01/2009 7:03 AM, Alex Mandel wrote: > Griggs, Donald wrote: >> Hi Alex >> >> I can't answer your specific questions, but I presume you've already >> studied the file format document (most recently mentioned by Roger >> Binn's recent post): >> >> http://www.sqlite.org/fileformat.html >> >

[sqlite] How to port sqlite to uc/os

Hi all: I want to port sqlite to uc/os without FS supporting. Is it extremely difficult? Can someone do me a favor? Tks. ___ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Performance tools?

I have some complex queries that take a long time. Is there a tool that can tell me which steps in the query are taking the longest? I'm thinking of output similar to the EXPLAIN or EXPLAIN QUERY PLAN that would annotate the tables/indices/VM instructions with how long that portion of the que