[sqlite] ANN: SQLite Maestro 11.3 released

2011-03-14 Thread SQL Maestro Group
Hi! SQL Maestro Group announces the release of SQLite Maestro 11.3, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ New features = 1. SQLite Maestro has been

Re: [sqlite] Optimization SQLite

2011-03-14 Thread Richard Hipp
Email forwarded to the sqlite-users mailing list. I use gcc and gdb and plain old text editor. I am not able to recommend an IDE since I don't use one. On Mon, Mar 14, 2011 at 11:16 AM, Thiago Gregolon thiagogrego...@gmail.comwrote: Good morning, My name is Thiago from UDESC - Universidade

Re: [sqlite] Optimization SQLite

2011-03-14 Thread Black, Michael (IS)
Try CodeBlocks Cross-platform and works with gcc or MSVC or pretty much whatever. I put in gcc 64-bit for it. http://www.codeblocks.org/ Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From:

[sqlite] X most recent entries

2011-03-14 Thread Ian Hardingham
Hey guys. I have a table with an autoincrement primary ID, and as part of a select I would like to only take the 5000 largest/most recent ids. Is there a quick way of doing this without having to get the max first? Thanks, Ian ___ sqlite-users

Re: [sqlite] X most recent entries

2011-03-14 Thread Adam DeVita
select id from table order by id desc limit 5000 Adam On Mon, Mar 14, 2011 at 1:52 PM, Ian Hardingham i...@omroth.com wrote: Hey guys. I have a table with an autoincrement primary ID, and as part of a select I would like to only take the 5000 largest/most recent ids. Is there a quick way

Re: [sqlite] X most recent entries

2011-03-14 Thread Ian Hardingham
Ah, sorry about this - my query is this one: SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM multiturnTable WHERE player2 = '?') AND (complete=0 OR p1SubmitScore=0 OR p2SubmitScore=0) And I only want to consider the

Re: [sqlite] X most recent entries

2011-03-14 Thread Duquette, William H (318K)
Assuming that higher rowids really are later rowids, wouldn't adding ORDER BY rowid DESC and LIMIT 5000 do the job? Will On 3/14/11 10:58 AM, Ian Hardingham i...@omroth.com wrote: Ah, sorry about this - my query is this one: SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM

Re: [sqlite] X most recent entries

2011-03-14 Thread Adam DeVita
Are you wanting the last 5000 from player 1 and last 5000 from player 2? You can even limit and order the sub selects. Otherwise, I don't see the purpose of a union when OR would do. SELECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM multiturnTable WHERE player1 ='?' order by

Re: [sqlite] X most recent entries

2011-03-14 Thread Pavel Ivanov
Try this one: select * from (select * from multiturnTable order by rowid desc limit 5000) where (player1 = ? or player2 = ?) and (complete=0 or p1SubmitScore=0 or p2SubmitScore=0) Pavel On Mon, Mar 14, 2011 at 1:58 PM, Ian Hardingham i...@omroth.com wrote: Ah, sorry about this - my query is

[sqlite] BUG: mutex_w32.c; diagnostic message needs to be clearer

2011-03-14 Thread Noah Hart
In the routine winMutexTry at line 284 -printf(enter mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef); +printf(try mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef); -- View this message in context:

Re: [sqlite] BUG: mutex_w32.c; diagnostic message needs to be clearer

2011-03-14 Thread Shane Harrelson
I updated the debug statement here: http://www.sqlite.org/src/info/def98fd23e Thanks for the report. -Shane On Mon, Mar 14, 2011 at 7:54 PM, Noah Hart n...@lipmantpa.com wrote: In the routine winMutexTry at line 284 -    printf(enter mutex %p (%d) with nRef=%d\n, p, p-trace, p-nRef); +