Re: [sqlite] SQLite as R data store

Andrew Piskorski wrote: As an R user, I'm happy to see the project below, it could become a very handy use of SQLite. I suspect it's well out of scope for that project, but it would be particularly cool to eventually see some of the integration go the other way, and allow use of SQLite's SQL

Re: [sqlite] Relative query cost

Thanks Marco, I'll take a look and if it compares well to may current favourite GUI http://www.kraslabs.com/sqlite_analyzer.php I'll be buying a copy! If you feel up to the challenge, perhaps you can convert the output of the explain statement into a graphical tool, SQL Server style. -- View th

Re: [sqlite] Relative query cost

Well... it doesn't give you the details you are asking, but please take a look at my SQLiteManager, I think it could be useful to you: http://www.sqlabs.net/sqlitemanager.php --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ On May 27, 2006, at 6:56 PM, Jay Sprenkle wrote:

Re: [sqlite] Relative query cost

On 5/27/06, Mikey C <[EMAIL PROTECTED]> wrote: Hi, Does anyone know of a tool that can use the output of the explain statement to produce something akin to: http://www.nldelphi.com/artimages/sqls38.jpg Which is what MS SQL Server gives. When developing queries it would be good to see how dif

[sqlite] Relative query cost

Hi, Does anyone know of a tool that can use the output of the explain statement to produce something akin to: http://www.nldelphi.com/artimages/sqls38.jpg Which is what MS SQL Server gives. When developing queries it would be good to see how different queries compare in terms of relative cost

Re: [sqlite] last_insert_rowid()

Mikey C <[EMAIL PROTECTED]> wrote: > Hi, > > Does last_insert_rowid() return the identity of the main insert or would it > return the id of a row inserted by a trigger if the main insert caused a 2nd > insert to occur on another table via a trigger? > Both. If last_insert_rowid() is called from

[sqlite] last_insert_rowid()

Hi, Does last_insert_rowid() return the identity of the main insert or would it return the id of a row inserted by a trigger if the main insert caused a 2nd insert to occur on another table via a trigger? SQL Server has a scope_identity() function to make sure you can get the original id regardl