Re: [sqlite] capturing and testing a hot journal

[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 <sc...@casaderobison.com>
>> 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
>

Re: [sqlite] capturing and testing a hot journal

[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 <sc...@casaderobison.com>
> 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
>> > >>>>>>>&

Re: [sqlite] capturing and testing a hot journal

[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 <sc...@casaderobison.com>
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.
> > >>>>>>>>>>>
> > >>>>>>>>>>>
> > >>>>&g

Re: [sqlite] capturing and testing a hot journal

[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 <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
>>>>>>>>>>>> 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

[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 <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
>>>>>>>>>>> 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

[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 <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
>>>>>>>>>> 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

[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 <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
>>>>>>>>> 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

[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 <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
>>>>>>> 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

[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 <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
>>>>>>>> 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

[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 <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
>>>>>> 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

[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 <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 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

[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 <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 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

[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 <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 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

[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 <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 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

[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 <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 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

[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 <slav...@bigfraud.org>
> 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

[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 <slav...@bigfraud.org> 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

[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 <rsm...@rsweb.co.za> 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

[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 <rsm...@rsweb.co.za> 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

[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 <rsm...@rsweb.co.za> 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

[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 <rsm...@rsweb.co.za> 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
>>>&g

Re: [sqlite] capturing and testing a hot journal

[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 <rsm...@rsweb.co.za> 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

[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 <rsm...@rsweb.co.za> 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

[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 <rsm...@rsweb.co.za> 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

[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 <rsm...@rsweb.co.za> 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

[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 <slav...@bigfraud.org>
> 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

[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 <slav...@bigfraud.org> 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

[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 <slav...@bigfraud.org>
>> wrote:
>>
>>>
>>> On 15 Jul 2014, at 2:20am, William Drago <wdr...@suffolk.lib.ny.us>
>>> 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

[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 <slav...@bigfraud.org>
> wrote:
>
>>
>> On 15 Jul 2014, at 2:20am, William Drago <wdr...@suffolk.lib.ny.us>
>> 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

[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] capturing and testing a hot journal

[mm.w]

seriously? you should fix and solve why the soft crashed in the first
place, reality check please.

"But it is possible that Dropbox will copy a database and journal
files that are not consistent with each other, which can create
problems"

fix the sync process, that's easy.

Best.



On Mon, Jul 14, 2014 at 3:04 PM, Drago, William @ MWG - NARDAEAST <
william.dr...@l-3com.com> wrote:

> This may be a bit simplistic, but it does give me a reasonable degree of
> confidence that hot journal files are being handled correctly in my
> application.
>
> I simply put a 1/0 on the line before my commit to purposely crash my app.
> Sure enough there's a journal file after the crash (I have a rather large
> transaction consisting of among other things, about 35 rows inserted, each
> containing a blob).
>
> When I restart my app it looks for the presence of a journal file and will
> open and read the db so that SQLite can deal with it. It also displays a
> message letting the user know that something went wrong during the last run.
>
> I do this with a test db of course, not the real one.
>
> -Bill
>
>
>
>
> > -Original Message-
> > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> > boun...@sqlite.org] On Behalf Of Charles Parnot
> > Sent: Saturday, July 12, 2014 4:38 AM
> > To: sqlite-users@sqlite.org
> > Subject: [sqlite] capturing and testing a hot journal
> >
> > Hi all,
> >
> > For testing purposes of our application (a Mac app), I am generating
> > what I thought would be a database with a "hot" journal using this
> > approach (on an existing database):
> >
> > - open the database (and PRAGMA journal_mode = TRUNCATE;)
> > - open a transaction: BEGIN IMMEDIATE TRANSACTION;
> > - add some rows: INSERT etc...
> > - **make a copy of the db and journal files** (while still hot?)
> > - close the transaction
> >
> > Then I open the copied database+journal (naming the files
> > appropriately), again in TRUNCATE journal mode. As expected, the
> > content of the database does not include the inserted rows. However,
> > the journal file is not emptied, even after closing the database. Based
> > on the documentation
> > (http://www.sqlite.org/lockingv3.html#hot_journals), I would have
> > expected the journal file to be emptied because it is "hot".
> >
> > There are 2 options here:
> >
> > - the journal file is actually not "hot" and I misunderstood the
> > conditions that make it hot
> > - there is a bug in SQLite
> >
> > Obviously, I strongly suspect I am misunderstanding things, and don't
> > think it is an SQLite bug. Despite intensive Google-ing and more
> > testing, I am not sure what makes the journal non-hot.
> >
> > Thanks for your help!
> >
> > Charles
> >
> >
> > NB: You might be wondering why I am doing the above. I realize SQLite
> > has already much more advanced tests for "hot" db+journals (running
> > custom versions of filesystems to generate all kind of edge cases). The
> > test case I am generating is just for a simple edge case of our
> > Dropbox-based syncing (see: https://github.com/cparnot/PARStore and
> > http://mjtsai.com/blog/2014/05/21/findings-1-0-and-parstore/). For a
> > given database file, there is only one device that can write to it, all
> > other devices being read-only (not in terms of filesystem, but sqlite-
> > wise). But it is possible that Dropbox will copy a database and journal
> > files that are not consistent with each other, which can create
> > problems. For instance, maybe a read-only device could try to open the
> > (still old) database with a new non-empty journal file and sqlite would
> > empty that journal file, then Dropbox could in turn empty the journal
> > file before the writer client had finished the transaction. I am not
> > (yet) going to test for and try to protect against more complicated
> > (and rarer) edge cases where the database is in the middle of writing a
> > transaction (which I suspect will only happen in case of crashes, not
> > because of Dropbox, in which case the recovery of the database by the
> > read-only client would actually be beneficial).
> >
> > --
> > Charles Parnot
> > charles.par...@gmail.com
> > http://app.net/cparnot
> > twitter: @cparnot
> >
> > Your Lab Notebook, Reinvented.
> > http://findingsapp.com
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 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 

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

[mm.w]

what's your file system? looks like not related at all to sqlite but your
code


On Fri, Jul 11, 2014 at 4:31 PM, Mayank Kumar (mayankum)  wrote:

> Hi Richard
> I have enabled error  logging as suggested. Is there a way to test this
> logging. For e.g. I just corrupted the database by modifying the sqlite db
> using vi and then got the following message:-
>
> "file is encrypted or is not a database"
> After this error message my process dies(we terminate the process), and I
> don't see any logs from my callback.  Is this callback called before the
> sqlite3_xxx calls returns , if yes then why I don't see any error messages
> from the callback ?
>
> -Mayank
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:
> sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp
> Sent: Tuesday, July 08, 2014 1:05 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Sometimes when my process restarts, it returns error
> "database is locked"
>
> On Tue, Jul 8, 2014 at 3:58 PM, Mayank Kumar (mayankum) <
> mayan...@cisco.com>
> wrote:
>
> > Hi All
> >
> > We have a process with a single sqlite db and a single connection to
> > the database from a thread. From time to time our processs restarts
> > and reopens the database or tries to create the database if it doesn't
> exists.
> >  Sometimes when the process restarts, we get the error "database is
> locked"
> > although the way the process is restarted is the following:-
> >
> > -we always starts the process as a child by doing a vfork and exec -if
> > we receive a sigchld, we waitpid and finally restarts the process in
> > same way
> >
>
> I don't think this is possible.  I think something else must be going on.
>
> Have you enabled logging?  See http://www.sqlite.org/errlog.html for
> details.  The error log might give additional clues.
>
>
>
> >
> > Could this scenario ever lead to database locked scenario, should we
> > build a retry mechanism when we get this error or this shouldn't occur
> > if we know the older process has died.
> >
> > Any suggestions?
> >
> > -Mayank
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can't make SQLite work

[mm.w]

thx to teach me-self about the port LOL


On Wed, Jul 9, 2014 at 3:03 PM, mm.w <0xcafef...@gmail.com> wrote:

> ? ...
>
>
> On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin <slav...@bigfraud.org>
> wrote:
>
>>
>> On 7 Jul 2014, at 4:21am, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > as we start low a more simple solution if recent features are needed
>>
>> Nothing to do with MacPorts is simple.
>>
>> If you've messed up your shell path and 'which sqlite3' doesn't give an
>> answer, just download the executable from the SQLite download page.
>>
>> 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] Can't make SQLite work

[mm.w]

? ...


On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 7 Jul 2014, at 4:21am, mm.w <0xcafef...@gmail.com> wrote:
>
> > as we start low a more simple solution if recent features are needed
>
> Nothing to do with MacPorts is simple.
>
> If you've messed up your shell path and 'which sqlite3' doesn't give an
> answer, just download the executable from the SQLite download page.
>
> 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] Can't make SQLite work

[mm.w]

? ...


On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 7 Jul 2014, at 4:21am, mm.w <0xcafef...@gmail.com> wrote:
>
> > as we start low a more simple solution if recent features are needed
>
> Nothing to do with MacPorts is simple.
>
> If you've messed up your shell path and 'which sqlite3' doesn't give an
> answer, just download the executable from the SQLite download page.
>
> 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] column affinity and the query planner's use of indices

[mm.w]

Hello, Keith Medcalf would not be "more simple" just to say "create your
own metadata wrapper"
which is perfectly doable and legitimate in such case.

Best.


On Tue, Jul 8, 2014 at 10:47 AM, Simon Slavin  wrote:

>
> On 8 Jul 2014, at 6:16pm, Hinrichsen, John  wrote:
>
> >>> It would be more intuitive: why should aggregate functions like min(),
> >>> max(), and sum() return column data stripped of the original column
> >>> affinity?
>
> Can you talk us through the original problem again ?
>
> Are you talking about the affinity of the column x, or the affinity of the
> result of these functions.  And how is this a problem ?
>
> 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] Sqlite in dead lock state when deleting records from the same table from different threads

[mm.w]

your sunglasses won't stop my gaze


On Mon, Jul 7, 2014 at 4:21 PM, mm.w <0xcafef...@gmail.com> wrote:

> comply to my request or stop, sorry but truth must be told at some point.
>
>
> On Mon, Jul 7, 2014 at 6:02 AM, Srikanth Bemineni <
> bemineni.srika...@gmail.com> wrote:
>
>> Hi,
>>
>> How can I find this in the statement ?
>>
>> Will BEGIN immediate get an exclusive lock.? or like Igor specified if I
>> call "Delete * from where 0" will it be able to get an immediate lock on
>> the table.
>>
>> Srikanth
>>
>>
>>
>> On Sun, Jul 6, 2014 at 9:21 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > what's the syscall set behind the scene might help, os?
>> >
>> >
>> > On Sun, Jul 6, 2014 at 6:04 PM, Srikanth Bemineni <
>> > bemineni.srika...@gmail.com> wrote:
>> >
>> > > Hi,
>> > >
>> > > Is it possible for any  SQLLite developer to explain the locking
>> > mechanism
>> > > in case of the shared connections, specifically table level locking,
>> how
>> > I
>> > > can debug this and find out who is holding the lock. ?
>> > >
>> > > Srikanth Bemineni
>> > >
>> > >
>> > >
>> > >
>> > > On Thu, Jul 3, 2014 at 12:47 PM, Srikanth Bemineni <
>> > > bemineni.srika...@gmail.com> wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > But in shared cache mode. I assume this is going to be a table level
>> > > lock,
>> > > > instead of a lock on the whole database. This will really block
>> other
>> > > > threads which are dealing with other tables.
>> > > >
>> > > >
>> > > > http://www.sqlite.org/sharedcache.html
>> > > >
>> > > > 2.1 Transaction Level Locking
>> > > >
>> > > > SQLite connections can open two kinds of transactions, read and
>> write
>> > > > transactions. This is not done explicitly, a transaction is
>> implicitly
>> > a
>> > > > read-transaction until it first writes to a database table, at which
>> > > point
>> > > > it becomes a write-transaction.
>> > > >
>> > > > At most one connection to a single shared cache may open a write
>> > > > transaction at any one time. This may co-exist with any number of
>> read
>> > > > transactions.
>> > > > 2.2 Table Level Locking
>> > > >
>> > > > When two or more connections use a shared-cache, locks are used to
>> > > > serialize concurrent access attempts on a per-table basis. Tables
>> > support
>> > > > two types of locks, "read-locks" and "write-locks". Locks are
>> granted
>> > to
>> > > > connections - at any one time, each database connection has either a
>> > > > read-lock, write-lock or no lock on each database table.
>> > > >
>> > > > At any one time, a single table may have any number of active
>> > read-locks
>> > > > or a single active write lock. To read data a table, a connection
>> must
>> > > > first obtain a read-lock. To write to a table, a connection must
>> > obtain a
>> > > > write-lock on that table. If a required table lock cannot be
>> obtained,
>> > > the
>> > > > query fails and SQLITE_LOCKED is returned to the caller.
>> > > >
>> > > > Once a connection obtains a table lock, it is not released until the
>> > > > current transaction (read or write) is concluded.
>> > > >
>> > > >
>> > > > As per the above documentation
>> > > > "Once a connection obtains a table lock, it is not released until
>> the
>> > > > current transaction (read or write) is concluded."
>> > > >
>> > > > This means once the statement is finalized or the whole transaction
>> > > > is committed. Currently I am getting an error on table level locks
>> > > >
>> > > > Thread 1 SQLITE_LOCKED(6) Error  is locked
>> > > > Thread 2 SQLITE_LOCKED(6) Error database table is locked
>> > > >
>> > > > Srikanth Bemineni
>> > > >
>> > > >
>> > > > On Thu, Jul 3, 2014 at 12:35 PM, Simon Slavin 

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

[mm.w]

comply to my request or stop, sorry but truth must be told at some point.


On Mon, Jul 7, 2014 at 6:02 AM, Srikanth Bemineni <
bemineni.srika...@gmail.com> wrote:

> Hi,
>
> How can I find this in the statement ?
>
> Will BEGIN immediate get an exclusive lock.? or like Igor specified if I
> call "Delete * from where 0" will it be able to get an immediate lock on
> the table.
>
> Srikanth
>
>
>
> On Sun, Jul 6, 2014 at 9:21 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > what's the syscall set behind the scene might help, os?
> >
> >
> > On Sun, Jul 6, 2014 at 6:04 PM, Srikanth Bemineni <
> > bemineni.srika...@gmail.com> wrote:
> >
> > > Hi,
> > >
> > > Is it possible for any  SQLLite developer to explain the locking
> > mechanism
> > > in case of the shared connections, specifically table level locking,
> how
> > I
> > > can debug this and find out who is holding the lock. ?
> > >
> > > Srikanth Bemineni
> > >
> > >
> > >
> > >
> > > On Thu, Jul 3, 2014 at 12:47 PM, Srikanth Bemineni <
> > > bemineni.srika...@gmail.com> wrote:
> > >
> > > > Hi,
> > > >
> > > > But in shared cache mode. I assume this is going to be a table level
> > > lock,
> > > > instead of a lock on the whole database. This will really block other
> > > > threads which are dealing with other tables.
> > > >
> > > >
> > > > http://www.sqlite.org/sharedcache.html
> > > >
> > > > 2.1 Transaction Level Locking
> > > >
> > > > SQLite connections can open two kinds of transactions, read and write
> > > > transactions. This is not done explicitly, a transaction is
> implicitly
> > a
> > > > read-transaction until it first writes to a database table, at which
> > > point
> > > > it becomes a write-transaction.
> > > >
> > > > At most one connection to a single shared cache may open a write
> > > > transaction at any one time. This may co-exist with any number of
> read
> > > > transactions.
> > > > 2.2 Table Level Locking
> > > >
> > > > When two or more connections use a shared-cache, locks are used to
> > > > serialize concurrent access attempts on a per-table basis. Tables
> > support
> > > > two types of locks, "read-locks" and "write-locks". Locks are granted
> > to
> > > > connections - at any one time, each database connection has either a
> > > > read-lock, write-lock or no lock on each database table.
> > > >
> > > > At any one time, a single table may have any number of active
> > read-locks
> > > > or a single active write lock. To read data a table, a connection
> must
> > > > first obtain a read-lock. To write to a table, a connection must
> > obtain a
> > > > write-lock on that table. If a required table lock cannot be
> obtained,
> > > the
> > > > query fails and SQLITE_LOCKED is returned to the caller.
> > > >
> > > > Once a connection obtains a table lock, it is not released until the
> > > > current transaction (read or write) is concluded.
> > > >
> > > >
> > > > As per the above documentation
> > > > "Once a connection obtains a table lock, it is not released until the
> > > > current transaction (read or write) is concluded."
> > > >
> > > > This means once the statement is finalized or the whole transaction
> > > > is committed. Currently I am getting an error on table level locks
> > > >
> > > > Thread 1 SQLITE_LOCKED(6) Error  is locked
> > > > Thread 2 SQLITE_LOCKED(6) Error database table is locked
> > > >
> > > > Srikanth Bemineni
> > > >
> > > >
> > > > On Thu, Jul 3, 2014 at 12:35 PM, Simon Slavin <slav...@bigfraud.org>
> > > > wrote:
> > > >
> > > >>
> > > >> On 3 Jul 2014, at 6:11pm, Srikanth Bemineni <
> > > bemineni.srika...@gmail.com>
> > > >> wrote:
> > > >> >
> > > >> > As per Igor
> > > >> > BEGIN IMMEDIATE should get a write lock on the table 1 when first
> > > select
> > > >> > call is initiated
> > > >> >
> > > >> > 10:00.234 Thread 1 BEGIN
> > >

Re: [sqlite] Can't make SQLite work

[mm.w]

as we start low a more simple solution if recent features are needed

http://www.macports.org/

sudo port install sqlite3

best


On Sun, Jul 6, 2014 at 10:27 AM, Richard Hipp  wrote:

> On Sat, Jul 5, 2014 at 3:46 PM, Mike Seabrook Sr 
> wrote:
>
> > Hi there,
> >
> > I am a Masters student at Grand Canyon University. We are to download
> your
> > product. You can download the executable free of charge directly from the
> > SQLite project Web site at http://sqlite.org, which also provides
> > extensive documentation and tutorials on its usage. Yet only MacBook Pro
> I
> > am using the Mountain Lion OS X 10.8.5. I can't make your program
> download
> > to complete this week's homework assignment to turn in by Wednesday
> > morning. Can you please guide me to making this work?
> >
>
> All Macs for the past 8 years come with the "sqlite3" program
> pre-installed.  Just type "sqlite3" from the command-line prompt.
>
> You'd only need to download a new version if you need some of the more
> recent features.
>
>
>
>
> >
> > Mike Seabrook
> > 602-717-7462.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

[mm.w]

what's the syscall set behind the scene might help, os?


On Sun, Jul 6, 2014 at 6:04 PM, Srikanth Bemineni <
bemineni.srika...@gmail.com> wrote:

> Hi,
>
> Is it possible for any  SQLLite developer to explain the locking mechanism
> in case of the shared connections, specifically table level locking, how I
> can debug this and find out who is holding the lock. ?
>
> Srikanth Bemineni
>
>
>
>
> On Thu, Jul 3, 2014 at 12:47 PM, Srikanth Bemineni <
> bemineni.srika...@gmail.com> wrote:
>
> > Hi,
> >
> > But in shared cache mode. I assume this is going to be a table level
> lock,
> > instead of a lock on the whole database. This will really block other
> > threads which are dealing with other tables.
> >
> >
> > http://www.sqlite.org/sharedcache.html
> >
> > 2.1 Transaction Level Locking
> >
> > SQLite connections can open two kinds of transactions, read and write
> > transactions. This is not done explicitly, a transaction is implicitly a
> > read-transaction until it first writes to a database table, at which
> point
> > it becomes a write-transaction.
> >
> > At most one connection to a single shared cache may open a write
> > transaction at any one time. This may co-exist with any number of read
> > transactions.
> > 2.2 Table Level Locking
> >
> > When two or more connections use a shared-cache, locks are used to
> > serialize concurrent access attempts on a per-table basis. Tables support
> > two types of locks, "read-locks" and "write-locks". Locks are granted to
> > connections - at any one time, each database connection has either a
> > read-lock, write-lock or no lock on each database table.
> >
> > At any one time, a single table may have any number of active read-locks
> > or a single active write lock. To read data a table, a connection must
> > first obtain a read-lock. To write to a table, a connection must obtain a
> > write-lock on that table. If a required table lock cannot be obtained,
> the
> > query fails and SQLITE_LOCKED is returned to the caller.
> >
> > Once a connection obtains a table lock, it is not released until the
> > current transaction (read or write) is concluded.
> >
> >
> > As per the above documentation
> > "Once a connection obtains a table lock, it is not released until the
> > current transaction (read or write) is concluded."
> >
> > This means once the statement is finalized or the whole transaction
> > is committed. Currently I am getting an error on table level locks
> >
> > Thread 1 SQLITE_LOCKED(6) Error  is locked
> > Thread 2 SQLITE_LOCKED(6) Error database table is locked
> >
> > Srikanth Bemineni
> >
> >
> > On Thu, Jul 3, 2014 at 12:35 PM, Simon Slavin 
> > wrote:
> >
> >>
> >> On 3 Jul 2014, at 6:11pm, Srikanth Bemineni <
> bemineni.srika...@gmail.com>
> >> wrote:
> >> >
> >> > As per Igor
> >> > BEGIN IMMEDIATE should get a write lock on the table 1 when first
> select
> >> > call is initiated
> >> >
> >> > 10:00.234 Thread 1 BEGIN
> >> > 10:00.235 Thread 1 select * from 
> >> > 10:00.234 Thread 1 select * from 
> >> > 10:00.456 Thread 1 delete from 
> >> > 10:00.500 Thread 1 COMMIT
> >> >
> >> > Igor
> >> >
> >> > 1. If there is no second thread , then the above transaction works
> fine.
> >> > Here also I am doing the select operation first . So the same thread
> can
> >> > update a read lock to write lock ?
> >> >
> >> > 2. Will BEGIN IMMEDIATE  get a write lock on the table for the first
> >> select
> >> > statement as per the  thread sequence above.
> >>
> >> You're referring to 'read lock' and 'write lock' but it's easier to
> think
> >> of there just being a lock.
> >>
> >> BEGIN IMMEDIATE gets a lock right there at the BEGIN IMMEDIATE command.
> >>  It doesn't have to wait for anything later.  Now nothing else can
> happen
> >> to the database until the COMMIT/ROLLBACK.
> >>
> >> Simon.
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users@sqlite.org
> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >>
> >
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Updating one DB from another

[mm.w]

morality: opting for the pseudo-hot-sync-based-on-will-be-ever-faulty, in
the first place, was ridiculous, I don't know how it could have been even
retained.

-- best.


On Thu, Jun 19, 2014 at 3:19 PM, mm.w <0xcafef...@gmail.com> wrote:

> diff and update when a user is actually migrating, let server1 run until
> all users have migrated, if migrated prevents to ever connect to server1
>
> simple.
>
> best
>
>
> On Thu, Jun 19, 2014 at 1:59 PM, jose isaias cabrera <
> cabr...@wrc.xerox.com> wrote:
>
>> Simon Slavin wrote...
>>
>>
>>
>>> On 19 Jun 2014, at 3:55pm, jose isaias cabrera <cabr...@wrc.xerox.com>
>>> wrote:
>>>
>>>  These servers will be in two different servers and in two different
>>>> parts of the world, so network access will be very slow.  What I am
>>>> thinking in doing is to copy the data on Server1 to Server2 and set the
>>>> starting id at a higher point than the last id on Server1.  For example,
>>>> Server1 highest project id is 134000, so, I would set the start id for
>>>> Server2 to 135000. The Server two will continue to add new projects, so the
>>>> next project id will be 135001 and so forth.
>>>>
>>>
>>> Is your whole database really just in a single table ?  If not, you have
>>> to figure out how to spot related records in other tables.  Once you've
>>> done that you need to have a 'LastUpdateDate' column on every table.  And
>>> then you have to worry about spotting rows which have been deleted. Since
>>> the row has been deleted, there are no 'LastUpdateDate' values which let
>>> you spot it !
>>>
>>
>> Thanks for helping Simon.  Yes, there are a bunch of more tables and yes,
>> each of them have a LastUpdateDate and they all will be based on ProjID,
>> which is id in the LSOpenProjects table.  This is only temporarery until we
>> close all the records in Server1.db and then, only one db, Server2.db will
>> be used.
>>
>>
>>
>>> Synchronising two different databases is ridiculously difficult to get
>>> right.  Especially when both of them continue to be modified and when you
>>> continue to make use of AUTOINCREMENT columns to number new rows.  There is
>>> no good general solution.  There's not even really a good book on
>>> approaches to the problem.
>>>
>>
>> Yes, I understand.  For Server1, no record will be added, so the last
>> record opened, in Server1, will continue to be the last one until it is
>> closed. For Server2, I will insert a dummy record to be 135001, which will
>> guide the rest of the new records that will be open in Server2.  So the
>> next autoincrement will be 135002, etc.  There last record for Server1
>> should be, at most, at 134500, so there is a space of 500 empty records.
>>  We want to do this so that there is an specific number that will guide the
>> original record for Server2 as well as for Server1.
>>
>>
>>> From the information you posted I would recommend that you keep the two
>>> database files separate and explain to your users when to use one and when
>>> to use the other.  You can have two different apps, one of which uses the
>>> 'old server' data, and the other accesses the 'new server' data.  Or you
>>> can have one app which can flip between database files.  If this is at all
>>> practical in your business it will make things much simpler and your users
>>> will understand how their system works far better.
>>>
>>
>> Yes, this will happen, and they know, but in a few months, Server1 will
>> no longer be, so we need to continue to update until we close that server.
>>
>>
>>> However if you have a reason to need both sets of data in the same
>>> database, then consider what would happen if instead of introducing a
>>> 'LastUpdateDate' field everywhere and the clever programming you'd need to
>>> do to use it correctly, do the following:
>>>
>>> * Create a new table called 'SQLCommandLog' in a new attached database.
>>> * Table has the usual AUTOINCREMENT rowid and one text column called
>>> 'command'.
>>> * All commands which might change the data (INSERT/UPDATE/DELETE) get
>>> saved in the table.
>>> * To update another database to reflect the changes to this one, simply
>>> issue those commands, then empty the table again ready for new commands.
>>>
>>> That way you don't have to copy a big database file of your data to the
>>> other server, you just copy a small database of SQL commands.
>>>
>>
>> H...
>>
>>
>>> There are the usual problems with choosing different AUTOINCREMENT row
>>> numbers on different servers but this system may be simpler to implement
>>> than anything clever with deep understanding of your business logic.
>>>
>>> Simon.
>>>
>>
>> I appreciate your input, Simon.
>>
>> josé
>> ___
>> 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] Updating one DB from another

[mm.w]

diff and update when a user is actually migrating, let server1 run until
all users have migrated, if migrated prevents to ever connect to server1

simple.

best


On Thu, Jun 19, 2014 at 1:59 PM, jose isaias cabrera 
wrote:

> Simon Slavin wrote...
>
>
>
>> On 19 Jun 2014, at 3:55pm, jose isaias cabrera 
>> wrote:
>>
>>  These servers will be in two different servers and in two different
>>> parts of the world, so network access will be very slow.  What I am
>>> thinking in doing is to copy the data on Server1 to Server2 and set the
>>> starting id at a higher point than the last id on Server1.  For example,
>>> Server1 highest project id is 134000, so, I would set the start id for
>>> Server2 to 135000. The Server two will continue to add new projects, so the
>>> next project id will be 135001 and so forth.
>>>
>>
>> Is your whole database really just in a single table ?  If not, you have
>> to figure out how to spot related records in other tables.  Once you've
>> done that you need to have a 'LastUpdateDate' column on every table.  And
>> then you have to worry about spotting rows which have been deleted. Since
>> the row has been deleted, there are no 'LastUpdateDate' values which let
>> you spot it !
>>
>
> Thanks for helping Simon.  Yes, there are a bunch of more tables and yes,
> each of them have a LastUpdateDate and they all will be based on ProjID,
> which is id in the LSOpenProjects table.  This is only temporarery until we
> close all the records in Server1.db and then, only one db, Server2.db will
> be used.
>
>
>
>> Synchronising two different databases is ridiculously difficult to get
>> right.  Especially when both of them continue to be modified and when you
>> continue to make use of AUTOINCREMENT columns to number new rows.  There is
>> no good general solution.  There's not even really a good book on
>> approaches to the problem.
>>
>
> Yes, I understand.  For Server1, no record will be added, so the last
> record opened, in Server1, will continue to be the last one until it is
> closed. For Server2, I will insert a dummy record to be 135001, which will
> guide the rest of the new records that will be open in Server2.  So the
> next autoincrement will be 135002, etc.  There last record for Server1
> should be, at most, at 134500, so there is a space of 500 empty records.
>  We want to do this so that there is an specific number that will guide the
> original record for Server2 as well as for Server1.
>
>
>> From the information you posted I would recommend that you keep the two
>> database files separate and explain to your users when to use one and when
>> to use the other.  You can have two different apps, one of which uses the
>> 'old server' data, and the other accesses the 'new server' data.  Or you
>> can have one app which can flip between database files.  If this is at all
>> practical in your business it will make things much simpler and your users
>> will understand how their system works far better.
>>
>
> Yes, this will happen, and they know, but in a few months, Server1 will no
> longer be, so we need to continue to update until we close that server.
>
>
>> However if you have a reason to need both sets of data in the same
>> database, then consider what would happen if instead of introducing a
>> 'LastUpdateDate' field everywhere and the clever programming you'd need to
>> do to use it correctly, do the following:
>>
>> * Create a new table called 'SQLCommandLog' in a new attached database.
>> * Table has the usual AUTOINCREMENT rowid and one text column called
>> 'command'.
>> * All commands which might change the data (INSERT/UPDATE/DELETE) get
>> saved in the table.
>> * To update another database to reflect the changes to this one, simply
>> issue those commands, then empty the table again ready for new commands.
>>
>> That way you don't have to copy a big database file of your data to the
>> other server, you just copy a small database of SQL commands.
>>
>
> H...
>
>
>> There are the usual problems with choosing different AUTOINCREMENT row
>> numbers on different servers but this system may be simpler to implement
>> than anything clever with deep understanding of your business logic.
>>
>> Simon.
>>
>
> I appreciate your input, Simon.
>
> josé
> ___
> 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] Android sqlite error

[mm.w]

you can't write at dest, then the journal file fails, quite obvious reading
the logs


On Wed, Jun 11, 2014 at 11:41 PM, Sathish N  wrote:

> I am new for sqlite.
>
> The following sqlite error comes in my android phone. when i run the
> application sum times.
> I like to know the meaning of this error, why this error come and how to
> solve this. I googled about this but nowhere the answer is mentioned i
> tried all possiblities from what i got when googled about this error.
>
>  E SQLiteLog: (14) cannot open file at line 30179 of [00cd9d8ce4]
>  E SQLiteLog: (14) os_unix.c:30179: (24)
> open(/data/data/com.android.bluetooth/databases/btopp.db-journal) -
>  E SQLiteLog: (14) cannot open file at line 30179 of [00cd9d8ce4]
>  E SQLiteLog: (14) os_unix.c:30199: (24)
> open(/data/data/com.android.bluetooth/databases/btopp.db-journal) -
>  E SQLiteLog: (14) statement aborts at 23: [SELECT * FROM btopp ORDER BY
> _id] unable to open database file
>  E SQLiteQuery: exception: unable to open database file (code 14); query:
> SELECT * FROM btopp ORDER BY _id
>
>
> Kindly please help regarding this issue why this happens
> --
> Regards
> Sathish N
> ___
> 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] Application with 'grid' form for entering table data wanted

[mm.w]

I know about that

https://github.com/j4mie/idiorm

no cargobay


On Wed, Jun 4, 2014 at 7:08 AM, David Bicking  wrote:

>
> I don't know php, but this sounds like what I think you want: phpGrid |
> PHP Datagrid Made Easy.
>
>
>  phpGrid | PHP Datagrid Made Easy.
> phpGrid is a simple, powerful and fully customizable PHP component for
> generating PHP AJAX datagrid for create, read, update, delete (CRUD)
> records.
> View on phpgrid.com Preview by Yahoo
> David
>
>
> 
>  From: "c...@isbd.net" 
> To: sqlite-users@sqlite.org
> Sent: Wednesday, June 4, 2014 6:29 AM
> Subject: Re: [sqlite] Application with 'grid' form for entering table
> datawanted
>
>
> Stephen Chrzanowski  wrote:
> > By the sounds of it, the OP wants a spreadsheet app, that isn't a
> > spreadsheet app, acts like a database, but isn't quite a database, looks
> > simple to use, but provide editable information in a reasonable format.
> >
> You're almost right.  Many people use spreadsheets for the sort of
> data entry task that I'm trying to do but really spreadsheets aren't
> optimum for the job.
>
> Yes, I basically want a spreadsheet data entry screen with a database
> behind it.  However the *detail* of how spreadsheets work for data
> entry isn't really ideal.
>
>
> > To bring up a point about Google that RSmith brought up, Google Docs has
> a
> > spreadsheet app that has zero install, accessible by many (If you want)
> and
> > available from anywhere provided an internet connection is available, and
> > allows you to edit, search, sort, filter, and all the other bells and
> > whistles other spreadsheet and database applications have.  Mind you
> > linking an external data requester application might be a bit of a PITA
> (If
> > that is a requirement) might start throwing additional complexities into
> > the mix.
> >
> That might be of interest, can you point me at it please.
>
>
> > Since the LAMP setup is available, there are other spreadsheet type
> > applications that allow you to move from Google Docs to in-house.  Off
> the
> > top of my head I can't think of the names I've used in the past (I write
> > databases, not spreadsheets) but they are out there, free for all, just
> > short of public domain (MIT maybe?), and in a
> > 'download-extract-run-configure' format usually, which is GREAT with a
> LAMP
> > setup.
> >
> Hmmm, why is it that all these apps are "... can't think of the names
> ..." ?  :-)
>
>
> > The other option is to go ground up with PHP and some very basic AJAX
> > calls, but even then, you'd need SOME kind of management.  How many rows
> to
> > display, how many columns to display, do we add rows, remove rows, what
> > field is what cast, validation requirements, data storage considerations,
>
> No validation, just text fields.  Number of columns is defined by the
> number of columns in the database table.  Open to 'all' because it's
> on a home LAN with no (HTTP) access from outside.
>
> > data VOLUME considerations, who accesses the data, what is read only and
> > who/what can write to the table, are we talking one database, one table,
> > one user, or, many databases, many tables, many users, does encryption
> come
> > into play and if so at what level?  Some kind of management HAS to
> happen,
> > like it or not.  And if basic management comes into play, you might as
> well
> > stick with something that already exists (Google Docs, OpenOffice,
> > LibreOffice, Excel, Notepad).
> >
>
> --
> Chris Green
> ·
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to write this commands?

[mm.w]

>> Note to self: Someday, you want to be like Igor.

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

Re: [sqlite] Porting SQLite to plain C RTOS

[mm.w]

http://pubs.opengroup.org/onlinepubs/7908799/xsh/systime.h.html

http://pubs.opengroup.org/onlinepubs/7908799/xsh/flockfile.html

http://pubs.opengroup.org/onlinepubs/009695399/functions/fcntl.html

// IEEE Std 1003.1, 2004 Edition @!!= linux



On Tue, May 13, 2014 at 7:55 AM, Artur Deterer wrote:

> Hello SQLite Developers,
>
>
>
> my company would like to use sqlite in our embedded systems for which we
> use
> a plain C proprietary operating system.
>
> Memory allocation and deallocation within this system is realized through
> standard malloc/free functions. At this point of
>
> system development we are trying to adapt SQLite to our platform and  face
> some difficulties:
>
>
>
> Before I tell you which errors occur I explain to you the work steps I
> walked through.
>
> 1)As far as I know I have to tell sqlite that it should not
> work
> on the implemented operating systems but on a
>
> custom platform and this is to be done setting the macro
> SQL_OTHER_OS to 1. (in my code, line 30: SQL_OTHER_OS=1;)
>
> I did this within the first lines of sqlite3.c file. and at
> line 9870 I changed the value of SQL_OTHER_OS to 1 too.
>
> 2)With our single-threaded task scheduler we also have to tell
> sqlite to not allow multithreading operations
>
> as I did changing the value of SQL_THREADSAFE to 0 in line
> 7081.
>
> 3)On your web pages you wrote that a user has to implement the
> functions sqlite3_os_init() and sqlite3_os_end()
>
> in case that he wants sqlite to run on a custom system but
> I
> do not know which implementation is needed or whether
>
> an own implementation is needed because our os memory
> operations are based on malloc and free.
>
> 4)As I read your manual to port SQLite to a new operating
> system, I realized that an own implementation of
>
> sqlite3_vfs is necessary. I took
>  test_demovfs.c as
> skeleton for a ownOSVFS implementation. Within our os
>
> we have an own implementation of FAT32 file system
> functions
> which I used for substituting the file operation
>
> functions offered in test_demovfs.
>
> 5)I set the function sqlite3_initialize() within sqlite3.c in
> comments to implement this function within uTaskerVFS.c.
>
> This file also includes the sqlite3 header file and is
> appended to this email.
>
>
>
> As I walked through these steps I am not confident whether my
> implementation
> is correct or misses any point (e.g. sqlite3_os_init()).
>
> The main reason I write to you is that our cross-compiler (ARM GCC) for an
> ARM Cortex M4 system throws compiler errors
>
> according to sqlite. They tell me that references to several c structures
> (e.g. timeval, flock) are missing. These are used within a
>
> code part that asks whether the current platform is Linux (if macro: line
> 23528 ) what obviously is not correct.
>
> I think that if the macro SQL_OTHER_OS set to 1 the code should not enable
> the code part  designed for linux os.
>
>
>
> Have you an idea of solving the porting difficulties I described in this
> email ?
>
> It would be great ,too, if you could tell me whether I am wrong with my
> implementation.
>
> Can you please give me a more detailed instruction or maybe an example
>
> integration of sqlite into a custom os?
>
>
>
> Kind regards
>
> Deterer
>
>
> ___
> 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] select 1 where 1 - 1;

[mm.w]

Hihihi,

some folks do not share the same references,
anyway yes 3 passes that's named super bowle, LOL (warning many bad jokes
inside)



On Mon, May 5, 2014 at 3:31 PM, Petite Abeille wrote:

>
> On May 6, 2014, at 12:15 AM, Jay Kreibich  wrote:
>
> > Cross what bridge?
>
> http://www.youtube.com/watch?v=zKhEw7nD9C4
>
> > You seem to be trying to use common sense and semantic meaning to make
> an argument.  To quote an old CS prof, “If you argue in English**, you’re
> wrong.”  Math and formal specifications are really the only thing here, and
> these do exactly what one would expect.
>
> ( … must… refrain… from… argh…. ) … never mind… all good and peaceful in
> the beautiful kingdom...
>
> ___
> 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] select 1 where 1 - 1;

[mm.w]

LOL

 be careful not to break the stinger and leave it buried in the skin.

Hello

Petite Abeille, when you "eval" an expression, are you doing from the right
or on the lvalue.

Best.



On Mon, May 5, 2014 at 1:03 PM, Petite Abeille wrote:

>
> On May 5, 2014, at 9:15 PM, RSmith  wrote:
>
> > Je suis desole mon ami…
>
> Moi aussi :P
>
> I have no quarrel with you, good Sir Knight, but I must cross this bridge:
>
> select 1 where 1 is 1;
> select 1 where 1 is not 1;
> select 1 where 1 is ( 1 = 1 );
> select 1 in ( null ); — oh…
> select 1 in ( not null ); — really?
>
> Anyway… if, as Stephan Beal mentioned earlier on, one looks at SQLite’s
> SQL parser as some sort of glorified calculator, then, yes, it all makes
> perfect sense in some kind of wonderful way... :)
>
> http://www.sqlite.org/src/finfo?name=src/parse.y
> http://www.sqlite.org/src/artifact/22d6a074e5f5a7258947a1dc55a9bf946b765dd0
>
> N.B. One more, just for fun:
>
> sqlite>  select 1 in ( null is null );
> > 1
>
> sqlite>  select 1 in ( null is not null );
> > 0
>
> m'kay...
>
>
>
>
> ___
> 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] select 1 where 1 - 1;

[mm.w]

I know Simon, just asking, nope an empty string is a valid string, else you
say no NULL allowed for strings, might be a backend option 8)


On Mon, May 5, 2014 at 8:27 AM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 5 May 2014, at 4:18pm, mm.w <0xcafef...@gmail.com> wrote:
>
> > "an empty string should be false" strongly disagree, a NULL string should
> > be solely false, now in this case, the question is: comparisons should be
> > handled as bin or by; 'literal' values? or equality/comparison must not
>  be
> > eval'ed and strictly made on type?
>
>
> It's a consequence of some other requirements by SQL and of weak typing.
>  Sorry.
>
> It is a requirement that an empty string must evaluate to TRUE or FALSE or
> NULL.
>
> If you take a function that requires a number and feed it an empty string,
> it understands the string as meaning zero.
>
> If you take a test that requires a boolean and feed it zero, it
> understands that value as meaning FALSE.
>
> Therefore an empty string must evaluate to FALSE.
>
> 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] select 1 where 1 - 1;

[mm.w]

 select inf; should be true or false? :)


On Mon, May 5, 2014 at 8:18 AM, mm.w <0xcafef...@gmail.com> wrote:

> Hello,
>
> "an empty string should be false" strongly disagree, a NULL string should
> be solely false, now in this case, the question is: comparisons should be
> handled as bin or by; 'literal' values? or equality/comparison must not  be
> eval'ed and strictly made on type?
>
> one other of the quirk would be to cast to a float, ugly I might admit.
>
> Best.
>
>
>
> On Sun, May 4, 2014 at 4:14 PM, James K. Lowden 
> <jklow...@schemamania.org>wrote:
>
>> On Fri, 2 May 2014 21:09:46 +0200
>> Petite Abeille <petite.abei...@gmail.com> wrote:
>>
>> >
>> > On May 2, 2014, at 8:54 PM, Richard Hipp <d...@sqlite.org> wrote:
>> >
>> > > I'm guessing that Mr. Abeille is upset that SQLite ?
>> >
>> > ? doesn?t even bother with SQL syntax and will happily accept any old
>> > junk as a sorry excuse for a query.
>> >
>> > select 1 where null;
>> > select 1 where not null;
>> >
>> > When SQLite 4 sees the light of the day, I wish for a strict SQL
>> > parser and proper error messages.
>>
>> To amplify the point, the issue isn't pure fussiness or obligation to
>> adhere to standards.  A permissive parser invites error.
>>
>> It's not hard to imagine
>>
>> select 1 where 1 - 1;
>>
>> was intended as
>>
>> select 1 where 1 = 1;
>>
>> which, in the midst of a large query producing expected results, might
>> easily be overlooked.
>>
>> I doubt Petite is confused by boolean evaluation, but rather is
>> dismayed by its appearance in this context.
>>
>> SQL is not C.  To the extent the SQL supplied by SQLite is nonstandard,
>> it might as well be another language entirely.  The better one knows
>> SQL, the harder a nonconformant implementation is to use.
>>
>> Not long ago I was helping someone with a query in MS Access. Easy,
>> just use a correlated subquery in an update statement. Hard, if
>> it chokes the parser.  Perhaps you know the joke with the punchline,
>> "Assume a can opener."
>>
>> --jkl
>> ___
>> 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] select 1 where 1 - 1;

[mm.w]

Hello,

"an empty string should be false" strongly disagree, a NULL string should
be solely false, now in this case, the question is: comparisons should be
handled as bin or by; 'literal' values? or equality/comparison must not  be
eval'ed and strictly made on type?

one other of the quirk would be to cast to a float, ugly I might admit.

Best.



On Sun, May 4, 2014 at 4:14 PM, James K. Lowden wrote:

> On Fri, 2 May 2014 21:09:46 +0200
> Petite Abeille  wrote:
>
> >
> > On May 2, 2014, at 8:54 PM, Richard Hipp  wrote:
> >
> > > I'm guessing that Mr. Abeille is upset that SQLite ?
> >
> > ? doesn?t even bother with SQL syntax and will happily accept any old
> > junk as a sorry excuse for a query.
> >
> > select 1 where null;
> > select 1 where not null;
> >
> > When SQLite 4 sees the light of the day, I wish for a strict SQL
> > parser and proper error messages.
>
> To amplify the point, the issue isn't pure fussiness or obligation to
> adhere to standards.  A permissive parser invites error.
>
> It's not hard to imagine
>
> select 1 where 1 - 1;
>
> was intended as
>
> select 1 where 1 = 1;
>
> which, in the midst of a large query producing expected results, might
> easily be overlooked.
>
> I doubt Petite is confused by boolean evaluation, but rather is
> dismayed by its appearance in this context.
>
> SQL is not C.  To the extent the SQL supplied by SQLite is nonstandard,
> it might as well be another language entirely.  The better one knows
> SQL, the harder a nonconformant implementation is to use.
>
> Not long ago I was helping someone with a query in MS Access. Easy,
> just use a correlated subquery in an update statement. Hard, if
> it chokes the parser.  Perhaps you know the joke with the punchline,
> "Assume a can opener."
>
> --jkl
> ___
> 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] WP8 compiled version

[mm.w]

Hello,

not on win phone, for the other questions: yes
never used Xamarin, as far I can see that's a mono based toolchain, I don't
do C#

Best


On Sun, Apr 27, 2014 at 11:19 AM, Vadim Kantorov wrote:

> Hello,
>
> I'm a newbie for SQLite. I am considering SQLite as the full-text
> search solution for a mobile application (WP8, Android, iOS using
> Xamarin). As far as I got, a manual rebuilding of SQLite is needed for
> all three platforms to support FTS4. Is it correct?
>
> Has anyone tried to do so for all the platforms and does it work?
>
> Thanks,
> --
> Vadim Kantorov
> ___
> 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] Most efficient storage for arrays

[mm.w]

Ok, you can store a JSON like structure, or plist, coding is a creative
discipline, not a nerd stuff.


On Wed, Apr 23, 2014 at 12:16 PM, mm.w <0xcafef...@gmail.com> wrote:

> Ok, you can store a JSON like structure, by reproducing the graf""
> adapted to SQL I wrote that (for fun, not only writing code for my day to
> day job) [mostly that what core data does with all this mysterious ids,
> that's just a transpose vertical to horizontal],  there are
> primitive-tables named by serializable types and the tree is represented by
> addresses, like any recursive expat-like parser will do.
>
>
> On Tue, Apr 22, 2014 at 10:13 PM, Keith Medcalf <kmedc...@dessus.com>wrote:
>
>>
>> >>> Your data is from MongoDB :)  Note they do have an extended JSON to
>> >>> deal with types like ObjectId, binary and dates:
>> >> Yes, it is. But I control the document structure and it does not have
>> >> any types that can't be converted easily after a pull over the net.
>> >
>> >Does that mean you can make it individual fields instead of a list?  As
>> >Petite Abeille pointed out you need to do SQL things the SQL way or you
>> >will end up in a world of hurt.
>>
>> You need to use a RELATIONAL datastore in a RELATIONAL way.  This applies
>> whether your access method is SQL, ISAM, HIDAM, BDAM or VSAM.  If the
>> underlying datastore is not relational, you may also be able to use one (or
>> more) of the mentioned access methods.  However, then you will be able to
>> store non-relational data in it and manupulate it easily.  SQLite is a
>> RELATIONAL datastore that uses the SQL access method.
>>
>> Please do not confuse the access method and the datastore.  The datastore
>> defines the properties of the filing cabinets, and the access method the
>> language spoken by the filing clerk.
>>
>> Any filing clerk can be taught to use many underlying storage cabinet
>> systems, just as any given storage cabinet system may be accessed by any
>> number of clerks speaking different languages.
>>
>>
>>
>>
>> ___
>> 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] Most efficient storage for arrays

[mm.w]

Ok, you can store a JSON like structure, by reproducing the graf"" adapted
to SQL I wrote that (for fun, not only writing code for my day to day job)
[mostly that what core data does with all this mysterious ids, that's just
a transpose vertical to horizontal],  there are primitive-tables named by
serializable types and the tree is represented by addresses, like any
recursive expat-like parser will do.


On Tue, Apr 22, 2014 at 10:13 PM, Keith Medcalf  wrote:

>
> >>> Your data is from MongoDB :)  Note they do have an extended JSON to
> >>> deal with types like ObjectId, binary and dates:
> >> Yes, it is. But I control the document structure and it does not have
> >> any types that can't be converted easily after a pull over the net.
> >
> >Does that mean you can make it individual fields instead of a list?  As
> >Petite Abeille pointed out you need to do SQL things the SQL way or you
> >will end up in a world of hurt.
>
> You need to use a RELATIONAL datastore in a RELATIONAL way.  This applies
> whether your access method is SQL, ISAM, HIDAM, BDAM or VSAM.  If the
> underlying datastore is not relational, you may also be able to use one (or
> more) of the mentioned access methods.  However, then you will be able to
> store non-relational data in it and manupulate it easily.  SQLite is a
> RELATIONAL datastore that uses the SQL access method.
>
> Please do not confuse the access method and the datastore.  The datastore
> defines the properties of the filing cabinets, and the access method the
> language spoken by the filing clerk.
>
> Any filing clerk can be taught to use many underlying storage cabinet
> systems, just as any given storage cabinet system may be accessed by any
> number of clerks speaking different languages.
>
>
>
>
> ___
> 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] Any interest for open source multi-user 'SQLite database server' application?

[mm.w]

Hello,

First off, agreed an ODBC interface would be more suitable and secure,
don't trust today-most-web-devs to make the RPC layer secure
[cruft-obfuscation open backdoor they know], not trolling around just the
day to day reality; when I sit on some server-codes ... if you can call
that "code" at all.

Second off, concurrent writings/readings to a sqlite's db-file is a bit
odd, challenging 40 years of evolution,
e.g there are a lot of stuff you don't need at runtime, then do you extract
 a suitable "workable runtime image"
or you just use the provided plain-sqlite-interface ?

Best.



On Fri, Apr 18, 2014 at 7:23 AM, Dennis Jenkins  wrote:

> On Fri, Apr 18, 2014 at 6:32 AM, Christian Smith <
> csm...@thewrongchristian.org.uk> wrote:
>
> > On Tue, Apr 01, 2014 at 01:08:59PM +, Harmen de Jong - CoachR Group
> > B.V. wrote:
> > > We have built our own SQLite database server application and are
> > considering making this open source. Since there will be some time
> involved
> > into making it an open source project and maintaining it, we would first
> > like to make an inventory to find out if there is any interest in this
> > server application.
> > >
> > > ==> How it works:
> > >
> > > Clients can communicate with this server over TCP/IP sockets. Queries
> > are submitted and returned in XML format (BLOB results are returned in
> > binary format to prevent CPU intensive encoding and decoding). The server
> > application is written in native Visual C++ (without using MFC). If we
> > would make this project open source we would also include a client
> example.
> >
> >
> > I dare say that parsing and encoding XML would be more processor
> intensive
> > that BLOB encoding.
> >
> > IMO, you'd also increase your potential target audience if you could also
> > provide reasonably functional JDBC, ADO.NET, PHP and/or Python database
> > drivers. Providing any of these would allow existing users to plug your
> new
> > database into existing applications with the minimal of fuss.
> Personally, I
> > don't like the idea of XML as the protocol, largely because of the
> parsing
> > overhead, and have been looking at a similar server based on RPC, but for
> > debugging purposes it would be great.
> >
> > Regards,
> > Christian
> > ___
> >
>
>
> Not all XML libraries are inefficient.  TinyXml2 would probably work great
> for this use-case.  (disclaimer: I use TinyXml2 in an unrelated project,
> but I am not the author).
> ___
> 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] about merge rows

[mm.w]

@hello,

it looks like an old sybase
-ms-flatten-like
export, if I understand well you got that just after splitting then
pivoting the properties, am I wrong?


On Thu, Apr 17, 2014 at 6:43 PM, Igor Tandetnik  wrote:

> On 4/17/2014 9:26 PM, YAN HONG YE wrote:
>
>> I want to merge all the mnote, how to do this?
>>
>
> What do you mean "merge"? What should the table look like afterward?
> --
> Igor Tandetnik
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Useful - A Portable Class Library (PCL) for low-level (raw) access to SQLite

[mm.w]

Hello,

may you tag your message withC#, as far as I know [[a Portable low-level
(raw) access to SQLite]] that's already named sqlite itself as per see,
written in a portable "low-levelable" language named C, I might be mistaken
thu.

