Re: [sqlite] A Potential Bug

2014-07-15 Thread David Empson 
In this case, sqlite3VdbeAllocUnpackedRecord is called with pSpace = 0 and 
szSpace = 0.

The calculated value of nOff will also be 0, since pSpace is 0. nByte must be 
greater than zero, as it is the sum of two positive terms.

Therefore the test "if( nByte>szSpace+nOff )" will be true, and the code path 
taken will allocate memory.

Not a bug.

On 16/07/2014, at 1:31 pm, Dongpeng Xu  wrote:

> Hi, all,
> 
> I am using our automatic bug finding tool to scan the source code of
> sqlite. The tool is designed to find potential null dereference bug. It
> issues warning for the function sqlite3VdbeAllocUnpackedRecord.
> 
> SQLITE_PRIVATE UnpackedRecord *sqlite3VdbeAllocUnpackedRecord(
>  KeyInfo *pKeyInfo,  /* Description of the record */
>  char *pSpace,   /* Unaligned space available */
>  int szSpace,/* Size of pSpace[] in bytes */
>  char **ppFree   /* OUT: Caller should free this pointer */
> ){
>  UnpackedRecord *p;  /* Unpacked record to return */
>  int nOff;   /* Increment pSpace by nOff to align it */
>  int nByte;  /* Number of bytes required for *p */
> 
>  /* We want to shift the pointer pSpace up such that it is 8-byte aligned.
>  ** Thus, we need to calculate a value, nOff, between 0 and 7, to shift
>  ** it by.  If pSpace is already 8-byte aligned, nOff should be zero.
>  */
>  nOff = (8 - (SQLITE_PTR_TO_INT(pSpace) & 7)) & 7;
>  nByte = ROUND8(sizeof(UnpackedRecord)) + sizeof(Mem)*(pKeyInfo->nField+1);
>  if( nByte>szSpace+nOff ){
>p = (UnpackedRecord *)sqlite3DbMallocRaw(pKeyInfo->db, nByte);
>*ppFree = (char *)p;
>if( !p ) return 0;
>  }else{
>p = (UnpackedRecord*)&pSpace[nOff];
>*ppFree = 0;
>  }
> 
>  p->aMem = (Mem*)&((char*)p)[ROUND8(sizeof(UnpackedRecord))];
>  assert( pKeyInfo->aSortOrder!=0 );
>  p->pKeyInfo = pKeyInfo;
>  p->nField = pKeyInfo->nField + 1;
>  return p;
> }
> 
> The suspicious context is in the function sqlite3VdbeSorterInit, it calls
> sqlite3VdbeAllocUnpackedRecord as below:
> pSorter->pUnpacked = sqlite3VdbeAllocUnpackedRecord(pCsr->pKeyInfo, 0, 0,
> &d);
> 
> The second and third parameters are set to zero. However, in
> sqlite3VdbeAllocUnpackedRecord, p is set to pSpace + nOff if nByte <=
> szSpace + nOff and will be dereferenced later.
> 
> I am wondering whether this is a real bug. Is there a concrete execution
> path that reach the dereference point? Any comments are welcome. Thanks!
> 
> Sincerely,
> Dongpeng

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

[sqlite] A Potential Bug

2014-07-15 Thread Dongpeng Xu 
Hi, all,

I am using our automatic bug finding tool to scan the source code of
sqlite. The tool is designed to find potential null dereference bug. It
issues warning for the function sqlite3VdbeAllocUnpackedRecord.

SQLITE_PRIVATE UnpackedRecord *sqlite3VdbeAllocUnpackedRecord(
  KeyInfo *pKeyInfo,  /* Description of the record */
  char *pSpace,   /* Unaligned space available */
  int szSpace,/* Size of pSpace[] in bytes */
  char **ppFree   /* OUT: Caller should free this pointer */
){
  UnpackedRecord *p;  /* Unpacked record to return */
  int nOff;   /* Increment pSpace by nOff to align it */
  int nByte;  /* Number of bytes required for *p */

  /* We want to shift the pointer pSpace up such that it is 8-byte aligned.
  ** Thus, we need to calculate a value, nOff, between 0 and 7, to shift
  ** it by.  If pSpace is already 8-byte aligned, nOff should be zero.
  */
  nOff = (8 - (SQLITE_PTR_TO_INT(pSpace) & 7)) & 7;
  nByte = ROUND8(sizeof(UnpackedRecord)) + sizeof(Mem)*(pKeyInfo->nField+1);
  if( nByte>szSpace+nOff ){
p = (UnpackedRecord *)sqlite3DbMallocRaw(pKeyInfo->db, nByte);
*ppFree = (char *)p;
if( !p ) return 0;
  }else{
p = (UnpackedRecord*)&pSpace[nOff];
*ppFree = 0;
  }

  p->aMem = (Mem*)&((char*)p)[ROUND8(sizeof(UnpackedRecord))];
  assert( pKeyInfo->aSortOrder!=0 );
  p->pKeyInfo = pKeyInfo;
  p->nField = pKeyInfo->nField + 1;
  return p;
}

The suspicious context is in the function sqlite3VdbeSorterInit, it calls
sqlite3VdbeAllocUnpackedRecord as below:
pSorter->pUnpacked = sqlite3VdbeAllocUnpackedRecord(pCsr->pKeyInfo, 0, 0,
&d);

The second and third parameters are set to zero. However, in
sqlite3VdbeAllocUnpackedRecord, p is set to pSpace + nOff if nByte <=
szSpace + nOff and will be dereferenced later.

I am wondering whether this is a real bug. Is there a concrete execution
path that reach the dereference point? Any comments are welcome. Thanks!

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread Will Parsons 
mm.w wrote:
>>
Can someone please get this a*h*l* banned?

-- 
Will

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

Re: [sqlite] Setting boundaries in a search

2014-07-15 Thread Simon Slavin 

> On 16 Jul 2014, at 3:21am, jose isaias cabrera  wrote:
> 
> SELECT * from startcodes where code = 'e';
> 
> but I want to search only from id >= 8 and <= 14.  Is there a way to set the 
> boundary for that SELECT that will only search ids 8-14?  I know I can do a 
> WHERE id BETWEEN 8 AND 14, but is there another faster way?

That way is not particularly slow.  You just need to have a good index.  A good 
index for that search would be

CREATE INDEX sci ON startcodes (code,id)

You will find that that SELECT will then be blisteringly fast even with 
millions of rows in your table.

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

Re: [sqlite] Setting boundaries in a search

2014-07-15 Thread Igor Tandetnik 

On 7/15/2014 10:21 PM, jose isaias cabrera wrote:

SELECT * from startcodes where code = 'e';

but I want to search only from id >= 8 and <= 14.


Just say so:

SELECT * from startcodes where code = 'e' and id between 8 and 14;


I know I
can do a WHERE id BETWEEN 8 AND 14, but is there another faster way?


So you already know the answer. How exactly does it fail to satisfy your 
requirements?

--
Igor Tandetnik

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

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Edward Ned Harvey (sqlite) 
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
> 
> Which does /not/ describe it as "The official SQLite database engine", which
> is the point I was making.

I used NuGet.
http://www.nuget.org/packages/System.Data.SQLite.Core/
"The official SQLite database engine" published by "SQLite Development Team"

Anyway, thanks for the answers everyone.  I'm happy to move on from this 
topic...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Setting boundaries in a search

2014-07-15 Thread jose isaias cabrera 


Greetings.

Pardon the newbie question, but is there a way to set boundaries on a 
search?  Imagine this scenario:

startcodes
id,code,date
1,a,2014-08-06
2,b,2014-08-06
3,z,2014-08-06
4,g,2014-08-06
5,g,2014-08-06
6,j,2014-08-06
7,p,2014-08-06
8,t,2014-08-06
9,e,2014-08-06
10,w,2014-08-06
11,w,2014-08-06
12,y,2014-08-06
13,m,2014-08-06
14,o,2014-08-06
15,o,2014-08-06
16,p,2014-08-06
17,u,2014-08-06
18,u,2014-08-06
19,a,2014-08-06
20,a,2014-08-06

SELECT * from startcodes where code = 'e';

but I want to search only from id >= 8 and <= 14.  Is there a way to set the 
boundary for that SELECT that will only search ids 8-14?  I know I can do a 
WHERE id BETWEEN 8 AND 14, but is there another faster way?


thanks.

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
and yes I don't spit in a face of someone, then selling my so good
"reputation" you are  joke rsmith and you would dare any of the crap face
to face sorry truth must be told and I did not started this shit for the
record.


On Tue, Jul 15, 2014 at 5:39 PM, mm.w <0xcafef...@gmail.com> wrote:

> if you want some hint about google mail I can provide you, I could even
> ask for my username change without any loss
>
>
> On Tue, Jul 15, 2014 at 5:37 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> yes because I have nothing to hide, if you wish to block me so be it, no
>> offense taken, do it and we can share a beer anytime.
>>
>>
>> On Tue, Jul 15, 2014 at 5:35 PM, Scott Robison 
>> wrote:
>>
>>> You stay public even when it is annoying the entire list? I don't
>>> suppose a
>>> request to temporarily block him from the list would do any good, would
>>> it?
>>> May be time to investigate how to get gmail to block specific addresses.
>>>
>>>
>>> On Tue, Jul 15, 2014 at 6:34 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
>>> > and I stay public even it looks weird, but seriously grew up and fast
>>> > kiddo.
>>> >
>>> >
>>> > On Tue, Jul 15, 2014 at 5:21 PM, mm.w <0xcafef...@gmail.com> wrote:
>>> >
>>> > > yes where arethe social kills? telling crap loooking a like a
>>> queenie?
>>> > > just work on tv man not real life.
>>> > >
>>> > >
>>> > > On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote:
>>> > >
>>> > >> almost 2 hours of of unbelievable crap seriously?  just for
>>> accusing me
>>> > >> of bad behaviors towards Simon on a topic you don't even know? sorry
>>> > again.
>>> > >>
>>> > >>
>>> > >> On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:
>>> > >>
>>> > >>> I thought you were a good person... seriously? what it is your
>>> issue
>>> > >>> with just telling the truth, I am the first person here to say I am
>>> > full of
>>> > >>> shit, sorry for the derogatory language but that's fact get back on
>>> > your
>>> > >>> feet man!
>>> > >>>
>>> > >>>
>>> > >>> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com>
>>> wrote:
>>> > >>>
>>> >  oh boy
>>> > 
>>> > 
>>> >  On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com>
>>> wrote:
>>> > 
>>> > > and moreover you bluntly lie 
>>> > >
>>> > >
>>> > > On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com>
>>> wrote:
>>> > >
>>> > >> I am sorry I am jocking but you 'r calling of for white flag
>>> and use
>>> > >> it to charge again.
>>> > >>
>>> > >>
>>> > >> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com>
>>> wrote:
>>> > >>
>>> > >>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I
>>> give
>>> > >>> a try 8D
>>> > >>>
>>> > >>>
>>> > >>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com>
>>> > wrote:
>>> > >>>
>>> >  I already accepted your apologies why don't you give some air
>>> >  simply? instead of poisoning the actual lame situation?
>>> > 
>>> > 
>>> >  On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com>
>>> > wrote:
>>> > 
>>> > > am not else you don't understand one single line of my
>>> previous
>>> > > comments, you are just pissed off and not able to calling off
>>> > thing I did
>>> > >
>>> > >
>>> > > On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com>
>>> > > wrote:
>>> > >
>>> > >> you dare to affirm that I affirm , I
>>> > >>
>>> > >>
>>> > >> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com
>>> >
>>> > >> wrote:
>>> > >>
>>> > >>> hello, if you think so, I have noting to say to you,
>>> because
>>> > you
>>> > >>> already made your judgement without giving a right of
>>> answer,
>>> > so be it.
>>> > >>>
>>> > >>>
>>> > >>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith <
>>> rsm...@rsweb.co.za>
>>> > >>> wrote:
>>> > >>>
>>> > 
>>> >  On 2014/07/16 00:03, mm.w wrote:
>>> > 
>>> > > And to finally be clear I am a plain guy I don't hide
>>> behind
>>> > > the curtain like you lamely try, that's public and solely
>>> > addressed to
>>> > > you//..
>>> > >
>>> > 
>>> >  I'd really like to not have another go at this thread, and
>>> >  again would like to apologise to the onlookers - but would
>>> > like to affirm
>>> >  that this is not a personal feud that spilt onto the
>>> forum, I
>>> > have to date
>>> >  not received a single mail from Mr. mm.w which did not
>>> also
>>> > reach the list
>>> >  - contrary to the insinuation. I think he may simply be
>>> > unaware he is/was
>>> >  posting to the list, for which I apologise too and ask to
>>> > please give him
>>> > >>>

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
if you want some hint about google mail I can provide you, I could even ask
for my username change without any loss


