AW: [sqlite] sqlite shared-cache mode usage

2006-08-28 Thread Marc Ruff
Hi everybody, I am in the same situation, wondering if two or more processes can access the database if one of them is in shared-cache mode, e.g. one process act as in test_server.c serving multiple clients, another process reads/writes the database through the ODBC driver of C. Werner. Thanks

[sqlite] Connect to SQLite Through C Program

2006-08-28 Thread Tikky
Hi , I am struggling to connect SQLite database through C program. I got some code from the SQLite.org, when ever i tried to compile that c code it showing error like " Unable to include sqlite.h file". Please refer me solution. Could you refer any website for the code. Plz Reply me [EMAIL

[sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

2006-08-28 Thread Tikky
Hi, I am also one of SQLilte User. I am struggling to compile c code for sqlite. If you don't mind , please send me c code to compile. i am waiting for ur reply. thanks [EMAIL PROTECTED] wrote: > > Thanks for your fast response. > Now I can compile and test program works > fine, but. >

Re: [sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

2006-08-28 Thread davep
Try providing a -I directive followed by the path to the include files. > > Hi, > I am also one of SQLilte User. I am struggling to compile c code for > sqlite. > If you don't mind , please send me c code to compile. > i am waiting for ur reply. > thanks >

[sqlite] how to create database in sqlite prompt

2006-08-28 Thread Tikky
Hi, unable to create database in sqlite prompt. Can U provide any specific command. Thanks. -- View this message in context: http://www.nabble.com/how-to-create-database-in-sqlite-prompt-tf2176202.html#a6016984 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] Connect to SQLite Through C Program

2006-08-28 Thread Martin Jenkins
Tikky wrote: Hi , I am struggling to connect SQLite database through C program. I got some code from the SQLite.org, when ever i tried to compile that c code it showing error like " Unable to include sqlite.h file". Please refer me solution. This is an FAQ: sqlite.h and sqlite3.h are generated

Re: [sqlite] how to create database in sqlite prompt

2006-08-28 Thread Martin Jenkins
Tikky wrote: Hi, unable to create database in sqlite prompt. Can U provide any specific command. See http://www.sqlite.org/sqlite.html Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] how to create database in sqlite prompt

2006-08-28 Thread P Kishor
On 8/28/06, Tikky <[EMAIL PROTECTED]> wrote: Hi, unable to create database in sqlite prompt. Can U provide any specific command. You don't create a database at the sqlite prompt. You create it at your OS prompt, and then you create your tables at the sqlite prompt. % sqlite3 mydb ..

[sqlite] Why I can't connect CVS repository?

2006-08-28 Thread xin.ye
Hi, In order to download the sqlite3.3.5, I installed wincvs client and configure the preferences according to the instruction. But when logging in, after I input the passward(anonymous), connection failed and showed something like "the server refused connection actively"... What's wrong?

RE: [sqlite] Re: R: Re: [sqlite] How to compile sqlite3 C sample code

2006-08-28 Thread Lodewijk Duymaer van Twist
Hi, How about downloading the sample code from www.apress.com http://www.apress.com/book/supplementDownload.html?bID=10130=3537 Nice book, try getting it. Kind regards, Lodewijk -Original Message- From: Tikky [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 2:18 AM To:

Re: [sqlite] Why I can't connect CVS repository?

2006-08-28 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: > Where else can I get the sqlite version 3.3.5(and the version should > support to be compiled under linux)? Can't help with your CVS problem, but you should find the source you want at this link - http://www.sqlite.org/sqlite-3.3.5.tar.gz Martin

[sqlite] Performance Question

2006-08-28 Thread Slater, Chad
Hello, Consider the following lookup table definition: CREATE TABLE foobar ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, table1_id INTEGER NOT NULL REFERENCES table1, table2_id INTEGER NOT NULL REFERENCES table2 ); The id primary key column is not necessary for anything in my

Re: [sqlite] Performance Question

2006-08-28 Thread drh
"Slater, Chad" <[EMAIL PROTECTED]> wrote: > Hello, > > Consider the following lookup table definition: > > CREATE TABLE foobar ( > id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, > table1_id INTEGER NOT NULL REFERENCES table1, > table2_id INTEGER NOT NULL REFERENCES table2 > ); > >

Re: [sqlite] sqlite shared-cache mode usage

2006-08-28 Thread drh
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > Good morning all, > > I'm in the design stage of a project and had a question about sqlite > shared-cache mode. > The new version of firefox will use mozStorage, which is based on > sqlite using shared-cache mode. I want other programs to be able >

Re: [sqlite] Performance Question

2006-08-28 Thread Kurt Welgehausen
[EMAIL PROTECTED] wrote: > Saying NOT NULL on a PRIMARY KEY is redundant, by the way. > -- > D. Richard Hipp <[EMAIL PROTECTED]> **kaw<~/tdpsa>$ sqlite3 Loading resources from /home/kaw/.sqliterc SQLite version 3.3.7 Enter ".help" for instructions sqlite> .nullvalue '<>' sqlite> create table

Re: [sqlite] Performance Question

2006-08-28 Thread Derrell . Lipman
Kurt Welgehausen <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: > >> Saying NOT NULL on a PRIMARY KEY is redundant, by the way. >> -- >> D. Richard Hipp <[EMAIL PROTECTED]> > > **kaw<~/tdpsa>$ sqlite3 > Loading resources from /home/kaw/.sqliterc > SQLite version 3.3.7 > Enter ".help"

Re: [sqlite] sqlite shared-cache mode usage

2006-08-28 Thread drh
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 8/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Let me emphasize that everything in the previous paragraph is > > hearsay and supposition and could be wildly incorrect. > > Thanks Dr.H. > > I hope it's not true. If it's true It really

Re: [sqlite] sqlite shared-cache mode usage

2006-08-28 Thread Jay Sprenkle
The problem is that they have to work on broken operating systems. I don't know of another way to patch around the problem. Do you? nope. If it breaks because of something you did, then YOU are the bum. If it's broken because of the operating system THEY are the bums.

Re: [sqlite] sqlite shared-cache mode usage

2006-08-28 Thread John Stanton
Jay Sprenkle wrote: The problem is that they have to work on broken operating systems. I don't know of another way to patch around the problem. Do you? nope. If it breaks because of something you did, then YOU are the bum. If it's broken because of the operating system THEY are the bums.

Re: [sqlite] sqlite shared-cache mode usage

2006-08-28 Thread Ritesh Kapoor
Can you - DRH or someone else provide some more background information on why locking dosen't work on NFS mounted file systems. If its a known issue then is there an SQLite compile time option that would remove locking - i couldn't find one. When I got stuck with this problem I had to remove all