Best.



On Thu, Apr 10, 2014 at 2:16 PM, Mike Parsons wrote:

> Thought some of you would find this useful ...
> https://github.com/ericsink/SQLitePCL.raw
> ___
> 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] Establishing a connection and downloading tables from an SQLite server

[mm.w]

Hello,

design your own RPC layer thru https with all the credentials you need.

Best.




On Mon, Apr 7, 2014 at 12:21 PM, Armando Gonzalez wrote:

> Donald:
>
> I appreciate the response.
>
> I guess that using a command line interface program could work. I used it
> for a local database and it worked perfectly, but the problem is that I'm
> not sure how to do it when the original file is in a remote server. Again,
> maybe I'm missing something obvious and if I am, I'm sorry.
>
> I need the downloads from a remote server to be scheduled. That's why I was
> thinking about using powershell - I have used it before in scheduling
> tasks. I still found your suggestion interesting, but I can't really make
> use of it effectively.
>
> Thank you for your time and advice. I hope you could keep helping me!
>
> Armando
>
>  Original Message 
> Subject: Re: [sqlite] Establishing a connection and downloading tables
> from an SQLite server
> From: Donald Griggs 
> Date: Sat, April 05, 2014 5:31 am
> To: General Discussion of SQLite Database 
>
> Greetings, Armondo.
>
> Would a simple script invoking the Sqlite3 commandline interface
> programdo what you want?
> http://sqlite.org/sqlite.html
>
> sqlite3  possibly invoked by a cron job,
> where MyScriptFile contains something like:
> 
> .open MyAsteriskDatabaseFilename
> .mode csv
> .output MyExportFileName.csv 
> SELECT MyDesiredFields FROM MyDesiredTable
> WHERE MyConditions
> ORDER BY MyDesiredOrder;
> .quit
> =
>
>
>
>
>
>
> On Fri, Apr 4, 2014 at 12:45 PM, Armando Gonzalez > >wrote:
>
> > To whom it may concern:
> >
> > I am absolutely new to to the world of SQLite (and SQL in general, to be
> > honest, please don't assume any previous knowledge from me) and well, I
> > stumbled upon an SQLite issue I can't seem to resolve on my own.
> >
> > I have an Asterisk VoIP phone server at my workplace. It was installed by
> > an external company, and it provides a variety of services, like reports
> of
> > the phone activity, etc.
> >
> > It was (and still is) working fine, but one of my colleagues wanted a
> > different type of report that the external company wasn't supplying, and
> > they wouldn't be able to supply them as he wanted, to be honest.
> >
> > The external company granted me access to the server's databases, and I
> > learnt that they worked with SQLite. The server used a service called
> > SQLite Manager to manage the SQLite databases. The manager has an easy
> > enough to understand GUI, and I managed to download the table I needed
> > manually and produce the wanted reports with software locally installed
> in
> > my computer.
> >
> > That's all working fine. The thing is that it would be so much better and
> > much more efficient if I could automatically download the needed table to
> > produce the reports, because that way I could produce the reports much
> > faster and get on with other things I have to do.
> >
> > I have Google'd how to do it with Powershell and well, I don't really
> know
> > what I'm doing. I would really appreciate any assistance/guidance if
> > possible.
> >
> > As a quick recap:
> >
> > I need to automatically download a table from a SQLite database on a
> local
> > server.
> >
> > I have access to Visual Studio 2012 and Powershell if any programming is
> > necessary.
> >
> > Anyways, I'm going to leave it at that.
> >
> > Thank you very much for taking the time to read this and hopefully for
> > helping me in the future!
> >
> > Armando Gonzalez
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] comma-separated string data