On Tue, Jul 15, 2014 at 5:37 PM, mm.w <0xcafef...@gmail.com> wrote:

> yes because I have nothing to hide, if you wish to block me so be it, no
> offense taken, do it and we can share a beer anytime.
>
>
> On Tue, Jul 15, 2014 at 5:35 PM, Scott Robison 
> wrote:
>
>> You stay public even when it is annoying the entire list? I don't suppose
>> a
>> request to temporarily block him from the list would do any good, would
>> it?
>> May be time to investigate how to get gmail to block specific addresses.
>>
>>
>> On Tue, Jul 15, 2014 at 6:34 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > and I stay public even it looks weird, but seriously grew up and fast
>> > kiddo.
>> >
>> >
>> > On Tue, Jul 15, 2014 at 5:21 PM, mm.w <0xcafef...@gmail.com> wrote:
>> >
>> > > yes where arethe social kills? telling crap loooking a like a queenie?
>> > > just work on tv man not real life.
>> > >
>> > >
>> > > On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote:
>> > >
>> > >> almost 2 hours of of unbelievable crap seriously?  just for accusing
>> me
>> > >> of bad behaviors towards Simon on a topic you don't even know? sorry
>> > again.
>> > >>
>> > >>
>> > >> On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:
>> > >>
>> > >>> I thought you were a good person... seriously? what it is your issue
>> > >>> with just telling the truth, I am the first person here to say I am
>> > full of
>> > >>> shit, sorry for the derogatory language but that's fact get back on
>> > your
>> > >>> feet man!
>> > >>>
>> > >>>
>> > >>> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:
>> > >>>
>> >  oh boy
>> > 
>> > 
>> >  On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com>
>> wrote:
>> > 
>> > > and moreover you bluntly lie 
>> > >
>> > >
>> > > On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com>
>> wrote:
>> > >
>> > >> I am sorry I am jocking but you 'r calling of for white flag and
>> use
>> > >> it to charge again.
>> > >>
>> > >>
>> > >> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com>
>> wrote:
>> > >>
>> > >>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I
>> give
>> > >>> a try 8D
>> > >>>
>> > >>>
>> > >>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com>
>> > wrote:
>> > >>>
>> >  I already accepted your apologies why don't you give some air
>> >  simply? instead of poisoning the actual lame situation?
>> > 
>> > 
>> >  On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com>
>> > wrote:
>> > 
>> > > am not else you don't understand one single line of my
>> previous
>> > > comments, you are just pissed off and not able to calling off
>> > thing I did
>> > >
>> > >
>> > > On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com>
>> > > wrote:
>> > >
>> > >> you dare to affirm that I affirm , I
>> > >>
>> > >>
>> > >> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com>
>> > >> wrote:
>> > >>
>> > >>> hello, if you think so, I have noting to say to you, because
>> > you
>> > >>> already made your judgement without giving a right of
>> answer,
>> > so be it.
>> > >>>
>> > >>>
>> > >>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith > >
>> > >>> wrote:
>> > >>>
>> > 
>> >  On 2014/07/16 00:03, mm.w wrote:
>> > 
>> > > And to finally be clear I am a plain guy I don't hide
>> behind
>> > > the curtain like you lamely try, that's public and solely
>> > addressed to
>> > > you//..
>> > >
>> > 
>> >  I'd really like to not have another go at this thread, and
>> >  again would like to apologise to the onlookers - but would
>> > like to affirm
>> >  that this is not a personal feud that spilt onto the
>> forum, I
>> > have to date
>> >  not received a single mail from Mr. mm.w which did not also
>> > reach the list
>> >  - contrary to the insinuation. I think he may simply be
>> > unaware he is/was
>> >  posting to the list, for which I apologise too and ask to
>> > please give him
>> >  the benefit of the doubt and excuse the thread.
>> > 
>> >  Mm.w, Sir, I guarantee you I have not a single hard
>> feeling,
>> > we
>> >  all have bad days, but please take this off-list hence.
>> > 
>> >  Thank you kindly
>> >  Ryan
>> > 
>> > 
>> > >>>
>> > >>
>> > >
>> > 
>> > >>>
>> > >>
>> > >
>> > 
>> > >>>
>> > >>
>> >

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
yes because I have nothing to hide, if you wish to block me so be it, no
offense taken, do it and we can share a beer anytime.


On Tue, Jul 15, 2014 at 5:35 PM, Scott Robison 
wrote:

> You stay public even when it is annoying the entire list? I don't suppose a
> request to temporarily block him from the list would do any good, would it?
> May be time to investigate how to get gmail to block specific addresses.
>
>
> On Tue, Jul 15, 2014 at 6:34 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > and I stay public even it looks weird, but seriously grew up and fast
> > kiddo.
> >
> >
> > On Tue, Jul 15, 2014 at 5:21 PM, mm.w <0xcafef...@gmail.com> wrote:
> >
> > > yes where arethe social kills? telling crap loooking a like a queenie?
> > > just work on tv man not real life.
> > >
> > >
> > > On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote:
> > >
> > >> almost 2 hours of of unbelievable crap seriously?  just for accusing
> me
> > >> of bad behaviors towards Simon on a topic you don't even know? sorry
> > again.
> > >>
> > >>
> > >> On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:
> > >>
> > >>> I thought you were a good person... seriously? what it is your issue
> > >>> with just telling the truth, I am the first person here to say I am
> > full of
> > >>> shit, sorry for the derogatory language but that's fact get back on
> > your
> > >>> feet man!
> > >>>
> > >>>
> > >>> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:
> > >>>
> >  oh boy
> > 
> > 
> >  On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:
> > 
> > > and moreover you bluntly lie 
> > >
> > >
> > > On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com>
> wrote:
> > >
> > >> I am sorry I am jocking but you 'r calling of for white flag and
> use
> > >> it to charge again.
> > >>
> > >>
> > >> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com>
> wrote:
> > >>
> > >>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I
> give
> > >>> a try 8D
> > >>>
> > >>>
> > >>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com>
> > wrote:
> > >>>
> >  I already accepted your apologies why don't you give some air
> >  simply? instead of poisoning the actual lame situation?
> > 
> > 
> >  On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com>
> > wrote:
> > 
> > > am not else you don't understand one single line of my previous
> > > comments, you are just pissed off and not able to calling off
> > thing I did
> > >
> > >
> > > On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com>
> > > wrote:
> > >
> > >> you dare to affirm that I affirm , I
> > >>
> > >>
> > >> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com>
> > >> wrote:
> > >>
> > >>> hello, if you think so, I have noting to say to you, because
> > you
> > >>> already made your judgement without giving a right of answer,
> > so be it.
> > >>>
> > >>>
> > >>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith 
> > >>> wrote:
> > >>>
> > 
> >  On 2014/07/16 00:03, mm.w wrote:
> > 
> > > And to finally be clear I am a plain guy I don't hide
> behind
> > > the curtain like you lamely try, that's public and solely
> > addressed to
> > > you//..
> > >
> > 
> >  I'd really like to not have another go at this thread, and
> >  again would like to apologise to the onlookers - but would
> > like to affirm
> >  that this is not a personal feud that spilt onto the forum,
> I
> > have to date
> >  not received a single mail from Mr. mm.w which did not also
> > reach the list
> >  - contrary to the insinuation. I think he may simply be
> > unaware he is/was
> >  posting to the list, for which I apologise too and ask to
> > please give him
> >  the benefit of the doubt and excuse the thread.
> > 
> >  Mm.w, Sir, I guarantee you I have not a single hard feeling,
> > we
> >  all have bad days, but please take this off-list hence.
> > 
> >  Thank you kindly
> >  Ryan
> > 
> > 
> > >>>
> > >>
> > >
> > 
> > >>>
> > >>
> > >
> > 
> > >>>
> > >>
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> Scott Robison
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/lis

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread Scott Robison 
You stay public even when it is annoying the entire list? I don't suppose a
request to temporarily block him from the list would do any good, would it?
May be time to investigate how to get gmail to block specific addresses.


On Tue, Jul 15, 2014 at 6:34 PM, mm.w <0xcafef...@gmail.com> wrote:

> and I stay public even it looks weird, but seriously grew up and fast
> kiddo.
>
>
> On Tue, Jul 15, 2014 at 5:21 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > yes where arethe social kills? telling crap loooking a like a queenie?
> > just work on tv man not real life.
> >
> >
> > On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote:
> >
> >> almost 2 hours of of unbelievable crap seriously?  just for accusing me
> >> of bad behaviors towards Simon on a topic you don't even know? sorry
> again.
> >>
> >>
> >> On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:
> >>
> >>> I thought you were a good person... seriously? what it is your issue
> >>> with just telling the truth, I am the first person here to say I am
> full of
> >>> shit, sorry for the derogatory language but that's fact get back on
> your
> >>> feet man!
> >>>
> >>>
> >>> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:
> >>>
>  oh boy
> 
> 
>  On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:
> 
> > and moreover you bluntly lie 
> >
> >
> > On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:
> >
> >> I am sorry I am jocking but you 'r calling of for white flag and use
> >> it to charge again.
> >>
> >>
> >> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:
> >>
> >>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give
> >>> a try 8D
> >>>
> >>>
> >>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com>
> wrote:
> >>>
>  I already accepted your apologies why don't you give some air
>  simply? instead of poisoning the actual lame situation?
> 
> 
>  On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com>
> wrote:
> 
> > am not else you don't understand one single line of my previous
> > comments, you are just pissed off and not able to calling off
> thing I did
> >
> >
> > On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com>
> > wrote:
> >
> >> you dare to affirm that I affirm , I
> >>
> >>
> >> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com>
> >> wrote:
> >>
> >>> hello, if you think so, I have noting to say to you, because
> you
> >>> already made your judgement without giving a right of answer,
> so be it.
> >>>
> >>>
> >>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith 
> >>> wrote:
> >>>
> 
>  On 2014/07/16 00:03, mm.w wrote:
> 
> > And to finally be clear I am a plain guy I don't hide behind
> > the curtain like you lamely try, that's public and solely
> addressed to
> > you//..
> >
> 
>  I'd really like to not have another go at this thread, and
>  again would like to apologise to the onlookers - but would
> like to affirm
>  that this is not a personal feud that spilt onto the forum, I
> have to date
>  not received a single mail from Mr. mm.w which did not also
> reach the list
>  - contrary to the insinuation. I think he may simply be
> unaware he is/was
>  posting to the list, for which I apologise too and ask to
> please give him
>  the benefit of the doubt and excuse the thread.
> 
>  Mm.w, Sir, I guarantee you I have not a single hard feeling,
> we
>  all have bad days, but please take this off-list hence.
> 
>  Thank you kindly
>  Ryan
> 
> 
> >>>
> >>
> >
> 
> >>>
> >>
> >
> 
> >>>
> >>
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
and I stay public even it looks weird, but seriously grew up and fast kiddo.


On Tue, Jul 15, 2014 at 5:21 PM, mm.w <0xcafef...@gmail.com> wrote:

> yes where arethe social kills? telling crap loooking a like a queenie?
> just work on tv man not real life.
>
>
> On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> almost 2 hours of of unbelievable crap seriously?  just for accusing me
>> of bad behaviors towards Simon on a topic you don't even know? sorry again.
>>
>>
>> On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> I thought you were a good person... seriously? what it is your issue
>>> with just telling the truth, I am the first person here to say I am full of
>>> shit, sorry for the derogatory language but that's fact get back on your
>>> feet man!
>>>
>>>
>>> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 oh boy


 On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:

> and moreover you bluntly lie 
>
>
> On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> I am sorry I am jocking but you 'r calling of for white flag and use
>> it to charge again.
>>
>>
>> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give
>>> a try 8D
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 I already accepted your apologies why don't you give some air
 simply? instead of poisoning the actual lame situation?


 On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:

> am not else you don't understand one single line of my previous
> comments, you are just pissed off and not able to calling off thing I 
> did
>
>
> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com>
> wrote:
>
>> you dare to affirm that I affirm , I
>>
>>
>> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com>
>> wrote:
>>
>>> hello, if you think so, I have noting to say to you, because you
>>> already made your judgement without giving a right of answer, so be 
>>> it.
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith 
>>> wrote:
>>>

 On 2014/07/16 00:03, mm.w wrote:

