Re: [sqlite] Tracing Statements...

2006-02-11 Thread Tim Murison
On Sat, 2006-02-11 at 01:19 -0800, Nathaniel Smith wrote: > On Sat, Feb 11, 2006 at 03:37:11AM -0500, Tim Murison wrote: > > I would like to be able to generate a log of all sql statements executed > > by my program. > > > > Unfortunately all of my queries use parameters, and I would like to get

Re: [sqlite] Book?

2006-02-11 Thread Xavier Noria
On Feb 11, 2006, at 17:59, Clint Bailey wrote: Hi, Is there any know book in print for sqlite that is included in PHP5? I just finished "SQLite" http://www.bookpool.com/sm/067232685X and has helped me a lot, then the deltas in the web site helps to stay in sync with 3.x. I saw in

[sqlite] Book?

2006-02-11 Thread Clint Bailey
Hi, Is there any know book in print for sqlite that is included in PHP5?

[sqlite] Re: [Monotone-devel] [sqlite] disk locality (and delta storage)

2006-02-11 Thread drh
Daniel Carosone <[EMAIL PROTECTED]> wrote: > > > Just type (for example): > > > >monotone httpserver & > > > > and then point your webbrowser at 127.0.0.1. > > My personal favourite is jetty in Java for this kind of thing; I'm not > sure monotone itself should grow a http server :) The

[sqlite] Help with multiple join

2006-02-11 Thread Lloyd Thomas
As you can tell I am no sql guru. Is there anyway I could do the following without 'group by'. query: SELECT C.call_id, C.extn_no, C.dest, U.group_name FROM call_data AS C, grp_user AS G, user_grp AS U LEFT JOIN user_grp ON G.group_id = U.group_id LEFT JOIN grp_user ON C.extn_no = G.extn_no

[sqlite] Re: [Monotone-devel] [sqlite] disk locality (and delta storage)

2006-02-11 Thread Nathaniel Smith
On Fri, Feb 10, 2006 at 07:06:27PM -0500, [EMAIL PROTECTED] wrote: > Daniel Carosone <[EMAIL PROTECTED]> wrote: > > Wiki pages doesn't seem so hard, they're pretty much text documents > > stored in a VCS anyway. > > There are some complications. Each wiki page acts if it where > its own

[sqlite] Re: [Monotone-devel] Re: [sqlite] disk locality (and delta storage)

2006-02-11 Thread Nathaniel Smith
Thanks for this detailed email! I've been a bit crazy with codecon the last week, and most of what I have to say is "hmm, lots to think about here", so, yeah :-). I did want to reply to your VCS system comments, though: On Tue, Feb 07, 2006 at 10:17:54AM -0500, [EMAIL PROTECTED] wrote: > What

Re: [sqlite] Re: Database Disk Full

2006-02-11 Thread John Stanton
The first message informs all users of the problem. The one you propose might satisfy a technonerd, but confuse the more casual user. There is however a case for writing such a detailed message to syslog or similar system log. Dave Dyer wrote: It is a reasonable assumption to make that the

Re: [sqlite] Tracing Statements...

2006-02-11 Thread Nathaniel Smith
On Sat, Feb 11, 2006 at 03:37:11AM -0500, Tim Murison wrote: > I would like to be able to generate a log of all sql statements executed > by my program. > > Unfortunately all of my queries use parameters, and I would like to get > the full query (all parameters replaced with their sqlite3_bind_*

[sqlite] Tracing Statements...

2006-02-11 Thread Tim Murison
Hi, I would like to be able to generate a log of all sql statements executed by my program. Unfortunately all of my queries use parameters, and I would like to get the full query (all parameters replaced with their sqlite3_bind_* values). Any ideas? Cheers, -Tim