Sandhya,

You use Sqlite the same way you use a file in your application. You link in the runtime library containing the file handling API when you create your executable. Sqlite gives an embedded application the capability of using SQL for data management.

If you are building a client server model you might want to look at using something like PostgreSQL or Mysql which are DBMS servers. There is no Sqlite server.

Sqlite is used as an embedded DBMS in programs such as the Firefox browser, LCC IDE and similar.

sandhya wrote:
You link Sqlite into your application...May i know what it mean?
Please explain me.
Also you wanna want to say that we shouldn't use this in Client /Server
applications.Like,Connecting to the Sqlite server through the application
and performing all the operations through(application) it and updating the
server.
Really i am totally confused with this.......If you don't mind can you just
explain me where we can use this SQLITE.pls

Thank you,
Sandhya



----- Original Message ----- From: "John Stanton" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, July 19, 2006 5:10 PM
Subject: Re: [sqlite] reg:sqlite usage



Sandhya,

You have not grasped the concept of Sqlite.  It is a RDBMS LIBRARY, not
a server.  You link Sqlite into your application.  As Dr Hipp points out
it it an alternative to fopen, not Oracle.

sandhya wrote:

Hi,
 I am very new to SQLITE.I have downloaded and installed Sqlite 3 in my
windows system.I built lib and dll too.
I tried the sample given in the documetation.The connection info i have
given the DB name, the table name and the query.But the database name

what

ever i am giving it is getting stored in my current application.Will it

be

like that.
Is there any interface to see the tables i have created in using the

sample

given there?
Where can i manually enter the queries?
Can i perform Client-server application kind of a thing.
I mean,With the available API , i will be writing the coding and which

will

perform all the operations mentined like creating table,DB,inserting etc
etc.Which should update in server directly.If i want to do so.....Where

i

need to mention the IP of my server.
Please guide me how to proceed for Client/Server kind of applications.

Thank you.
Regards
Sandhya R








Reply via email to