> And to finally be clear I am a plain guy I don't hide behind
> the curtain like you lamely try, that's public and solely 
> addressed to
> you//..
>

 I'd really like to not have another go at this thread, and
 again would like to apologise to the onlookers - but would like to 
 affirm
 that this is not a personal feud that spilt onto the forum, I have 
 to date
 not received a single mail from Mr. mm.w which did not also reach 
 the list
 - contrary to the insinuation. I think he may simply be unaware he 
 is/was
 posting to the list, for which I apologise too and ask to please 
 give him
 the benefit of the doubt and excuse the thread.

 Mm.w, Sir, I guarantee you I have not a single hard feeling, we
 all have bad days, but please take this off-list hence.

 Thank you kindly
 Ryan


>>>
>>
>

>>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
yes where arethe social kills? telling crap loooking a like a queenie? just
work on tv man not real life.


On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote:

> almost 2 hours of of unbelievable crap seriously?  just for accusing me of
> bad behaviors towards Simon on a topic you don't even know? sorry again.
>
>
> On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> I thought you were a good person... seriously? what it is your issue with
>> just telling the truth, I am the first person here to say I am full of
>> shit, sorry for the derogatory language but that's fact get back on your
>> feet man!
>>
>>
>> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> oh boy
>>>
>>>
>>> On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 and moreover you bluntly lie 


 On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:

> I am sorry I am jocking but you 'r calling of for white flag and use
> it to charge again.
>
>
> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a
>> try 8D
>>
>>
>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> I already accepted your apologies why don't you give some air
>>> simply? instead of poisoning the actual lame situation?
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 am not else you don't understand one single line of my previous
 comments, you are just pissed off and not able to calling off thing I 
 did


 On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:

> you dare to affirm that I affirm , I
>
>
> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com>
> wrote:
>
>> hello, if you think so, I have noting to say to you, because you
>> already made your judgement without giving a right of answer, so be 
>> it.
>>
>>
>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith 
>> wrote:
>>
>>>
>>> On 2014/07/16 00:03, mm.w wrote:
>>>
 And to finally be clear I am a plain guy I don't hide behind
 the curtain like you lamely try, that's public and solely 
 addressed to
 you//..

>>>
>>> I'd really like to not have another go at this thread, and again
>>> would like to apologise to the onlookers - but would like to affirm 
>>> that
>>> this is not a personal feud that spilt onto the forum, I have to 
>>> date not
>>> received a single mail from Mr. mm.w which did not also reach the 
>>> list -
>>> contrary to the insinuation. I think he may simply be unaware he 
>>> is/was
>>> posting to the list, for which I apologise too and ask to please 
>>> give him
>>> the benefit of the doubt and excuse the thread.
>>>
>>> Mm.w, Sir, I guarantee you I have not a single hard feeling, we
>>> all have bad days, but please take this off-list hence.
>>>
>>> Thank you kindly
>>> Ryan
>>>
>>>
>>
>

>>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
almost 2 hours of of unbelievable crap seriously?  just for accusing me of
bad behaviors towards Simon on a topic you don't even know? sorry again.


On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote:

> I thought you were a good person... seriously? what it is your issue with
> just telling the truth, I am the first person here to say I am full of
> shit, sorry for the derogatory language but that's fact get back on your
> feet man!
>
>
> On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> oh boy
>>
>>
>> On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> and moreover you bluntly lie 
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 I am sorry I am jocking but you 'r calling of for white flag and use it
 to charge again.


 On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:

> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a
> try 8D
>
>
> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> I already accepted your apologies why don't you give some air simply?
>> instead of poisoning the actual lame situation?
>>
>>
>> On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> am not else you don't understand one single line of my previous
>>> comments, you are just pissed off and not able to calling off thing I 
>>> did
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 you dare to affirm that I affirm , I


 On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:

> hello, if you think so, I have noting to say to you, because you
> already made your judgement without giving a right of answer, so be 
> it.
>
>
> On Tue, Jul 15, 2014 at 4:18 PM, RSmith 
> wrote:
>
>>
>> On 2014/07/16 00:03, mm.w wrote:
>>
>>> And to finally be clear I am a plain guy I don't hide behind the
>>> curtain like you lamely try, that's public and solely addressed to 
>>> you//..
>>>
>>
>> I'd really like to not have another go at this thread, and again
>> would like to apologise to the onlookers - but would like to affirm 
>> that
>> this is not a personal feud that spilt onto the forum, I have to 
>> date not
>> received a single mail from Mr. mm.w which did not also reach the 
>> list -
>> contrary to the insinuation. I think he may simply be unaware he 
>> is/was
>> posting to the list, for which I apologise too and ask to please 
>> give him
>> the benefit of the doubt and excuse the thread.
>>
>> Mm.w, Sir, I guarantee you I have not a single hard feeling, we
>> all have bad days, but please take this off-list hence.
>>
>> Thank you kindly
>> Ryan
>>
>>
>

>>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
I thought you were a good person... seriously? what it is your issue with
just telling the truth, I am the first person here to say I am full of
shit, sorry for the derogatory language but that's fact get back on your
feet man!


On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:

> oh boy
>
>
> On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> and moreover you bluntly lie 
>>
>>
>> On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> I am sorry I am jocking but you 'r calling of for white flag and use it
>>> to charge again.
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a
 try 8D


 On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:

> I already accepted your apologies why don't you give some air simply?
> instead of poisoning the actual lame situation?
>
>
> On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> am not else you don't understand one single line of my previous
>> comments, you are just pissed off and not able to calling off thing I did
>>
>>
>> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> you dare to affirm that I affirm , I
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 hello, if you think so, I have noting to say to you, because you
 already made your judgement without giving a right of answer, so be it.


 On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:

>
> On 2014/07/16 00:03, mm.w wrote:
>
>> And to finally be clear I am a plain guy I don't hide behind the
>> curtain like you lamely try, that's public and solely addressed to 
>> you//..
>>
>
> I'd really like to not have another go at this thread, and again
> would like to apologise to the onlookers - but would like to affirm 
> that
> this is not a personal feud that spilt onto the forum, I have to date 
> not
> received a single mail from Mr. mm.w which did not also reach the 
> list -
> contrary to the insinuation. I think he may simply be unaware he 
> is/was
> posting to the list, for which I apologise too and ask to please give 
> him
> the benefit of the doubt and excuse the thread.
>
> Mm.w, Sir, I guarantee you I have not a single hard feeling, we
> all have bad days, but please take this off-list hence.
>
> Thank you kindly
> Ryan
>
>

>>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
and moreover you bluntly lie 


On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:

> I am sorry I am jocking but you 'r calling of for white flag and use it to
> charge again.
>
>
> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try
>> 8D
>>
>>
>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> I already accepted your apologies why don't you give some air simply?
>>> instead of poisoning the actual lame situation?
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 am not else you don't understand one single line of my previous
 comments, you are just pissed off and not able to calling off thing I did


 On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:

> you dare to affirm that I affirm , I
>
>
> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> hello, if you think so, I have noting to say to you, because you
>> already made your judgement without giving a right of answer, so be it.
>>
>>
>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:
>>
>>>
>>> On 2014/07/16 00:03, mm.w wrote:
>>>
 And to finally be clear I am a plain guy I don't hide behind the
 curtain like you lamely try, that's public and solely addressed to 
 you//..

>>>
>>> I'd really like to not have another go at this thread, and again
>>> would like to apologise to the onlookers - but would like to affirm that
>>> this is not a personal feud that spilt onto the forum, I have to date 
>>> not
>>> received a single mail from Mr. mm.w which did not also reach the list -
>>> contrary to the insinuation. I think he may simply be unaware he is/was
>>> posting to the list, for which I apologise too and ask to please give 
>>> him
>>> the benefit of the doubt and excuse the thread.
>>>
>>> Mm.w, Sir, I guarantee you I have not a single hard feeling, we all
>>> have bad days, but please take this off-list hence.
>>>
>>> Thank you kindly
>>> Ryan
>>>
>>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
oh boy


On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote:

> and moreover you bluntly lie 
>
>
> On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> I am sorry I am jocking but you 'r calling of for white flag and use it
>> to charge again.
>>
>>
>> On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a
>>> try 8D
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 I already accepted your apologies why don't you give some air simply?
 instead of poisoning the actual lame situation?


 On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:

> am not else you don't understand one single line of my previous
> comments, you are just pissed off and not able to calling off thing I did
>
>
> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> you dare to affirm that I affirm , I
>>
>>
>> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> hello, if you think so, I have noting to say to you, because you
>>> already made your judgement without giving a right of answer, so be it.
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:
>>>

 On 2014/07/16 00:03, mm.w wrote:

> And to finally be clear I am a plain guy I don't hide behind the
> curtain like you lamely try, that's public and solely addressed to 
> you//..
>

 I'd really like to not have another go at this thread, and again
 would like to apologise to the onlookers - but would like to affirm 
 that
 this is not a personal feud that spilt onto the forum, I have to date 
 not
 received a single mail from Mr. mm.w which did not also reach the list 
 -
 contrary to the insinuation. I think he may simply be unaware he is/was
 posting to the list, for which I apologise too and ask to please give 
 him
 the benefit of the doubt and excuse the thread.

 Mm.w, Sir, I guarantee you I have not a single hard feeling, we all
 have bad days, but please take this off-list hence.

 Thank you kindly
 Ryan


>>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
I am sorry I am jocking but you 'r calling of for white flag and use it to
charge again.


On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote:

> seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try
> 8D
>
>
> On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> I already accepted your apologies why don't you give some air simply?
>> instead of poisoning the actual lame situation?
>>
>>
>> On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> am not else you don't understand one single line of my previous
>>> comments, you are just pissed off and not able to calling off thing I did
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 you dare to affirm that I affirm , I


 On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:

> hello, if you think so, I have noting to say to you, because you
> already made your judgement without giving a right of answer, so be it.
>
>
> On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:
>
>>
>> On 2014/07/16 00:03, mm.w wrote:
>>
>>> And to finally be clear I am a plain guy I don't hide behind the
>>> curtain like you lamely try, that's public and solely addressed to 
>>> you//..
>>>
>>
>> I'd really like to not have another go at this thread, and again
>> would like to apologise to the onlookers - but would like to affirm that
>> this is not a personal feud that spilt onto the forum, I have to date not
>> received a single mail from Mr. mm.w which did not also reach the list -
>> contrary to the insinuation. I think he may simply be unaware he is/was
>> posting to the list, for which I apologise too and ask to please give him
>> the benefit of the doubt and excuse the thread.
>>
>> Mm.w, Sir, I guarantee you I have not a single hard feeling, we all
>> have bad days, but please take this off-list hence.
>>
>> Thank you kindly
>> Ryan
>>
>>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try 8D


On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote:

> I already accepted your apologies why don't you give some air simply?
> instead of poisoning the actual lame situation?
>
>
> On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> am not else you don't understand one single line of my previous comments,
>> you are just pissed off and not able to calling off thing I did
>>
>>
>> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> you dare to affirm that I affirm , I
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 hello, if you think so, I have noting to say to you, because you
 already made your judgement without giving a right of answer, so be it.


 On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:

>
> On 2014/07/16 00:03, mm.w wrote:
>
>> And to finally be clear I am a plain guy I don't hide behind the
>> curtain like you lamely try, that's public and solely addressed to 
>> you//..
>>
>
> I'd really like to not have another go at this thread, and again would
> like to apologise to the onlookers - but would like to affirm that this is
> not a personal feud that spilt onto the forum, I have to date not received
> a single mail from Mr. mm.w which did not also reach the list - contrary 
> to
> the insinuation. I think he may simply be unaware he is/was posting to the
> list, for which I apologise too and ask to please give him the benefit of
> the doubt and excuse the thread.
>
> Mm.w, Sir, I guarantee you I have not a single hard feeling, we all
> have bad days, but please take this off-list hence.
>
> Thank you kindly
> Ryan
>
>

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
I already accepted your apologies why don't you give some air simply?
instead of poisoning the actual lame situation?


On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote:

> am not else you don't understand one single line of my previous comments,
> you are just pissed off and not able to calling off thing I did
>
>
> On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> you dare to affirm that I affirm , I
>>
>>
>> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> hello, if you think so, I have noting to say to you, because you already
>>> made your judgement without giving a right of answer, so be it.
>>>
>>>
>>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:
>>>

 On 2014/07/16 00:03, mm.w wrote:

