Re: [sqlite] Content filtered message notification

SQLite is a software library used by a wide variety of computer programs, including iTunes, Skype, Adobe Acrobat, Firefox, Chrome, Dropbox, and others. SQLite is not something that is "installed". It is a component part of those other programs. We have found that errors like the one you

Re: [sqlite] Index and GLOB

I believe the behavior is expected and believe (subject to correction) that the single composite index is placed on a concatenation of the three column values (basename + extension + path). I don't know how the internals of SQLite work never having explored the code, but in situations like

Re: [sqlite] Index and GLOB

Mike Goins wrote: > Using the latest binary, sqlite3-3.6.23.1.bin.gz > > sqlite> CREATE TABLE tb_file (tb_file_key INTEGER NOT NULL PRIMARY KEY > AUTOINCREMENT , basename TEXT, extension TEXT, path TEXT, deleted > INTEGER default 0 ); > sqlite> CREATE INDEX fullpath_idx on tb_file (basename,

Re: [sqlite] Index and GLOB

Tim Romano wrote: > I believe the behavior is expected and believe (subject to correction) that > the single composite index is placed on a concatenation of the three column > values (basename + extension + path). I don't know how the internals of > SQLite work never having explored the code,

Re: [sqlite] Index and GLOB

Right, Igor. We can eliminate the middle-column issue : ... where basename GLOB 'a'// no index ... where basename GLOB 'a*' // index used Regards Tim Romano On Sun, Apr 11, 2010 at 8:43 AM, Igor Tandetnik wrote: > Tim Romano wrote: > > I believe the behavior is

Re: [sqlite] Reduce database file size

Roger Binns writes: > On 04/10/2010 03:06 PM, Nikolaus Rath wrote: >> However, I noticed that if I dump the entire database into a text file >> with the SQLite shell and then compress the text file, the result is >> significantly smaller than the "stripped" compressed

Re: [sqlite] Reduce database file size

On 04/11/2010 11:09 AM, Nikolaus Rath wrote: > Yes, you remember correctly. Actually that would be a perfect solution. > But how do I use it? It seems to me that I need to pass some argument to > Shell.command_dump(), because the following just produces an empty file: > > > import apsw > ofh =

Re: [sqlite] Reduce database file size

Roger Binns writes: > On 04/11/2010 11:09 AM, Nikolaus Rath wrote: >> Yes, you remember correctly. Actually that would be a perfect solution. >> But how do I use it? It seems to me that I need to pass some argument to >> Shell.command_dump(), because the following just

[sqlite] Fwd: explain the aggregation query in sqlite

-- Forwarded message -- From: D. Richard Hipp Date: Sun, Apr 11, 2010 at 4:14 PM Subject: Re: explain the aggregation query in sqlite To: shyam gautam Please send your questions to sqlite-us...@sqlite.org. On Apr 11, 2010, at 6:36 AM,

Re: [sqlite] Reduce database file size

Nikolaus Rath wrote: > I see. I gues I got confused by the help that refers to the parameter as > 'cmd': The help shows that a list of TABLE is taken in the same syntax as SQLite's shell uses. Also note that the help is formatted for documenting interactive usage rather than API usage. > That

[sqlite] Support for Backup

Hi all, I just want to know whether SQLite support automatic backup of the DB contents. Or is there any other DBs which support this feature? Regards, Sen ___ sqlite-users mailing list sqlite-users@sqlite.org