Re: [sqlite] Hashing 2 SQLite db files with the same data

Hi again peeps, thanks for all your help. Seems there are many variables that could restrict doing this reliably. As several of you have mentioned, I should really rethink my design before this simple idea becomes far more complex than it needs to be. Cheers, David.

Re: [sqlite] Hashing 2 SQLite db files with the same data

But if data was added exactly in the same way/order shouldn't the counters all count to the same end result if the process was repeated at a later time on a another machine? Maybe, maybe not. Since the file format specifies meaningful fields only (my guess) it's quite possible that the

Re: [sqlite] Hashing 2 SQLite db files with the same data

On Tue, Apr 3, 2012 at 8:27 PM, Webdude wrote: > But if data was added exactly in the same way/order shouldn't the counters > all count to the same end result if the process was repeated at a later time > on a another machine? Well, why not... try it? :)

Re: [sqlite] Hashing 2 SQLite db files with the same data

Hi Jay, thanks for your help, / > Does anyone know if SQLite stores additional unique internal />/ > information such as timestamps etc. that would affect this, and />/ > if so could these "additional to the data" variable features be />/ > disabled in any way? // />/ SQLite files

Re: [sqlite] Hashing 2 SQLite db files with the same data

On 4 Apr 2012, at 2:15am, Webdude wrote: > But the same SQLite version, using the same schema, setup with the same > PRAGMA's, creating a db with the same data and in the same order, and despite > hardware / HDD / OS, should still produce the same file byte-for byte ?

Re: [sqlite] Hashing 2 SQLite db files with the same data

Hi Jean-Christophe thanks for your help. > Instead of trying to compare the hashes of DB files themselves, you > appear to want a strict comparison of sets in the contents of the DBs. No, I physically need the end resulting file to hash to the same value. The file becomes a new identity in

Re: [sqlite] Downgrade support for OS/2?

Well. I know some banks and some transportation systems still use OS/2. Do they use sqlite? If yes, I'm sure their apps are stable, meaning their sqlite implementation is stable. Does sqlite need to continue for OS/2? Most likely not. Death of a friend. I always liked OS/2. It's still

[sqlite] Problem compiling Tcl bindings on Win

I thought it might be nice to be able to keep my Tcl bindings for SQLite up to date, so I downloaded the autoconf tarball on both my linux and Win (Vista) machines. Not surprisingly, the compile went fine on linux. On Windows I also downloaded and installed MSYS / MINGW. I got into the tea

Re: [sqlite] how to use c binding and write output in c

YAN HONG YE wrote: > Richard Hipp wrote: > >> On Sun, Apr 1, 2012 at 11:21 PM, Roy Tam wrote: > >> 2012/4/2 YAN HONG YE : >> > when I run this following code , the html file encoding changed to >> GB2312,not utf-8, I

Re: [sqlite] Consistency check in big databases results out of memory error.

On Tue, Apr 3, 2012 at 1:52 PM, Kari Hoijarvi wrote: > Thanks a lot, I'll keep my eye on it. > The patch is in. http://www.sqlite.org/src/info/fa3a498dfe > > Kari > > > > On 4/3/2012 12:25 PM, Richard Hipp wrote: > >> On Tue, Apr 3, 2012 at 1:05 PM, Kari >>

Re: [sqlite] Consistency check in big databases results out of memory error.

Thanks a lot, I'll keep my eye on it. Kari On 4/3/2012 12:25 PM, Richard Hipp wrote: On Tue, Apr 3, 2012 at 1:05 PM, Kari Hoijarviwrote: Hello, running PRAGMA integrity_check from command line works for a 300 GB database, but I seem to have hit some kind of limit

Re: [sqlite] Downgrade support for OS/2?

On 03.04.2012 19:38 Richard Hipp said the following: We propose to remove the VFS module for OS/2 from the SQLite amalgamation in the next release, reducing the size of the amalgamation source file by 1924 lines (or about 1.4%). If this change will cause you any serious hardship, please speak

[sqlite] Downgrade support for OS/2?

We propose to remove the VFS module for OS/2 from the SQLite amalgamation in the next release, reducing the size of the amalgamation source file by 1924 lines (or about 1.4%). If this change will cause you any serious hardship, please speak up and we will reconsider. -- D. Richard Hipp

Re: [sqlite] Consistency check in big databases results out of memory error.