> And to finally be clear I am a plain guy I don't hide behind the
> curtain like you lamely try, that's public and solely addressed to you//..
>

 I'd really like to not have another go at this thread, and again would
 like to apologise to the onlookers - but would like to affirm that this is
 not a personal feud that spilt onto the forum, I have to date not received
 a single mail from Mr. mm.w which did not also reach the list - contrary to
 the insinuation. I think he may simply be unaware he is/was posting to the
 list, for which I apologise too and ask to please give him the benefit of
 the doubt and excuse the thread.

 Mm.w, Sir, I guarantee you I have not a single hard feeling, we all
 have bad days, but please take this off-list hence.

 Thank you kindly
 Ryan


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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
am not else you don't understand one single line of my previous comments,
you are just pissed off and not able to calling off thing I did


On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote:

> you dare to affirm that I affirm , I
>
>
> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> hello, if you think so, I have noting to say to you, because you already
>> made your judgement without giving a right of answer, so be it.
>>
>>
>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:
>>
>>>
>>> On 2014/07/16 00:03, mm.w wrote:
>>>
 And to finally be clear I am a plain guy I don't hide behind the
 curtain like you lamely try, that's public and solely addressed to you//..

>>>
>>> I'd really like to not have another go at this thread, and again would
>>> like to apologise to the onlookers - but would like to affirm that this is
>>> not a personal feud that spilt onto the forum, I have to date not received
>>> a single mail from Mr. mm.w which did not also reach the list - contrary to
>>> the insinuation. I think he may simply be unaware he is/was posting to the
>>> list, for which I apologise too and ask to please give him the benefit of
>>> the doubt and excuse the thread.
>>>
>>> Mm.w, Sir, I guarantee you I have not a single hard feeling, we all have
>>> bad days, but please take this off-list hence.
>>>
>>> Thank you kindly
>>> Ryan
>>>
>>>
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
you dare to affirm that I affirm , I


On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote:

> hello, if you think so, I have noting to say to you, because you already
> made your judgement without giving a right of answer, so be it.
>
>
> On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:
>
>>
>> On 2014/07/16 00:03, mm.w wrote:
>>
>>> And to finally be clear I am a plain guy I don't hide behind the curtain
>>> like you lamely try, that's public and solely addressed to you//..
>>>
>>
>> I'd really like to not have another go at this thread, and again would
>> like to apologise to the onlookers - but would like to affirm that this is
>> not a personal feud that spilt onto the forum, I have to date not received
>> a single mail from Mr. mm.w which did not also reach the list - contrary to
>> the insinuation. I think he may simply be unaware he is/was posting to the
>> list, for which I apologise too and ask to please give him the benefit of
>> the doubt and excuse the thread.
>>
>> Mm.w, Sir, I guarantee you I have not a single hard feeling, we all have
>> bad days, but please take this off-list hence.
>>
>> Thank you kindly
>> Ryan
>>
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
hello, if you think so, I have noting to say to you, because you already
made your judgement without giving a right of answer, so be it.


On Tue, Jul 15, 2014 at 4:18 PM, RSmith  wrote:

>
> On 2014/07/16 00:03, mm.w wrote:
>
>> And to finally be clear I am a plain guy I don't hide behind the curtain
>> like you lamely try, that's public and solely addressed to you//..
>>
>
> I'd really like to not have another go at this thread, and again would
> like to apologise to the onlookers - but would like to affirm that this is
> not a personal feud that spilt onto the forum, I have to date not received
> a single mail from Mr. mm.w which did not also reach the list - contrary to
> the insinuation. I think he may simply be unaware he is/was posting to the
> list, for which I apologise too and ask to please give him the benefit of
> the doubt and excuse the thread.
>
> Mm.w, Sir, I guarantee you I have not a single hard feeling, we all have
> bad days, but please take this off-list hence.
>
> Thank you kindly
> Ryan
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread RSmith 


On 2014/07/16 00:03, mm.w wrote:
And to finally be clear I am a plain guy I don't hide behind the curtain like you lamely try, that's public and solely addressed 
to you//..


I'd really like to not have another go at this thread, and again would like to apologise to the onlookers - but would like to affirm 
that this is not a personal feud that spilt onto the forum, I have to date not received a single mail from Mr. mm.w which did not 
also reach the list - contrary to the insinuation. I think he may simply be unaware he is/was posting to the list, for which I 
apologise too and ask to please give him the benefit of the doubt and excuse the thread.


Mm.w, Sir, I guarantee you I have not a single hard feeling, we all have bad 
days, but please take this off-list hence.

Thank you kindly
Ryan

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
anyway no drama here, I am not here to fight or getting personal, that's
just on a situation I ve seen I get passionate that's all


On Tue, Jul 15, 2014 at 3:28 PM, mm.w <0xcafef...@gmail.com> wrote:

> I agree I am not the best "communication guy ever born" but I can say no
> guys don't roll-back this is a terrible idea without getting personal
>
>
> On Tue, Jul 15, 2014 at 3:26 PM, Simon Slavin 
> wrote:
>
>>
>> On 15 Jul 2014, at 11:03pm, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > Simon is enough solid to answer himself
>>
>> Thank you.
>>
>> > I don't think he is
>> > crying in the corner
>>
>> True.  But if lots of people all post the same advice it can be more
>> persuasive than one person posting the same thing again and again.  So
>> having make my statement I retire from the discussion.
>>
>> 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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
I agree I am not the best "communication guy ever born" but I can say no
guys don't roll-back this is a terrible idea without getting personal


On Tue, Jul 15, 2014 at 3:26 PM, Simon Slavin  wrote:

>
> On 15 Jul 2014, at 11:03pm, mm.w <0xcafef...@gmail.com> wrote:
>
> > Simon is enough solid to answer himself
>
> Thank you.
>
> > I don't think he is
> > crying in the corner
>
> True.  But if lots of people all post the same advice it can be more
> persuasive than one person posting the same thing again and again.  So
> having make my statement I retire from the discussion.
>
> 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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread Simon Slavin 

On 15 Jul 2014, at 11:03pm, mm.w <0xcafef...@gmail.com> wrote:

> Simon is enough solid to answer himself

Thank you.

> I don't think he is
> crying in the corner

True.  But if lots of people all post the same advice it can be more persuasive 
than one person posting the same thing again and again.  So having make my 
statement I retire from the discussion.

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
And to finally be clear I am a plain guy I don't hide behind the curtain
like you lamely try, that's public and solely addressed to you, no rocket
science here when you are honest with yourself, but I can tell you, I will
be the last guy here to burn you out personally, if you don't like arguing
stop coding and Simon is enough solid to answer himself I don't think he is
crying in the corner... he certainly does not need a baby-sister popping up
with ridiculous statements thinking she is the queeny, sorry but this is
ridiculous, anyone who lead team over 50 persons on tough projects means
projecting yourself over a 2 years round, must laugh at large, I can't tell
you, my little candy.

Best.




On Tue, Jul 15, 2014 at 2:04 PM, mm.w <0xcafef...@gmail.com> wrote:

> don't try to look good when you are not.
>
> thank you.
>
>
> On Tue, Jul 15, 2014 at 2:02 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> why Apologies when it's solely addressed to you, please don't be a hypocrite
>> everybody can understand that in your first paragraph you are out of the
>> topic and the line.
>>
>> thank you, apology accepted... (SIK)
>>
>>
>> On Tue, Jul 15, 2014 at 1:59 PM, RSmith  wrote:
>>
>>> On 2014/07/15 22:33, mm.w wrote:
>>>
 whine_spam++  //

>>>
>>> Apologies to all.
>>>
>>> Not sure if this is intended for Simon too, or only myself - either way,
>>> would you be so kind as to take it off-list, it is of no benefit to others
>>> here - much appreciated.
>>>
>>>
>>>
>>> ___
>>> 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] Preferred cast in C#

2014-07-15 Thread Simon Slavin 

> On 15 Jul 2014, at 8:05pm, Drago, William @ MWG - NARDAEAST 
>  wrote:
> 
>> On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite)
>>  wrote:
>> 
>>> In C#, using the System.Data.Sqlite.Core package, which is described
>>> as "The official SQLite database engine" and published by "SQLite
>>> Development Team"
>> 
>> That's Joe's code.  You probably got that off of git or nuget.org.
> 
> It's also available on the download page here:
> 
> http://system.data.sqlite.org/

Which does /not/ describe it as "The official SQLite database engine", which is 
the point I was making.

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
don't try to look good when you are not.

thank you.


On Tue, Jul 15, 2014 at 2:02 PM, mm.w <0xcafef...@gmail.com> wrote:

> why Apologies when it's solely addressed to you, please don't be a hypocrite
> everybody can understand that in your first paragraph you are out of the
> topic and the line.
>
> thank you, apology accepted... (SIK)
>
>
> On Tue, Jul 15, 2014 at 1:59 PM, RSmith  wrote:
>
>> On 2014/07/15 22:33, mm.w wrote:
>>
>>> whine_spam++  //
>>>
>>
>> Apologies to all.
>>
>> Not sure if this is intended for Simon too, or only myself - either way,
>> would you be so kind as to take it off-list, it is of no benefit to others
>> here - much appreciated.
>>
>>
>>
>> ___
>> 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] capturing and testing a hot journal

2014-07-15 Thread mm.w 
why Apologies when it's solely addressed to you, please don't be a hypocrite
everybody can understand that in your first paragraph you are out of the
topic and the line.

thank you, apology accepted... (SIK)


On Tue, Jul 15, 2014 at 1:59 PM, RSmith  wrote:

> On 2014/07/15 22:33, mm.w wrote:
>
>> whine_spam++  //
>>
>
> Apologies to all.
>
> Not sure if this is intended for Simon too, or only myself - either way,
> would you be so kind as to take it off-list, it is of no benefit to others
> here - much appreciated.
>
>
>
> ___
> 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] capturing and testing a hot journal

2014-07-15 Thread RSmith 

On 2014/07/15 22:33, mm.w wrote:

whine_spam++  //


Apologies to all.

Not sure if this is intended for Simon too, or only myself - either way, would you be so kind as to take it off-list, it is of no 
benefit to others here - much appreciated.



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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
to be clear, I am not a social worker but an engineer and never argue when
I consider that's a lost cause, if you cannot straight talking 5 minutes in
your life... don't ask me to say "bravo", it's not big deal my little ducky
when I think the contrary especially on a topic I know from the outside and
the inside and all the possible entry point.

thank you for getting back on earth.


On Tue, Jul 15, 2014 at 1:27 PM, mm.w <0xcafef...@gmail.com> wrote:

> sorry, I did not enter in the specifics of the answer, because it's driven
> by personal feelings which are off topic and surely misplaced but I will
> pass on this childish frustrations which are not my concern, bluntly I do
> not care, if you take that personally it's your problem, deal with it.
>
> thank you.
>
>
> On Tue, Jul 15, 2014 at 1:16 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> morality good question, wrong solution from the op + wrong solution gain
>> of simon to endorse the bad design, so then when you are serious you
>> roll-back to the entry point not the broken branch.
>>
>>
>>
>> On Tue, Jul 15, 2014 at 1:12 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> to be clear, the original solution does not answer the question, it
>>> tries to relay on sqlite specifics, where specifics are beyond the sqlite
>>> small world. you must read back the first request to understand.
>>>
>>>
>>> On Tue, Jul 15, 2014 at 1:10 PM, mm.w <0xcafef...@gmail.com> wrote:
>>>
 yes that's exactly what I said thank you to confirm my dear 8)

 " If the pipe dies halfway then the app would know it" sorry LOL


 On Tue, Jul 15, 2014 at 12:13 PM, RSmith  wrote:

>
> On 2014/07/15 19:06, mm.w wrote:
>
>> Simon your design-idea do not reflect any reality, this is weak,
>> there is a
>> lack of experience on the topic and we can feel it.
>>
>
> Strange, I feel nothing of the sort and the only weak thing I can see
> involves the correlation between the computer and social skill sets you
> wield. Maybe you had a very different use-case in mind than what is normal
> for SQLite? - which is of course allowed.
>
>
>  "You won't have anything to commit.  If your application really had
>> crashed
>> it wouldn't have any transaction data to commit.  If your application
>> had
>> not crashed the transaction would always have worked."
>>
>> nope you can have a partial upload, a broken socket pipe et cetera,
>> and you
>> only assume a version of the file is not already remote and assume
>> that
>> after crash you might be able to recover local anyway.
>>
>
> Partial uploads... broken pipes... these are all networking related
> issues and has nothing to do with file commitment of any SQLite code. When
> you make a server-client system which upload a stream or download it, or 
> in
> any way sends it somewhere or manages synchronicity, it is the
> responsibility of either the client or the server to commit those databits
> to disk, not the pipe's responsibility. If the pipe dies halfway then the
> app would know it, and no amount of half-commits can happen. The only time
> SQLite engine can "break" a file by not completing a commit is if the
> program itself crashes or the physical media errors out, just like Simon
> said - none of which involve programmed-logic solutions. Report error and
> die - this is the way the Force guides us.
>
>
>
>  there are two scenario to check:
>>
>> local = remote after any network transaction
>> local = remote
>>
>> after incident:
>>   + if not remote, test integrity of local
>>   + if remote make sure both are safe
>>   + if only remote restore/force sync has you got an interrupt (it
>> happens
>> with box)
>>
>> 1- the network flow could be interrupted no need a power failure for
>> that
>> to happen, it can happen that's you face also the case of undetected
>> broken
>> pipe, that's the reason you need to be notify by the network pooler
>> API you
>> use,
>>
>> 2- the journal tweaking only concern sqlite file and specific to it,
>> then
>> wrong design, make it work for anything using the "common regular"
>> system
>> of hashing/signing local to remote to ensure the integrity of the
>> data, at
>> least that's the only purpose of this discussion how I am sure
>> whatever
>> happen that I have my data in good shape somewhere.
>>
>
> This is establishing whether a file-transfer between some syncing
> services is successful and current, it has not a single thing to do with
> SQLite's ability to commit changes to the file or judging the need for
> roll-back. When SQLite starts the file is either broken or not, end of.
> This should be checked on a high level and has no bearing on anything to 
> do
> with SQLite.
>>>

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
sorry, I did not enter in the specifics of the answer, because it's driven
by personal feelings which are off topic and surely misplaced but I will
pass on this childish frustrations which are not my concern, bluntly I do
not care, if you take that personally it's your problem, deal with it.

thank you.


On Tue, Jul 15, 2014 at 1:16 PM, mm.w <0xcafef...@gmail.com> wrote:

> morality good question, wrong solution from the op + wrong solution gain
> of simon to endorse the bad design, so then when you are serious you
> roll-back to the entry point not the broken branch.
>
>
>
> On Tue, Jul 15, 2014 at 1:12 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> to be clear, the original solution does not answer the question, it tries
>> to relay on sqlite specifics, where specifics are beyond the sqlite small
>> world. you must read back the first request to understand.
>>
>>
>> On Tue, Jul 15, 2014 at 1:10 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>>> yes that's exactly what I said thank you to confirm my dear 8)
>>>
>>> " If the pipe dies halfway then the app would know it" sorry LOL
>>>
>>>
>>> On Tue, Jul 15, 2014 at 12:13 PM, RSmith  wrote:
>>>

 On 2014/07/15 19:06, mm.w wrote:

> Simon your design-idea do not reflect any reality, this is weak, there
> is a
> lack of experience on the topic and we can feel it.
>

 Strange, I feel nothing of the sort and the only weak thing I can see
 involves the correlation between the computer and social skill sets you
 wield. Maybe you had a very different use-case in mind than what is normal
 for SQLite? - which is of course allowed.


  "You won't have anything to commit.  If your application really had
> crashed
> it wouldn't have any transaction data to commit.  If your application
> had
> not crashed the transaction would always have worked."
>
> nope you can have a partial upload, a broken socket pipe et cetera,
> and you
> only assume a version of the file is not already remote and assume that
> after crash you might be able to recover local anyway.
>

 Partial uploads... broken pipes... these are all networking related
 issues and has nothing to do with file commitment of any SQLite code. When
 you make a server-client system which upload a stream or download it, or in
 any way sends it somewhere or manages synchronicity, it is the
 responsibility of either the client or the server to commit those databits
 to disk, not the pipe's responsibility. If the pipe dies halfway then the
 app would know it, and no amount of half-commits can happen. The only time
 SQLite engine can "break" a file by not completing a commit is if the
 program itself crashes or the physical media errors out, just like Simon
 said - none of which involve programmed-logic solutions. Report error and
 die - this is the way the Force guides us.



  there are two scenario to check:
>
> local = remote after any network transaction
> local = remote
>
> after incident:
>   + if not remote, test integrity of local
>   + if remote make sure both are safe
>   + if only remote restore/force sync has you got an interrupt (it
> happens
> with box)
>
> 1- the network flow could be interrupted no need a power failure for
> that
> to happen, it can happen that's you face also the case of undetected
> broken
> pipe, that's the reason you need to be notify by the network pooler
> API you
> use,
>
> 2- the journal tweaking only concern sqlite file and specific to it,
> then
> wrong design, make it work for anything using the "common regular"
> system
> of hashing/signing local to remote to ensure the integrity of the
> data, at
> least that's the only purpose of this discussion how I am sure whatever
> happen that I have my data in good shape somewhere.
>

 This is establishing whether a file-transfer between some syncing
 services is successful and current, it has not a single thing to do with
 SQLite's ability to commit changes to the file or judging the need for
 roll-back. When SQLite starts the file is either broken or not, end of.
 This should be checked on a high level and has no bearing on anything to do
 with SQLite.



 ___
 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] [bug] sqlite memory corruption (use by digikam)

2014-07-15 Thread Dan Kennedy 

On 07/16/2014 03:22 AM, Dan Kennedy wrote:

On 07/15/2014 09:06 PM, Mathieu Clabaut wrote:

Hello,

  Digikam bug https://bugs.kde.org/show_bug.cgi?id=323888#c89 seems 
to be

caused by a sqlite memory leak


It looks very much like the program is not calling sqlite3_close().

If you have a small program that shows SQLite leaking memory please 
make it available to us.




  and is said to be corrected with slqlite
3.8.5, but as shown in https://bugs.kde.org/show_bug.cgi?id=321680 a
similar problem appear in digikam 4.0.0 with sqlite 3.8.5.


I'm not sure what causes the crash in the stack trace in comment 8. I 
don't think these crashes are related to bug 323888 in any case. It's 
tough to say what the trace in comment 8 means really, except that the 
heap is corrupted.


The crashes in sqlite3MemCompare() are interesting though. Does the 
framework ever pass anything other than SQLITE_TRANSIENT or 
SQLITE_STATIC to sqlite3_bind_text(), bind_result() or similar?


Actually - it could be that a bad function pointer has been passed to 
one of the sqlite3_create_collation() functions. That would give you 
very similar stack traces anyhow.


Dan.


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

Re: [sqlite] [bug] sqlite memory corruption (use by digikam)

2014-07-15 Thread Dan Kennedy 

On 07/15/2014 09:06 PM, Mathieu Clabaut wrote:

Hello,

  Digikam bug https://bugs.kde.org/show_bug.cgi?id=323888#c89 seems to be
caused by a sqlite memory leak


It looks very much like the program is not calling sqlite3_close().

If you have a small program that shows SQLite leaking memory please make 
it available to us.




  and is said to be corrected with slqlite
3.8.5, but as shown in https://bugs.kde.org/show_bug.cgi?id=321680 a
similar problem appear in digikam 4.0.0 with sqlite 3.8.5.


I'm not sure what causes the crash in the stack trace in comment 8. I 
don't think these crashes are related to bug 323888 in any case. It's 
tough to say what the trace in comment 8 means really, except that the 
heap is corrupted.


The crashes in sqlite3MemCompare() are interesting though. Does the 
framework ever pass anything other than SQLITE_TRANSIENT or 
SQLITE_STATIC to sqlite3_bind_text(), bind_result() or similar?


Dan.

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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
morality good question, wrong solution from the op + wrong solution gain of
simon to endorse the bad design, so then when you are serious you roll-back
to the entry point not the broken branch.



On Tue, Jul 15, 2014 at 1:12 PM, mm.w <0xcafef...@gmail.com> wrote:

> to be clear, the original solution does not answer the question, it tries
> to relay on sqlite specifics, where specifics are beyond the sqlite small
> world. you must read back the first request to understand.
>
>
> On Tue, Jul 15, 2014 at 1:10 PM, mm.w <0xcafef...@gmail.com> wrote:
>
>> yes that's exactly what I said thank you to confirm my dear 8)
>>
>> " If the pipe dies halfway then the app would know it" sorry LOL
>>
>>
>> On Tue, Jul 15, 2014 at 12:13 PM, RSmith  wrote:
>>
>>>
>>> On 2014/07/15 19:06, mm.w wrote:
>>>
 Simon your design-idea do not reflect any reality, this is weak, there
 is a
 lack of experience on the topic and we can feel it.

>>>
>>> Strange, I feel nothing of the sort and the only weak thing I can see
>>> involves the correlation between the computer and social skill sets you
>>> wield. Maybe you had a very different use-case in mind than what is normal
>>> for SQLite? - which is of course allowed.
>>>
>>>
>>>  "You won't have anything to commit.  If your application really had
 crashed
 it wouldn't have any transaction data to commit.  If your application
 had
 not crashed the transaction would always have worked."

 nope you can have a partial upload, a broken socket pipe et cetera, and
 you
 only assume a version of the file is not already remote and assume that
 after crash you might be able to recover local anyway.

>>>
>>> Partial uploads... broken pipes... these are all networking related
>>> issues and has nothing to do with file commitment of any SQLite code. When
>>> you make a server-client system which upload a stream or download it, or in
>>> any way sends it somewhere or manages synchronicity, it is the
>>> responsibility of either the client or the server to commit those databits
>>> to disk, not the pipe's responsibility. If the pipe dies halfway then the
>>> app would know it, and no amount of half-commits can happen. The only time
>>> SQLite engine can "break" a file by not completing a commit is if the
>>> program itself crashes or the physical media errors out, just like Simon
>>> said - none of which involve programmed-logic solutions. Report error and
>>> die - this is the way the Force guides us.
>>>
>>>
>>>
>>>  there are two scenario to check:

 local = remote after any network transaction
 local = remote

 after incident:
   + if not remote, test integrity of local
   + if remote make sure both are safe
   + if only remote restore/force sync has you got an interrupt (it
 happens
 with box)

 1- the network flow could be interrupted no need a power failure for
 that
 to happen, it can happen that's you face also the case of undetected
 broken
 pipe, that's the reason you need to be notify by the network pooler API
 you
 use,

 2- the journal tweaking only concern sqlite file and specific to it,
 then
 wrong design, make it work for anything using the "common regular"
 system
 of hashing/signing local to remote to ensure the integrity of the data,
 at
 least that's the only purpose of this discussion how I am sure whatever
 happen that I have my data in good shape somewhere.

>>>
>>> This is establishing whether a file-transfer between some syncing
>>> services is successful and current, it has not a single thing to do with
>>> SQLite's ability to commit changes to the file or judging the need for
>>> roll-back. When SQLite starts the file is either broken or not, end of.
>>> This should be checked on a high level and has no bearing on anything to do
>>> with SQLite.
>>>
>>>
>>>
>>> ___
>>> 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] capturing and testing a hot journal

2014-07-15 Thread mm.w 
to be clear, the original solution does not answer the question, it tries
to relay on sqlite specifics, where specifics are beyond the sqlite small
world. you must read back the first request to understand.


On Tue, Jul 15, 2014 at 1:10 PM, mm.w <0xcafef...@gmail.com> wrote:

> yes that's exactly what I said thank you to confirm my dear 8)
>
> " If the pipe dies halfway then the app would know it" sorry LOL
>
>
> On Tue, Jul 15, 2014 at 12:13 PM, RSmith  wrote:
>
>>
>> On 2014/07/15 19:06, mm.w wrote:
>>
>>> Simon your design-idea do not reflect any reality, this is weak, there
>>> is a
>>> lack of experience on the topic and we can feel it.
>>>
>>
>> Strange, I feel nothing of the sort and the only weak thing I can see
>> involves the correlation between the computer and social skill sets you
>> wield. Maybe you had a very different use-case in mind than what is normal
>> for SQLite? - which is of course allowed.
>>
>>
>>  "You won't have anything to commit.  If your application really had
>>> crashed
>>> it wouldn't have any transaction data to commit.  If your application had
>>> not crashed the transaction would always have worked."
>>>
>>> nope you can have a partial upload, a broken socket pipe et cetera, and
>>> you
>>> only assume a version of the file is not already remote and assume that
>>> after crash you might be able to recover local anyway.
>>>
>>
>> Partial uploads... broken pipes... these are all networking related
>> issues and has nothing to do with file commitment of any SQLite code. When
>> you make a server-client system which upload a stream or download it, or in
>> any way sends it somewhere or manages synchronicity, it is the
>> responsibility of either the client or the server to commit those databits
>> to disk, not the pipe's responsibility. If the pipe dies halfway then the
>> app would know it, and no amount of half-commits can happen. The only time
>> SQLite engine can "break" a file by not completing a commit is if the
>> program itself crashes or the physical media errors out, just like Simon
>> said - none of which involve programmed-logic solutions. Report error and
>> die - this is the way the Force guides us.
>>
>>
>>
>>  there are two scenario to check:
>>>
>>> local = remote after any network transaction
>>> local = remote
>>>
>>> after incident:
>>>   + if not remote, test integrity of local
>>>   + if remote make sure both are safe
>>>   + if only remote restore/force sync has you got an interrupt (it
>>> happens
>>> with box)
>>>
>>> 1- the network flow could be interrupted no need a power failure for that
>>> to happen, it can happen that's you face also the case of undetected
>>> broken
>>> pipe, that's the reason you need to be notify by the network pooler API
>>> you
>>> use,
>>>
>>> 2- the journal tweaking only concern sqlite file and specific to it, then
>>> wrong design, make it work for anything using the "common regular" system
>>> of hashing/signing local to remote to ensure the integrity of the data,
>>> at
>>> least that's the only purpose of this discussion how I am sure whatever
>>> happen that I have my data in good shape somewhere.
>>>
>>
>> This is establishing whether a file-transfer between some syncing
>> services is successful and current, it has not a single thing to do with
>> SQLite's ability to commit changes to the file or judging the need for
>> roll-back. When SQLite starts the file is either broken or not, end of.
>> This should be checked on a high level and has no bearing on anything to do
>> with SQLite.
>>
>>
>>
>> ___
>> 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] capturing and testing a hot journal

2014-07-15 Thread mm.w 
yes that's exactly what I said thank you to confirm my dear 8)

" If the pipe dies halfway then the app would know it" sorry LOL


On Tue, Jul 15, 2014 at 12:13 PM, RSmith  wrote:

>
> On 2014/07/15 19:06, mm.w wrote:
>
>> Simon your design-idea do not reflect any reality, this is weak, there is
>> a
>> lack of experience on the topic and we can feel it.
>>
>
> Strange, I feel nothing of the sort and the only weak thing I can see
> involves the correlation between the computer and social skill sets you
> wield. Maybe you had a very different use-case in mind than what is normal
> for SQLite? - which is of course allowed.
>
>
>  "You won't have anything to commit.  If your application really had
>> crashed
>> it wouldn't have any transaction data to commit.  If your application had
>> not crashed the transaction would always have worked."
>>
>> nope you can have a partial upload, a broken socket pipe et cetera, and
>> you
>> only assume a version of the file is not already remote and assume that
>> after crash you might be able to recover local anyway.
>>
>
> Partial uploads... broken pipes... these are all networking related issues
> and has nothing to do with file commitment of any SQLite code. When you
> make a server-client system which upload a stream or download it, or in any
> way sends it somewhere or manages synchronicity, it is the responsibility
> of either the client or the server to commit those databits to disk, not
> the pipe's responsibility. If the pipe dies halfway then the app would know
> it, and no amount of half-commits can happen. The only time SQLite engine
> can "break" a file by not completing a commit is if the program itself
> crashes or the physical media errors out, just like Simon said - none of
> which involve programmed-logic solutions. Report error and die - this is
> the way the Force guides us.
>
>
>
>  there are two scenario to check:
>>
>> local = remote after any network transaction
>> local = remote
>>
>> after incident:
>>   + if not remote, test integrity of local
>>   + if remote make sure both are safe
>>   + if only remote restore/force sync has you got an interrupt (it happens
>> with box)
>>
>> 1- the network flow could be interrupted no need a power failure for that
>> to happen, it can happen that's you face also the case of undetected
>> broken
>> pipe, that's the reason you need to be notify by the network pooler API
>> you
>> use,
>>
>> 2- the journal tweaking only concern sqlite file and specific to it, then
>> wrong design, make it work for anything using the "common regular" system
>> of hashing/signing local to remote to ensure the integrity of the data, at
>> least that's the only purpose of this discussion how I am sure whatever
>> happen that I have my data in good shape somewhere.
>>
>
> This is establishing whether a file-transfer between some syncing services
> is successful and current, it has not a single thing to do with SQLite's
> ability to commit changes to the file or judging the need for roll-back.
> When SQLite starts the file is either broken or not, end of. This should be
> checked on a high level and has no bearing on anything to do with SQLite.
>
>
>
> ___
> 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] capturing and testing a hot journal

2014-07-15 Thread RSmith 


On 2014/07/15 19:06, mm.w wrote:

Simon your design-idea do not reflect any reality, this is weak, there is a
lack of experience on the topic and we can feel it.


Strange, I feel nothing of the sort and the only weak thing I can see involves the correlation between the computer and social skill 
sets you wield. Maybe you had a very different use-case in mind than what is normal for SQLite? - which is of course allowed.



"You won't have anything to commit.  If your application really had crashed
it wouldn't have any transaction data to commit.  If your application had
not crashed the transaction would always have worked."

nope you can have a partial upload, a broken socket pipe et cetera, and you
only assume a version of the file is not already remote and assume that
after crash you might be able to recover local anyway.


Partial uploads... broken pipes... these are all networking related issues and has nothing to do with file commitment of any SQLite 
code. When you make a server-client system which upload a stream or download it, or in any way sends it somewhere or manages 
synchronicity, it is the responsibility of either the client or the server to commit those databits to disk, not the pipe's 
responsibility. If the pipe dies halfway then the app would know it, and no amount of half-commits can happen. The only time SQLite 
engine can "break" a file by not completing a commit is if the program itself crashes or the physical media errors out, just like 
Simon said - none of which involve programmed-logic solutions. Report error and die - this is the way the Force guides us.




there are two scenario to check:

local = remote after any network transaction
local = remote

after incident:
  + if not remote, test integrity of local
  + if remote make sure both are safe
  + if only remote restore/force sync has you got an interrupt (it happens
with box)

1- the network flow could be interrupted no need a power failure for that
to happen, it can happen that's you face also the case of undetected broken
pipe, that's the reason you need to be notify by the network pooler API you
use,

2- the journal tweaking only concern sqlite file and specific to it, then
wrong design, make it work for anything using the "common regular" system
of hashing/signing local to remote to ensure the integrity of the data, at
least that's the only purpose of this discussion how I am sure whatever
happen that I have my data in good shape somewhere.


This is establishing whether a file-transfer between some syncing services is successful and current, it has not a single thing to 
do with SQLite's ability to commit changes to the file or judging the need for roll-back. When SQLite starts the file is either 
broken or not, end of. This should be checked on a high level and has no bearing on anything to do with SQLite.



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

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Drago, William @ MWG - NARDAEAST 
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Tuesday, July 15, 2014 2:35 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Preferred cast in C#
>
>
> On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite)
>  wrote:
>
> > In C#, using the System.Data.Sqlite.Core package, which is described
> as "The official SQLite database engine" and published by "SQLite
> Development Team"
>
> That's Joe's code.  You probably got that off of git or nuget.org.

It's also available on the download page here:

http://system.data.sqlite.org/

and if you don't have it already, the help file is here:

http://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimetype=application/x-chm

-Bill


CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite - issues

2014-07-15 Thread manish . kukreti 
Hi,
Below are the two issues I would like to report for SQLite .Net client.
1. SQLiteDataReader.GetString() method:
The method fails with "Invalid cast exception" when you try to retrieve a 
number stored in a text field.

2. SQLiteDataReader.GetValue performance in version 1.0.93:
This method is considerably slower in this version. While benchmarking, the 
fetch was about 7-8 times slower. First I thought it was the NGQP (since I 
upgraded from version 3.7 to 3.8.5), but while trying to break it down, it 
appeared the issue was with this fetch method.

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

[sqlite] [bug] sqlite memory corruption (use by digikam)

2014-07-15 Thread Mathieu Clabaut 
Hello,

 Digikam bug https://bugs.kde.org/show_bug.cgi?id=323888#c89 seems to be
caused by a sqlite memory leak and is said to be corrected with slqlite
3.8.5, but as shown in https://bugs.kde.org/show_bug.cgi?id=321680 a
similar problem appear in digikam 4.0.0 with sqlite 3.8.5.

 Best regards,

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

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Simon Slavin 

On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite)  
wrote:

> In C#, using the System.Data.Sqlite.Core package, which is described as "The 
> official SQLite database engine" and published by "SQLite Development Team"

That's Joe's code.  You probably got that off of git or nuget.org.  The 
description you quoted above should be changed.  That is an API developed by a 
member of the SQLite development team, but it's not the 'real' SQLite3 API, 
which is the one documented here:



What you have may be a good way to work with SQLite under what Visual Studio or 
ADO.NET requires, but it's not the 'official' SQLite interface.

I'd love to go on to solve your problem but unfortunately I know nothing about 
.NET and can't.

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

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread RSmith 


On 2014/07/15 19:42, Edward Ned Harvey (sqlite) wrote:

From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of RSmith


System.DBNull is not a native SQLite construct, it is probably one of the third
party connectors.

In C#, using the System.Data.Sqlite.Core package, which is described as "The official SQLite 
database engine" and published by "SQLite Development Team"...  The results of a 
Select statement are returned as an Object().  If the database contents were Null, then the result 
is an instance of System.DBNull() class, rather than returning null.

If this is not using the API directly, I don't know what is.


Yes, you do not know what is.

In the API you may call routines that resemble these:
sqlite3_prepareV2();
sqlite3_openV2();
sqlite3_step();

or more specific to your needs:

int sqlite3_bind_double(sqlite3_stmt*, int, double);
int sqlite3_bind_int(sqlite3_stmt*, int, int);
int sqlite3_bind_int64(sqlite3_stmt*, int, sqlite3_int64);
int sqlite3_bind_null(sqlite3_stmt*, int);
int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n, void(*)(void*));

and retrieving values with...

const void *sqlite3_column_blob(sqlite3_stmt*, int iCol);
int sqlite3_column_bytes(sqlite3_stmt*, int iCol);
int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);
double sqlite3_column_double(sqlite3_stmt*, int iCol);
int sqlite3_column_int(sqlite3_stmt*, int iCol);
sqlite3_int64 sqlite3_column_int64(sqlite3_stmt*, int iCol);
const unsigned char *sqlite3_column_text(sqlite3_stmt*, int iCol);
const void *sqlite3_column_text16(sqlite3_stmt*, int iCol);
etc.

and finally some more for adding your own functions that will return any form of 
"long?" type or other you need...

In fact, let me get you the very introduction to the wonders of the SQLite API, 
and you will see your problem can be fixed in a few minutes by adding a simple 
function:

http://www.sqlite.org/cintro.html

Please feel free to ask for any advice or pointers or specific question you may 
have regarding using any of it.




I am not sure which development
environment you are using, I am guessing some C or scripting

The subject line says C#


Ah yes - Apologies for not checking the subject line, I have a bad habit of trying to establish the content of a message from the 
body only.





none of which is a standard or used in a wide
variety of systems - which is why the other poster did not even know what
you meant with "long?".

The official sqlite C# packages, if only counting the ones distributed by NuGet 
(not counting those who download direct from www.sqlite.org or build from 
source) has over 425,000 downloads, and is among the most popular packages 
deployed.


C# is by no means the defacto SQLite environment and 425K is extremely unimpressive, SQLIte is used on over a billion devices 
currently and many third party SQLite extensions and apps have download numbers that dwarf those, all of them being in no way 
"official" - I can provide links if needed. This is however not the point I was making at all and indeed very unimportant, I just 
wanted to let you know that your assumption that you have stumbled on the "one true" SQLite implementation and hence feel it should 
support data types specific to your platform is rather in need of illumination.





Maybe ask the designers of your connector for such functionality?

That's why I came to post here.

I thought, since there is a direct analogous native type in C# for each of the 
native storage types in SQLite, there was likely a native way to interoperate 
them seamlessly.  It seems I was wrong - but it's ok - the workaround was not 
terribly difficult.  I just felt like I was hacking and kludging my way through 
something that surely there must be a better way.