[mm.w]

Hello,

thus, good, incident closed, we've seen worse; I guess, the
misunderstanding was triggered by not following up and well on the lipstick
8-p

Best.


On Mon, Apr 7, 2014 at 4:27 PM, RSmith  wrote:

> On 2014/04/08 01:02, David Simmons wrote:
>
>> Why are these people allowed to use this discussion board?
>>
>> Using SQLite on a critical corporation application I find that by reading
>> the material provided it
>> is handling terabyte databases with remarkable performance.  SQLite does
>> not have the
>> cost associated with one like Oracle and does not require a full time DBA
>> to keep
>> things running at mediocre speeds like Oracle or MS SQLServer.  Grow up,
>> read the material
>> supplied, IMPROVE or GAIN programming skills before becoming a critic.
>>
>
> Let me be the first to apologise for whatever has offended you. Sometimes
> like-minded individuals in groups might share a common view and sometimes a
> jibe or two arise from it. There was no bad intent, but probably this is
> not the place for silly remarks and some restraint might go a long way, etc.
>
> I am however very perplexed by the rest of your note, maybe you are
> confused or did not follow the discussion or maybe misunderstood the
> content? SQLite was never under fire, quite the contrary, an actual problem
> was solved right in this thread via the virtues of SQLite. There were some
> notions as to the illogical paradigm some developers favour towards
> painting over sad DB designs rather than fixing it, which was highlighted
> with a silly analogy or two, but in no way to offend anyone or in any way
> pertaining to the utility of SQLite itself. Nobody was a critic with
> regards to SQLite.
>
> If I have misunderstood you, feel free to correct me please, but most of
> all, please have a lovely day.
>
>
>
>
>
>
>
>
>
>
>
>
> ___
> 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] comma-separated string data

