Sqlite is a wonderful tool. We use it with great success embedded in a custom application server for web applications, embedded in CGI processes and in some industrial process control applications. It is robust and very simple to use, and since it places all tables in one file, very easy to maintain.

sandhya wrote:
ya..Thank you ver much John.Right now i am using Postgresql only.But just i
want to find out the information abt Sqlite as i heard that it is having
very small footprint and its good for Embedded systems app.....
Now i got it,Thanks a lot.

-Sandhya

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



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