RE: [sqlite] Appropriate uses for SQLite

Yes, John, thanks very much. It seems absolutely clear by now that sharing data on a network mount by multiple web servers is not suitable for SQLite. Funny, now that I say that I wonder how I couldn't see that from the beginning this was a worst case scenario. I guess I didn't know much about

Re: [sqlite] BNF for sqlite3?

You might look at the Sqlite source and how it uses the Lemon parser. WB Stow wrote: Does anyone have a BNF file (http://en.wikipedia.org/wiki/Backus-Naur_form) for SQLite3? I want to generate a parser with it. If not, I guess I can start with the SQL92 BNF that I have and add the sqlite3

Re: [sqlite] Appropriate uses for SQLite

We used Sqlite in a web server successfully. It is embedded in a custom written web server which provides multithreaded access and application language support (an application server). It handles many databases, with each user capable of having their own database. Synchronization is

[sqlite] BNF for sqlite3?

Does anyone have a BNF file (http://en.wikipedia.org/wiki/Backus-Naur_form) for SQLite3? I want to generate a parser with it. If not, I guess I can start with the SQL92 BNF that I have and add the sqlite3 stuff to it... Thanks, Wayne Bloss

RE: [sqlite] Appropriate uses for SQLite

I have certainly got no desire to change the design goals of SQLite. The only reason I posted originally is because there was a strong recommendation in the documentation to use it for web sites which of course risk concurrent writes... The trouble introduced there in my case is that I am using

[sqlite] RE: SQLite Extension DLL with MSVC

Sorry, nevermind. I used the Arke Systems sqlite3 dll MSVC project/source as a starting point to make a compatible extensions dll. - Wayne Bloss -Original Message- From: WB Stow [mailto:[EMAIL PROTECTED] Sent: Sunday, February 04, 2007 4:04 PM To: 'sqlite-users@sqlite.org' Subject:

[sqlite] SQLite Extension DLL with MSVC

Does anyone have an example extension library that was built with MSVC (any version)? I have tried to build one, but when I call sqlite3_load_extension(), even though I get no errors, it's not working correctly... Thanks, Wayne B

Re: [sqlite] two process problem

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > On 2/3/07, Tom Shaw <[EMAIL PROTECTED]> wrote: > > SQLSTATE[HY000]: General error: 1 SQL logic error or missing database > > and > > SQLSTATE[HY000]: General error: 8 attempt to write a readonly database > > Tom what wrapper are you using to access

Re: [sqlite] two process problem

On 2/3/07, Tom Shaw <[EMAIL PROTECTED]> wrote: SQLSTATE[HY000]: General error: 1 SQL logic error or missing database and SQLSTATE[HY000]: General error: 8 attempt to write a readonly database Tom what wrapper are you using to access sqlite? These messages are not from sqlite itself, but

Re: [sqlite] sqlite / gac

Thanks. I found some info there and asked a couple questions myself. On Sun, Feb 04, 2007 at 08:41:37AM -0700, Robert Simpson wrote: > http://sqlite.phxsoftware.com is the site where I develop and maintain the > SQLite ADO.NET 2.0 wrapper. The project is 2 years old and is pretty > mature.

RE: [sqlite] sqlite / gac

http://sqlite.phxsoftware.com is the site where I develop and maintain the SQLite ADO.NET 2.0 wrapper. The project is 2 years old and is pretty mature. You'll find the forums pretty informative and I try and answer every question there fairly quickly. Robert Simpson > -Original

Re: [sqlite] sqlite / gac

It looks to be, yes (I haven't used that particular piece of kit, but from the page, it seems it will fit the bill nicely.) Ian On 2/4/07, Andrew <[EMAIL PROTECTED]> wrote: Hi Ian. Thanks for the info. P/Invoke is unsafe in the C# / common language infrastructure sense. Anything unmanaged

Re: [sqlite] sqlite / gac

Hi Ian. Thanks for the info. P/Invoke is unsafe in the C# / common language infrastructure sense. Anything unmanaged is unsafe. I had been planning to use the System.Data.SQLite implementation from http://sourceforge.net/projects/sqlite-dotnet2 . After I wrote the first email to this list, I

Re: [sqlite] UNIQUE constraint on column

"A. Pagaltzis" <[EMAIL PROTECTED]> wrote: > It's a pity that INSERT OR IGNORE (apparently?) does not set > last_insert_id properly regardless of outcome, Consider this case: CREATE TABLE t1(x INTEGER PRIMARY KEY, y UNIQUE, z UNIQUE); INSERT INTO t1 VALUES(1,'a','b'); INSERT INTO t1

Re: [sqlite] sqlite / gac

On 2/4/07, Andrew <[EMAIL PROTECTED]> wrote: Hi.. I'm writing a small application for my personal use and would like to try SQLite. I have a few basic questions that I didn't see answers for at sqlite.org and am hoping that someone on this list can help. First, I'd like to get SQLite

[sqlite] sqlite / gac

Hi.. I'm writing a small application for my personal use and would like to try SQLite. I have a few basic questions that I didn't see answers for at sqlite.org and am hoping that someone on this list can help. First, I'd like to get SQLite installed in the global assembly cache (for use on my