[sqlite] Final preparations for the release of System.Data.SQLite v1.0.83.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this Saturday, December 15th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] How to verify referential integrity of SQLite database

On 12 Dec 2012, at 9:30pm, "Levi Haskell (BLOOMBERG/ 731 LEXIN)" wrote: > I see your point but another way to look at it is that PRAGMA > foreign_keys=0/1 changes the definition of what constitutes a > legal/consistent state of the database, thus it makes sense that

Re: [sqlite] How to verify referential integrity of SQLite database

A way to verify the constraint integrety would be great. Some thoughts: - Introduce a boolean 'all_foreign_key_constraits_are_known_valid' (default false) that is stored in the database header - A new PRAGMA foreign_key_check checks the foreign key constraints - If it finds invalid constraints

Re: [sqlite] integrity_check runs out of memory for a not-big-at-all database

Thanks very much for your prompt reply! Cheers, -p On 12 December 2012 22:31, Richard Hipp wrote: > Bug fix here: http://www.sqlite.org/src/info/120c82d56e > > This fix will appear in SQLite version 3.7.16, sometime next year. >

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 04:28:21PM -0500, Richard Hipp scratched on the wall: > On Wed, Dec 12, 2012 at 4:18 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) < > lhask...@bloomberg.net> wrote: > > Intresting, doesn't sqlite3FkCheck() already take these into account? > > > > Yes, it does. But not every

Re: [sqlite] How to verify referential integrity of SQLite database

Agreed. I originally thought your complexity argument was against implementing it inside SQLite. - Levi - Original Message - From: d...@sqlite.org To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org At: Dec 12 2012 16:28:43 On Wed, Dec 12, 2012 at 4:18 PM, Levi

Re: [sqlite] How to verify referential integrity of SQLite database

Jos, I see your point but another way to look at it is that PRAGMA foreign_keys=0/1 changes the definition of what constitutes a legal/consistent state of the database, thus it makes sense that behavior of check_integrity PRAGMA would change accordingly. Thanks, - Levi - Original

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 4:18 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) < lhask...@bloomberg.net> wrote: > On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp wrote: > >On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp wrote: > >> On Wed, Dec 12, 2012 at 2:29 PM, Levi

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp wrote: >On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp wrote: >> On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) < >> lhask...@bloomberg.net> wrote: >> >>> My suggestion would be to have

Re: [sqlite] How to verify referential integrity of SQLite database

> This seems like a reasonable request. And while we are at > it, we will likely also verify UNIQUE and CHECK constraints too. > > PRAGMA quick_check is still available for users who do not > want to take the extra overhead of verifying UNIQUE, CHECK, > and foreign key constraints. > > Does

Re: [sqlite] How to verify referential integrity of SQLite database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/12/12 12:36, Richard Hipp wrote: > Does anybody know of any reason why we should not do this? I would love if this was combined with an optional per page checksum that detects corruption early. Roger -BEGIN PGP SIGNATURE- Version:

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp wrote: > On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) < > lhask...@bloomberg.net> wrote: > >> My suggestion would be to have check_integrity command verify referential >> integrity as well only if it's

Re: [sqlite] How to verify referential integrity of SQLite database

On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) < lhask...@bloomberg.net> wrote: > My suggestion would be to have check_integrity command verify referential > integrity as well only if it's executed while the foreign key enforcement > is enabled on the connection. > This

Re: [sqlite] How to verify referential integrity of SQLite database

On 12 Dec 2012, at 7:29pm, Levi Haskell (BLOOMBERG/ 731 LEXIN) wrote: > In a couple of cases due to minor bugs in an upgrade script and the fact > foreign keys are not enforced during their operation the database was left in > an inconsistent state with regards to the

[sqlite] How to verify referential integrity of SQLite database