[mm.w]

"But if the Customer can't tell the difference, does that make you a good
pimp?"

Hello,

you just don't get it then you don't get it, that's it.

Best Regards



On Mon, Apr 7, 2014 at 12:09 PM, RSmith  wrote:

>
> On 2014/04/07 20:57, Petite Abeille wrote:
>
>> Lipstick Driven Design: “You can put lipstick on a pig, but it’s still a
>> pig.”
>>
>
> But if the Customer can't tell the difference, does that make you a good
> pimp?
>
>
>
> ___
> 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] comma-separated string data

[mm.w]

Hello,

Dear Petite Abeille, you may repeat it 1 times, they don't listen, they
prefer adding to the previous mistake instead of fixing the origin (hiding
behind falsehood constraints, like it is way it is...) until it will fall
apart with unsolvable issues and developer-made-bugs, surely that's the way
to kill a product even the best selling one.

Best.



On Mon, Apr 7, 2014 at 11:24 AM, Petite Abeille wrote:

>
> On Apr 7, 2014, at 3:28 PM, Dominique Devienne 
> wrote:
>
> > For those interested, here's an article along the same lines that
> > better demonstrate what I mean by the above:
> >
> >
> http://technology.amis.nl/2013/06/26/oracle-database-12c-joining-and-outer-joining-with-collections/
>
> Aha! That’s what that mysterious CROSS/OUTER APPLY is all about. Thanks
> for the link :)
>
> > The new Oracle 12c join syntax is basically just syntax sugar hiding
> > the TABLE operator and its implicit COLUMN_VALUE column.
>
> Well, table( … ) can apply to records (e.g. pipelined function) with fully
> named attributes.
>
> So, really, we are saying this is rather high cholesterol for
> outer/full/cross join table( pipeline( parameter, ... ) )? Is it really
> worthwhile a full blown new keyword/concept? Doubtful.
>
> Anyway… back to SQLite :)
>
> As James K. Lowden kindly, and repetitively, pointed out:
>
> http://www.schemamania.org/sql/#lists
>
> Perhaps worthwhile quoting a few words:
>
> "Questions are frequently asked about table designs that are hopelessly
> wrong. The solution to the question is not to write the query, but to
> re-write the table, after which the query will practically write itself.
>
> Perhaps the most egregious example is a column whose value is a list or,
> in SQL terms, a repeating group. The elements in the list are perhaps
> comma-separated, and some poor schlep has the task of selecting or joining
> on the the nth element in the list.”
>
> Don’t be *that* schlep.
>
> N.B. There is no glory in beautifully solving a hopelessly wrong problem.
>
>
> ___
> 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] if possible point another table

