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

On 8 Jul 2013, at 5:51am, James K. Lowden wrote: > Your test doesn't show that the above *query* is inefficient, but that > SQLite executes it inefficiently. The query can be executed > efficiently; whether or not SQLite does so is a design choice. One problem with implementing a 'returned r

Re: [sqlite] SQLite3 extended API usage

On 8 Jul 2013, at 5:15am, techi eth wrote: > I am using SQLite3 version : 3.7.9. > > Do i need to configure with some option to get linkage problem get resolved. No. You just need to use version 3 API calls, not version 2 API calls. There is no call 'sqlite_get_table()' in SQLite version 3.

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

On Fri, 05 Jul 2013 02:19:08 +0200 Olaf Schmidt wrote: > Create Table T (ID Integer Primary Key, Item Text) > > Select Count(Lesser.ID), T.ID, T.Item From T As T > Left Outer Join T As Lesser > On T.ID > Lesser.ID > Group By T.ID > Order By T.ID > > I don't know,

Re: [sqlite] Another 2 questions about SQLite

On 7/8/2013 12:09 AM, James K. Lowden wrote: On Thu, 04 Jul 2013 16:08:38 -0400 Igor Tandetnik wrote: On 7/4/2013 3:15 PM, James K. Lowden wrote: This weird case is one of (I would say) misusing the connection. IMO SQLite should return an error if prepare is issued on a connection for which a

Re: [sqlite] UnQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/07/13 20:51, Nico Williams wrote: > QBE is nice and simple, but lacks expressive power. The Mongo query syntax with an example JSON object: { "a": 10, "b": {"c": 3}, "d": ["one", "two", "three"]} To find all a==10: {"a" : 10 } To find all

Re: [sqlite] Another 2 questions about SQLite

On 7/8/2013 12:09 AM, James K. Lowden wrote: In real life, programs are complex, and libraries are misused (intentionally or not). SQLite's job is to be a DBMS: to provide predictable, safe access to the database, defending against errors foreign and domestic (i.e. hardware errors, OS errors, *a

Re: [sqlite] SQLite3 extended API usage

Thanks. I am using SQLite3 version : 3.7.9. Do i need to configure with some option to get linkage problem get resolved. On Sat, Jul 6, 2013 at 1:34 PM, Luuk wrote: > On 06-07-2013 09:50, techi eth wrote: > >> Hi,When i try to use extended API like sqlite_get_table(), i am getting >> >> un

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

On Fri, 05 Jul 2013 12:38:37 +0200 Gabriel Corneanu wrote: > About complexity: I'm not sure it's NlogN; for each N you need to > count N-1 columns, that's N^2 IMO. You're right if the data aren't sorted. If the data are sorted, to *find* the largest value smaller than a given value is O(log N

Re: [sqlite] Another 2 questions about SQLite

On Thu, 04 Jul 2013 16:08:38 -0400 Igor Tandetnik wrote: > On 7/4/2013 3:15 PM, James K. Lowden wrote: > > This weird case is one of (I would say) misusing the connection. > > IMO SQLite should return an error if prepare is issued on a > > connection for which a previous prepare was not finalized

Re: [sqlite] Another 2 questions about SQLite

On Thu, 4 Jul 2013 20:36:10 +0100 Simon Slavin wrote: > On 4 Jul 2013, at 8:15pm, James K. Lowden > wrote: > > > It doesn't usually matter, right? The fact that the atomic SELECT > > is spread out across N function calls is irrelevant if they are > > executed in uninterrupted sequence, because

Re: [sqlite] UnQLite

On Sun, Jul 7, 2013 at 8:40 PM, Roger Binns wrote: > On 07/07/13 16:19, Simon Slavin wrote: > > > What has generally become important to me is being able to supply > arbitrary JSON as a "record", be able to query it, and get the same > arbitrary JSON back out. > > In addition

Re: [sqlite] UnQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/07/13 16:19, Simon Slavin wrote: > What has generally become important to me is being able to supply arbitrary JSON as a "record", be able to query it, and get the same arbitrary JSON back out. In addition to unqlite, some

[sqlite] UnQLite

Some of you might be interested in UnQLite: the description, and a great deal of the underlying technology, is close to SQLite except that the underlying language is not SQL. Please note that I’m posting here for those of you who are interested in databases /per se/. Argu

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

On Sun, Jul 7, 2013 at 3:31 PM, Alex Bowden wrote: > > 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 sys

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, Sc

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

On Sun, Jul 7, 2013 at 11:34 AM, Keith Medcalf wrote: > > Despite the long diatribes you have not indicated a single case in which > the set ordinal of the row would be of any use whatsoever. > > For 40 years we have gotten on without it, so yes, it is only for you > newbies that somehow think th

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

Despite the long diatribes you have not indicated a single case in which the set ordinal of the row would be of any use whatsoever. For 40 years we have gotten on without it, so yes, it is only for you newbies that somehow think there is a use for it, and for 40 years no one has ever come upon

Re: [sqlite] skype artifacts and sqlite records.

Salvatore Fiorillo wrote: > The issue I am facing is on how I can identificate a sqlite record if I > have miss the database headers? Did you read ? Regards, Clemens ___ sqlite-users mailing list sqlite-users@sql

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

Am 06.07.2013 18:58, schrieb j.merrill- There are reasons to want what is in other SQL implementations implemented with "row_number() OVER (ORDER BY ...)" but "disconnected Recordsets" or for data "passed across thread- or machine-boundaries" are definitely NOT valid reasons. Since they are se

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

Am 06.07.2013 19:25, schrieb Keith Medcalf: Date: Fri, 05 Jul 2013 02:04:04 +0200 From: Olaf Schmidt To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a way to return the row number? (NOT the rowid) Message-ID: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Am 03.07.