On Tue, Apr 3, 2012 at 1:05 PM, Kari Hoijarvi wrote: > Hello, > > running PRAGMA integrity_check from command line works for a 300 GB > database, but I seem to have hit some kind of limit with 832 GB sqlite DB. > > I running on Windows server 2008 R2 standard (64bit of

[sqlite] Consistency check in big databases results out of memory error.

Hello, running PRAGMA integrity_check from command line works for a 300 GB database, but I seem to have hit some kind of limit with 832 GB sqlite DB. I running on Windows server 2008 R2 standard (64bit of course). Is this a Windows or sqlite problem? Any good ideas for workarounds? Kari

Re: [sqlite] Foreign Key Problems

On 3 Apr 2012, at 5:38pm, Dan Kennedy wrote: > On 04/03/2012 11:18 PM, Pete wrote: >> I am running OS X 10.6.8 and sqlite3 comes with the OS. Does anyone know >> where I can get a version of sqlite3 for OS X that does support foreign >> keys? It would have to be a

Re: [sqlite] Foreign Key Problems

On 04/03/2012 11:18 PM, Pete wrote: Thanks you SImon. I see this is because the version of sqlite3 I have does not support foreign keys. I am running OS X 10.6.8 and sqlite3 comes with the OS. Does anyone know where I can get a version of sqlite3 for OS X that does support foreign keys? It

Re: [sqlite] Foreign Key Problems

Thanks you SImon. I see this is because the version of sqlite3 I have does not support foreign keys. I am running OS X 10.6.8 and sqlite3 comes with the OS. Does anyone know where I can get a version of sqlite3 for OS X that does support foreign keys? It would have to be a compiled binary

Re: [sqlite] Hashing 2 SQLite db files with the same data

On Tue, Apr 03, 2012 at 01:22:02AM +0100, Simon Slavin scratched on the wall: > On 3 Apr 2012, at 12:27am, Webdude wrote: > > Does anyone know if SQLite stores additional unique internal > > information such as timestamps etc. that would affect this, and > > if so could

Re: [sqlite] problem with 3.7.11 cmdline shell

On Tue, Apr 3, 2012 at 6:36 AM, Han Rougoor wrote: > problem: reserved words not quoted in dump output > version: 3.7.11 > file: shell.c > line: 1308 > example: > Already fixed at http://www.sqlite.org/src/info/638b711502 but thanks for the report all the same. > >

[sqlite] problem with 3.7.11 cmdline shell

problem: reserved words not quoted in dump output version: 3.7.11 file: shell.c line: 1308 example: create table "group" as select 1; .dump outputs: PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE "group"("1"); INSERT INTO group VALUES(1); COMMIT;

[sqlite] Compiling warnings in SQLite v3.7.11

Hi, I would like to report two compiler warnings when compiling v3.7.11 with Embedded Visaul C++ 4.0 for Windows Mobile devices: - sqlite3.c, line 68356, code "u.bb.r.flags = (u16)(UNPACKED_INCRKEY * (1 & (u.bb.oc - OP_SeekLt)));" causes compiler warning "warning C4244: '=' : conversion from

[sqlite] Simultaneous opening of database sometimes fails even with 1 second timeout and only 2 processes

Hello, I am experiancing a weird problem: sometimes (1 time in a 10-100) when 2 processes try to open the same database file (and execute something like 'create table foo if not exists'), one of them fails with SQLITE_BUSY — despite 1 second (or bigger) timeout. Processes themselves produce

Re: [sqlite] Hashing 2 SQLite db files with the same data

Database files are purportedly platform independent. So why don't you distribute the database file instead of building it? Then your checksum would be fine. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman

Re: [sqlite] Simultaneous opening of database sometimes fails even with 1 second timeout and only 2 processes

On Tue, Apr 3, 2012 at 3:53 PM, Simon Slavin wrote: > > On 3 Apr 2012, at 9:53am, Dan Kennedy wrote: > >> As Jay says, deadlock is not possible for implicit transactions. >> SQLite will keep retrying until either your busy-handler returns >> zero (if

Re: [sqlite] Simultaneous opening of database sometimes fails even with 1 second timeout and only 2 processes

On 3 Apr 2012, at 9:53am, Dan Kennedy wrote: > As Jay says, deadlock is not possible for implicit transactions. > SQLite will keep retrying until either your busy-handler returns > zero (if you configured a busy-handler) or the timeout is reached > (if you configured a

[sqlite] We have a snake in paradise

We have a snake in paradise. Pls Administrator, remove the OP of this message. We cannot afford this kind of distractions from SQLite or distortion of what SQLite is. TIA -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Darko

Re: [sqlite] Simultaneous opening of database sometimes fails even with 1 second timeout and only 2 processes

On 04/03/2012 04:20 PM, Gregory Petrosyan wrote: On Tue, Apr 3, 2012 at 12:53 PM, Dan Kennedy wrote: As a side note: why does not SQLite automatically retry implicit transactions after invoking busy handler? It's a race. That's what SQLITE_BUSY means. As Jay says,

Re: [sqlite] Simultaneous opening of database sometimes fails even with 1 second timeout and only 2 processes

On Tue, Apr 3, 2012 at 12:53 PM, Dan Kennedy wrote: >> As a side note: why does not SQLite automatically retry implicit >> transactions after invoking busy handler? > > It's a race. That's what SQLITE_BUSY means. > > As Jay says, deadlock is not possible for implicit

Re: [sqlite] Simultaneous opening of database sometimes fails even with 1 second timeout and only 2 processes

On 04/03/2012 12:48 PM, Gregory Petrosyan wrote: On Mon, Apr 2, 2012 at 7:51 PM, Jay A. Kreibich wrote: On Mon, Apr 02, 2012 at 07:40:58PM +0400, Gregory Petrosyan scratched on the wall: Hello, I am experiancing a weird problem: sometimes (1 time in a 10-100) when 2

[sqlite] how to use c binding and write output in c

Date: Mon, 2 Apr 2012 00:37:18 -0400 From: Richard Hipp wrote: On Sun, Apr 1, 2012 at 11:21 PM, Roy Tam wrote: > 2012/4/2 YAN HONG YE : > > when I run this following code , the html file encoding changed to > GB2312,not utf-8, I don't