[mm.w]

refactoring the model using views might be an option too.


On Thu, Apr 3, 2014 at 9:50 PM, mm.w <0xcafef...@gmail.com> wrote:

> Hello,
>
> yep; else; it would require an "eval" or the support to sql scripting, as
> none of this exists, it has to be done at the program level; in a regular
> two queries run, nothing fancy or extraordinary.
>
> Best.
>
>
> On Thu, Apr 3, 2014 at 9:13 PM, Andy Goth <andrew.m.g...@gmail.com> wrote:
>
>> On 4/3/2014 10:10 PM, Keith Medcalf wrote:
>>
>>>
>>>   select *
>>> from k1
>>> union
>>>   select *
>>> from k2;
>>>
>>
>> My understanding of the question was, how to select from tables whose
>> names are somehow computed or extracted from another table
>>
>> --
>> Andy Goth | 
>>
>> ___
>> 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] if possible point another table

[mm.w]

Hello,

yep; else; it would require an "eval" or the support to sql scripting, as
none of this exists, it has to be done at the program level; in a regular
two queries run, nothing fancy or extraordinary.

Best.


On Thu, Apr 3, 2014 at 9:13 PM, Andy Goth  wrote:

> On 4/3/2014 10:10 PM, Keith Medcalf wrote:
>
>>
>>   select *
>> from k1
>> union
>>   select *
>> from k2;
>>
>
> My understanding of the question was, how to select from tables whose
> names are somehow computed or extracted from another table
>
> --
> Andy Goth | 
>
> ___
> 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] SQLite3_create_collation

[mm.w]

CoreData, last I have heard only use the sqlite's storage capability, "not
really sqlite in the sense people might understand", BTW that's the reason
they don't need metadata and some other stuff, because their sqlite-lib
serves only CoreData purposes, "not really a public" wee wee, similar to
the CoreICU




On Wed, Apr 2, 2014 at 2:21 PM, mm.w <0xcafef...@gmail.com> wrote:

> Hello,
>
> "First off, there are no Obj-C APIs for SQLite built into iOS" yes or not
> that's named CoreData which saves its graph either to a plist or a sqlite
> db,
>
> Second off, don't use the sqlite-lib delivered by the sub-system; inline
> your own version, (don't ask why, just do), see build options
>
> Best Regards
>
>
> On Wed, Apr 2, 2014 at 1:59 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
>>
>> On 2 Apr 2014, at 8:51pm, Donald Steele <xln...@sbcglobal.net> wrote:
>>
>> > If I was having no problems I would not have asked the question. I will
>> continue to look for better information & will eventually get it done.
>> Thanks anyway.
>>
>> Well, your answer doesn't make sense and people are drawing two
>> contradictory conclusions from it:
>>
>> A) You're using the SQLite API.
>> B) You're using Core Data.
>>
>> Once you figure out which of those you're doing, people will be able to
>> help you.
>>
>> 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] SQLite3_create_collation

[mm.w]

Hello,

"First off, there are no Obj-C APIs for SQLite built into iOS" yes or not
that's named CoreData which saves its graph either to a plist or a sqlite
db,

Second off, don't use the sqlite-lib delivered by the sub-system; inline
your own version, (don't ask why, just do), see build options

Best Regards


On Wed, Apr 2, 2014 at 1:59 PM, Simon Slavin  wrote:

>
> On 2 Apr 2014, at 8:51pm, Donald Steele  wrote:
>
> > If I was having no problems I would not have asked the question. I will
> continue to look for better information & will eventually get it done.
> Thanks anyway.
>
> Well, your answer doesn't make sense and people are drawing two
> contradictory conclusions from it:
>
> A) You're using the SQLite API.
> B) You're using Core Data.
>
> Once you figure out which of those you're doing, people will be able to
> help you.
>
> 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] apparent column data type affected by numeric operation elsewhere

[mm.w]

Hello,

attached my build settings/patches if it helps, I added stuff for win

Best.



On Mon, Mar 24, 2014 at 10:15 AM, mm.w <0xcafef...@gmail.com> wrote:

> Hello ok thx,
>
> I currently use 3.8.3.1 amalgamation, I try to keep on official updates, I
> have already mine to deal with
>
> Best.
>
>
> On Mon, Mar 24, 2014 at 10:10 AM, Richard Hipp <d...@sqlite.org> wrote:
>
>> On Mon, Mar 24, 2014 at 1:07 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > Hello,
>> >
>> > is it fixed in 3.8.4.1 or only in the repo?
>> > is that possible to add the date on the "Download Page" section?
>> >
>>
>> It was fixed earlier this morning on trunk.  You can download the latest
>> sources from the website (see the "tarball" and "zip archive" links on
>> http://www.sqlite.org/src/info/221f8f9447) or you can use the diffs on
>> that
>> page to patch whatever version of Fossil you are using.
>>
>>
>>
>> >
>> > Best.
>> >
>> >
>> > On Mon, Mar 24, 2014 at 8:35 AM, Richard Hipp <d...@sqlite.org> wrote:
>> >
>> > > Also worked correctly in 3.8.2.  Problem introduced in 3.8.3.  Fixed
>> > here:
>> > > http://www.sqlite.org/src/info/221f8f9447
>> > >
>> > >
>> > >
>> > >
>> > > On Mon, Mar 24, 2014 at 4:52 AM, Clemens Ladisch <clem...@ladisch.de>
>> > > wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > it appears that SQLite thinks it can reuse a register even when
>> > > > another operation changes it by applying numeric affinity:
>> > > >
>> > > > > create table t(x);
>> > > > > insert into t values('1');
>> > > > > select typeof(x) from t where x=x;
>> > > > text
>> > > > > select typeof(x) from t where x=x+0;
>> > > > integer
>> > > >
>> > > > (first reported here: <http://stackoverflow.com/questions/22598026
>> >)
>> > > >
>> > > > This worked correctly in SQLite 3.7.17.
>> > > >
>> > > >
>> > > > Regards,
>> > > > Clemens
>> > > > ___
>> > > > sqlite-users mailing list
>> > > > sqlite-users@sqlite.org
>> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > > >
>> > >
>> > >
>> > >
>> > > --
>> > > D. Richard Hipp
>> > > d...@sqlite.org
>> > > ___
>> > > sqlite-users mailing list
>> > > sqlite-users@sqlite.org
>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > >
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>>
>>
>>
>> --
>> D. Richard Hipp
>> d...@sqlite.org
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
#ifndef __clang_analyzer__

#ifndef _REENTRANT
#define _REENTRANT 1
#endif
#define SQLITE_ENABLE_COLUMN_METADATA 1
#define SQLITE_HAVE_ISNAN 1
#define SQLITE_THREADSAFE 1
#define SQLITE_ENABLE_FTS3 1
#define SQLITE_ENABLE_RTREE 1
#define SQLITE_DEFAULT_PAGE_SIZE 4096

#if defined(_MSC_VER)
#include 
#include 
#include 
#include 
#ifndef usleep
static inline void _usleep_win(__int64 useconds)
{ 
HANDLE timer;
LARGE_INTEGER due;
due.QuadPart = -(10 * useconds);
timer = CreateWaitableTimer(NULL, TRUE, NULL);
SetWaitableTimer(timer, , 0, NULL, NULL, FALSE);
WaitForSingleObject(timer, INFINITE);
CloseHandle(timer); 
}
#define usleep(x) _usleep_win((x))
#endif
#if _MSC_VER < 1600
#ifndef isnan
#define isnan(x) ((x)!=(x))
#endif
#ifndef isinf
#define isinf(x) (!_finite((x)))
#endif
#else
#ifndef isnan
   

Re: [sqlite] apparent column data type affected by numeric operation elsewhere

[mm.w]

Hello ok thx,

I currently use 3.8.3.1 amalgamation, I try to keep on official updates, I
have already mine to deal with

Best.


On Mon, Mar 24, 2014 at 10:10 AM, Richard Hipp <d...@sqlite.org> wrote:

> On Mon, Mar 24, 2014 at 1:07 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > Hello,
> >
> > is it fixed in 3.8.4.1 or only in the repo?
> > is that possible to add the date on the "Download Page" section?
> >
>
> It was fixed earlier this morning on trunk.  You can download the latest
> sources from the website (see the "tarball" and "zip archive" links on
> http://www.sqlite.org/src/info/221f8f9447) or you can use the diffs on
> that
> page to patch whatever version of Fossil you are using.
>
>
>
> >
> > Best.
> >
> >
> > On Mon, Mar 24, 2014 at 8:35 AM, Richard Hipp <d...@sqlite.org> wrote:
> >
> > > Also worked correctly in 3.8.2.  Problem introduced in 3.8.3.  Fixed
> > here:
> > > http://www.sqlite.org/src/info/221f8f9447
> > >
> > >
> > >
> > >
> > > On Mon, Mar 24, 2014 at 4:52 AM, Clemens Ladisch <clem...@ladisch.de>
> > > wrote:
> > >
> > > > Hi,
> > > >
> > > > it appears that SQLite thinks it can reuse a register even when
> > > > another operation changes it by applying numeric affinity:
> > > >
> > > > > create table t(x);
> > > > > insert into t values('1');
> > > > > select typeof(x) from t where x=x;
> > > > text
> > > > > select typeof(x) from t where x=x+0;
> > > > integer
> > > >
> > > > (first reported here: <http://stackoverflow.com/questions/22598026>)
> > > >
> > > > This worked correctly in SQLite 3.7.17.
> > > >
> > > >
> > > > Regards,
> > > > Clemens
> > > > ___
> > > > sqlite-users mailing list
> > > > sqlite-users@sqlite.org
> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > >
> > >
> > >
> > > --
> > > D. Richard Hipp
> > > d...@sqlite.org
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] apparent column data type affected by numeric operation elsewhere

[mm.w]

Hello,

is it fixed in 3.8.4.1 or only in the repo?
is that possible to add the date on the "Download Page" section?

Best.


On Mon, Mar 24, 2014 at 8:35 AM, Richard Hipp  wrote:

> Also worked correctly in 3.8.2.  Problem introduced in 3.8.3.  Fixed here:
> http://www.sqlite.org/src/info/221f8f9447
>
>
>
>
> On Mon, Mar 24, 2014 at 4:52 AM, Clemens Ladisch 
> wrote:
>
> > Hi,
> >
> > it appears that SQLite thinks it can reuse a register even when
> > another operation changes it by applying numeric affinity:
> >
> > > create table t(x);
> > > insert into t values('1');
> > > select typeof(x) from t where x=x;
> > text
> > > select typeof(x) from t where x=x+0;
> > integer
> >
> > (first reported here: )
> >
> > This worked correctly in SQLite 3.7.17.
> >
> >
> > Regards,
> > Clemens
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

[mm.w]

Hello,

you might emulate it this way, depends on the scale, size matters 8)

hstore
id | key   | value
 1 | firstname   | John
 1 | lastname   | Doe
 2 | firstname   | John
 2 | lastname   | Doe

obj2hstore

id_obj | id_hstore
  2| 1
  3| 2


Best.





On Tue, Mar 18, 2014 at 6:09 PM, mm.w <0xcafef...@gmail.com> wrote:

> Hello,
>
> you can do a pivot, depends how big the data are, the best option would
> be to extend a script like mysql2sqlite and then transform the DB to avoid
> serialized like oddities.
>
> other option use json
>
>
>
>
>
>
> On Tue, Mar 18, 2014 at 1:09 PM, Petite Abeille 
> <petite.abei...@gmail.com>wrote:
>
>>
>> On Mar 18, 2014, at 8:56 PM, Stefan Keller <sfkel...@gmail.com> wrote:
>>
>> > And, actually, as you may have realized, PostgreSQL proved that even
>> > (post-)relational databases can handle KVP efficiently.
>>
>> Just because one can, doesn't mean one should. But, as always, to each
>> their own.
>>
>> ___
>> 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] Opening and closing an SQLITE3 db in PHP

