[sqlite] SQLite using internally by Windows 10

[E. Timothy Uy]

Congratulations.

On Thu, Apr 30, 2015 at 8:24 PM, Richard Hipp  wrote:

> https://twitter.com/john_lam/status/593837681945092096
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

Re: [sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

I tried

  conn = new SQLiteConnection(String.Format("Data
Source={0};ToFullPath=False", ":memory:"));

but unfortunately still no love

On Thu, Feb 12, 2015 at 3:45 AM, E. Timothy Uy <t...@loqu8.com> wrote:

> http://system.data.sqlite.org/index.html/artifact/9a65aebbcf2379f3
>
> Hmm, yes, I think that this is the issue. Need to have handling of the
> :cerod:pwd: tag  near
>
>  if (!fullUri)
>   {
> if (isMemory)
>   fileName = MemoryFileName;
> else
> {
> #if PLATFORM_COMPACTFRAMEWORK
>   if (fileName.StartsWith("./") || fileName.StartsWith(".\\"))
> fileName = 
> Path.GetDirectoryName(System.Reflection.Assembly.GetCallingAssembly().GetName().CodeBase)
>  + fileName.Substring(1);
> #endif
>   bool toFullPath = SQLiteConvert.ToBoolean(FindKey(opts, 
> "ToFullPath", DefaultToFullPath.ToString()));
>   fileName = ExpandFileName(fileName, toFullPath);
>     }
>   }
>
>
> Maybe I can temporarily shunt it using "toFullPath".
>
> On Thu, Feb 12, 2015 at 3:43 AM, E. Timothy Uy <t...@loqu8.com> wrote:
>
>> I have confirmed that the unencrypted version works fine. Perhaps this is
>> the issue, that it is trying to ExpandFilename on a string that is
>> prepended by ":cerod:".
>>
>> On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>>
>>> I'm working on switching our custom build of System.Data.SQLite from our
>>> custom build and am having problems opening a CEROD database. Going back
>>> over our code, I see that I wrote in Open():
>>>
>>>  // TU: Need to split out "cerod" prepend to filename before
>>> expandfilename
>>>
>>> string pattern = "(:.*:)(.*)";
>>>
>>>   Match m = Regex.Match(fileName, pattern);
>>>
>>>   if (m.Groups.Count == 3)
>>>
>>>   {
>>>
>>>   string prefix = m.Groups[1].ToString();
>>>
>>>   string cleanFileName = m.Groups[2].ToString();
>>>
>>>   cleanFileName = ExpandFileName(cleanFileName);
>>>
>>>
>>>
>>>   fileName = prefix + cleanFileName;
>>>
>>>   }
>>>
>>>   else
>>>
>>>   {
>>>
>>>   fileName = ExpandFileName(fileName);
>>>
>>>   }
>>>
>>>
>>> Maybe something similar is needed?
>>>
>>
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

http://system.data.sqlite.org/index.html/artifact/9a65aebbcf2379f3

Hmm, yes, I think that this is the issue. Need to have handling of the
:cerod:pwd: tag  near

 if (!fullUri)
  {
if (isMemory)
  fileName = MemoryFileName;
else
{
#if PLATFORM_COMPACTFRAMEWORK
  if (fileName.StartsWith("./") || fileName.StartsWith(".\\"))
fileName =
Path.GetDirectoryName(System.Reflection.Assembly.GetCallingAssembly().GetName().CodeBase)
+ fileName.Substring(1);
#endif
  bool toFullPath = SQLiteConvert.ToBoolean(FindKey(opts,
"ToFullPath", DefaultToFullPath.ToString()));
  fileName = ExpandFileName(fileName, toFullPath);
}
  }


Maybe I can temporarily shunt it using "toFullPath".

On Thu, Feb 12, 2015 at 3:43 AM, E. Timothy Uy <t...@loqu8.com> wrote:

> I have confirmed that the unencrypted version works fine. Perhaps this is
> the issue, that it is trying to ExpandFilename on a string that is
> prepended by ":cerod:".
>
> On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>
>> I'm working on switching our custom build of System.Data.SQLite from our
>> custom build and am having problems opening a CEROD database. Going back
>> over our code, I see that I wrote in Open():
>>
>>  // TU: Need to split out "cerod" prepend to filename before
>> expandfilename
>>
>> string pattern = "(:.*:)(.*)";
>>
>>   Match m = Regex.Match(fileName, pattern);
>>
>>   if (m.Groups.Count == 3)
>>
>>   {
>>
>>   string prefix = m.Groups[1].ToString();
>>
>>   string cleanFileName = m.Groups[2].ToString();
>>
>>   cleanFileName = ExpandFileName(cleanFileName);
>>
>>
>>
>>   fileName = prefix + cleanFileName;
>>
>>   }
>>
>>   else
>>
>>   {
>>
>>   fileName = ExpandFileName(fileName);
>>
>>   }
>>
>>
>> Maybe something similar is needed?
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

I have confirmed that the unencrypted version works fine. Perhaps this is
the issue, that it is trying to ExpandFilename on a string that is
prepended by ":cerod:".

On Wed, Feb 11, 2015 at 7:37 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> I'm working on switching our custom build of System.Data.SQLite from our
> custom build and am having problems opening a CEROD database. Going back
> over our code, I see that I wrote in Open():
>
>  // TU: Need to split out "cerod" prepend to filename before
> expandfilename
>
> string pattern = "(:.*:)(.*)";
>
>   Match m = Regex.Match(fileName, pattern);
>
>   if (m.Groups.Count == 3)
>
>   {
>
>   string prefix = m.Groups[1].ToString();
>
>   string cleanFileName = m.Groups[2].ToString();
>
>   cleanFileName = ExpandFileName(cleanFileName);
>
>
>
>   fileName = prefix + cleanFileName;
>
>   }
>
>   else
>
>   {
>
>   fileName = ExpandFileName(fileName);
>
>   }
>
>
> Maybe something similar is needed?
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] CEROD in System.Data.SQLite

[E. Timothy Uy]

I'm working on switching our custom build of System.Data.SQLite from our
custom build and am having problems opening a CEROD database. Going back
over our code, I see that I wrote in Open():

 // TU: Need to split out "cerod" prepend to filename before expandfilename

string pattern = "(:.*:)(.*)";

  Match m = Regex.Match(fileName, pattern);

  if (m.Groups.Count == 3)

  {

  string prefix = m.Groups[1].ToString();

  string cleanFileName = m.Groups[2].ToString();

  cleanFileName = ExpandFileName(cleanFileName);



  fileName = prefix + cleanFileName;

  }

  else

  {

  fileName = ExpandFileName(fileName);

  }


Maybe something similar is needed?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] recommended way to attach SQLite.Interop.dll

[E. Timothy Uy]

Hi, when I add the nuget package for System.Data.SQLite, I don't see the
interop.dll. However, it is in the nuget packages folder. Am I supposed to
manually link to this? Concerned about missing things if we update the
nuget. Ideally it should show up automagically. (maybe I missed something)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] visx for regular old windows

[E. Timothy Uy]

Ok, I don't see it. But that is good to know (about MSBuild)

On Wed, Feb 11, 2015 at 4:22 PM, Joe Mistachkin <sql...@mistachkin.com>
wrote:

> I've been told that MSBuild will use it but that VS will not show/"see"
> it.  However, after learning this I didn't verify.  Things may improve in
> VS 2015.  Perhaps we can find out from the CTP release?
>
> Sent from my iPod
>
> > On Feb 11, 2015, at 4:13 PM, E. Timothy Uy <t...@loqu8.com> wrote:
> >
> > Does the visx for regular old windows actually work? After installing it
> I
> > don't see anything in VS2013.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] visx for regular old windows

[E. Timothy Uy]

Does the visx for regular old windows actually work? After installing it I
don't see anything in VS2013.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] default ignore-glob for sqlite

[E. Timothy Uy]

Jan, I added to your list

.target_source
lemon.obj
libsqlite3.lib
mkkeywordhash.obj
sqlite3.def
sqlite3.dll
sqlite3.exp
sqlite3.lib

On Thu, Nov 6, 2014 at 9:25 AM, E. Timothy Uy <t...@loqu8.com> wrote:

