On 11/13/2016 07:04 PM, Jan Berkel wrote:
Got a crash in the FTS5 code which only happens on a specific search
query (int the form of: "ab cd" OR "ab cd" *)
The crash occurs In fts5MultiIterNext(), on the following line:
pSeg->xNext(p, pSeg, &bNewTerm);
Debugger shows that pSeg is set, but xN
Friday, November 11, 2016, 9:00:36 PM, you wrote:
Ok, thanks!
> Encryption in system.data.sqlite is legacy encryption, only used within
> itself, and not with other applications.
> On Fri, Nov 11, 2016 at 6:24 PM, Richard Andersen wrote:
>>
>>
>> I'm using the ADO.NET version (System.Data.SQli
An out-of-the-box question: why do you need to have pages at all? I as a
user never cared about the exact page a result was on.
Take a look at http://use-the-index-luke.com/no-offset which explains how
to do keyset pagination.
You can also get the total amount of results until a given row by doin
On 14 Nov 2016, at 7:23am, Mike King wrote:
> Thanks. In answer to your question a page of results is displayed in a grid
> on the screen. The user selects a row. If they then change the sort order I
> want to show the page that contains the selected row (and reselect it).
> Each row has a uniqu
Hello Mike,
What I do is I note the currently selected ID prior to the sort, then
sort using a query and return the ID's in the new sorted order. Then
in the program I search for the ID and display the selected line again
in my list control. Basically, I maintain in memory a complete list of
the
Sunday, November 13, 2016, 2:16:40 PM, you wrote:
Thanks. Well what I've done is to create an encrypted database with
SQLite2009 and then use that in my C# project. I just add the password to
the connection string in my app and then it works right away. As far as
I understand (I'm new to all this)
Richard,
> Well what I've done is to create an encrypted database with
> SQLite2009 and then use that in my C# project. I just add the password to
> the connection string in my app and then it works right away.
According to the information on the SQLite2009 website
(http://sqlite2009pro.azureweb
On 11/14/2016 2:23 AM, Mike King wrote:
Thanks. In answer to your question a page of results is displayed in a grid
on the screen. The user selects a row. If they then change the sort order I
want to show the page that contains the selected row (and reselect it).
Each row has a unique ID and i ne
> On Nov 14, 2016, at 7:23 AM, Ulrich Telle wrote:
>
> The RSA encryption offered by System.Data.SQLite should not be used, if
> security is a concern for you. You should prefer an AES encryption scheme.
I’m surprised anything encrypts databases with RSA, as that algorithm is pretty
unsuitabl
On Thu, Nov 10, 2016 at 11:52 AM, Richard Hipp wrote:
> On 11/10/16, pisymbol . wrote:
> > sqlite-3.6.20-1.el6_7.2.i686
> > sqlite-3.6.20-1.el6_7.2.x86_64
>
> Are you aware that SQLite 3.6.20 was published over 7 years ago on
> 2009-11-04 and that there have been 82 subsequent releases of SQLite
On Mon, Nov 14, 2016 at 12:14 PM, pisymbol . wrote:
>
>
> On Thu, Nov 10, 2016 at 11:52 AM, Richard Hipp wrote:
>
>> On 11/10/16, pisymbol . wrote:
>> > sqlite-3.6.20-1.el6_7.2.i686
>> > sqlite-3.6.20-1.el6_7.2.x86_64
>>
>> Are you aware that SQLite 3.6.20 was published over 7 years ago on
>> 2
> > On Nov 14, 2016, at 7:23 AM, Ulrich Telle wrote:
> >
> > The RSA encryption offered by System.Data.SQLite should not be used,
> > if security is a concern for you. You should prefer an AES encryption
> > scheme.
>
> I’m surprised anything encrypts databases with RSA, as that algorithm
> is p
I am very interested in the answer to this question. Currently it seems
like the only way to get multiple connection to the in-memory db is with
'cache=shared' and I understand that subsequent connections opened to that
memory database are Read/Write regardless of whether the new connections
are o
On 14 Nov 2016, at 7:38pm, Daniel Meyer wrote:
> I am very interested in the answer to this question. Currently it seems
> like the only way to get multiple connection to the in-memory db is with
> 'cache=shared' and I understand that subsequent connections opened to that
> memory database are
On Mon, Nov 14, 2016 at 12:38 PM, pisymbol . wrote:
>
>
> On Mon, Nov 14, 2016 at 12:14 PM, pisymbol . wrote:
>
>>
>>
>> On Thu, Nov 10, 2016 at 11:52 AM, Richard Hipp wrote:
>>
>>> On 11/10/16, pisymbol . wrote:
>>> > sqlite-3.6.20-1.el6_7.2.i686
>>> > sqlite-3.6.20-1.el6_7.2.x86_64
>>>
>>> A
On 11/14/16, Daniel Meyer wrote:
>
> Is the right approach to write a custom VFS?
>
https://www.sqlite.org/src/artifact/e5225bc22e79dde6
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://maili
In SQLiteFunction.cs :
internal static bool UnbindAllFunctions(...
...
else
{
//
// NOTE: Need to use a copy of the function dictionary in
this method
// because the dictionary is modified within the
UnbindFunction
//
Can you move project to different hardware?
On Mon, Nov 14, 2016 at 3:02 PM, pisymbol . wrote:
> On Mon, Nov 14, 2016 at 12:38 PM, pisymbol . wrote:
>
> >
> >
> > On Mon, Nov 14, 2016 at 12:14 PM, pisymbol . wrote:
> >
> >>
> >>
> >> On Thu, Nov 10, 2016 at 11:52 AM, Richard Hipp wrote:
> >>
On Mon, Nov 14, 2016 at 5:13 PM, Stephen Chrzanowski
wrote:
> Can you move project to different hardware?
>
Nope.
Here's at least one stack trace:
#0 sqlite3VdbeUsesBtree (yyp=0x7fffec013a28, yymajor=1, yyminor=...,
pParse=) at sqlite3.c:71844
#1 sqlite3FinishCoding (yyp=0x7fffec013a28, yyma
On 15 Nov 2016, at 1:18am, pisymbol . wrote:
> Obviously, I must be doing something
> wrong
Yep. You're using a 7 year old version of the library.
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.o
On Mon, Nov 14, 2016 at 8:19 PM, Simon Slavin wrote:
>
> On 15 Nov 2016, at 1:18am, pisymbol . wrote:
>
> > Obviously, I must be doing something
> > wrong
>
> Yep. You're using a 7 year old version of the library.
>
That crash is from me statically linking aginst 3.15-1! Same thing, so
obvious
On Mon, Nov 14, 2016 at 8:26 PM, pisymbol . wrote:
>
>
> On Mon, Nov 14, 2016 at 8:19 PM, Simon Slavin
> wrote:
>
>>
>> On 15 Nov 2016, at 1:18am, pisymbol . wrote:
>>
>> > Obviously, I must be doing something
>> > wrong
>>
>> Yep. You're using a 7 year old version of the library.
>>
>
> That
On Mon, 14 Nov 2016 20:30:57 -0500
"pisymbol ." wrote:
> One last thing: This is during initialization and I access the
> database through that query several times before hitting this crash.
>
> I thought it was memory corruption but it always the same line.
Trying to be helpful, even if it doe
The virtual table approach works very well for us here. Unfortunately it is all
proprietary code, so I can share only a basic description.
Bottom layer is an abstraction layer that provides an interface to some form of
shared memory (BSD, SysV or Posix or even a memory-mapped file); This provide
24 matches
Mail list logo