[mm.w]

Hello, you should ask that on the php stream, they would probably know
better about their wrapper implementation.

try catching up with Ilia.

Best Regards


On Tue, Mar 18, 2014 at 4:49 PM, Tim Streater  wrote:

> Part of my app will, at user request, read some data from an SQLite db and
> also some files from disk, and send it all out on the network. This may in
> some cases take several minutes, at the end of which the db gets updated
> here and there. While this is happening, the user may wish to do another
> action that will require read/write access to this db. Typically this will
> be another process.
>
> As it happens I'd not tried exactly the above until yesterday, at which
> point I got "database locked" after my timeout period expired. Although I'm
> careful to finalize() and close() as appropriate, the way things are
> structured at present the database is left open while the slow processing
> (writing to the network) takes place.
>
> I can rejig this without too much trouble, but for various reasons it's
> not just a simple case of "closing the db earlier", and so I'd like to be
> sure I understand how things work before starting. I'm using PHP's sqlite3
> class rather than PDO, and I've done nothing explicit about the journal
> mode.
>
> My questions are:
>
> 1) I start with $dbh = new sqlite3 ($dbname); Am I right in thinking that
> this does not explicitly open the db (and hence acquire a lock), but that
> the db is opened and the default lock (SQLITE_OPEN_READWRITE |
> SQLITE_OPEN_CREATE) is acquired only when the first query is done?
>
> 2) If I want to use a different flag such as SQLITE_OPEN_READONLY do I
> need to do an explicit open such as $dbh->open ($dbname,
> SQLITE_OPEN_READONLY); or is there a way to specify the flag(s) with "new
> sqlite3" ?
>
> 3) Is the lock always released if I do $dbh->close(); ?
>
> 4) Would it just be simpler to switch to WAL mode?
>
> My rejigging would involve closing db's when I'm about to do something
> potentially slow and then and re-opening them later but I don't think that
> would cause significant overhead.
>
>
>
> --
> Cheers  --  Tim
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Weird out of memory problem a prepare

[mm.w]

Hello,

what's your SharedSection value? [heap limitation]

Best Regards.


On Tue, Mar 4, 2014 at 12:16 PM, Clemens Ladisch  wrote:

> Eduardo Morras wrote:
> > Trying simple "SELECT r.name FROM resource AS r WHERE r.name = ?" gets
> "Out of memory" too calling preparev2.
>
> This has nothing to do with the query itself.
>
> If you aren't doing something funny with the memory allocator, it's likely
> that SQLite's database object got corrupt by some other buggy code.
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite destroys civilization.

[mm.w]

LOL

don't know if it will go thru see png

layer or neuron out of bounds !

Best Regards.


On Sun, Mar 2, 2014 at 2:04 PM, Richard Hipp  wrote:

> On Sun, Mar 2, 2014 at 12:34 PM, Richard Hipp  wrote:
>
> > Reports on twitter say that the "nanobots" in the TV drama "Revolution"
> > have source code in the season two finale that looks like this:
> >
> > https://pbs.twimg.com/media/BhvIsgBCYAAQdvP.png:large
> >
> > Compare to the SQLite source code here:
> >
> > http://www.sqlite.org/src/artifact/69761e167?ln=1264-1281
> >
>
> A video clip from the episode can be seen here:
>
> http://www.nbc.com/revolution/video/repairing-the-code/2748856#i145567,p1
>
> You can clearly see the SQLite code on the monitor.  The dialog goes
> something like this:
>
> Aaron:  Wait.  Hold on.  There.
> Male actor 1: What?
> Aaron: There's a memory leak here.  This chunk of code.  (Points to the
> SQLite analyzeTable() routine).  That's the problem.  It's eating up all
> available resources.  It will force a segmentation fault. The whole system
> will crash!
>
> At that point, I said "Not in my code!"
>
> But upon closer inspection, Aaron is correct.  The code has been altered
> slightly.  This is what Aaron is looking at (line numbers added):
>
> 01 static void analyzeTable(Parse *pParse, Table *pTab, Index *pOnlyIdx){
> 02   int iDb;
> 03   int iStatCur;
> 04   int *key = (char*)malloc(8*sizeOf(char))
> 05   assert( pTab!=0 );
> 06   assert( ecrypBtreeHoldsAllMutexes(pParse->db) );
> 07   iDb = ecrypSchemaToIndex(pParse->db, pTab->pSchema);
> 08   ecrypBeginWriteOperation(pParse, 0, iDb);
> 09   iStatCur = pParse->nTab;
> 10   pParse->nTab += 3;
> 11   if( pOnlyIdx ){
> 12 openStatTable(pParse, iDb, iStatCur, pOnlyIdx->zName, "idx");
> 13   }else{
> 14 openStatTable(pParse, iDb, iStatCur, pTab->zName, "tbl");
> 15   }
> 16 }
>
> The changes from SQLite are (1) all "sqlite3" name prefixes are changes to
> "ecryp" and (2) line 04 has been added.  Line 04 is the "memory leak".  It
> also contains at least four other errors:  (A) there is no semicolon at the
> end.  (B) "sizeof" has a capital "O". (C) It assigns a char* pointer to an
> int* variable.  (D) It calls malloc() directly, which is forbidden inside
> of SQLite since the application might assign a different set of memory
> allocation functions.  The first two errors are fatal - this function won't
> even compile.  But, heh, it's a TV show
>
> So there you go.  SQLite used in evil nanobots that destroy civilization.
>
> I've never actually seen Revolution (I don't own a TV set).  So I don't
> really understand the plot.  Can somebody who has watched this drama please
> brief me?  In particular, I'm curious to know if Aaron a good guy or a bad
> guy?
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite_compileoption_get + cte

[mm.w]

Hello

you meant that's for the Buzz 8) (joke inside)

Best Regards


On Sat, Mar 1, 2014 at 11:06 AM, Petite Abeille <petite.abei...@gmail.com>wrote:

>
> On Mar 1, 2014, at 6:30 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > ? PRAGMA compile_options;
>
> Yes, sure. But much snazzier to use a CTE, no? :D
>
>  ( One very unfortunate aspect of pragmas is that one cannot query them
> with regular SQL… sigh…)
>
> ___
> 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] sqlite_compileoption_get + cte

[mm.w]

Hello,

? PRAGMA compile_options;

Best Regards.


On Sat, Mar 1, 2014 at 7:01 AM, Petite Abeille wrote:

> Just because we can:
>
> with
> Option( name, position )
> as
> (
>   select  sqlite_compileoption_get( 1 ) as name,
>   1 as position
>
>   union all
>   select  sqlite_compileoption_get( position + 1 ) as name,
>   position + 1 as position
>   fromOption
>   where   sqlite_compileoption_get( position + 1 ) is not null
> )
> selectname
> from  Option
>
> order by  name
>
> > ENABLE_FTS3_PARENTHESIS
> > ENABLE_RTREE
> > ENABLE_STAT4
> > SYSTEM_MALLOC
> > THREADSAFE=1
>
>
>
> ___
> 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] EF6 - SQLite file remains locked after dispose

[mm.w]

Hello,

my bad learning c# on the rock, I feel dirty.

Best Regards.


On Thu, Feb 27, 2014 at 1:17 PM, mm.w <0xcafef...@gmail.com> wrote:

> Hello
>
> tell him to add a call named close() ...
>
> but anyway try that:
>
> var sqliteConnection = null;
> using (sqliteConnection = new ... ) { ... }
> sqliteConnection = null;
>
> // delete
>
> or
>
> var sqliteConnection = null;
> using (sqliteConnection = new ... ) { ... }
> sqliteConnection.Dispose();
> sqliteConnection = null;
>
> // delete
>
> or
>
> var sqliteConnection = null;
> using (sqliteConnection = new ... ) { ... }
> GC.Collect();
>
> // delete
>
> Best Regards.
>
>
> On Thu, Feb 27, 2014 at 1:00 PM, Joe Strommen <joe.strom...@gmail.com>wrote:
>
>> The File.Delete call *is* outside the scope using block.
>>
>> Anyhow, I've added a comment to the ticket.  It would be great if a dev
>> working on SQLite-LINQ integration gave this a look.
>>
>> Thanks much!
>>
>>
>>
>> On Thu, Feb 27, 2014 at 2:55 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > Hello,
>> >
>> > so then move your code out of a scoped using block or force the gc at
>> the
>> > end before deleting the file
>> >
>> > anyway what an ugly language! java almost died (google saved it, they
>> > should not have), and they did it again! calling that c#, by bad.
>> >
>> > Best Regards.
>> >
>> >
>> > On Thu, Feb 27, 2014 at 12:50 PM, Joe Strommen <joe.strom...@gmail.com
>> > >wrote:
>> >
>> > > After looking into this further, I think this is the same problem
>> > described
>> > > in ticket aba4549801, which was marked resolved in Sep 2013 (
>> > > https://system.data.sqlite.org/index.html/tktview?name=aba4549801)
>> > >
>> > > I will add a comment to the ticket to try to get it re-opened.
>> > >
>> > > Thanks
>> > > Joe
>> > >
>> > >
>> > > On Thu, Feb 27, 2014 at 2:49 PM, mm.w <0xcafef...@gmail.com> wrote:
>> > >
>> > > > Hello,
>> > > >
>> > > > is it the class you use?
>> > > >
>> > > > https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs
>> > > >
>> > > > then extend SQLiteConnection and overwrite
>> > > >
>> > > > public void Dispose () to trace what's happening
>> > > >
>> > > >
>> > > > Best Regards.
>> > > >
>> > > >
>> > > > On Thu, Feb 27, 2014 at 12:33 PM, mm.w <0xcafef...@gmail.com>
>> wrote:
>> > > >
>> > > > > Hello,
>> > > > >
>> > > > > reading quickly the doc
>> > > > >
>> > > > > "Constructs a new context instance using the existing connection
>> to
>> > > > > connect to a database. The connection will not be disposed when
>> the
>> > > > context
>> > > > > is disposed ifcontextOwnsConnection is false."
>> > > > >
>> > > > > base(existingConnection, false) { }
>> > > > >
>> > > > > Best Regards.
>> > > > >
>> > > > >
>> > > > > On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <
>> > joe.strom...@gmail.com
>> > > > >wrote:
>> > > > >
>> > > > >> The end of the using() block automatically closes the connection.
>> >  If
>> > > I
>> > > > >> remove the line with "efContext.TestEntities.Count()" then it
>> works
>> > > > fine.
>> > > > >>
>> > > > >>
>> > > > >> On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com>
>> wrote:
>> > > > >>
>> > > > >> > Hello,
>> > > > >> >
>> > > > >> > I don't know anything about c# and the  Entity Framework, but
>> > > > something
>> > > > >> > obvious where do you close your connection?
>> > > > >> >
>> > > > >> > Best Regards.
>> > > > >> >
>> > > > >> >
>> > > > >> > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen <
>&g

Re: [sqlite] EF6 - SQLite file remains locked after dispose

[mm.w]

Hello

tell him to add a call named close() ...

but anyway try that:

var sqliteConnection = null;
using (sqliteConnection = new ... ) { ... }
sqliteConnection = null;

// delete

or

var sqliteConnection = null;
using (sqliteConnection = new ... ) { ... }
sqliteConnection.Dispose();
sqliteConnection = null;

// delete

or

var sqliteConnection = null;
using (sqliteConnection = new ... ) { ... }
GC.Collect();

// delete

Best Regards.


On Thu, Feb 27, 2014 at 1:00 PM, Joe Strommen <joe.strom...@gmail.com>wrote:

> The File.Delete call *is* outside the scope using block.
>
> Anyhow, I've added a comment to the ticket.  It would be great if a dev
> working on SQLite-LINQ integration gave this a look.
>
> Thanks much!
>
>
>
> On Thu, Feb 27, 2014 at 2:55 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > Hello,
> >
> > so then move your code out of a scoped using block or force the gc at the
> > end before deleting the file
> >
> > anyway what an ugly language! java almost died (google saved it, they
> > should not have), and they did it again! calling that c#, by bad.
> >
> > Best Regards.
> >
> >
> > On Thu, Feb 27, 2014 at 12:50 PM, Joe Strommen <joe.strom...@gmail.com
> > >wrote:
> >
> > > After looking into this further, I think this is the same problem
> > described
> > > in ticket aba4549801, which was marked resolved in Sep 2013 (
> > > https://system.data.sqlite.org/index.html/tktview?name=aba4549801)
> > >
> > > I will add a comment to the ticket to try to get it re-opened.
> > >
> > > Thanks
> > > Joe
> > >
> > >
> > > On Thu, Feb 27, 2014 at 2:49 PM, mm.w <0xcafef...@gmail.com> wrote:
> > >
> > > > Hello,
> > > >
> > > > is it the class you use?
> > > >
> > > > https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs
> > > >
> > > > then extend SQLiteConnection and overwrite
> > > >
> > > > public void Dispose () to trace what's happening
> > > >
> > > >
> > > > Best Regards.
> > > >
> > > >
> > > > On Thu, Feb 27, 2014 at 12:33 PM, mm.w <0xcafef...@gmail.com> wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > reading quickly the doc
> > > > >
> > > > > "Constructs a new context instance using the existing connection to
> > > > > connect to a database. The connection will not be disposed when the
> > > > context
> > > > > is disposed ifcontextOwnsConnection is false."
> > > > >
> > > > > base(existingConnection, false) { }
> > > > >
> > > > > Best Regards.
> > > > >
> > > > >
> > > > > On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <
> > joe.strom...@gmail.com
> > > > >wrote:
> > > > >
> > > > >> The end of the using() block automatically closes the connection.
> >  If
> > > I
> > > > >> remove the line with "efContext.TestEntities.Count()" then it
> works
> > > > fine.
> > > > >>
> > > > >>
> > > > >> On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com>
> wrote:
> > > > >>
> > > > >> > Hello,
> > > > >> >
> > > > >> > I don't know anything about c# and the  Entity Framework, but
> > > > something
> > > > >> > obvious where do you close your connection?
> > > > >> >
> > > > >> > Best Regards.
> > > > >> >
> > > > >> >
> > > > >> > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen <
> > > > joe.strom...@gmail.com
> > > > >> > >wrote:
> > > > >> >
> > > > >> > > Hi all,
> > > > >> > >I'm using SQLite with Entity Framework 6 and having a
> > problem.
> > >  I
> > > > >> am
> > > > >> > > unable to delete the sqlite file, even though I'm disposing
> all
> > my
> > > > >> > > disposable objects.  Below is a minimal code sample that
> > > > demonstrates
> > > > >> the
> > > > >> > > issue.  I'd appreciate any advice/workarounds you can provide.
> > >  I

Re: [sqlite] EF6 - SQLite file remains locked after dispose

[mm.w]

Hello,

so then move your code out of a scoped using block or force the gc at the
end before deleting the file

anyway what an ugly language! java almost died (google saved it, they
should not have), and they did it again! calling that c#, by bad.

Best Regards.


On Thu, Feb 27, 2014 at 12:50 PM, Joe Strommen <joe.strom...@gmail.com>wrote:

> After looking into this further, I think this is the same problem described
> in ticket aba4549801, which was marked resolved in Sep 2013 (
> https://system.data.sqlite.org/index.html/tktview?name=aba4549801)
>
> I will add a comment to the ticket to try to get it re-opened.
>
> Thanks
> Joe
>
>
> On Thu, Feb 27, 2014 at 2:49 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > Hello,
> >
> > is it the class you use?
> >
> > https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs
> >
> > then extend SQLiteConnection and overwrite
> >
> > public void Dispose () to trace what's happening
> >
> >
> > Best Regards.
> >
> >
> > On Thu, Feb 27, 2014 at 12:33 PM, mm.w <0xcafef...@gmail.com> wrote:
> >
> > > Hello,
> > >
> > > reading quickly the doc
> > >
> > > "Constructs a new context instance using the existing connection to
> > > connect to a database. The connection will not be disposed when the
> > context
> > > is disposed ifcontextOwnsConnection is false."
> > >
> > > base(existingConnection, false) { }
> > >
> > > Best Regards.
> > >
> > >
> > > On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <joe.strom...@gmail.com
> > >wrote:
> > >
> > >> The end of the using() block automatically closes the connection.  If
> I
> > >> remove the line with "efContext.TestEntities.Count()" then it works
> > fine.
> > >>
> > >>
> > >> On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com> wrote:
> > >>
> > >> > Hello,
> > >> >
> > >> > I don't know anything about c# and the  Entity Framework, but
> > something
> > >> > obvious where do you close your connection?
> > >> >
> > >> > Best Regards.
> > >> >
> > >> >
> > >> > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen <
> > joe.strom...@gmail.com
> > >> > >wrote:
> > >> >
> > >> > > Hi all,
> > >> > >I'm using SQLite with Entity Framework 6 and having a problem.
>  I
> > >> am
> > >> > > unable to delete the sqlite file, even though I'm disposing all my
> > >> > > disposable objects.  Below is a minimal code sample that
> > demonstrates
> > >> the
> > >> > > issue.  I'd appreciate any advice/workarounds you can provide.
>  I'm
> > >> happy
> > >> > > to enter a ticket for this, but I wanted to verify that I'm not
> > doing
> > >> > > something wrong first.
> > >> > >
> > >> > > (I'm using the latest System.Data.SQLite NuGet package, which is
> > >> version
> > >> > > 1.0.91)
> > >> > >
> > >> > > Thanks
> > >> > > Joe Strommen
> > >> > >
> > >> > > class Program
> > >> > > {
> > >> > > public class TestContext : DbContext
> > >> > > {
> > >> > > public TestContext(DbConnection existingConnection) :
> > >> > > base(existingConnection, false) { }
> > >> > >
> > >> > > public DbSet TestEntities { get; set; }
> > >> > > }
> > >> > >
> > >> > > public class TestEntity
> > >> > > {
> > >> > > public long Id { get; set; }
> > >> > >
> > >> > > public string Value { get; set; }
> > >> > > }
> > >> > >
> > >> > > static void Main(string[] args)
> > >> > > {
> > >> > > var path = "test.sqlite";
> > >> > > if (File.Exists(path)) { File.Delete(path); }
> > >> > > using (var sqliteConnection = new
> SQLiteConnection("Data
> > >> > > Source=" + path

Re: [sqlite] EF6 - SQLite file remains locked after dispose

[mm.w]

Hello,

is it the class you use?

https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs

then extend SQLiteConnection and overwrite

public void Dispose () to trace what's happening


Best Regards.


On Thu, Feb 27, 2014 at 12:33 PM, mm.w <0xcafef...@gmail.com> wrote:

> Hello,
>
> reading quickly the doc
>
> "Constructs a new context instance using the existing connection to
> connect to a database. The connection will not be disposed when the context
> is disposed ifcontextOwnsConnection is false."
>
> base(existingConnection, false) { }
>
> Best Regards.
>
>
> On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <joe.strom...@gmail.com>wrote:
>
>> The end of the using() block automatically closes the connection.  If I
>> remove the line with "efContext.TestEntities.Count()" then it works fine.
>>
>>
>> On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > Hello,
>> >
>> > I don't know anything about c# and the  Entity Framework, but something
>> > obvious where do you close your connection?
>> >
>> > Best Regards.
>> >
>> >
>> > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen <joe.strom...@gmail.com
>> > >wrote:
>> >
>> > > Hi all,
>> > >I'm using SQLite with Entity Framework 6 and having a problem.  I
>> am
>> > > unable to delete the sqlite file, even though I'm disposing all my
>> > > disposable objects.  Below is a minimal code sample that demonstrates
>> the
>> > > issue.  I'd appreciate any advice/workarounds you can provide.  I'm
>> happy
>> > > to enter a ticket for this, but I wanted to verify that I'm not doing
>> > > something wrong first.
>> > >
>> > > (I'm using the latest System.Data.SQLite NuGet package, which is
>> version
>> > > 1.0.91)
>> > >
>> > > Thanks
>> > > Joe Strommen
>> > >
>> > > class Program
>> > > {
>> > > public class TestContext : DbContext
>> > > {
>> > > public TestContext(DbConnection existingConnection) :
>> > > base(existingConnection, false) { }
>> > >
>> > > public DbSet TestEntities { get; set; }
>> > > }
>> > >
>> > > public class TestEntity
>> > > {
>> > > public long Id { get; set; }
>> > >
>> > > public string Value { get; set; }
>> > > }
>> > >
>> > > static void Main(string[] args)
>> > > {
>> > > var path = "test.sqlite";
>> > > if (File.Exists(path)) { File.Delete(path); }
>> > > using (var sqliteConnection = new SQLiteConnection("Data
>> > > Source=" + path))
>> > > {
>> > > sqliteConnection.Open();
>> > >
>> > > using (var sqliteCmd =
>> sqliteConnection.CreateCommand())
>> > > {
>> > > sqliteCmd.CommandText =
>> > > "CREATE TABLE TestEntities (Id INTEGER PRIMARY
>> > KEY
>> > > AUTOINCREMENT, Value TEXT);" +
>> > > "INSERT INTO TestEntities ('Value') VALUES
>> > > ('Value1'), ('Value2'), ('Value3');";
>> > > sqliteCmd.ExecuteNonQuery();
>> > > }
>> > >
>> > > using (var efContext = new
>> TestContext(sqliteConnection))
>> > > {
>> > > var entityCount = efContext.TestEntities.Count();
>> > > }
>> > > }
>> > > File.Delete(path); // Fails; the file is still locked.
>> > > }
>> > > }
>> > > ___
>> > > sqlite-users mailing list
>> > > sqlite-users@sqlite.org
>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > >
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EF6 - SQLite file remains locked after dispose

[mm.w]

http://msdn.microsoft.com/en-us/library/system.data.entity.dbcontext(v=vs.113).aspx

public class TestContext : DbContext ?





On Thu, Feb 27, 2014 at 12:41 PM, Joe Strommen <joe.strom...@gmail.com>wrote:

> To be more specific - the end of the "using (var sqliteConnection = new
> SQLiteConnection("Data Source=" + path))" block will close the connection.
>  I'm not relying on Entity Framework to close the connection for me.
>
>
>
> On Thu, Feb 27, 2014 at 2:33 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > Hello,
> >
> > reading quickly the doc
> >
> > "Constructs a new context instance using the existing connection to
> connect
> > to a database. The connection will not be disposed when the context is
> > disposed ifcontextOwnsConnection is false."
> >
> > base(existingConnection, false) { }
> >
> > Best Regards.
> >
> >
> > On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <joe.strom...@gmail.com
> > >wrote:
> >
> > > The end of the using() block automatically closes the connection.  If I
> > > remove the line with "efContext.TestEntities.Count()" then it works
> fine.
> > >
> > >
> > > On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com> wrote:
> > >
> > > > Hello,
> > > >
> > > > I don't know anything about c# and the  Entity Framework, but
> something
> > > > obvious where do you close your connection?
> > > >
> > > > Best Regards.
> > > >
> > > >
> > > > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen <
> joe.strom...@gmail.com
> > > > >wrote:
> > > >
> > > > > Hi all,
> > > > >I'm using SQLite with Entity Framework 6 and having a problem.
>  I
> > am
> > > > > unable to delete the sqlite file, even though I'm disposing all my
> > > > > disposable objects.  Below is a minimal code sample that
> demonstrates
> > > the
> > > > > issue.  I'd appreciate any advice/workarounds you can provide.  I'm
> > > happy
> > > > > to enter a ticket for this, but I wanted to verify that I'm not
> doing
> > > > > something wrong first.
> > > > >
> > > > > (I'm using the latest System.Data.SQLite NuGet package, which is
> > > version
> > > > > 1.0.91)
> > > > >
> > > > > Thanks
> > > > > Joe Strommen
> > > > >
> > > > > class Program
> > > > > {
> > > > > public class TestContext : DbContext
> > > > > {
> > > > > public TestContext(DbConnection existingConnection) :
> > > > > base(existingConnection, false) { }
> > > > >
> > > > > public DbSet TestEntities { get; set; }
> > > > > }
> > > > >
> > > > > public class TestEntity
> > > > > {
> > > > > public long Id { get; set; }
> > > > >
> > > > > public string Value { get; set; }
> > > > > }
> > > > >
> > > > > static void Main(string[] args)
> > > > > {
> > > > > var path = "test.sqlite";
> > > > > if (File.Exists(path)) { File.Delete(path); }
> > > > > using (var sqliteConnection = new
> SQLiteConnection("Data
> > > > > Source=" + path))
> > > > > {
> > > > > sqliteConnection.Open();
> > > > >
> > > > > using (var sqliteCmd =
> > > sqliteConnection.CreateCommand())
> > > > > {
> > > > > sqliteCmd.CommandText =
> > > > > "CREATE TABLE TestEntities (Id INTEGER
> > PRIMARY
> > > > KEY
> > > > > AUTOINCREMENT, Value TEXT);" +
> > > > > "INSERT INTO TestEntities ('Value') VALUES
> > > > > ('Value1'), ('Value2'), ('Value3');";
> > > > > sqliteCmd.ExecuteNonQuery();
> > > > > }
> > > > >
> > > > > using (var efContext = new
> > > TestContext(sqliteConnection))
> > > > >  

Re: [sqlite] EF6 - SQLite file remains locked after dispose

[mm.w]

Hello,

reading quickly the doc

"Constructs a new context instance using the existing connection to connect
to a database. The connection will not be disposed when the context is
disposed ifcontextOwnsConnection is false."

base(existingConnection, false) { }

Best Regards.


On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <joe.strom...@gmail.com>wrote:

> The end of the using() block automatically closes the connection.  If I
> remove the line with "efContext.TestEntities.Count()" then it works fine.
>
>
> On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com> wrote:
>
> > Hello,
> >
> > I don't know anything about c# and the  Entity Framework, but something
> > obvious where do you close your connection?
> >
> > Best Regards.
> >
> >
> > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen <joe.strom...@gmail.com
> > >wrote:
> >
> > > Hi all,
> > >I'm using SQLite with Entity Framework 6 and having a problem.  I am
> > > unable to delete the sqlite file, even though I'm disposing all my
> > > disposable objects.  Below is a minimal code sample that demonstrates
> the
> > > issue.  I'd appreciate any advice/workarounds you can provide.  I'm
> happy
> > > to enter a ticket for this, but I wanted to verify that I'm not doing
> > > something wrong first.
> > >
> > > (I'm using the latest System.Data.SQLite NuGet package, which is
> version
> > > 1.0.91)
> > >
> > > Thanks
> > > Joe Strommen
> > >
> > > class Program
> > > {
> > > public class TestContext : DbContext
> > > {
> > > public TestContext(DbConnection existingConnection) :
> > > base(existingConnection, false) { }
> > >
> > > public DbSet TestEntities { get; set; }
> > > }
> > >
> > > public class TestEntity
> > > {
> > > public long Id { get; set; }
> > >
> > > public string Value { get; set; }
> > > }
> > >
> > > static void Main(string[] args)
> > > {
> > > var path = "test.sqlite";
> > > if (File.Exists(path)) { File.Delete(path); }
> > > using (var sqliteConnection = new SQLiteConnection("Data
> > > Source=" + path))
> > > {
> > > sqliteConnection.Open();
> > >
> > > using (var sqliteCmd =
> sqliteConnection.CreateCommand())
> > > {
> > > sqliteCmd.CommandText =
> > > "CREATE TABLE TestEntities (Id INTEGER PRIMARY
> > KEY
> > > AUTOINCREMENT, Value TEXT);" +
> > > "INSERT INTO TestEntities ('Value') VALUES
> > > ('Value1'), ('Value2'), ('Value3');";
> > > sqliteCmd.ExecuteNonQuery();
> > > }
> > >
> > > using (var efContext = new
> TestContext(sqliteConnection))
> > > {
> > > var entityCount = efContext.TestEntities.Count();
> > > }
> > > }
> > > File.Delete(path); // Fails; the file is still locked.
> > > }
> > > }
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EF6 - SQLite file remains locked after dispose

[mm.w]

Hello,

I don't know anything about c# and the  Entity Framework, but something
obvious where do you close your connection?

Best Regards.


On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen wrote:

> Hi all,
>I'm using SQLite with Entity Framework 6 and having a problem.  I am
> unable to delete the sqlite file, even though I'm disposing all my
> disposable objects.  Below is a minimal code sample that demonstrates the
> issue.  I'd appreciate any advice/workarounds you can provide.  I'm happy
> to enter a ticket for this, but I wanted to verify that I'm not doing
> something wrong first.
>
> (I'm using the latest System.Data.SQLite NuGet package, which is version
> 1.0.91)
>
> Thanks
> Joe Strommen
>
> class Program
> {
> public class TestContext : DbContext
> {
> public TestContext(DbConnection existingConnection) :
> base(existingConnection, false) { }
>
> public DbSet TestEntities { get; set; }
> }
>
> public class TestEntity
> {
> public long Id { get; set; }
>
> public string Value { get; set; }
> }
>
> static void Main(string[] args)
> {
> var path = "test.sqlite";
> if (File.Exists(path)) { File.Delete(path); }
> using (var sqliteConnection = new SQLiteConnection("Data
> Source=" + path))
> {
> sqliteConnection.Open();
>
> using (var sqliteCmd = sqliteConnection.CreateCommand())
> {
> sqliteCmd.CommandText =
> "CREATE TABLE TestEntities (Id INTEGER PRIMARY KEY
> AUTOINCREMENT, Value TEXT);" +
> "INSERT INTO TestEntities ('Value') VALUES
> ('Value1'), ('Value2'), ('Value3');";
> sqliteCmd.ExecuteNonQuery();
> }
>
> using (var efContext = new TestContext(sqliteConnection))
> {
> var entityCount = efContext.TestEntities.Count();
> }
> }
> File.Delete(path); // Fails; the file is still locked.
> }
> }
> ___
> 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] compile problem with sqlite 3.7.6.3 on ubuntu

[mm.w]

Hello

that's an undefined symbol of some lib/fork "sqlite_shell_init_icu", this
is not part of sqlite standard amalgamation, I guess you need to
add shell_icu_linux.c from the fork at compile time.

Best Regards


On Thu, Feb 27, 2014 at 11:35 AM, Nabeel Younus  wrote:

> HI,
>
>Thanks for your reply.
>
> I have already installed ICU lib i.e. libicu-dev.
>
> Waiting for your reply.
>
> Regards,
> Nabeel
>
>
> On Fri, Feb 28, 2014 at 2:56 AM, Richard Hipp  wrote:
>
> > Maybe you need to install the ICU library on your system.
> >
> >
> > On Wed, Feb 26, 2014 at 10:04 PM, Nabeel Younus 
> wrote:
> >
> > > Hi everyone,
> > >
> > > I am having a problem with compiling sqlite 3.7.6.3 on Linux i686.
> I
> > > have to use only this version because it has been provided by our
> > clients.
> > >
> > > The *sqlite3.7.6.3* folder contains *amalgamation folder, src
> folder
> > > and patches files. *
> > >
> > >  I have changed my directory to *src* folder. Then I have performed
> > > configure which works ok. But when I run *make command* I get an error
> > > message:
> > >
> > > */sqlite/src/./src/shell.c:2668: undefined reference to
> > > `sqlite_shell_init_icu'*
> > > *collect2: ld returned 1 exit status*
> > > *make: *** [sqlite3] Error 1*
> > >
> > >  Can anyone please help to solve this problem?
> > >
> > > Regards,
> > > ---
> > > Nabeel
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> >
> >
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> Regards,
> --
> Nabeel Younus Khan
> PhD Student (Computer Science Dept),
> University of Otago
> Dunedin, New Zealand
> Cell: +64212689881
> *Website: http://www.nabeelyounuskhan.com
>  *
> ___
> 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] Query Flattening / Query Optimization / Correlated Subquery Substitution

[mm.w]

Hello,

thank you for your reply, that works for me. To give a context and a
background; my comment was implying a change of design by adding an
abstraction layer between the data and the representation, a change of
raw-data storage with the support of a middle-man-linker e.g async data
events, but I must recognize, this is one of my default I always imagine
that people would get immediately what I have deep in my mind, I apology
for that, that's also very true, I don't know anything about your project
and its goal, again, the proof that telepathy does not work!

Best Regards.



On Tue, Feb 25, 2014 at 6:18 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
>
>
> On Monday, 24 February, 2014 21:53, mm.w <0xcafef...@gmail.com> said:
>
> >I don't want to be annoying but why nowadays people are
> >sub-abusing-sub-selecting instead of using JOINs? moreover, that is in
> >most cases faster (a lot) and certainly more Human Readable.
>
> Neither JOIN nor LEFT JOIN will work in this case because the RateClass
and ClassRate are sparse relative to RawData.  That is, there is RawData
for every Month of every Year, but the RateClass only changes infrequently
(a few times scattered over a few years) and the ClassRate also only
changes occassionally (and not necessarily at the same time as the
RateClass changed).
>
> One could project both sparse tables to cover the entire range of Year,
Month and then do a simple equijoin, but it is far more complicated to
project and join than to perform simple correlated subqueries to find the
Class and Rate in effect at a given Year & Month.
>
> On Mon, Feb 24, 2014 at 8:34 PM, Keith Medcalf <kmedc...@dessus.com>
> >wrote:
> >
> >>
> >> Previous send munged.  If it managed to make it properly, my apologies
> >for
> >> posting the same message twice.
> >>
> >> Using the following schema:
> >>
> >> CREATE TABLE TKRawData
> >> (
> >>  EmpNo text collate nocase not null,
> >>  CustNo integer not null,
> >>  JobNo integer not null,
> >>  RawYear integer not null,
> >>  RawMonth integer not null,
> >>  RawDays real not null,
> >>  primary key (EmpNo, JobNo, CustNo, RawYear, RawMonth)
> >> );
> >>
> >> CREATE TABLE TKClassRates
> >> (
> >>  RateClass integer not null,
> >>  Year integer not null,
> >>  Month integer not null,
> >>  Rate real not null,
> >>  primary key (RateClass, Year, Month)
> >> );
> >>
> >> CREATE TABLE TKEmpRateClass
> >> (
> >>  EmpNo text not null,
> >>  Year integer not null,
> >>  Month integer not null,
> >>  RateClass integer not null,
> >>  primary key (EmpNo, Year, Month)
> >> );
> >>
> >> CREATE INDEX TKClassRatesCover on TKClassRates (RateClass, Year desc,
> >> Month desc, Rate);
> >>
> >> CREATE INDEX TKEmpRateClassCover on TKEmpRateClass (EmpNo, Year desc,
> >> Month desc, RateClass);
> >>
> >> CREATE VIEW TKRawDataRate
> >> as
> >> select *,
> >>RawDays*RawRate as RawCharge
> >>   from (  select *,
> >>  coalesce((  select Rate
> >>from TKClassRates
> >>   where RateClass = RawRateClass
> >> and Year*12+Month-1 <=
> >> RawYear*12+RawMonth-1
> >>order by Year desc, Month desc limit 1), 1)
> >as
> >> RawRate
> >> from (  select *,
> >>coalesce((  select RateClass
> >>  from TKEmpRateClass
> >> where EmpNo = TKRawData.EmpNo
> >>   and Year*12+Month-1 <=
> >> RawYear*12+RawMonth-1
> >>  order by Year desc, Month desc
> >limit
> >> 1), 1) as RawRateClass
> >>   from TKRawData
> >>  ) as T1
> >>) as T2;
> >>
> >> Doing the following:
> >>
> >> SELECT * FROM TKRawDataRate;
> >>
> >> results in the following plan:
> >>
> >> sqlite> explain query plan select * from tkrawdatarate;
> >> 0|0|0|SCAN TABLE TKRawData
> >> 0|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 1
> >> 1|0|0|SEARCH TABLE TKEmpRateClass USING COVERING INDEX
> >TKEmpRateClassCover
> >> (EmpNo=?)
> >> 0|0|0|EXECUTE CORRELATED SCALAR SU

Re: [sqlite] Query Flattening / Query Optimization / Correlated Subquery Substitution

[mm.w]

Hello,

I don't want to be annoying but why nowadays people are
sub-abusing-sub-selecting instead of using JOINs? moreover, that is in most
cases faster (a lot) and certainly more Human Readable.

Best Regards


On Mon, Feb 24, 2014 at 8:34 PM, Keith Medcalf  wrote:

>
> Previous send munged.  If it managed to make it properly, my apologies for
> posting the same message twice.
>
> Using the following schema:
>
> CREATE TABLE TKRawData
> (
>  EmpNo text collate nocase not null,
>  CustNo integer not null,
>  JobNo integer not null,
>  RawYear integer not null,
>  RawMonth integer not null,
>  RawDays real not null,
>  primary key (EmpNo, JobNo, CustNo, RawYear, RawMonth)
> );
>
> CREATE TABLE TKClassRates
> (
>  RateClass integer not null,
>  Year integer not null,
>  Month integer not null,
>  Rate real not null,
>  primary key (RateClass, Year, Month)
> );
>
> CREATE TABLE TKEmpRateClass
> (
>  EmpNo text not null,
>  Year integer not null,
>  Month integer not null,
>  RateClass integer not null,
>  primary key (EmpNo, Year, Month)
> );
>
> CREATE INDEX TKClassRatesCover on TKClassRates (RateClass, Year desc,
> Month desc, Rate);
>
> CREATE INDEX TKEmpRateClassCover on TKEmpRateClass (EmpNo, Year desc,
> Month desc, RateClass);
>
> CREATE VIEW TKRawDataRate
> as
> select *,
>RawDays*RawRate as RawCharge
>   from (  select *,
>  coalesce((  select Rate
>from TKClassRates
>   where RateClass = RawRateClass
> and Year*12+Month-1 <=
> RawYear*12+RawMonth-1
>order by Year desc, Month desc limit 1), 1) as
> RawRate
> from (  select *,
>coalesce((  select RateClass
>  from TKEmpRateClass
> where EmpNo = TKRawData.EmpNo
>   and Year*12+Month-1 <=
> RawYear*12+RawMonth-1
>  order by Year desc, Month desc limit
> 1), 1) as RawRateClass
>   from TKRawData
>  ) as T1
>) as T2;
>
> Doing the following:
>
> SELECT * FROM TKRawDataRate;
>
> results in the following plan:
>
> sqlite> explain query plan select * from tkrawdatarate;
> 0|0|0|SCAN TABLE TKRawData
> 0|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 1
> 1|0|0|SEARCH TABLE TKEmpRateClass USING COVERING INDEX TKEmpRateClassCover
> (EmpNo=?)
> 0|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 2
> 2|0|0|SEARCH TABLE TKClassRates USING COVERING INDEX TKClassRatesCover
> (RateClass=?)
> 2|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 3
> 3|0|0|SEARCH TABLE TKEmpRateClass USING COVERING INDEX TKEmpRateClassCover
> (EmpNo=?)
> 0|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 4
> 4|0|0|SEARCH TABLE TKClassRates USING COVERING INDEX TKClassRatesCover
> (RateClass=?)
> 4|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 5
> 5|0|0|SEARCH TABLE TKEmpRateClass USING COVERING INDEX TKEmpRateClassCover
> (EmpNo=?)
> sqlite>
>
> Results are correct and the plan is the same with or without analyze
> (there is really only one way to answer the query).  The query planner
> seems to be substituting the correlated subqueries each time the
> intermediate is referenced rather than executing the subquery once and
> passing the result up/along.
>
> create view TKRawDataTest
> as
> select *,
>RawDays * coalesce((  select Rate
>from TKClassRates
>   where RateClass = coalesce((  select
> RateClass
>   from
> TKEmpRateClass
>  where EmpNo =
> TKRawData.EmpNo
>and
> Year*12+Month-1 <= RawYear*12+RawMonth-1
>   order by Year
> desc, Month desc limit 1), 1)
> and Year*12+Month-1 <=
> RawYear*12+RawMonth-1
>order by Year desc, Month desc limit 1), 1) as
> RawCharge
>   from TKRawData;
>
> however, does generate a plan with only one execution of each correlated
> subquery, but does not give me access to the intermediate results (it also
> generates correct results)
>
> SELECT * FROM TKRawDataTest;
>
> sqlite> explain query plan select * from tkrawdatatest;
> 0|0|0|SCAN TABLE TKRawData
> 0|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 1
> 1|0|0|SEARCH TABLE TKClassRates USING COVERING INDEX TKClassRatesCover
> (RateClass=?)
> 1|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 2
> 2|0|0|SEARCH TABLE TKEmpRateClass USING COVERING INDEX TKEmpRateClassCover
> (EmpNo=?)
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___

Re: [sqlite] partially excluding records

[mm.w]

Hello

I would simply inner join, then filtering.

Best Regards.


On Fri, Feb 21, 2014 at 12:11 PM, David Bicking  wrote:

>
> 
> On Fri, 2/21/14, Igor Tandetnik  wrote:
>
>  Subject: Re: [sqlite] partially excluding records
>  To: sqlite-users@sqlite.org
>  Date: Friday, February 21, 2014, 2:58 PM
>
>  On 2/21/2014 1:23 PM,
>  David Bicking wrote:
>  >> SELECT Key, COUNT(STATUS) Cnt
>  >> , MIN(STATUS) || CASE WHEN COUNT(STATUS)>1 THEN '+' ELSE '' END
> Statuses
>  >> FROM T1
>  >> WHERE ...
>  >> GROUP BY KEY;
>  >>
>
> > You might be looking for something like this:
> > select key, sum(STATUS != 'C') + (case when sum(STATUS != 'C') = 0 then
>  sum(STATUS
> > 'C') else 0 end) Cnt, ...
>
> > No special WHERE clause needed.
>
> *** found another typo in my example, that should have been WHEN
> COUNT(DISTINCT STATUS)>1 ***
>
> *** Annoying that they make up their minds that they want it to work like
> this today, then end the meeting with... and you can have this done by
> Monday, right? I need to calm down. ***
>
> Anyway, there are other fields and messy CASE statements that probably
> wouldn't work with this solution.
>
> But I am curious, wouldn't this yield a "Statuses" for key 2 of 'C+', when
> it should be 'O'?
>
> Thanks,
> David
>
>  ___
>  sqlite-users mailing list
>  sqlite-users@sqlite.org
>  http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with .mode line

[mm.w]

hello,

this is only a problem of carriage returns or/and line feed.

http://notepad-plus-plus.org/

Best Regards.



On Thu, Feb 20, 2014 at 6:58 AM, pelek  wrote:

> indeed ! I tried to open same file with Programers Notepad and file looked
> exacly like I need. But when I was opening file in standard windows notepad
> then I got whole CREATE TABLE code in one line!
> It is problem for me, because I am trying to open same file with c# code.
> Unfortunetly c# is opening the code: CREATE TABLE in one line  - which is
> wrong !! :( :( :(
>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/Problem-with-mode-line-tp74045p74058.html
> Sent from the SQLite mailing list archive at Nabble.com.
> ___
> 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