[sqlite] Mozilla wiki 'avoid SQLite'

Oh dear. So you think that a high level language is one that does things by calling a lower level language? Stop embarrassing yourself. A high level language is one where the language designers are free to use whatever structural concepts best fit the problems that the language is designed

[sqlite] Mozilla wiki 'avoid SQLite'

> On 15 Jun 2015, at 15:44, Scott Robison wrote: > > Too many of these technology based discussions (whether languages or > operating systems or text editors or database engines or whatever) break > down into almost a religious fervor of "this is the one true You mean like your comment from

Re: [sqlite] INTEGER PRIMARY KEY and SQLITE_ENABLE_STAT2

logical? It seems equally logical to me that one of A or B might be evaluated, and if it were false, then the other might not be evaluated. And it would be logical to choose which of A or B to evaluated on a predicted cost and probability of an advantageous false result. but hay. Who said

Re: [sqlite] does sqlite work with Apple iCloud and IOS 5

Andy Simon's answer is totally nonsense. I suspect that he has misunderstood something that he's read. The only thing that he is right about, is that neither of us can tell you anything about iOS 5 until the cloud API is public. However, what I can tell you, which isn't about iOS 5, is

Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance

It's not your problem. If the idiot user wants a slow machine, that's his choice. It certainly isn't your job to turn off sync in order to hide how slow Windows is. On 30 Nov 2012, at 17:41, David de Regt wrote: > Hey all. I've been struggling with a basic perf issue

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

I can't wait to try order by row_number desc On 1 Jul 2013, at 10:33, Tony Papadimitriou wrote: > Is there a function (or method), e.g., row(), to return the sequence number > of the selected row? This is not the same as ROWID. row() should give a > sequence number

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

tand what the results will be. This would be just another nail in the coffin of relationality and simplicity, on a minor whim. On 1 Jul 2013, at 11:01, Tony Papadimitriou <to...@acm.org> wrote: > > -Original Message----- From: Alex Bowden > Sent: Monday, July 01, 2013 12:46 PM

Re: [sqlite] Is there a way to return the row number? (NOTthe rowid)

de. In fact it might require extra, to prevent it. It's pointless, but benign. > So, why make it sound like I don't know what I'm talking about? I think you beat me to it. > > -Original Message----- From: Alex Bowden > Sent: Monday, July 01, 2013 2:07 PM > To: General Discussion o

Re: [sqlite] Is there a way to return the row number? (NOTthe rowid)

e able to do what this > 'row' function. (e.g. MySQL). So, your point it moot. > >>> So, why make it sound like I don't know what I'm talking about? >> I think you beat me to it. > > No comment! > > -Original Message- From: Alex Bowden > Sent: Monday,

Re: [sqlite] Is there a way to return the row number? (NOTthe rowid)

The SQL standard has always been a moving feast, chasing the field implementations, perfectly capable of going back on it's earlier mistakes, the main purpose of which, on a good day, is to promote standardisation of SQL implementations and try and keep to the Relational Theory model where

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

> State why you don't > like it and move on. Don't contribute any code that might address the idea. > The rest? It is not useful. It is useful. It help stops people who don't understand the concept of relational, screwing up the system. You just disagree with that. On 7 Jul 2013, at 22:24,