[sqlite] uSQLite, doing HTTP

2005-11-16 Thread roger
HTTP started with the idea that it would be possible to connect via HTTP, for tunneling purposes. I have been looking at the links and suggestions and have reached the following conclusions:- 1) Adding general purpose web server capabilities in uSQL would be a mistake. The purpose is to add

[sqlite] SQL syntax possibilities

2005-11-16 Thread roger
uSQLite does not (generally) enter into the details of the query it is passed. There is however an exception for security. uSQLite requires a login and (depending on the user and network) assigns the user a level: 0: No access 1: Select only 2: Update/Insert only 3: Select/Update/Insert only 4:

Re: [sqlite] SQL syntax possibilities

2005-11-16 Thread Eric Bohlman
[EMAIL PROTECTED] wrote: uSQLite does not (generally) enter into the details of the query it is passed. There is however an exception for security. uSQLite requires a login and (depending on the user and network) assigns the user a level: 0: No access 1: Select only 2: Update/Insert only 3:

RE: [sqlite] SQL syntax possibilities

2005-11-16 Thread roger
> Original Message > Subject: Re: [sqlite] SQL syntax possibilities > From: Eric Bohlman <[EMAIL PROTECTED]> > Date: Wed, November 16, 2005 10:54 am > To: sqlite-users@sqlite.org > > [EMAIL PROTECTED] wrote: > > uSQLite does not (generally) enter into the details of the query

Re: [sqlite] optimizing out function calls

2005-11-16 Thread Robin Breathe
Nathan Kurz wrote: > I'm using a computationally expensive user defined function called > 'match()'. In case it makes a difference, match() is written in C, > and for testing, I'm loading it as a shared library into the sqlite3 > shell application. I want to return the value of match(), and also

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

2005-11-16 Thread Florian Weimer
* D. Richard Hipp: > If an error occurs in a step function, record that fact in > the aggregate context. Then when the finalizer is called, > check the error flag in the context and call sqlite3_result_error > at that point if it is appropriate to do so. Does this really work? According to my

[sqlite] How dangerous is PRAGMA Synchronous OFF?

2005-11-16 Thread Dinsmore, Jeff
I have a little engine doing HL7 messaging using SQLite3 from Tcl (Windows Server 2003 with a local attached RAID 5 for database). I'm looking for some speed improvements, so yesterday I experimented with PRAGMA synchronous = OFF. Holy Cats - it's WAAAY faster - like night and day. So, I'd like

RE: [sqlite] uSQLiteServer Source code available

2005-11-16 Thread Doug Nebeker
I'd be interested in seeing that code--there's always something to be learned from another implementation. For those interested, I've put my code up at: http://www.poweradmin.com/sourcecode/index.asp (HTTPServer.zip--you'll see it) I welcome any feedback. Probably better to send it to my

RE: [sqlite] uSQLiteServer Source code available

2005-11-16 Thread Eduardo
At 15:52 16/11/2005, you wrote: I'd be interested in seeing that code--there's always something to be learned from another implementation. For those interested, I've put my code up at: http://www.poweradmin.com/sourcecode/index.asp (HTTPServer.zip--you'll see it) I welcome any feedback.

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

2005-11-16 Thread Florian Weimer
* Nathan Kurz: > On Wed, Nov 16, 2005 at 01:16:40PM +0100, Florian Weimer wrote: >> * D. Richard Hipp: >> >> > If an error occurs in a step function, record that fact in >> > the aggregate context. Then when the finalizer is called, >> > check the error flag in the context and call

Re: [sqlite] SQL syntax possibilities

2005-11-16 Thread Darren Duncan
At 1:34 AM -0700 11/16/05, [EMAIL PROTECTED] wrote: uSQLite does not (generally) enter into the details of the query it is passed. There is however an exception for security. uSQLite requires a login and (depending on the user and network) assigns the user a level: 0: No access 1: Select only

RE: [sqlite] SQL syntax possibilities

2005-11-16 Thread roger
> Original Message > Subject: Re: [sqlite] SQL syntax possibilities > From: Darren Duncan <[EMAIL PROTECTED]> > Date: Wed, November 16, 2005 10:41 pm > To: sqlite-users@sqlite.org > > At 1:34 AM -0700 11/16/05, [EMAIL PROTECTED] wrote: > >uSQLite does not (generally) enter

Re: [sqlite] uSQLiteServer Source code available

2005-11-16 Thread Joe Wilson
Is the source available for this nano web server? --- [EMAIL PROTECTED] wrote: > FWIW, the www.sqlite.org website is implemented using a > webserver written as a single file of C code - 752 lines > (exclusive of comments). It's unix-specific though, and > in fact really wants to run on Linux. >

Re: [sqlite] uSQLiteServer Source code available

2005-11-16 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > Is the source available for this nano web server? > > --- [EMAIL PROTECTED] wrote: > > FWIW, the www.sqlite.org website is implemented using a > > webserver written as a single file of C code - 752 lines > > (exclusive of comments). It's unix-specific

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

2005-11-16 Thread Preston Z
If the power never goes out and no programs ever crash on you system then Synchronous = OFF is for you, but the rest of the world might still want it ON. Really it sounds like the thing you need to worry about most is the unexpected termination of your program. If you aren't worried about

Re: [sqlite] How dangerous is PRAGMA Synchronous OFF?

2005-11-16 Thread drh
"Preston Z" <[EMAIL PROTECTED]> wrote: > If the power never goes out and no programs ever crash on you system then > Synchronous = OFF is for you, but the rest of the world might still want it > ON. Minor clarification: Program crashes will not cause data corruption with synchronous=off. But

RE: [sqlite] uSQLiteServer Source code available

2005-11-16 Thread johns
Roger, I am on the road at the moment, but will be home in a week and can give you the essence of a very simple HTTP server and client, with socket interface for Unix and Win32. In an embedded world you only need it simple. JS Quoting [EMAIL PROTECTED]: > > > > > > HTTP is just a