[sqlite] foreign_key_check mystery

On 2016/05/19 12:51 AM, James K. Lowden wrote: > On Wed, 18 May 2016 19:06:30 +0200 > R Smith wrote: > >>> I'm not convinced the requirement that the referenced columns be >>> unique is justified >> How do you see a parent-child relationship possible where the parent >> is not Unique? > I think

[sqlite] Sqlite incompatibility with Postgres

> Restriction is applied to the values of the tuple. The number of tuples is > not a value of the tuple. No, I can't agree. Restriction is a membership test, a function on members: should this tuple be included in the result set or not? Cardinality of a set is a second order function on the

[sqlite] INTEGRITY_CHECK consumes entire system memory

Hi, please check if this helps: http://serverfault.com/questions/325277/windows-server-2008-r2-metafile-ram-usage The provided script (setfc.ps1) did help for us and thus we implemented the suggested SetSystemFileCacheSize calls in our application. Regards, dg. -Original Message-

[sqlite] WITHOUT ROWID

Hello, I wonder if there are any drawbacks/things to be aware of, etc. for tables created "WITHOUT ROWID". I am considering using such tables in another project. Thanks. Regards, Ertan K???ko?lu

[sqlite] WITHOUT ROWID

On 5/19/16, Ertan K???ko?lu wrote: > Hello, > > I wonder if there are any drawbacks/things to be aware of, etc. for tables > created "WITHOUT ROWID". I am considering using such tables in another > project. Experiment. Run your application with WITHOUT ROWID and measure performance (where

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

This link is a presentation on 'we wish git had this' https://www.youtube.com/watch?v=ghtpJnrdgbo by DRH. This is the fossil page on the subject of comparing vs git. http://www.fossil-scm.org/xfer/doc/trunk/www/fossil-v-git.wiki That said, at my workplace we use git. How else can Windows

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

To add to Tony's comment... Where would you find that the developers and the actual owner of the software would answer questions to newbies? I remember when I started using this software, a complete newbie to SQLite, I asked a bunch of questions and some of them, the first to respond was Dr.

[sqlite] WITHOUT ROWID

On 2016/05/19 2:50 PM, Richard Hipp wrote: > On 5/19/16, Ertan K???ko?lu wrote: >> Hello, >> >> I wonder if there are any drawbacks/things to be aware of, etc. for tables >> created "WITHOUT ROWID". I am considering using such tables in another >> project. > Experiment. Run your application

[sqlite] Sqlite incompatibility with Postgres

On Thu, 19 May 2016 10:29:48 +1000 "dandl" wrote: > > Restriction is applied to the values of the tuple. The number of > > tuples is not a value of the tuple. > > No, I can't agree. Restriction is a membership test, a function on > members: should this tuple be included in the result set or

[sqlite] Sqlite incompatibility with Postgres

On 2016-05-19 9:17 PM, dandl wrote: > Every aggregation function is at least second order: a function that applies > a function to the set. So for MIN the function is 'less than', for SUM() the > function is 'plus' and so on. In Andl aggregation functions are provided by > fold(), which takes a

[sqlite] Using LSM and Memory Mapped files -- Question about LSM_CONFIG_MMAP

I am interested in using the LSM (https://www.sqlite.org/src4/doc/trunk/www/lsmusr.wiki) The characteristics of my application is that I would like to enable the memory-mapped file feature so that I can offload data in memory to disk temporarily.I don't care about data-recover after my