This is a fair point, and a valid request, as I said previously. Just that there is not a direct relation to those types currently 
(and probably won't be) in SQLite itself, but the C# Core package might well support it, and if not yet, might be able to. I'd leave 
it to a Core dev to answer or add a ticket for you.



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

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

2014-07-15 Thread Simon Slavin 

On 15 Jul 2014, at 6:58pm, Mayank Kumar (mayankum)  wrote:

> I was calling it after sqlite3_open,I will try calling before sqlite3_open 
> and update the thread.

When you call sqlite3_config() after sqlite3_open() it returns SQLITE_MISUSE to 
tell you you're doing it wrong.  The fact that you didn't notice this error 
shows us you are not checking the result codes returned by (almost ?) all 
sqlite3 API calls.

Checking these results codes for /every/ call helps programmers spot and 
correct almost all errors.  It's important to check them all because often the 
error is returned by a different call to the one which, logically, should be 
generating the error.  It's simple, you just replace



with something like

if ( != SQLITE_OK) {

}

When people report problems to this list, having them make this change to 
/every/ sqlite3 call makes a lot of them go away.

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

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

2014-07-15 Thread Mayank Kumar (mayankum) 
I was calling it after sqlite3_open,I will try calling before sqlite3_open and 
update the thread.

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Roger Binns
Sent: Tuesday, July 15, 2014 10:05 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Sometimes when my process restarts, it returns error 
"database is locked"

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 14/07/14 22:39, Mayank Kumar (mayankum) wrote:
> The file system is ext3. I am calling this api
> 
> sqlite3_config(SQLITE_CONFIG_LOG, errorLogCallback, NULL);
[...]
> Is my understanding correct since my callback is not getting called ?

Did you check the result of the sqlite3_config call?  It can only be called 
before SQLite is initialised.

You can test that the callback is working by trying to open a database named 
/dev/null and executing any SQL.  This is an example of the diagnostics you 
will get:

  http://rogerbinns.github.io/apsw/tips.html#diagnostics

Roger

-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlPFX04ACgkQmOOfHg372QT16gCgoHzHNaGCVAYwxBfu79iXuRt6
B7gAoJY5RX9MCgimDCSeloiXnNrZncgZ
=uqmR
-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] Preferred cast in C#

2014-07-15 Thread Edward Ned Harvey (sqlite) 
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of RSmith
> 
> 
> System.DBNull is not a native SQLite construct, it is probably one of the 
> third
> party connectors. 

In C#, using the System.Data.Sqlite.Core package, which is described as "The 
official SQLite database engine" and published by "SQLite Development Team"...  
The results of a Select statement are returned as an Object().  If the database 
contents were Null, then the result is an instance of System.DBNull() class, 
rather than returning null.

If this is not using the API directly, I don't know what is.


> I am not sure which development
> environment you are using, I am guessing some C or scripting

The subject line says C#


> none of which is a standard or used in a wide
> variety of systems - which is why the other poster did not even know what
> you meant with "long?".  

The official sqlite C# packages, if only counting the ones distributed by NuGet 
(not counting those who download direct from www.sqlite.org or build from 
source) has over 425,000 downloads, and is among the most popular packages 
deployed.


> Maybe ask the designers of your connector for such functionality?

That's why I came to post here.

I thought, since there is a direct analogous native type in C# for each of the 
native storage types in SQLite, there was likely a native way to interoperate 
them seamlessly.  It seems I was wrong - but it's ok - the workaround was not 
terribly difficult.  I just felt like I was hacking and kludging my way through 
something that surely there must be a better way.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
but it does not imply that in rare cases that either of files are not
busted, that's the reason of "backups" being able to recover last seen (the
lossy case, shit happens)


On Tue, Jul 15, 2014 at 10:06 AM, mm.w <0xcafef...@gmail.com> wrote:

> Simon your design-idea do not reflect any reality, this is weak, there is
> a lack of experience on the topic and we can feel it.
>
> "You won't have anything to commit.  If your application really had
> crashed it wouldn't have any transaction data to commit.  If your
> application had not crashed the transaction would always have worked."
>
> nope you can have a partial upload, a broken socket pipe et cetera, and
> you only assume a version of the file is not already remote and assume that
> after crash you might be able to recover local anyway.
>
>
> there are two scenario to check:
>
> local = remote after any network transaction
> local = remote
>
> after incident:
>  + if not remote, test integrity of local
>  + if remote make sure both are safe
>  + if only remote restore/force sync has you got an interrupt (it happens
> with box)
>
> 1- the network flow could be interrupted no need a power failure for that
> to happen, it can happen that's you face also the case of undetected broken
> pipe, that's the reason you need to be notify by the network pooler API you
> use,
>
> 2- the journal tweaking only concern sqlite file and specific to it, then
> wrong design, make it work for anything using the "common regular" system
> of hashing/signing local to remote to ensure the integrity of the data, at
> least that's the only purpose of this discussion how I am sure whatever
> happen that I have my data in good shape somewhere.
>
>
>
>
>
>
>
> On Tue, Jul 15, 2014 at 9:16 AM, Simon Slavin 
> wrote:
>
>>
>> On 15 Jul 2014, at 2:53pm, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > ok sorry, I did not red all thru, may you simply sha1 local and remote
>> ? if
>> > != commit again
>>
>> You won't have anything to commit.  If your application really had
>> crashed it wouldn't have any transaction data to commit.  If your
>> application had not crashed the transaction would always have worked.
>>
>> Anything that might sync a file automatically can make a mistake like
>> this:
>>
>> 1) computer A and computer B both have local copies of the database open
>> 2) users of computer A and computer B both make changes to their local
>> copies
>> 3) computer A and computer B both close their local copies
>>
>> Now the automatic syncing routine kicks in and notices that both copies
>> have been modified since the last sync.  Whichever copy it chooses, the
>> changes made to the other copy are still going to be lost.
>>
>> Also, since the sync process doesn't understand that the journal file is
>> intimately related to the database file, it can notice one file was updated
>> and copy that across to another computer, and leave the other file as it
>> was.  While SQLite will notice that the two files don't match, and will not
>> corrupt its database by trying to update it with the wrong journal, there's
>> no way to tell whether you are going to get the data before the last
>> transaction was committed or after.
>>
>> My recommendation to the OP is not to do any programming around this at
>> all, since whatever programming you come up with will not be dependable.
>>  The routines for checking unexpected journal files in SQLite are very
>> clever.  Just leave SQLite to sort out rare crashes by itself, which it
>> does pretty well.
>>
>> If, on the other hand, crashes aren't rare then I agree with the other
>> poster to this thread who said that time is better spent diagnosing the
>> cause of your crashes.
>>
>> 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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
Simon your design-idea do not reflect any reality, this is weak, there is a
lack of experience on the topic and we can feel it.

"You won't have anything to commit.  If your application really had crashed
it wouldn't have any transaction data to commit.  If your application had
not crashed the transaction would always have worked."

nope you can have a partial upload, a broken socket pipe et cetera, and you
only assume a version of the file is not already remote and assume that
after crash you might be able to recover local anyway.


there are two scenario to check:

local = remote after any network transaction
local = remote

after incident:
 + if not remote, test integrity of local
 + if remote make sure both are safe
 + if only remote restore/force sync has you got an interrupt (it happens
with box)

1- the network flow could be interrupted no need a power failure for that
to happen, it can happen that's you face also the case of undetected broken
pipe, that's the reason you need to be notify by the network pooler API you
use,

2- the journal tweaking only concern sqlite file and specific to it, then
wrong design, make it work for anything using the "common regular" system
of hashing/signing local to remote to ensure the integrity of the data, at
least that's the only purpose of this discussion how I am sure whatever
happen that I have my data in good shape somewhere.







On Tue, Jul 15, 2014 at 9:16 AM, Simon Slavin  wrote:

>
> On 15 Jul 2014, at 2:53pm, mm.w <0xcafef...@gmail.com> wrote:
>
> > ok sorry, I did not red all thru, may you simply sha1 local and remote ?
> if
> > != commit again
>
> You won't have anything to commit.  If your application really had crashed
> it wouldn't have any transaction data to commit.  If your application had
> not crashed the transaction would always have worked.
>
> Anything that might sync a file automatically can make a mistake like this:
>
> 1) computer A and computer B both have local copies of the database open
> 2) users of computer A and computer B both make changes to their local
> copies
> 3) computer A and computer B both close their local copies
>
> Now the automatic syncing routine kicks in and notices that both copies
> have been modified since the last sync.  Whichever copy it chooses, the
> changes made to the other copy are still going to be lost.
>
> Also, since the sync process doesn't understand that the journal file is
> intimately related to the database file, it can notice one file was updated
> and copy that across to another computer, and leave the other file as it
> was.  While SQLite will notice that the two files don't match, and will not
> corrupt its database by trying to update it with the wrong journal, there's
> no way to tell whether you are going to get the data before the last
> transaction was committed or after.
>
> My recommendation to the OP is not to do any programming around this at
> all, since whatever programming you come up with will not be dependable.
>  The routines for checking unexpected journal files in SQLite are very
> clever.  Just leave SQLite to sort out rare crashes by itself, which it
> does pretty well.
>
> If, on the other hand, crashes aren't rare then I agree with the other
> poster to this thread who said that time is better spent diagnosing the
> cause of your crashes.
>
> 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

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

2014-07-15 Thread Roger Binns 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 14/07/14 22:39, Mayank Kumar (mayankum) wrote:
> The file system is ext3. I am calling this api
> 
> sqlite3_config(SQLITE_CONFIG_LOG, errorLogCallback, NULL);
[...]
> Is my understanding correct since my callback is not getting called ?

Did you check the result of the sqlite3_config call?  It can only be
called before SQLite is initialised.

You can test that the callback is working by trying to open a database
named /dev/null and executing any SQL.  This is an example of the
diagnostics you will get:

  http://rogerbinns.github.io/apsw/tips.html#diagnostics

Roger

-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlPFX04ACgkQmOOfHg372QT16gCgoHzHNaGCVAYwxBfu79iXuRt6
B7gAoJY5RX9MCgimDCSeloiXnNrZncgZ
=uqmR
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread RSmith 


On 2014/07/15 13:48, Edward Ned Harvey (sqlite) wrote:

I would really love to have an easy way of putting a long? into the database,
and then getting a long? back out.  Maybe it exists and I'm just doing it the
hard way right now...

I guess what I'm really getting at is this:  The 5 data types in sqlite are Null, Integer, 
Real, Text, and Blob.  These all have native counterparts in C#, specifically:  null, long? 
(or Nullable), double? (or Nullable), string, and byte[].

If I have something like a long? or a double?, and I want to natively store it 
and retrieve it, I am surprised such a thing doesn't exist.  Instead, I have to 
check for null and if so, then store System.DBNull, and when I retrieve it, I 
have to check for System.DBNull and if so, then return null...


System.DBNull is not a native SQLite construct, it is probably one of the third party connectors. SQLite supports natively a lot of 
methods for data typing that might not be obvious to the TCL or native to third party connectors. Using the API directly one can not 
only access these other methods but also add innumerable conversion routines to suit your flavour of project variable types.


That said, I am sure that if you were using the API natively, or able to do so, the question would never arise, so I understand that 
this is not an option. Further to this, I am not sure which development environment you are using, I am guessing some C or scripting 
format or such, all of which support different data typing, and more importantly, none of which is a standard or used in a wide 
variety of systems - which is why the other poster did not even know what you meant with "long?".  SQLite's narrow set of types play 
to the advantage of being connectable to all the myriad of platforms it supports, but sadly with it comes the caveat of not having 
many specific types and some of the base types are maybe a bit too wide - I believe they are getting fleshed out a bit in SQLite4.  
Maybe ask the designers of your connector for such functionality?


Either way, I hope you find a suitable solution, and if you do manage to get a change for the connector in support of your quest, be 
sure to let us know!


Cheers,
Ryan


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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread Simon Slavin 

On 15 Jul 2014, at 2:53pm, mm.w <0xcafef...@gmail.com> wrote:

> ok sorry, I did not red all thru, may you simply sha1 local and remote ? if
> != commit again

You won't have anything to commit.  If your application really had crashed it 
wouldn't have any transaction data to commit.  If your application had not 
crashed the transaction would always have worked.

Anything that might sync a file automatically can make a mistake like this:

1) computer A and computer B both have local copies of the database open
2) users of computer A and computer B both make changes to their local copies
3) computer A and computer B both close their local copies

Now the automatic syncing routine kicks in and notices that both copies have 
been modified since the last sync.  Whichever copy it chooses, the changes made 
to the other copy are still going to be lost.

Also, since the sync process doesn't understand that the journal file is 
intimately related to the database file, it can notice one file was updated and 
copy that across to another computer, and leave the other file as it was.  
While SQLite will notice that the two files don't match, and will not corrupt 
its database by trying to update it with the wrong journal, there's no way to 
tell whether you are going to get the data before the last transaction was 
committed or after.

