Re: [sqlite] Yes - Getting SPAM from Using Mailing List

On 27-4-2018 20:57, Denis Burke wrote: > I know steps were taken to reduce it, but just confirming it is still going > on today. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] Broken DB?

http://www.sqlite.org/howtocorrupt.html 2018-04-27 23:58 GMT+02:00, Kevin O'Gorman: > I've got a working site, but I made a copy of the database in order to do > some development work. > I've hit a snag that looks like a problem in the data. > > Ive written a management command to show the

Re: [sqlite] Broken DB?

Oops. Wrong list. Should go to a Django group. I noticed as soon as I sent this. Please ignore. On Fri, Apr 27, 2018 at 2:58 PM, Kevin O'Gorman wrote: > I've got a working site, but I made a copy of the database in order to do > some development work. > I've hit a

[sqlite] Broken DB?

I've got a working site, but I made a copy of the database in order to do some development work. I've hit a snag that looks like a problem in the data. Ive written a management command to show the problem: from django.core.management.base import BaseCommand, CommandError # Stuff for the library

Re: [sqlite] File Locking

Looks right to me anyway. I'm under the impression that network share locking can be sketchy, but you did say "expected". -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Denis Burke Sent: Friday, April 27, 2018 2:52 PM To: SQLite

[sqlite] Yes - Getting SPAM from Using Mailing List

I know steps were taken to reduce it, but just confirming it is still going on today. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] File Locking

I have read the excellent page: https://www.sqlite.org/lockingv3.html I was hoping someone could clarify/confirm the behavior during the following steps. On a Windows PC, if I have a SQLite DB open (using system.data.sqlite if that is an important fact) over a Windows network share, here are the

Re: [sqlite] [sqlite-dev] Timeout Not Working for Me

I have never run into this issue myself. However, you do not specify the version or Platform (Windows , Linux (plus distribution), Other (Apple iOS, MVS, BSD, etc). Nor the version of CPython nor from whence it came (preloaded? version? Downloaded and installed yourself? Built

Re: [sqlite] Sqlite query to get the offset of an entry in the list.

How about SELECT ID,NAME, (SELECT COUNT(*) FROM TABLE WHERE NAME<=(SELECT NAME FROM TABLE WHERE ID=d.ID)) as Position FROM TABLE d ORDER BY ID; sqlite> create table t(ID,name text); sqlite> insert into t values (1,'AAA'),(2,'ZZZ'),(3,'BBB'),(4,'WWW'),(5,'CCC'); sqlite> select

Re: [sqlite] Sqlite query to get the offset of an entry in the list.

Again, requiring that both "id" and "name" are candidate keys. In which case, since there has to be unique indexes to enforce that, one might use the more straightforward: select count(*) from table where name <= (select name from table where id=?) order by name; --- The fact that there's

Re: [sqlite] Sqlite query to get the offset of an entry in the list.

The constraint, obviously, being that "id" and "name" are each candidate keys ... --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users-

Re: [sqlite] Sqlite query to get the offset of an entry in the list.

create table data (id integer primary key, name text); insert into data (name) values ('AAA'), ('ZZZ'), ('BBB'), ('WWW'), ('CCC'); select * from data; 1|AAA 2|ZZZ 3|BBB 4|WWW 5|CCC select * from data order by name; 1|AAA 3|BBB 5|CCC 4|WWW 2|ZZZ create table temp.ranked as select * from data

Re: [sqlite] Sqlite query to get the offset of an entry in the list.

SELECT COUNT(*)+1 FROM TABLE WHERE NAME < (SELECT NAME FROM TABLE WHERE ID = 3) (I think) From: sqlite-users on behalf of Hegde, Deepakakumar (D.) Sent: Friday, April 27, 2018 3:51:27

Re: [sqlite] Sqlite query to get the offset of an entry in the list.

On 27 April 2018 at 15:51, Hegde, Deepakakumar (D.) wrote: > Hi All, > > We have a requirement where in offset of the primary key ID is needed as per > the sorted list. . . . > 1 AAA > 3 BBB > 5 CCC > 4 WWW > 2 ZZZ > > So position of ID 3 as per the sorted

[sqlite] Sqlite query to get the offset of an entry in the list.

Hi All, We have a requirement where in offset of the primary key ID is needed as per the sorted list. Table: ID NAME 1 AAA 2 ZZZ 3 BBB 4 WWW 5 CCC Now need to get the offset of the ID 3 in the sorted list of the NAME. SELECT * FROM TABLE ORDER BY NAME ASC

Re: [sqlite] XOR operator

R Smith wrote > it would be nice to have > an XOR operator in the way that & and | work...  Is there any character > left to use, or one that are regularly used as XOR in other languages?  > The $ sign seems to be free, but it would be nice to conform to some > standard. Perhaps a combined