Hello, We have an application that relies heavily on SQLite foreign key feature to ensure referential integrity of our database. Naturally we always enable foreign key enforcement immediately after connecting. However periodically, when we roll out new software (we have well over 300K

Re: [sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT?

Jay A. Kreibich, Thank you for the discussion about the SQLITE difference between DISTINCT and UNIQUE. -- Message: 14 Date: Wed, 12 Dec 2012 10:15:34 -0600 From: "Jay A. Kreibich" To: General Discussion of SQLite Database

Re: [sqlite] JDBC Drivers for SQLite?

http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Check out Google for more. On 12/12/2012 8:54 AM, Tilsley, Jerry M. wrote: All, Might be a silly question, but does anyone know if any JDBC drivers exist for SQLite? Thanks, Jerry

[sqlite] JDBC Drivers for SQLite?

All, Might be a silly question, but does anyone know if any JDBC drivers exist for SQLite? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are

[sqlite] FTS4 extension: problem with field-specified search

Doesn't work search by field name like to "test test": sqlite> CREATE VIRTUAL TABLE test_fts USING fts4("test test"); sqlite> insert into test_fts values ('test'); sqlite> select * from test_fts where test_fts match '"test test":test'; sqlite> select * from test_fts where test_fts match 'test';

Re: [sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT?

On Wed, Dec 12, 2012 at 06:26:54AM -0800, Frank Chang scratched on the wall: > Hello, In the latest version of SQLite, is there any subtle distinction > between UNIQUE and DISTINCT? If there exists a subtle distinction between > UNQUE and DISTINCT in Sqlite, what is the appropriate Insert or

Re: [sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT?

On 12 Dec 2012, at 2:26pm, Frank Chang wrote: > Hello, In the latest version of SQLite, is there any subtle distinction > between UNIQUE and DISTINCT? If there exists a subtle distinction between > UNQUE and DISTINCT in Sqlite, what is the appropriate Insert or replace

Re: [sqlite] SQLite :Is there any subtle distinction between UNIQUE andDISTINCT?

Frank Chang wrote: > Hello, In the latest version of SQLite, is there any subtle distinction > between UNIQUE and DISTINCT? There is very little in common between UNIQUE and DISTINCT. I'm not sure I understand the question. What problem are you trying to solve, that led

Re: [sqlite] integrity_check runs out of memory for a not-big-at-all database

Bug fix here: http://www.sqlite.org/src/info/120c82d56e This fix will appear in SQLite version 3.7.16, sometime next year. On Tue, Dec 11, 2012 at 7:10 PM, Phil Schwan wrote: > Using sqlite 3.7.14.1 2012-10-04 19:37:12 > 091570e46d04e84b67228e0bdbcd6e1fb60c6bdb on a 16 GB

[sqlite] SQLite :Is there any subtle distinction between UNIQUE and DISTINCT?

Hello, In the latest version of SQLite, is there any subtle distinction between UNIQUE and DISTINCT? If there exists a subtle distinction between UNQUE and DISTINCT in Sqlite, what is the appropriate Insert or replace syntax, CREATE INDEX usage, and the SELECT statements? Thank you.

Re: [sqlite] sqlite3_wal_checkpoint

On Sun, Aug 21, 2011 at 8:35 AM, janet watson wrote: > Hi I receive this message box when I turn on my laptop.. it says there > is an error... how do I get this to stop.does this have any connection > to my Iphone? what is it connected to if not that? I hope you

[sqlite] integrity_check runs out of memory for a not-big-at-all database

Using sqlite 3.7.14.1 2012-10-04 19:37:12 091570e46d04e84b67228e0bdbcd6e1fb60c6bdb on a 16 GB Linux-64 desktop. I'm having a problem that bears a passing similarity to http://osdir.com/ml/sqlite-users/2012-04/msg00094.html But unlike that user, my database is only 15 MB. If I run

[sqlite] SQLite R*Tree Module documentation error

The latitude range for the first insert statement in section 3.2 of the SQLite R*Tree Module documentation doesn't work with the query statements in section 3.3. Presumably you meant to use 35.3776 and 35.3778 instead of 30.3776 and 30.3778? Ed

Re: [sqlite] table backup

I am using SQLite version 3.7.14.1. On Wed, Dec 12, 2012 at 2:56 PM, dd wrote: > Hi Michael > > I am using journal mode truncate. Explicitly, I am not running any pragma > for synchronous. (i think, it's default value is 2 - Full). > > Regards, > d > > > On Tue, Dec 11,

Re: [sqlite] table backup

Hi Michael I am using journal mode truncate. Explicitly, I am not running any pragma for synchronous. (i think, it's default value is 2 - Full). Regards, d On Tue, Dec 11, 2012 at 5:08 PM, Michael Black wrote: > I don't see in the thread where you say what journal mode

[sqlite] ANN: SQLiteManager 4 - Working with sqlite databases will never be the same!

Hello, we are extremely proud to announce a major release for our SQLiteManager application (available for both MacOS X and Windows). SQLiteManager is a powerful database management system for sqlite databases, it combines an easy to use interface with blazing speed and advanced features.