My recommendation to the OP is not to do any programming around this at all, 
since whatever programming you come up with will not be dependable.  The 
routines for checking unexpected journal files in SQLite are very clever.  Just 
leave SQLite to sort out rare crashes by itself, which it does pretty well.

If, on the other hand, crashes aren't rare then I agree with the other poster 
to this thread who said that time is better spent diagnosing the cause of your 
crashes.

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

Re: [sqlite] R-tree index database

2014-07-15 Thread Clemens Ladisch 
Grzegorz Sikorski wrote:
> On 15/07/14 16:13, Clemens Ladisch wrote:
>> Grzegorz Sikorski wrote:
>>> I have a database file with single virtual table storing R*tree index.
>>> There is very strange behaviour I observe: the more rows I put into
>>> this table the longer sqlite3_open_v2 operation on the database takes.
>>
>> SQLite does not read table contents when opening a database.
>
> Sorry, maybe I was not very clear. Adding calls to open/close over
> insert statements operation heavily increases the total insert time
> (including open/exec/close).

Closing a database also throws away its page cache.

> What is strange here, if I add open/close calls around another
> databases that hold only raw SQLite3 tables, the overhead in similar
> scenario is negligible.

'Normal' tables can just append new records at the end; this is not
possible in R-trees.


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

Re: [sqlite] R-tree index database

2014-07-15 Thread Clemens Ladisch 
Grzegorz Sikorski wrote:
> I have a database file with single virtual table storing R*tree index.
> There is very strange behaviour I observe: the more rows I put into
> this table the longer sqlite3_open_v2 operation on the database takes.

SQLite does not read table contents when opening a database.

This sounds like a virus scanner running amok.

> ExchangeDefender Message Security: Click below to verify authenticity
> https://admin.exchangedefender.com/verify.php?id=s6FAo3io010130&from=g.sikor...@camlintechnologies.com

What prevents a virus from replacing this link with
?


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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
forgot if != commit again or restore if local unusable (lossy scenario)


On Tue, Jul 15, 2014 at 7:01 AM, mm.w <0xcafef...@gmail.com> wrote:

> yes indeed the "journal tweaking" would work solely for this special file
> case, comparing local and remote that's how for instance git works like
> many other sync software, I don't know the API but is the box thing notify
> you "on start transaction" then "on close", if not it sucks ?
>
>
> On Tue, Jul 15, 2014 at 6:53 AM, mm.w <0xcafef...@gmail.com> wrote:
>
>> ok sorry, I did not red all thru, may you simply sha1 local and remote ?
>> if != commit again
>>
>>
>> On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin 
>> wrote:
>>
>>>
>>> On 15 Jul 2014, at 2:20am, William Drago 
>>> wrote:
>>>
>>> > The software doesn't crash on its own; I'm forcing it to crash with a
>>> divide-by-zero for test purposes. This doesn't happen in actual use and
>>> there's no reason other than a power failure for a transaction to not
>>> commit successfully. But that doesn't mean I shouldn't handle a failed
>>> transaction if it ever does happen.
>>>
>>> If all you're trying to do is spot crashes then you don't have to
>>> implement your own semaphore system or locking system.  Use
>>>
>>> PRAGMA journal_mode = DELETE
>>>
>>> which is the default.  Then you know that if a journal file exists, a
>>> process is in the middle of a transaction, or a process which in the middle
>>> of a transaction crashed.
>>>
>>> All you need to do is check to see if a file exists with the name of the
>>> journal file.  Presumably you'd be wanting to do this when your application
>>> starts up, before it opens the database.
>>>
>>> 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

Re: [sqlite] pragma and prepare statement

2014-07-15 Thread Baptiste Daroussin 
The second point seems to explain my problems thanks you

2014-07-10 18:05 GMT+02:00 Dan Kennedy :
> On 07/10/2014 08:44 PM, Baptiste Daroussin wrote:
>>
>> Hi,
>>
>> We are using sqlite intensively in out developement and we discovered
>> that apparently we cannot create a statement with a pragma
>>
>> Is there a reason why it is not possible? is it a bug or a per design
>
>
> The docs feature the following two points:
>
> * No error messages are generated if an unknown pragma is issued. Unknown
> pragmas are simply ignored. This means if there is a typo in a pragma
> statement the library does not inform the user of the fact.
>
> * Some pragmas take effect during the SQL compilation stage, not the
> execution stage. This means if using the C-language sqlite3_prepare()
> , sqlite3_step()
> , sqlite3_finalize()
>  API (or similar in a wrapper
> interface), the pragma may run during the sqlite3_prepare()
>  call, not during the
> sqlite3_step()  call as normal SQL
> statements do. Or the pragma might run during sqlite3_step() just like
> normal SQL statements. Whether or not the pragma runs during
> sqlite3_prepare() or sqlite3_step() depends on the pragma and on the
> specific release of SQLite.
>
> Do either of them explain what you are seeing?
>
>   https://www.sqlite.org/pragma.html
>
> Dan.
>
>
>
> ___
> 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] capturing and testing a hot journal

2014-07-15 Thread mm.w 
yes indeed the "journal tweaking" would work solely for this special file
case, comparing local and remote that's how for instance git works like
many other sync software, I don't know the API but is the box thing notify
you "on start transaction" then "on close", if not it sucks ?


On Tue, Jul 15, 2014 at 6:53 AM, mm.w <0xcafef...@gmail.com> wrote:

> ok sorry, I did not red all thru, may you simply sha1 local and remote ?
> if != commit again
>
>
> On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin 
> wrote:
>
>>
>> On 15 Jul 2014, at 2:20am, William Drago 
>> wrote:
>>
>> > The software doesn't crash on its own; I'm forcing it to crash with a
>> divide-by-zero for test purposes. This doesn't happen in actual use and
>> there's no reason other than a power failure for a transaction to not
>> commit successfully. But that doesn't mean I shouldn't handle a failed
>> transaction if it ever does happen.
>>
>> If all you're trying to do is spot crashes then you don't have to
>> implement your own semaphore system or locking system.  Use
>>
>> PRAGMA journal_mode = DELETE
>>
>> which is the default.  Then you know that if a journal file exists, a
>> process is in the middle of a transaction, or a process which in the middle
>> of a transaction crashed.
>>
>> All you need to do is check to see if a file exists with the name of the
>> journal file.  Presumably you'd be wanting to do this when your application
>> starts up, before it opens the database.
>>
>> 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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w 
ok sorry, I did not red all thru, may you simply sha1 local and remote ? if
!= commit again


On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin  wrote:

>
> On 15 Jul 2014, at 2:20am, William Drago  wrote:
>
> > The software doesn't crash on its own; I'm forcing it to crash with a
> divide-by-zero for test purposes. This doesn't happen in actual use and
> there's no reason other than a power failure for a transaction to not
> commit successfully. But that doesn't mean I shouldn't handle a failed
> transaction if it ever does happen.
>
> If all you're trying to do is spot crashes then you don't have to
> implement your own semaphore system or locking system.  Use
>
> PRAGMA journal_mode = DELETE
>
> which is the default.  Then you know that if a journal file exists, a
> process is in the middle of a transaction, or a process which in the middle
> of a transaction crashed.
>
> All you need to do is check to see if a file exists with the name of the
> journal file.  Presumably you'd be wanting to do this when your application
> starts up, before it opens the database.
>
> 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

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Edward Ned Harvey (sqlite) 
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Edward Ned Harvey (sqlite)
> 
> I would really love to have an easy way of putting a long? into the database,
> and then getting a long? back out.  Maybe it exists and I'm just doing it the
> hard way right now...

I guess what I'm really getting at is this:  The 5 data types in sqlite are 
Null, Integer, Real, Text, and Blob.  These all have native counterparts in C#, 
specifically:  null, long? (or Nullable), double? (or Nullable), 
string, and byte[].

If I have something like a long? or a double?, and I want to natively store it 
and retrieve it, I am surprised such a thing doesn't exist.  Instead, I have to 
check for null and if so, then store System.DBNull, and when I retrieve it, I 
have to check for System.DBNull and if so, then return null...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Edward Ned Harvey (sqlite) 
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Hick Gunter
> 
> Why is the column nullable if you require a default value to be returned?

The default value for long? or string or byte[] is null.  Which makes perfect 
sense.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Edward Ned Harvey (sqlite) 
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Random Coder
> 
> Could you not do something like this to handle the nullable types?
> 
> T GetValue(string field)
> {
> object obj = reader[field];
> 
> if (obj is System.DBNull)
> return default(T);
> else
> return (T)obj;
> }
> 
> Assuming the type is nullable, it should do the right thing, and if it's an
> unexpected type, it'll throw an exception when casting to T.

In fact, that's what I'm doing now - except I decided to make it specifically 
long, string, and byte[], rather than generic.  Because I wanted to discourage 
any sort of belief of actual support for things like int, uint16, uint64, etc.  
All of which would technically work except ulong (uint64)...

If this is the way people use it, so be it.  I just thought there would 
probably exist something more natural, that I couldn't find...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Edward Ned Harvey (sqlite) 
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Joseph L. Casale
> 
> > I would really love to have an easy way of putting a long? into the 
> > database,
> and then getting a long? back out.
> 
> What do you want to happen when the column is null as in your string
> example?

I would like the long? to be null.  

Based on your response, it seems you didn't notice the ? mark.  This is a 
shorthand for Nullable which means it may be either null, or a long. 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] R-tree index database

2014-07-15 Thread Grzegorz Sikorski 

Hi,

I have a database file with single virtual table storing R*tree index. 
There is very strange behaviour I observe: the more rows I put into this 
table the longer sqlite3_open_v2 operation on the database takes. The 
database open/close performance hit is huge and growing linearly with 
the number of rows in the table. However if I keep the connection opened 
all the time, the insert performance is fine and stays more-less 
independent on number of rows. Is this expected behaviour or a bug?


Regards,
Greg

--
ExchangeDefender Message Security: Click below to verify authenticity
https://admin.exchangedefender.com/verify.php?id=s6FAo3io010130&from=g.sikor...@camlintechnologies.com


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

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread Simon Slavin 

On 15 Jul 2014, at 2:20am, William Drago  wrote:

> The software doesn't crash on its own; I'm forcing it to crash with a 
> divide-by-zero for test purposes. This doesn't happen in actual use and 
> there's no reason other than a power failure for a transaction to not commit 
> successfully. But that doesn't mean I shouldn't handle a failed transaction 
> if it ever does happen.

If all you're trying to do is spot crashes then you don't have to implement 
your own semaphore system or locking system.  Use

PRAGMA journal_mode = DELETE

which is the default.  Then you know that if a journal file exists, a process 
is in the middle of a transaction, or a process which in the middle of a 
transaction crashed.

All you need to do is check to see if a file exists with the name of the 
journal file.  Presumably you'd be wanting to do this when your application 
starts up, before it opens the database.

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

Re: [sqlite] Preferred cast in C#

2014-07-15 Thread Hick Gunter 
Why is the column nullable if you require a default value to be returned?

-Ursprüngliche Nachricht-
Von: Random Coder [mailto:random.co...@gmail.com]
Gesendet: Dienstag, 15. Juli 2014 03:50
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Preferred cast in C#

Could you not do something like this to handle the nullable types?

T GetValue(string field)
{
object obj = reader[field];

if (obj is System.DBNull)
return default(T);
else
return (T)obj;
}

Assuming the type is nullable, it should do the right thing, and if it's an 
unexpected type, it'll throw an exception when casting to T.



On Mon, Jul 14, 2014 at 4:07 PM, Edward Ned Harvey (sqlite) < 
sql...@nedharvey.com> wrote:

> I understand there are only 5 data types in Sqlite, and that the
> column type isn't necessarily the type of object returned in a query.
> Is there a more seamless way to cast responses than this?
>
> I would really love to have an easy way of putting a long? into the
> database, and then getting a long? back out.  Maybe it exists and I'm
> just doing it the hard way right now...
>
> string employeeName;
>
> object myObj = reader["employeeName"];
> if (myObj is System.DBNull)
> employeeName = null;
> else if (myObj is string)
> employeeName = (string)myObj;
> else
> throw new Exception("Unexpected object type");
> ___
> 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


---
Gunter Hick
Software Engineer

Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna,
Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then
delete this message from your system. Please do not copy it or use it for any 
purposes, or disclose its contents to any person as to do so could be a breach 
of confidence. Thank you for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users