Re: [sqlite] About SQLite Versions (Newbie)

2011-07-23 Thread Panos Katergiathis
Thank you both for your help. Panos On Jul 23, 2011, at 11:38 PM, Simon Slavin wrote: > > On 23 Jul 2011, at 6:47pm, Panos Katergiathis wrote: > >> Oh, this is nice (not having to worry). >> >> I assume that by "The database file format is fixed", you mean "fixed until >> SQLite4 is

Re: [sqlite] About SQLite Versions (Newbie)

2011-07-23 Thread Simon Slavin
On 23 Jul 2011, at 6:47pm, Panos Katergiathis wrote: > Oh, this is nice (not having to worry). > > I assume that by "The database file format is fixed", you mean "fixed until > SQLite4 is around", at which point the updating of files will also be > required. > > Is this correct (or should i

Re: [sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Abhinav Upadhyay
On Sun, Jul 24, 2011 at 1:40 AM, Abhinav Upadhyay wrote: > On Sat, Jul 23, 2011 at 11:00 PM, Richard Hipp wrote: >> On Sat, Jul 23, 2011 at 1:01 PM, Abhinav Upadhyay < >> er.abhinav.upadh...@gmail.com> wrote: >> >>> Hi, >>> >>>  I am using the

Re: [sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Abhinav Upadhyay
On Sat, Jul 23, 2011 at 11:00 PM, Richard Hipp wrote: > On Sat, Jul 23, 2011 at 1:01 PM, Abhinav Upadhyay < > er.abhinav.upadh...@gmail.com> wrote: > >> Hi, >> >>  I am using the Sqlite3 amalgamation. I am trying to register a custom >> tokenizer with sqlite for my FTS

Re: [sqlite] About SQLite Versions (Newbie)

2011-07-23 Thread Panos Katergiathis
Oh, this is nice (not having to worry). I assume that by "The database file format is fixed", you mean "fixed until SQLite4 is around", at which point the updating of files will also be required. Is this correct (or should i be getting some sleep)? Regards On Jul 23, 2011, at 8:29 PM,

Re: [sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Richard Hipp
On Sat, Jul 23, 2011 at 1:01 PM, Abhinav Upadhyay < er.abhinav.upadh...@gmail.com> wrote: > Hi, > > I am using the Sqlite3 amalgamation. I am trying to register a custom > tokenizer with sqlite for my FTS application. The custom tokenizer is > in it's separate source file. I have included

Re: [sqlite] About SQLite Versions (Newbie)

2011-07-23 Thread Richard Hipp
On Sat, Jul 23, 2011 at 12:53 PM, Panos Katergiathis wrote: > Hello all > > I fail to understand what "Upgrading from version x.x.x.x to x.x.x.x" > means. > > If i have understood properly so far, SQLite databases are single files, > that are structured according to some

[sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Abhinav Upadhyay
Hi, I am using the Sqlite3 amalgamation. I am trying to register a custom tokenizer with sqlite for my FTS application. The custom tokenizer is in it's separate source file. I have included sqlite3.h header with the tokenizer source but sqlite3.h does not contain the declaration of the various

[sqlite] About SQLite Versions (Newbie)

2011-07-23 Thread Panos Katergiathis
Hello all I fail to understand what "Upgrading from version x.x.x.x to x.x.x.x" means. If i have understood properly so far, SQLite databases are single files, that are structured according to some specification, which - of course - will evolve in the future. So, those files will need to be

Re: [sqlite] How best to determine changes in a db

2011-07-23 Thread Roger Andersson
On 07/23/11 01:09 PM, Kent Tenney wrote: > Right, but I really want a generic solution, since so many apps > store data in sqlite. if I can monitor Shotwell changes, I can > do the same for Banshee, Firefox, Zotero ... > Something like http://www.softwareaddins.com/CompareDataWiz.htm but for

Re: [sqlite] SQLite3.dll for Win 64

2011-07-23 Thread Tom Browder
On Fri, Jul 22, 2011 at 06:23, Everton Vieira wrote: > Please Help. I need an SQLite3.dll for Win 64? This link has Windows 64-bit binary installation packages--may find it in one of them: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki HTH

Re: [sqlite] How best to determine changes in a db

2011-07-23 Thread Kent Tenney
On Fri, Jul 22, 2011 at 9:22 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/22/2011 02:06 PM, Kent Tenney wrote: >> I make copies periodically, so I have 2 files >> shotwell_2011-07-21.db and shotwell_2011-07-22.db > > Shotwell is open

[sqlite] SQLite3.dll for Win 64

2011-07-23 Thread Everton Vieira
Please Help. I need an SQLite3.dll for Win 64?   I've try to download the source and make this dll but I have not success.   Anyone knows where to download this dll, or anyone knows how to make this dll with the source?   Many Thanks Everton ___

[sqlite] Multiplex VACUUM fails to delete chunks on Windows

2011-07-23 Thread Ralf Junker
VACUUM with multiplex does not delete chunks on Windows (fossil [8ce2b74a82]). It seems this is because the file handle(s) are still held open by the multiplex layer when xDelete is triggered. Since Windows can not delete open files, they are kept. I have not investigated this in depth, but

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

2011-07-23 Thread Joe Mistachkin
> > I upgrade to the latest Managed Only System.Data.SQLite 1.0.74.0 which I > understand I have to rename sqlite.so to SQLite.Interop.dll > /SQLite.Interop.DLL (tried both) and placed in the apps bin folder. > Alternatively, you can compile the System.Data.SQLite project using: MSBuild