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