> Thank you Jan.
>
> On Thu, Nov 6, 2014 at 7:46 AM, Jan Nijtmans <jan.nijtm...@gmail.com>
> wrote:
>
>> 2014-11-06 1:14 GMT+01:00 E. Timothy Uy <t...@loqu8.com>:
>> > Hi, I noticed that the ignore-glob for sqlite is empty. Is it just
>> because
>> > fossil does not transfer this information? What should I be using?
>>
>> I'm using the "ignore-glob" versioned setting below.
>>
>> Regards,
>>   Jan Nijtmans
>>
>> $ cat .fossil-settings/ignore-glob
>> tsrc/*
>> *.db
>> Makefile
>> config.h
>> config.log
>> config.status
>> keywordhash.h
>> lemon
>> lemon.exe
>> lempar.c
>> libsqlite3.la
>> libtclsqlite3.la
>> libtool
>> mkkeywordhash
>> mkkeywordhash.exe
>> opcodes.c
>> opcodes.h
>> parse.c
>> parse.h
>> parse.h.temp
>> parse.out
>> parse.y
>> shell.c
>> sqlite3
>> sqlite3.c
>> sqlite3.exe
>> sqlite3.h
>> sqlite3.lo
>> sqlite3.o
>> sqlite3.pc
>> sqlite3ext.h
>> tclsqlite.lo
>> tclsqlite.o
>> testfixture
>> testfixture.exe
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling for WP81

[E. Timothy Uy]

I found the issue. I call vcvarsphoneall.bat and then vcvarsall.bat again
in order to reset everything. But WindowsPhoneKitDir does not get unset,
this triggers build-all-msvc.bat to cal vcvarsphoneall once again. Probably
that segment needs to be removed from build-all-msvc.bat since it seems
that you are no longer dependent on vcvarsphoneall.bat.

On Thu, Nov 20, 2014 at 12:03 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> It seem the problem was that I was calling vcvarsphoneall first. Though I
> am surprised the winrt build worked fine.
>
> On Thu, Nov 20, 2014 at 11:15 AM, Joe Mistachkin <sql...@mistachkin.com>
> wrote:
>
>>
>> E. Timothy Uy wrote:
>> >
>> >> Seems that when making mkkeywordhash.exe, it should be using the x86
>> lib
>> >> paths.
>> >>
>> >> On Thu, Nov 20, 2014 at 12:45 AM, E. Timothy Uy <t...@loqu8.com> wrote:
>> >>
>> >>> Hi, I am attempting to compile for WP81 using build-all-msvc.bat.
>> >>> However, when I initialize with vcvarsphoneall, I end up with
>> >>>
>> >
>>
>> Please try the following commands from a Visual Studio 2013 Command
>> Prompt:
>>
>> SET PLATFORMS=x86 x86_arm
>> SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1
>>
>> CALL tool\build-all-msvc.bat C:\path\to\output\dir
>>
>> --
>> Joe Mistachkin
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling for WP81

[E. Timothy Uy]

It seem the problem was that I was calling vcvarsphoneall first. Though I
am surprised the winrt build worked fine.

On Thu, Nov 20, 2014 at 11:15 AM, Joe Mistachkin <sql...@mistachkin.com>
wrote:

>
> E. Timothy Uy wrote:
> >
> >> Seems that when making mkkeywordhash.exe, it should be using the x86 lib
> >> paths.
> >>
> >> On Thu, Nov 20, 2014 at 12:45 AM, E. Timothy Uy <t...@loqu8.com> wrote:
> >>
> >>> Hi, I am attempting to compile for WP81 using build-all-msvc.bat.
> >>> However, when I initialize with vcvarsphoneall, I end up with
> >>>
> >
>
> Please try the following commands from a Visual Studio 2013 Command Prompt:
>
> SET PLATFORMS=x86 x86_arm
> SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1
>
> CALL tool\build-all-msvc.bat C:\path\to\output\dir
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling for WP81

[E. Timothy Uy]

Seems that when making mkkeywordhash.exe, it should be using the x86 lib
paths.

On Thu, Nov 20, 2014 at 12:45 AM, E. Timothy Uy <t...@loqu8.com> wrote:

> Hi, I am attempting to compile for WP81 using build-all-msvc.bat. However,
> when I initialize with vcvarsphoneall, I end up with
>
> /debug
> /out:mkkeywordhash.exe
> "/LIBPATH:F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib"
> "/LIBPATH:C:\Program Files (x86)\Windows Phone Silverlight
> Kits\8.1\lib\x86"
> mkkeywordhash.obj
> LINK : fatal error LNK1104: cannot open file 'kernel32.lib'
> NMAKE : fatal error U1077: '"F:\Program Files (x86)\Microsoft Visual
> Studio 12.0\VC\bin\cl.EXE"' : return code '0x2'
> Stop.
> Failed to build Debug "sqlite3.dll" for platform x86_arm.
>
> Any tips on how I should do this? Should I even be using
> build-all-msvc.bat?
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] compiling for WP81

[E. Timothy Uy]

Hi, I am attempting to compile for WP81 using build-all-msvc.bat. However,
when I initialize with vcvarsphoneall, I end up with

/debug
/out:mkkeywordhash.exe
"/LIBPATH:F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib"
"/LIBPATH:C:\Program Files (x86)\Windows Phone Silverlight Kits\8.1\lib\x86"
mkkeywordhash.obj
LINK : fatal error LNK1104: cannot open file 'kernel32.lib'
NMAKE : fatal error U1077: '"F:\Program Files (x86)\Microsoft Visual Studio
12.0\VC\bin\cl.EXE"' : return code '0x2'
Stop.
Failed to build Debug "sqlite3.dll" for platform x86_arm.

Any tips on how I should do this? Should I even be using build-all-msvc.bat?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] default ignore-glob for sqlite

[E. Timothy Uy]

Thank you Jan.

On Thu, Nov 6, 2014 at 7:46 AM, Jan Nijtmans <jan.nijtm...@gmail.com> wrote:

> 2014-11-06 1:14 GMT+01:00 E. Timothy Uy <t...@loqu8.com>:
> > Hi, I noticed that the ignore-glob for sqlite is empty. Is it just
> because
> > fossil does not transfer this information? What should I be using?
>
> I'm using the "ignore-glob" versioned setting below.
>
> Regards,
>   Jan Nijtmans
>
> $ cat .fossil-settings/ignore-glob
> tsrc/*
> *.db
> Makefile
> config.h
> config.log
> config.status
> keywordhash.h
> lemon
> lemon.exe
> lempar.c
> libsqlite3.la
> libtclsqlite3.la
> libtool
> mkkeywordhash
> mkkeywordhash.exe
> opcodes.c
> opcodes.h
> parse.c
> parse.h
> parse.h.temp
> parse.out
> parse.y
> shell.c
> sqlite3
> sqlite3.c
> sqlite3.exe
> sqlite3.h
> sqlite3.lo
> sqlite3.o
> sqlite3.pc
> sqlite3ext.h
> tclsqlite.lo
> tclsqlite.o
> testfixture
> testfixture.exe
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] default ignore-glob for sqlite

[E. Timothy Uy]

Hi, I noticed that the ignore-glob for sqlite is empty. Is it just because
fossil does not transfer this information? What should I be using?

Thank you,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

Thank you, that is helpful information.

On Tue, Nov 4, 2014 at 11:52 PM, Stephan Beal <sgb...@googlemail.com> wrote:

> On Wed, Nov 5, 2014 at 7:07 AM, E. Timothy Uy <t...@loqu8.com> wrote:
>
> > The problem is ultimately not time-warps. DRH can confirm - the problem
> is
> > actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil
> > there are entries in the plink table where the parent id (pid) is greater
> > than the commit id (cid). There are over a thousand of these.
>
>
> Those IDs are _transient_, not part of the historical record. The "child ID
> comes before parent ID" behaviour also appears on completely benign repos
> (i've seen it before in my own while testing libfossil).
>
>
>
> > If I had more brain cells, I could perhaps invent a way to efficiently
> use
> > the plink table to generate the proper export list where parents always
> > come before children regardless of mtime.
> >
>
> i've also attempted something similar in libfossil, but haven't been
> successful. The RIDs cannot be used to figure it out, and neither can
> mtime. The only 100% reliable way i know of traversing the history is to
> read each manifest, as the P-cards give us that piece of context we need to
> know the ordering.
>
> --
> - stephan beal
> http://wanderinghorse.net/home/stephan/
> http://gplus.to/sgbeal
> "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
> those who insist on a perfect world, freedom will have to do." -- Bigby
> Wolf
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

As I walked away to do the dishes, these verses from Matthew suddenly came
to mind:

The LORD said unto my Lord, Sit thou on my right hand, till I make thine
> enemies thy footstool? If David then call him Lord, how is he his son?


I think I'll just be quiet now.

Blessings,
Tim

On Tue, Nov 4, 2014 at 10:07 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> I am not behind http://repo.or.cz/w/sqlite.git - though Kyle (the one
> behind it) has some good ideas that would be nice to get into fossil. But
> he doesn't care to try to get them into fossil. I do. Please don't
> misinterpret the answers below as any kind of disrespect for DRH, SQLite or
> fossil - they are all held in high regard.
>
>
>> 1. Why is it a good idea for you, E. Timothy Uy, to dump the SQLite code
>> repo into a Git repo?  What does this achieve, that keeping it in Fossil
>> does not?
>>
>
> Like fossil, I use SQLite code as part of a larger project. This larger
> project is using Git. I would like to reference all third-party code as Git
> submodules - this is already done for components that are SVN-based.
> Previously I had an untracked folder holding fossil repositories and I
> briefly considered some kind of macro or script to fossil clone - but I
> like how Git submodules also keep track of the particular commit that is
> used by the master repo.
>
>
>> 2. Why is it a good idea for our BDFL, D. Richard Hipp, to modify the
>> SQLite repo to make it easier for you to dump it into a Git repo?  Keep in
>> mind that the costs here are not just his time, but also the loss of a test
>> case.
>
>
> I don't think DRH needs modify the repo to make it easier to help _me_
> dump it into a Git repo. In fact, (see #3), I no longer think the
> time-warps should be fixed at all.
>
> However, I do want to point out that
>
> 1. There are two existing tags that fix the two time-warps. However, these
> have been un-fixed without deleting the fixing tags. This is confusing.
> Maybe the tags should be deleted? Or maybe there are two more tags
> somewhere that unfix the fixes?
>
> b. SQLite is the crown jewel example of the beauty of fossil. Fossil
> offers "fossil export --git repo.fossil | git fast-import". Why should this
> break for SQLite? It shouldn't.
>
> c. It is a matter of perception. If SQLite is good example of fossil,
> putting your code into fossil means never getting it out again. That is
> scary.
>
> I don’t think you can convince anyone that #2 is a good idea, but I’m
>> curious about why #1 is a good idea.
>>
>> Bonus persuasion point 3: Why not persuade the Git people to modify their
>> tool to cope with time warps?  Isn’t their major value proposition w.r.t
>> the other open source DVCSes that Git is more powerful and flexible?  Here
>> we see Fossil doing something Git cannot or will not do, and it’s not a
>> matter of mission scope, as with the bug tracker or wiki features of Fossil.
>
>
> The problem is ultimately not time-warps. DRH can confirm - the problem is
> actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil
> there are entries in the plink table where the parent id (pid) is greater
> than the commit id (cid). There are over a thousand of these. I suspect
> that because of this, the --git export function sorts the commits by mtime
> instead of by objid. But ideally the export function should sort by objid
> with pid always less than cid. When sorting by mtime, time-warps cause the
> scenario where a commit is exported which refers to a parent which has not
> been mentioned. This is what causes the Git fast-import function to choke.
> The interim fix is to use a tag to change the time, then export.
>
> If I had more brain cells, I could perhaps invent a way to efficiently use
> the plink table to generate the proper export list where parents always
> come before children regardless of mtime.
>
> Respectfully,
> Tim
>
>
>
>
>
>
>
>
>
>
>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

I am not behind http://repo.or.cz/w/sqlite.git - though Kyle (the one
behind it) has some good ideas that would be nice to get into fossil. But
he doesn't care to try to get them into fossil. I do. Please don't
misinterpret the answers below as any kind of disrespect for DRH, SQLite or
fossil - they are all held in high regard.


> 1. Why is it a good idea for you, E. Timothy Uy, to dump the SQLite code
> repo into a Git repo?  What does this achieve, that keeping it in Fossil
> does not?
>

Like fossil, I use SQLite code as part of a larger project. This larger
project is using Git. I would like to reference all third-party code as Git
submodules - this is already done for components that are SVN-based.
Previously I had an untracked folder holding fossil repositories and I
briefly considered some kind of macro or script to fossil clone - but I
like how Git submodules also keep track of the particular commit that is
used by the master repo.


> 2. Why is it a good idea for our BDFL, D. Richard Hipp, to modify the
> SQLite repo to make it easier for you to dump it into a Git repo?  Keep in
> mind that the costs here are not just his time, but also the loss of a test
> case.


I don't think DRH needs modify the repo to make it easier to help _me_ dump
it into a Git repo. In fact, (see #3), I no longer think the time-warps
should be fixed at all.

However, I do want to point out that

1. There are two existing tags that fix the two time-warps. However, these
have been un-fixed without deleting the fixing tags. This is confusing.
Maybe the tags should be deleted? Or maybe there are two more tags
somewhere that unfix the fixes?

b. SQLite is the crown jewel example of the beauty of fossil. Fossil offers
"fossil export --git repo.fossil | git fast-import". Why should this break
for SQLite? It shouldn't.

c. It is a matter of perception. If SQLite is good example of fossil,
putting your code into fossil means never getting it out again. That is
scary.

I don’t think you can convince anyone that #2 is a good idea, but I’m
> curious about why #1 is a good idea.
>
> Bonus persuasion point 3: Why not persuade the Git people to modify their
> tool to cope with time warps?  Isn’t their major value proposition w.r.t
> the other open source DVCSes that Git is more powerful and flexible?  Here
> we see Fossil doing something Git cannot or will not do, and it’s not a
> matter of mission scope, as with the bug tracker or wiki features of Fossil.


The problem is ultimately not time-warps. DRH can confirm - the problem is
actually inside fossil and sqlite.fossil. Very early on in sqlite.fossil
there are entries in the plink table where the parent id (pid) is greater
than the commit id (cid). There are over a thousand of these. I suspect
that because of this, the --git export function sorts the commits by mtime
instead of by objid. But ideally the export function should sort by objid
with pid always less than cid. When sorting by mtime, time-warps cause the
scenario where a commit is exported which refers to a parent which has not
been mentioned. This is what causes the Git fast-import function to choke.
The interim fix is to use a tag to change the time, then export.

If I had more brain cells, I could perhaps invent a way to efficiently use
the plink table to generate the proper export list where parents always
come before children regardless of mtime.

Respectfully,
Tim











> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

Is that a philosophical question? :)

On Mon, Nov 3, 2014 at 5:52 PM, Richard Hipp <d...@sqlite.org> wrote:

> On Mon, Nov 3, 2014 at 8:46 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>
> > Ok, I now see that you intentionally left 2 time-warps in place. It would
> > be helpful to make that as a note for exporting to git.
> >
>
> Why would I want to export the SQLite history to Git?
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

Guess my photo got blocked -
https://www.sqlite.org/src/timeline?c=2010-09-28+20:26:44 shows the
time-warp but also the tag messages fixing them (which I guess you later
unfixed in the db).

On Mon, Nov 3, 2014 at 5:46 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Ok, I now see that you intentionally left 2 time-warps in place. It would
> be helpful to make that as a note for exporting to git. It is also
> confusing that the tags are there showing that they were fixed.
>
> On Mon, Nov 3, 2014 at 5:44 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>
>> Dear Richard,
>>
>> It is strange, but if you look at the timeline image I sent (second
>> email), your time-warp tag changes are clearly there but did not stick on
>> objid 35450 and 35460. I just manually did mine on this end (following your
>> same times) and it is now ok, though I feel a bit dirty changing commit
>> times!
>>
>> Leaving the time-warp in place will affect git export. Also, the other
>> barrier that blocks git export of the current sqlite version is that in the
>> fossil export.c, the pid needs to be filtered by type='ci' as one of the
>> parents is type='g' (tag). I have that in some notes in
>> http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a
>>
>> db_prepare(,
>>   "SELECT pid FROM plink"
>>   " WHERE cid=%d AND isprim"
>>   "   AND pid IN (SELECT objid FROM event WHERE type='ci')",
>>       ckinId
>> );
>>
>> Respectfully,
>> Tim
>>
>> On Mon, Nov 3, 2014 at 5:37 PM, Richard Hipp <d...@sqlite.org> wrote:
>>
>>> On Mon, Nov 3, 2014 at 8:13 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>>>
>>> > I found some posts in the past describing fixing time-warps using
>>> tags. How
>>> > does this process get initiated? I found two while trying to export to
>>> .git
>>> >
>>>
>>>
>>> The test_timewarps webpage will show them all to you.  Example:
>>>
>>>  http://www.sqlite.org/src/test_timewarps
>>>
>>> In the example above, most of the timewarps have been fixed.  To fix
>>> them,
>>> simple edit check-ins and change their time.
>>>
>>> I intentionally left one timewarp in SQLite unfixed.  See the
>>> https://www.sqlite.org/src/timeline?p=3f30f00a384d23=3f30f00a384d235
>>> timeline.  I left this one as a test case for ensuring that Fossil can
>>> display timewarps correctly.
>>>
>>>
>>>
>>>
>>> >
>>> > sqlite> SELECT l.*, ep.mtime, ec.mtime FROM plink l LEFT JOIN event ep
>>> ON
>>> > pid = ep.objid LEFT JOIN event ec ON cid = ec.objid WHERE ep.mtime >
>>> > ec.mtime LIMIT 10;
>>> >
>>> > 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683
>>> >
>>> > 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815
>>> >
>>> > Respectfully,
>>> >
>>> > Tim
>>> > ___
>>> > sqlite-users mailing list
>>> > sqlite-users@sqlite.org
>>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>> >
>>>
>>>
>>>
>>> --
>>> D. Richard Hipp
>>> d...@sqlite.org
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

Ok, I now see that you intentionally left 2 time-warps in place. It would
be helpful to make that as a note for exporting to git. It is also
confusing that the tags are there showing that they were fixed.

On Mon, Nov 3, 2014 at 5:44 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Dear Richard,
>
> It is strange, but if you look at the timeline image I sent (second
> email), your time-warp tag changes are clearly there but did not stick on
> objid 35450 and 35460. I just manually did mine on this end (following your
> same times) and it is now ok, though I feel a bit dirty changing commit
> times!
>
> Leaving the time-warp in place will affect git export. Also, the other
> barrier that blocks git export of the current sqlite version is that in the
> fossil export.c, the pid needs to be filtered by type='ci' as one of the
> parents is type='g' (tag). I have that in some notes in
> http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a
>
> db_prepare(,
>   "SELECT pid FROM plink"
>   " WHERE cid=%d AND isprim"
>   "   AND pid IN (SELECT objid FROM event WHERE type='ci')",
>   ckinId
> );
>
> Respectfully,
> Tim
>
> On Mon, Nov 3, 2014 at 5:37 PM, Richard Hipp <d...@sqlite.org> wrote:
>
>> On Mon, Nov 3, 2014 at 8:13 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>>
>> > I found some posts in the past describing fixing time-warps using tags.
>> How
>> > does this process get initiated? I found two while trying to export to
>> .git
>> >
>>
>>
>> The test_timewarps webpage will show them all to you.  Example:
>>
>>  http://www.sqlite.org/src/test_timewarps
>>
>> In the example above, most of the timewarps have been fixed.  To fix them,
>> simple edit check-ins and change their time.
>>
>> I intentionally left one timewarp in SQLite unfixed.  See the
>> https://www.sqlite.org/src/timeline?p=3f30f00a384d23=3f30f00a384d235
>> timeline.  I left this one as a test case for ensuring that Fossil can
>> display timewarps correctly.
>>
>>
>>
>>
>> >
>> > sqlite> SELECT l.*, ep.mtime, ec.mtime FROM plink l LEFT JOIN event ep
>> ON
>> > pid = ep.objid LEFT JOIN event ec ON cid = ec.objid WHERE ep.mtime >
>> > ec.mtime LIMIT 10;
>> >
>> > 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683
>> >
>> > 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815
>> >
>> > Respectfully,
>> >
>> > Tim
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>>
>>
>>
>> --
>> D. Richard Hipp
>> d...@sqlite.org
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

[E. Timothy Uy]

Dear Richard,

It is strange, but if you look at the timeline image I sent (second email),
your time-warp tag changes are clearly there but did not stick on objid
35450 and 35460. I just manually did mine on this end (following your same
times) and it is now ok, though I feel a bit dirty changing commit times!

Leaving the time-warp in place will affect git export. Also, the other
barrier that blocks git export of the current sqlite version is that in the
fossil export.c, the pid needs to be filtered by type='ci' as one of the
parents is type='g' (tag). I have that in some notes in
http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a

db_prepare(,
  "SELECT pid FROM plink"
  " WHERE cid=%d AND isprim"
  "   AND pid IN (SELECT objid FROM event WHERE type='ci')",
  ckinId
);

Respectfully,
Tim

On Mon, Nov 3, 2014 at 5:37 PM, Richard Hipp <d...@sqlite.org> wrote:

> On Mon, Nov 3, 2014 at 8:13 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>
> > I found some posts in the past describing fixing time-warps using tags.
> How
> > does this process get initiated? I found two while trying to export to
> .git
> >
>
>
> The test_timewarps webpage will show them all to you.  Example:
>
>  http://www.sqlite.org/src/test_timewarps
>
> In the example above, most of the timewarps have been fixed.  To fix them,
> simple edit check-ins and change their time.
>
> I intentionally left one timewarp in SQLite unfixed.  See the
> https://www.sqlite.org/src/timeline?p=3f30f00a384d23=3f30f00a384d235
> timeline.  I left this one as a test case for ensuring that Fossil can
> display timewarps correctly.
>
>
>
>
> >
> > sqlite> SELECT l.*, ep.mtime, ec.mtime FROM plink l LEFT JOIN event ep ON
> > pid = ep.objid LEFT JOIN event ec ON cid = ec.objid WHERE ep.mtime >
> > ec.mtime LIMIT 10;
> >
> > 35460|35462|1|2455469.2683|2455469.46484954|2455469.2683
> >
> > 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815
> >
> > Respectfully,
> >
> > Tim
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] fixing time-warp

[E. Timothy Uy]

I found some posts in the past describing fixing time-warps using tags. How
does this process get initiated? I found two while trying to export to .git

sqlite> SELECT l.*, ep.mtime, ec.mtime FROM plink l LEFT JOIN event ep ON
pid = ep.objid LEFT JOIN event ec ON cid = ec.objid WHERE ep.mtime >
ec.mtime LIMIT 10;

35460|35462|1|2455469.2683|2455469.46484954|2455469.2683

35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815

Respectfully,

Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] activate statement count with sqlite3_interrupt

[E. Timothy Uy]

In this case I have a text box where the user types in search results. I
want to cancel all pending searches the moment they start typing something
else.


On Mon, Apr 7, 2014 at 12:04 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Isn't the interrupt in play until all active statements have been stopped?
> Including statements that are added after the interrupt is called? I just
> want to make sure it is safe to call the next statement.
>
> " Any new SQL statements that are started after the sqlite3_interrupt()
> call and before the running statements reaches zero are interrupted as if
> they had been running prior to the sqlite3_interrupt() call."
>
>
> On Mon, Apr 7, 2014 at 11:52 AM, Richard Hipp <d...@sqlite.org> wrote:
>
>> On Mon, Apr 7, 2014 at 2:47 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>>
>> > Hi, I am considering using sqlite3_interrupt to interrupt a long query -
>> > but the documentation states that the order will stand until the
>> activate
>> > statement count is zero. How do I know that the activate statement
>> count is
>> > zero?
>> >
>>
>> You could use http://www.sqlite.org/c3ref/stmt_busy.html
>>
>> Why do you think you need to know that?  What does your application do
>> differently if the active statement count is zero versus if it is not?
>>
>>
>>
>>
>> --
>> D. Richard Hipp
>> d...@sqlite.org
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] activate statement count with sqlite3_interrupt

[E. Timothy Uy]

Isn't the interrupt in play until all active statements have been stopped?
Including statements that are added after the interrupt is called? I just
want to make sure it is safe to call the next statement.

" Any new SQL statements that are started after the sqlite3_interrupt()
call and before the running statements reaches zero are interrupted as if
they had been running prior to the sqlite3_interrupt() call."


On Mon, Apr 7, 2014 at 11:52 AM, Richard Hipp <d...@sqlite.org> wrote:

> On Mon, Apr 7, 2014 at 2:47 PM, E. Timothy Uy <t...@loqu8.com> wrote:
>
> > Hi, I am considering using sqlite3_interrupt to interrupt a long query -
> > but the documentation states that the order will stand until the activate
> > statement count is zero. How do I know that the activate statement count
> is
> > zero?
> >
>
> You could use http://www.sqlite.org/c3ref/stmt_busy.html
>
> Why do you think you need to know that?  What does your application do
> differently if the active statement count is zero versus if it is not?
>
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] activate statement count with sqlite3_interrupt

[E. Timothy Uy]

Hi, I am considering using sqlite3_interrupt to interrupt a long query -
but the documentation states that the order will stand until the activate
statement count is zero. How do I know that the activate statement count is
zero?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] too many SQL variables

[E. Timothy Uy]

Hehe, you know it.


On Thu, Jan 30, 2014 at 11:51 AM, RSmith  wrote:

>
>  Just for my edification, what is the limit on the number of SQL
>> parameters?
>> Today I hit "too may SQL variables" with about 1400...
>> Just for our edification, which kind of statement was that?
>>
>>
> The worst kind
>
> :)
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] too many SQL variables

[E. Timothy Uy]

Just for my edification, what is the limit on the number of SQL parameters?
Today I hit "too may SQL variables" with about 1400...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] order of = in join

[E. Timothy Uy]

#1 - f.term = t.term
SELECT m.term AS term, m.definition AS definition
FROM
(SELECT t.term, e.definition
FROM Terms_content t
INNER JOIN Favorites f ON f.term = t.term
LEFT JOIN TermEntries te ON te.termid = t.docid
LEFT JOIN Entries e ON e.docid = te.entryid) AS m
LEFT JOIN Favorites f ON f.term = m.term"

#2 - t.term = f.term
SELECT m.term AS term, m.definition AS definition
FROM
(SELECT t.term, e.definition
FROM Terms_content t
INNER JOIN Favorites f ON t.term = f.term
LEFT JOIN TermEntries te ON te.termid = t.docid
LEFT JOIN Entries e ON e.docid = te.entryid) AS m
LEFT JOIN Favorites f ON f.term = m.term


Here the Terms_content table is big, maybe 300k rows, while the Favorites
table is small, <100 rows. Query #1 takes 300 ms, and query #2 takes 30 ms.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] unable to use function MATCH in the requested context

[E. Timothy Uy]

This is a class of problems I started seeing around 3.8.x. Any insights
would be much appreciated. Sometimes it happens when there are more than a
few INNER JOINS, others, in the case, happen when I ORDER BY the virtual
table's docid. I feel like this used to work.

SQLite version 3.8.2 2013-12-06 14:53:30
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> CREATE VIRTUAL TABLE Terms USING fts3 (term)
>...> ;
> sqlite> INSERT INTO Terms VALUES ('hello tim');
> sqlite> INSERT INTO Terms VALUES ('goodbye tim');
> sqlite> CREATE TEMP TABLE Combos (combo);
> sqlite> INSERT INTO Combos VALUES ('hello');
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo;
> hello tim|hello
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo
> ORDER BY t.docid;
> Error: unable to use function MATCH in the requested context
> sqlite>


I know ordering by t.docid is probably redundant, but it is an example of
the issue I'm encountering. This is an issue in 3.8.0 also. The last time
it worked was 3.7.17

SQLite version 3.7.17 2013-05-20 00:56:22
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> CREATE VIRTUAL TABLE Terms USING fts3 (term)
>...> ;
> sqlite> INSERT INTO Terms VALUES ('hello tim');
> sqlite> INSERT INTO Terms VALUES ('goodbye tim');
> sqlite> CREATE TEMP TABLE Combos (combo);
> sqlite> INSERT INTO Combos VALUES ('hello');
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo;
> hello tim|hello
> sqlite> SELECT * FROM Terms t INNER JOIN Combos c ON t.term MATCH c.combo
> ORDER
> BY t.docid;
> hello tim|hello
> sqlite>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] unable to use function MATCH in requested context

[E. Timothy Uy]

In fact, it does not work in a nested query - the issue is actually
multiple inner joins. When I LEFT JOIN the rest of the tables, it works
fine. This must have been a change in the last year or so.


On Tue, Dec 31, 2013 at 3:15 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Hi, as a sanity check, did something change in the use of MATCH with JOINs?
>
> I used to do
>
> SELECT ...
> FROM Entries e
> INNER JOIN Combos c ON e.Entries MATCH c.combo
> INNER JOIN Entries_content ec ON ec.docid = e.docid
>
> but now I get "unable to use function MATCH in the requested context". I
> can pull it off in a nested query with the MATCH by itself, but I feel like
> this totally used to work. Here Entries is an FTS3 table and
> Entries_content is associated content.
>
> Thank you in advance.
>
> Respectfully
> Tim
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] unable to use function MATCH in requested context

[E. Timothy Uy]

Hi, as a sanity check, did something change in the use of MATCH with JOINs?

I used to do

SELECT ...
FROM Entries e
INNER JOIN Combos c ON e.Entries MATCH c.combo
INNER JOIN Entries_content ec ON ec.docid = e.docid

but now I get "unable to use function MATCH in the requested context". I
can pull it off in a nested query with the MATCH by itself, but I feel like
this totally used to work. Here Entries is an FTS3 table and
Entries_content is associated content.

Thank you in advance.

Respectfully
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] virtual table end of insert

[E. Timothy Uy]

In a virtual table, an insert of multiple rows calls xUpdate multiple
times. How can I tell when the entire insert is complete?

e.g.,
INSERT INTO myvirtualtable (token, rank) VALUES (..,..), (..,..),(..,..)

will call xUpdate 3 times. But I would like to know when the whole thing is
done so that I can do something

or is my only option sending a command?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] pDb->inTrans

[E. Timothy Uy]

Sorry, please ignore this message. I spaced out and forgot to 'fossil up'
after 'fossil sync'.


On Wed, Sep 4, 2013 at 2:48 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Hi, I'm getting the following error in the latest code (after merging with
> my own).
>
> sqlite3.c(145194) : error C2039: 'inTrans' : is not a member of 'Db'
> sqlite3.c(9976) : see declaration of 'Db'
> sqlite3.c(145234) : error C2039: 'inTrans' : is not a member of 'Db'
> sqlite3.c(9976) : see declaration of 'Db'
>
> The problem appears to be that struct Db does not have inTrans, which it
> definitely doesn't.
>
> Before I dig too deep, has anyone else seen this? I wonder if it should
> actually be something other than pDb->inTrans... maybe p->inTrans?
>
> Cheers,
> Tim
>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] pDb->inTrans

[E. Timothy Uy]

Hi, I'm getting the following error in the latest code (after merging with
my own).

sqlite3.c(145194) : error C2039: 'inTrans' : is not a member of 'Db'
sqlite3.c(9976) : see declaration of 'Db'
sqlite3.c(145234) : error C2039: 'inTrans' : is not a member of 'Db'
sqlite3.c(9976) : see declaration of 'Db'

The problem appears to be that struct Db does not have inTrans, which it
definitely doesn't.

Before I dig too deep, has anyone else seen this? I wonder if it should
actually be something other than pDb->inTrans... maybe p->inTrans?

Cheers,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] the Nth 32-bit int in byte array in query

[E. Timothy Uy]

Scratch that - I realized I could use substr.


On Tue, May 14, 2013 at 11:57 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> I'm using matchinfo(...,'s') to get the length of the longest subsequence
> of phrase matches from FTS4. I have 4 columns, so I end up with a byte
> array that is 16 bytes long. I would like to extract the value for the Nth
> column in query and sort by it. I would also be interested in getting the
> Max() value. Is there a way of doing this without writing any additional
> functions?
>
> Thanks,
> Tim
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] the Nth 32-bit int in byte array in query

[E. Timothy Uy]

I'm using matchinfo(...,'s') to get the length of the longest subsequence
of phrase matches from FTS4. I have 4 columns, so I end up with a byte
array that is 16 bytes long. I would like to extract the value for the Nth
column in query and sort by it. I would also be interested in getting the
Max() value. Is there a way of doing this without writing any additional
functions?

Thanks,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] bind field name?

[E. Timothy Uy]

Hi, is it possible to bind a field name to a sqlite query?

For example,

WHERE @field1 > @param1
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] compiling for WP8

[E. Timothy Uy]

Hi, I'm working on compiling for Windows Phone. Are there any helpful
notes? In particular, I'm stalled at the missing 'rc' (resource compiler)
in the WP8 developer command prompt.

Thanks,
tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling tools for winrt

[E. Timothy Uy]

Thanks Dimiter. I ended up making this change in Makefile.msc

165 165 !IFNDEF NSDKLIBPATH
166 -NSDKLIBPATH = $(WINDOWSSDKDIR)\lib
166 +NSDKLIBPATH = $(WINDOWSSDKDIR)\Lib\win8\um\x86
167 167 !ENDIF


On Wed, Jan 9, 2013 at 4:07 PM, Dimiter 'malkia' Stanev <mal...@gmail.com>wrote:

> This looks like general compile problem.
>
> The imported functions below are found in kernel32.dll (kernel32.lib
> import library). But I'm not sure whether under WinRT kernel32.dll is still
> used (it might be).
>
> If you can either add kernel32.lib to your link flags, or with pragma
>
> #ifdef _MSC_VER
> #pragma comment(lib, "kernel32.lib")
> #endif
>
>
> On 1/9/2013 3:04 PM, E. Timothy Uy wrote:
>
>> Hi, in xcompiling tools for winrt I get the errors below. I suspect this
>> because I am using the vcvars for cross compiling winrt. Is there a way to
>> make this work?
>>
>> MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
>> __imp__IsDebuggerPresent@0 referenced in function
>> ___raise_securityfailure
>> MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
>> _IsProcessorFeaturePresent@4 referenced in function ___report_gsfailure
>> MSVCRT.lib(crtexe.obj) : error LNK2019: unresolved external symbol
>> __imp__EncodePointer@4 referenced in function _pre_c_init
>> MSVCRT.lib(atonexit.obj) : error LNK2001: unresolved external symbol
>> __imp__EncodePointer@4
>> MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
>> __imp__**QueryPerformanceCounter@4 referenced in function
>> ___security_init_cookie
>> MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
>> __imp__GetCurrentProcessId@0 referenced in function
>> ___security_init_cookie
>> MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
>> __imp__GetCurrentThreadId@0 referenced in function
>> ___security_init_cookie
>> MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
>> __imp__**GetSystemTimeAsFileTime@4 referenced in function
>> ___security_init_cookie
>> MSVCRT.lib(atonexit.obj) : error LNK2019: unresolved external symbol
>> __imp__DecodePointer@4 referenced in function __onexit
>> mkkeywordhash.exe : fatal error LNK1120: 8 unresolved externals
>> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
>> Studio
>> 11.0\VC\bin\cl.exe"' : return code '0x2'
>> Stop.
>>
>>  __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] compiling tools for winrt

[E. Timothy Uy]

Hi, in xcompiling tools for winrt I get the errors below. I suspect this
because I am using the vcvars for cross compiling winrt. Is there a way to
make this work?

MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
__imp__IsDebuggerPresent@0 referenced in function ___raise_securityfailure
MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
_IsProcessorFeaturePresent@4 referenced in function ___report_gsfailure
MSVCRT.lib(crtexe.obj) : error LNK2019: unresolved external symbol
__imp__EncodePointer@4 referenced in function _pre_c_init
MSVCRT.lib(atonexit.obj) : error LNK2001: unresolved external symbol
__imp__EncodePointer@4
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__QueryPerformanceCounter@4 referenced in function
___security_init_cookie
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__GetCurrentProcessId@0 referenced in function ___security_init_cookie
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__GetCurrentThreadId@0 referenced in function ___security_init_cookie
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__GetSystemTimeAsFileTime@4 referenced in function
___security_init_cookie
MSVCRT.lib(atonexit.obj) : error LNK2019: unresolved external symbol
__imp__DecodePointer@4 referenced in function __onexit
mkkeywordhash.exe : fatal error LNK1120: 8 unresolved externals
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio
11.0\VC\bin\cl.exe"' : return code '0x2'
Stop.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] hfs+ on bootcamp -> database malformed?

[E. Timothy Uy]

No, I checked the hash of his version and mine, they are identical. It
really is something strange on his machine. He claims that it stopped
working after uninstalling HFS+.

On Wed, Nov 21, 2012 at 12:02 PM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 21 Nov 2012, at 6:32pm, E. Timothy Uy <t...@loqu8.com> wrote:
>
> > I'm suddenly getting a "database disk image is malformed" on a customer
> > after they had a bad HFS+ install. They are running Boot Camp on a Mac. I
> > checked and the db is exactly the same on my machine and his, but he gets
> > the error. Is anyone else seeing this?
>
> What version of SQL are you both running ?  Give us the result of
>
> SELECT sqlite_version()
>
> on both computers.
>
> If you copy the database from the HFS+ partition to the one you're booted
> from, does it still show as corrupt ?
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] hfs+ on bootcamp -> database malformed?

[E. Timothy Uy]

I'm suddenly getting a "database disk image is malformed" on a customer
after they had a bad HFS+ install. They are running Boot Camp on a Mac. I
checked and the db is exactly the same on my machine and his, but he gets
the error. Is anyone else seeing this?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] associating a ticket in the UI to a check-in

[E. Timothy Uy]

Never mind, I just needed brackets.

On Thu, Oct 18, 2012 at 8:07 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Is there a way to associate a ticket in the UI to a check-in or am I too
> late?
>
> Thanks,
> Tim
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] associating a ticket in the UI to a check-in

[E. Timothy Uy]

Is there a way to associate a ticket in the UI to a check-in or am I too
late?

Thanks,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DELETE Query Assistance Please

[E. Timothy Uy]

If you are trying to purge a huge database and it is not live, another
possibility is to attach a new blank database and SELECT into it. This way
you don't have to waste time with VACUUM.

On Mon, Sep 24, 2012 at 10:04 AM, Clemens Ladisch wrote:

> Don Goyette wrote:
> > > With 60*60*24 seconds per day, the number of days since the Unix epoch
> is:
> > >   sqlite> select strftime('%s', '2012-05-22') / (60*60*24);
> > >   15482
> >
> > The timestamp in the tables I'm reading is not in the format of
> > '2012-05-22'.
>
> Sorry, my explanations were not clear enough.  This is not yet the
> conversion; here I just determined the number of days between the Unix
> epoch and your example timestamp.
>
> That was used to derive the actual conversion formula that you wanted:
>
> > >   (excel_timestamp - 25569) * (60*60*24)
>
> And this was just a check of the formula, using your example timestamp:
>
> > >   > select datetime((41051.395834 - 25569) * (60*60*24),
> 'unixepoch');
> > >   2012-05-22 09:30:00
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Does a search on an external content FTS table use the index of the underlying content?

[E. Timothy Uy]

Thanks Richard. In the case of using a index modifying tokenizer like
Porter, is there a way to know which of the MATCH terms it actually matched
on or is that lost information?

On Wed, Sep 19, 2012 at 3:44 AM, Richard Hipp <d...@sqlite.org> wrote:

> On Wed, Sep 19, 2012 at 2:42 AM, E. Timothy Uy <t...@loqu8.com> wrote:
>
> > Let's say I have a table Data_content(term TEXT UNIQUE) which has an
> > indexed column 'term'. I then create an FTS4 table using
> >
> > CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term);
> >
> > If I later search using SELECT * FROM Data WHERE term IN (...), does it
> use
> > the indexes generated in Data_content, or do I have to generate another
> set
> > (or search Data_content directly).
> >
>
> FTS4 indices are only used with the MATCH operator.  And you cannot create
> an index on a virtual table.  So you'll either want to translate your IN
> into a MATCH or else search the Data_content table directly.
>
>
>
> >
> > Thanks.
> >
> > Respectfully,
> > Tim
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Does a search on an external content FTS table use the index of the underlying content?

[E. Timothy Uy]

Let's say I have a table Data_content(term TEXT UNIQUE) which has an
indexed column 'term'. I then create an FTS4 table using

CREATE VIRTUAL TABLE Data USING fts4 (content="Data_content", term);

If I later search using SELECT * FROM Data WHERE term IN (...), does it use
the indexes generated in Data_content, or do I have to generate another set
(or search Data_content directly).

Thanks.

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] IN operator hits

[E. Timothy Uy]

I apologize and thank Paul for his answer. In fact, what I really meant to
ask was how to get the original hit values for a MATCH operation when using
FTS4 with a Porter tokenizer. I'm not sure what I was thinking in asking
this question - please disregard it.

On Mon, Sep 17, 2012 at 4:28 PM, Igor Tandetnik <itandet...@mvps.org> wrote:

> E. Timothy Uy <t...@loqu8.com> wrote:
> > Is there a way to figure out which of the terms in an IN operator
> actually
> > hit?
>
> I'm not sure I understand the question. What exactly are you trying to
> achieve? I suggest you describe the problem you are trying to solve, rather
> than your proposed half-of-a-solution.
> --
> Igor Tandetnik
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] IN operator hits

[E. Timothy Uy]

Is there a way to figure out which of the terms in an IN operator actually
hit? Perhaps making a temp table is the only way. Any help is much
appreciated.

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] offset from matchinfo

[E. Timothy Uy]

Hi, it doesn't look like it is possible to get offset information from
matchinfo. Is that right? It seems like matchinfo should be the uber set of
data for matching. Sometimes early occurrence of a match may mean more
significance.

Thanks,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] classic update join question

[E. Timothy Uy]

Igor, what happens if there are multiple hits for

SELECT frequency FROM beta WHERE beta.term
= alpha.term

(there aren't but, it is possible for there to be).  Rob could be right in
a sense.

On Wed, Sep 5, 2012 at 1:28 PM, Igor Tandetnik  wrote:

> On 9/5/2012 4:20 PM, Rob Richardson wrote:
>
>> Well, I think you want a where clause on your main UPDATE query.  What
>> you wrote will set the frequency of every record in the alpha table to the
>> value from the beta table, for every record in the beta table that matches
>> an alpha record.  (It's late, I'm tired and that's incoherent.  I hope you
>> followed it.)  If you have 1000 records in the two tables that match each
>> other, every record in the alpha table will be updated 1000 times.
>>
>
> No, that's not true. Every record in alpha will be updated exactly once.
> --
> Igor Tandetnik
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] classic update join question

[E. Timothy Uy]

Dear Igor,

Are you saying that

UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term
= alpha.term)

is just as efficient as it gets and equivalent to an update using join (in
other dbs)? That would helpful to know. I do kind of imagine some kind of
black magic... ;)


On Wed, Sep 5, 2012 at 12:24 PM, Igor Tandetnik <itandet...@mvps.org> wrote:

> On 9/5/2012 12:38 PM, E. Timothy Uy wrote:
>
>> I have a column in table 'alpha' which I would like to populate with data
>> from table 'beta'. As far as I know, we cannot do an UPDATE using JOIN in
>> sqlite, but we can
>>
>> UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term =
>>
>>> alpha.term)
>>>
>>
>> Will the database really be doing a select in beta for
>> every single line in alpha?
>>
>
> Yes - same as when implementing a join. How do you think a join is
> performed - black magic?
> --
> Igor Tandetnik
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] classic update join question

[E. Timothy Uy]

Hi sqlite-users,

I have a column in table 'alpha' which I would like to populate with data
from table 'beta'. As far as I know, we cannot do an UPDATE using JOIN in
sqlite, but we can

UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term =
> alpha.term)


or we can create a temp table with the joined data and then drop and
replace alpha. How inefficient is the former method? Is it "ok"?  In this
case, alpha is about 100k rows and beta might be several million. The
'term' is indexed. Will the database really be doing a select in beta for
every single line in alpha?

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ONLY phrase in FTS4

[E. Timothy Uy]

Hi, if I am using the Porter tokenizer in FTS4 and want an exact "stemmed"
match, how would I proceed?  For example, I am if I am looking for
"completed missions" -> "complet mission", I don't want "American completed
missions".  Is it possible?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] MATCH multiple

[E. Timothy Uy]

I recently switched a table to FTS4. Usually I query this table using the
IN operator, e.g.,

   SELECT * FROM Table WHERE term IN (a,b,c)

If I want to use MATCH, is my only option

   SELECT * FROM Table WHERE term MATCH 'a or b or c'

or is there an equivalent to IN?

Much obliged.

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to get SQLite 4 source?

[E. Timothy Uy]

Hi Darren,

1. Install Fossil - http://www.fossil-scm.org.
2. At a command prompt or console, 'fossil clone
http://www.sqlite.org/src4sqlite4.fossil'.
3. (Not sure if this the "right" way) From here I usually 'mkdir
sqlite4_src', 'cd sqlite_src', then 'fossil open ../sqlite4.fossil'

Respectfully,
Tim




On Fri, Jun 29, 2012 at 9:50 PM, Darren Duncan wrote:

> Forgive me if I seem dense, but from http://www.sqlite.org/src4/**
> doc/trunk/www/index.wikiand
>  elsewhere on
> sqlite.org, though I can see individual source files, I don't see any
> place to get the whole SQLite 4 source at once, either as a tarball or
> version control instructions. So where do we go to actually download and
> play with it? -- Darren Duncan
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite4 (don't scream)

[E. Timothy Uy]

That's kind of cool, but how about $twentyseven!


> On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers 
> wrote:
>
> > Aghhh (just kidding)
> >
> > One request for a change - make bind and column start with the same
> index.
> > I always have to look up which one is zero based and which one is one
> based.
> >
>
> Right now, porting an app from SQLite3 to SQLite4 is mostly a global
> search/replace of "sqlite3"->"sqlite4".  (Maybe a little more than
> thatbut not
> much.)  Changing the index base for sqlite4_bind would really
> complicate matters.
>
> Recommend you not use sqlite4_bind() directly, but rather us named
> parameters (ex: "@one", ":two", "$three") with
> sqlite4_bind_parameter_index():
>
>sqlite4_bind_int(pStmt, sqlite4_bind_parameter_index(pStmt, "$three"),
> 3);
>
> That way, you never have to worry about miscounting the "?" parameters in
> your query and being off-by-one in your bindings.
>
>
> >
> > Rob
> >
> >
> > On 6/28/2012 10:57 AM, Simon Slavin wrote:
> >
> >> First, the important bit:
> >>
> >> "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is
> >> not going away."
> >>
> >> Now the URL:
> >>
> >>  http://www.sqlite.org/src4/doc/trunk/www/design.wiki>
> >> >
> >>
> >> Just thought some people might enjoy reading and thinking about it.
> >>
> >> Simon.
> >> __**_
> >> sqlite-users mailing list
> >> sqlite-users@sqlite.org
> >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
> >>
> >
> >
> > __**_
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Okapi BM25

[E. Timothy Uy]

Hi, I'm interested in integrating the Okapi BM25 ranking procedure into my
SQLite. Has anyone done this already?

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I consider this a bug. Anyone else?

[E. Timothy Uy]

" 40-80 hours digging deep into how System.Data.SQLite.dll is built "

Lol, I actually did this.

On Tue, Jun 26, 2012 at 11:00 AM, Andrew Rondeau
wrote:

> The answer of "just add sqlite.c to your project" is great when you're
> making something in C. The entire world does not use C, nor is C (or
> C++) always the best option for a particular project.
>
> Timothy Uy's offer actually makes a lot of sense if you're using
> something other then C or C++.
>
> For example, I just can't ship a .Net .exe that uses x-copy
> deployment, and runs on Linux/Mac (via Mono) unless I invest about
> 40-80 hours digging deep into how System.Data.SQLite.dll is built.
>
> On Tue, Jun 26, 2012 at 9:10 AM, Simon Slavin 
> wrote:
> >
> > On 26 Jun 2012, at 4:55pm, bi...@aol.com wrote:
> >
> >> Thank you everyone who took the time to comment on my Windows DLL
>  question.
> >> I'm also glad I'm not the only one who sees the problem with not  having
> >> the version in the resource block. This really would have helped when
>  Chrome
> >> and Firefox updated to a new version of SQLite and all my code stopped
> >> working.
> >
> > This is the reason you will see so many posts here telling you to build
> SQLite into your application instead of using a DLL.  Then you are not
> subject to the choices of any other person with code on your users'
> computers.  SQLite purposely issued a compact and simple amalgamation
> version of the source code especially to make this fast and simple.
> >
> > Simon.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I consider this a bug. Anyone else?

[E. Timothy Uy]

Bill, Andrew, PA Newsgroups et al.,

Would you be willing to invest in a subscription for a compiled, signed,
non-Debug, Windows-deployed SQLite DLL with resource information? We would
consider compiling and hosting the files for you. In addition, we could
offer improved stemming (multiple languages) as well as encrypted and/or
compressed databases.

Respectfully,
Tim

On Tue, Jun 26, 2012 at 12:10 AM, Roger Binns  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 25/06/12 23:38, Andrew Rondeau wrote:
> > Because my time is valuable;
>
> I'm still baffled why you think adding one source file to your project is
> a huge undertaking, but somehow getting a "community" going, debating how
> you want things, fiddling around, testing, waiting for releases to
> packaged differently etc is not.
>
> > For example, if I make a Mac application, I can target the SQLites
> > shipped with Mac. Problem solved, my valuable time can go to something
> > else.
>
> Except the version of SQLite differs between MacOS releases so you have to
> code and test against different revisions of the SQLite library.  Or you
> include one file statically into your app and it is the only one you have
> to test against.  And it can be the same version as you use on other
> platforms lessening the development and testing even more.
>
> Of course you don't have to listen to the several people who have
> repeatedly been telling you that what you wanted is the most time
> consuming and most brittle way of doing things.  However you will note
> that so far there have been zero people clamouring to form some sort of
> community for what you stated.  Good luck!
>
> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAk/pYE8ACgkQmOOfHg372QTEOwCg4IU49+Y/emng7oJY6Qu8vOka
> BiUAoLt1o0uZW/tjxWah0jyi0MkgfFer
> =idVg
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd insertion error FTS4 + ICU

[E. Timothy Uy]

Dear Dan,

With the change from U8_NEXT to U16_NEXT, I am able to insert 一日耶羅波安出. I
was also able to insert the rest of the data set (about 31000 more rows
containing both traditional and simplified Chinese). Is this an ICU error?
Seems like everything should be using U8_ in the tokenizer.

Thank you much.

Respectfully,
Tim


On Mon, Jun 18, 2012 at 2:20 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> I'll take a look right now. Though my first thought was if you change
> U8_NEXT to U16_NEXT, wouldn't you have to change it everywhere else?  I
> recompiled ICU with U_CHARSET_IS_UTF8 earlier and this did not help.
>
>
> On Mon, Jun 18, 2012 at 2:06 PM, Dan Kennedy <danielk1...@gmail.com>wrote:
>
>> On 06/19/2012 03:39 AM, E. Timothy Uy wrote:
>> > If anyone can unravel this mystery, it would be much appreciated. For
>> now,
>> > I inserted a comma - 一日、耶羅波安出 and it works. I suspect it must be somehow
>> > that the sequence of bytes encodes another character, which throws the
>> > tokenizer out of whack or maybe the fts4aux table.
>>
>> Can you try with this:
>>
>>  http://www.sqlite.org/src/info/892b74116a
>>
>> Thanks.
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd insertion error FTS4 + ICU

[E. Timothy Uy]

I'll take a look right now. Though my first thought was if you change
U8_NEXT to U16_NEXT, wouldn't you have to change it everywhere else?  I
recompiled ICU with U_CHARSET_IS_UTF8 earlier and this did not help.

On Mon, Jun 18, 2012 at 2:06 PM, Dan Kennedy <danielk1...@gmail.com> wrote:

> On 06/19/2012 03:39 AM, E. Timothy Uy wrote:
> > If anyone can unravel this mystery, it would be much appreciated. For
> now,
> > I inserted a comma - 一日、耶羅波安出 and it works. I suspect it must be somehow
> > that the sequence of bytes encodes another character, which throws the
> > tokenizer out of whack or maybe the fts4aux table.
>
> Can you try with this:
>
>  http://www.sqlite.org/src/info/892b74116a
>
> Thanks.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd insertion error FTS4 + ICU

[E. Timothy Uy]

If anyone can unravel this mystery, it would be much appreciated. For now,
I inserted a comma - 一日、耶羅波安出 and it works. I suspect it must be somehow
that the sequence of bytes encodes another character, which throws the
tokenizer out of whack or maybe the fts4aux table.

一
19968
%E4%B8%80
日
26085
%E6%97%A5
耶
32822
%E8%80%B6
羅
32645
%E7%BE%85
波
27874
%E6%B3%A2
安
23433
%E5%AE%89
出
20986
%E5%87%BA


On Mon, Jun 18, 2012 at 12:59 PM, E. Timothy Uy <t...@loqu8.com> wrote:

> Thanks for writing back Dan. Using charCodeAt() in Javascript, I have the
> following for 一日耶羅波安出:
>
> 19968
> 26085
> 32822
> 32645
> 27874
> 23433
> 20986
>
> I tried entering subsets of the data:
>
> 一日耶羅波安出 - Error: SQL logic error or missing database <-- target
> 一日耶羅波安 - Ok
> 日耶羅波安出 - Ok
> 耶羅波安出 - Ok
> 一日耶羅波安出x - Error: SQL logic error or missing database
> 一日耶羅波安x出 - Error: SQL logic error or missing database
> 一日耶羅波x安出 - Error: SQL logic error or missing database
> 一日耶羅x波安出 - Ok
> 一日耶x羅波安出 - Ok
> 一日x耶羅波安出 - Ok
> 一x日耶羅波安出 - Ok
> x一日耶羅波安出 - Ok
>
> I'm a bit concerned that this might be an indicator for a deeper issue.
> Running Ubuntu Linux x64.
>
> Respectfully,
> Tim
>
>
> On Mon, Jun 18, 2012 at 12:29 PM, Dan Kennedy <danielk1...@gmail.com>wrote:
>
>> On 06/19/2012 02:11 AM, E. Timothy Uy wrote:
>> > I recompiled ICU using U_CHARSET_IS_UTF8 and the error persists.
>> >
>> > On Mon, Jun 18, 2012 at 11:45 AM, E. Timothy Uy<t...@loqu8.com>  wrote:
>> >
>> >> Hopefully someone has some insight on this. I am using FTS4 with
>> >> tokenize=icu (and PRAGMA encoding="UTF-8"). I'm getting getting an
>> error
>> >> inserting the following into my virtual table:
>> >>
>> >> 一日耶羅波安出
>>
>> Can you post the list of codepoints in this text? Or the hex
>> of the utf-16 or utf-8 encoding of the same?
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd insertion error FTS4 + ICU

[E. Timothy Uy]

Thanks for writing back Dan. Using charCodeAt() in Javascript, I have the
following for 一日耶羅波安出:

19968
26085
32822
32645
27874
23433
20986

I tried entering subsets of the data:

一日耶羅波安出 - Error: SQL logic error or missing database <-- target
一日耶羅波安 - Ok
日耶羅波安出 - Ok
耶羅波安出 - Ok
一日耶羅波安出x - Error: SQL logic error or missing database
一日耶羅波安x出 - Error: SQL logic error or missing database
一日耶羅波x安出 - Error: SQL logic error or missing database
一日耶羅x波安出 - Ok
一日耶x羅波安出 - Ok
一日x耶羅波安出 - Ok
一x日耶羅波安出 - Ok
x一日耶羅波安出 - Ok

I'm a bit concerned that this might be an indicator for a deeper issue.
Running Ubuntu Linux x64.

Respectfully,
Tim


On Mon, Jun 18, 2012 at 12:29 PM, Dan Kennedy <danielk1...@gmail.com> wrote:

> On 06/19/2012 02:11 AM, E. Timothy Uy wrote:
> > I recompiled ICU using U_CHARSET_IS_UTF8 and the error persists.
> >
> > On Mon, Jun 18, 2012 at 11:45 AM, E. Timothy Uy<t...@loqu8.com>  wrote:
> >
> >> Hopefully someone has some insight on this. I am using FTS4 with
> >> tokenize=icu (and PRAGMA encoding="UTF-8"). I'm getting getting an error
> >> inserting the following into my virtual table:
> >>
> >> 一日耶羅波安出
>
> Can you post the list of codepoints in this text? Or the hex
> of the utf-16 or utf-8 encoding of the same?
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd insertion error FTS4 + ICU

[E. Timothy Uy]

I recompiled ICU using U_CHARSET_IS_UTF8 and the error persists.

On Mon, Jun 18, 2012 at 11:45 AM, E. Timothy Uy <t...@loqu8.com> wrote:

> Hopefully someone has some insight on this. I am using FTS4 with
> tokenize=icu (and PRAGMA encoding="UTF-8"). I'm getting getting an error
> inserting the following into my virtual table:
>
> 一日耶羅波安出
>
> If I add a byte to the front, lets say "|", it works. If I delete the
> first character, or delete the last, it works too. If I add more
> characters, it doesn't work. Seems like it is an encoding issue, and I
> wonder if it isn't because ICU is using UTF-16 internally.  This is a
> 1/31000 problem but aggravating nonetheless. If I don't use tokenize=icu it
> works.
>
> The error is SQLITE_ERROR: SQL logic error or missing database.
>
> Respectfully,
> Tim
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Odd insertion error FTS4 + ICU

[E. Timothy Uy]

Hopefully someone has some insight on this. I am using FTS4 with
tokenize=icu (and PRAGMA encoding="UTF-8"). I'm getting getting an error
inserting the following into my virtual table:

一日耶羅波安出

If I add a byte to the front, lets say "|", it works. If I delete the first
character, or delete the last, it works too. If I add more characters, it
doesn't work. Seems like it is an encoding issue, and I wonder if it isn't
because ICU is using UTF-16 internally.  This is a 1/31000 problem but
aggravating nonetheless. If I don't use tokenize=icu it works.

The error is SQLITE_ERROR: SQL logic error or missing database.

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] updating config.guess and config.sub

[E. Timothy Uy]

Hi, while compiling for Android, I ran into the issue where
arm-linux-androideabi is not recognized as a host.  Apparently there is an
updated version of config.guess and config.sub (from AutoTools) that
addresses this issue. Recommend an update of these two files in the next
version.

In case anyone runs into this the bleeding edge is available here:
http://git.savannah.gnu.org/gitweb/?p=config.git;a=tree

Respectfully,
Tim
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users