Re: [sqlite] How to determine player's leaderboard rank efficiently?

> > > Regarding: > > WITH RECURSIVE >x(y) AS (VALUES(1) UNION ALL SELECT y+1 FROM x WHERE y<1000) > INSERT INTO player SELECT printf('Player%d',i), i, random(), NULL FROM x; > > > If anyone's "playing along at home" I wondered if instead of: ... printf('Player%d',i), i,

Re: [sqlite] Edinburgh Buses

On 8/26/2014 5:39 PM, Errol Emden wrote: I have taken a different approach to the solution to this problem. Instead of paring the self-joins I have cross-joined the tables in pairs as follows: SELECT distinct R1.num, R1.company, S1.name, R2.num, R2.company FROM stops S1, stops S2, route R1,

Re: [sqlite] Edinburgh Buses

I have taken a different approach to the solution to this problem. Instead of paring the self-joins I have cross-joined the tables in pairs as follows: SELECT distinct R1.num, R1.company, S1.name, R2.num, R2.company FROM stops S1, stops S2, route R1, route R2 WHERE S1.name='Craiglockhart' AND

Re: [sqlite] SQLite wrapper for Swift

See also https://news.ycombinator.com/item?id=8226962 for discussion. On Tue, Aug 26, 2014 at 9:09 AM, Simon Slavin wrote: > A thin SQLite wrapper for Swift: > > > > Uses Swift variable types. You have to explicitly say what

Re: [sqlite] Curiosity question for an apparent change in Sqlite/timeline pattern

On Tue, Aug 26, 2014 at 12:58 PM, big stone wrote: > Hello, > > It seems to me that, all of a sudden, a LOT of micro-wins and bigger wins > are raining on the Sqlite/timeline > (since about august 1rst, the "in ()" improvement) > > Is it an effect of a new

Re: [sqlite] Window functions?

On 2014-08-26 18:00, sqlite-users-requ...@sqlite.org wrote: SELECT employee_name, employee_id, salary, rank() OVER(PARTITION BY dept ORDER BY salary DESC), 100.0*salary/sum(salary) OVER (PARTITION BY dept) FROM employee; I don't know if the above is valid SQL or not. But is

Re: [sqlite] Curiosity question for an apparent change in Sqlite/timeline pattern

On Tue, Aug 26, 2014 at 6:58 PM, big stone wrote: > (maybe I'm wrong and all is as speedy as usual) > Maybe this additional info will help: http://sqlite.org/src/reports?view=byweek http://sqlite.org/src/reports?view=bymonth -- - stephan beal

[sqlite] Curiosity question for an apparent change in Sqlite/timeline pattern

Hello, It seems to me that, all of a sudden, a LOT of micro-wins and bigger wins are raining on the Sqlite/timeline (since about august 1rst, the "in ()" improvement) Is it an effect of a new Compiling/Testing environnement ? of summer vaccation ? of partner's help ? (maybe I'm wrong and all is

Re: [sqlite] SQLite Database Browser v3.3.0 released

On 2014-08-25 17:04, Richard Hipp wrote: Thank you for creating this project.  I downloaded a copy.  It seems very nice. NOW, PLEASE CHANGE THE NAME!!! "SQLite" is a trademark.  You are welcomed and encouraged to use the code for SQLite, but not the name "SQLite". This is not just a legal

[sqlite] SQLite wrapper for Swift

A thin SQLite wrapper for Swift: Uses Swift variable types. You have to explicitly say what type you want your value as. Implements variable binding for security purposes. Implements a date class. I have not checked out how well it does this.

Re: [sqlite] Edinburgh Buses

Igor, thanks for a meaningful response. I am a neophyte at SQL, and learning it on my own. The graphical approach to a solution is another methodology I will be adding to my arsenal. The reason why I was checking both names against stop B is that my intent was to find the other route stops

Re: [sqlite] Window functions?

On 25.08.2014 20:47, Richard Hipp wrote: On Mon, Aug 25, 2014 at 1:21 PM, forkandwait wrote: You used the word "immense" which I like - it is an apt description of the knowledge and effort needed to add windowing functions to SQLite (and probably any other database

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 26, 2014 at 8:44 AM, 王庆刚 <2004wqg2...@163.com> wrote: > hi, Andy Ling: > The error disk I / o error I have resolved ; > but when I used the following code: > rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",); > it tell me can not find the data base; > Have you tried instead:

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

As I said before, that doesn’t look like a vxWorks path to a file. Are you sure D:\\WindRiver really exists? In general vxWorks uses the forward slash (/) as a path separator. Is this a remote mounted host file system you are trying to use? What is your current directory when it works the

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

hi, Andy Ling: The error disk I / o error I have resolved ; but when I used the following code: rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",); it tell me can not find the data base; when I used the following code: rc = sqlite3_open("SqliteOne.db",); It is OK How could I resolve the

Re: [sqlite] Window functions?

On Monday, August 25, 2014 09:25:47 PM Stephan Beal wrote: > On Mon, Aug 25, 2014 at 9:17 PM, Petite Abeille > > wrote: > > True. But what a quantum leap that would be. Like moving from the > > wheelbarrow to the jet engine. > > For the small percentage of users who

Re: [sqlite] Problem with recursive CTE

- Original Message - From: "Alek Paunov" To: "General Discussion of SQLite Database" Sent: Monday, August 25, 2014 4:04 PM Subject: Re: [sqlite] Problem with recursive CTE On 25.08.2014 15:42, Frank Millman wrote: I have upgraded to