The way we use Sqlite in web applications is as part of the web server,
creating an application server. We wrote our own webserver and
application specific language processor and use Sqlite for storage.
Sqlite is a great component for such a project and means that one
multi-threaded process runs everything instead of having web servers,
cgi processes and DBMS servers linked by interprocess communication.
We also created CGI processes which perform web activities and which
have embedded Sqlite and XML.
Another way for you to use Sqlite is to use it embedded in something
like PHP (which comes supplied with embedded Sqlite) or to use a wrapper
around Sqlite for your favorite high level language. We don't use it
that way so others can give you better advice if you go that way.
sandhya wrote:
John,
If u don't mind can you please explain me is it possible if i load /store
any files as Large objects inside DB and open it via a webserver instead of
storing it in a local system and opening.In that case what i have to do.Like
my DB whether i should place in the Webserver applcaition and access it or
how can i do it?
----- Original Message -----
From: "John Stanton" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, July 19, 2006 6:04 PM
Subject: Re: [sqlite] reg:sqlite usage
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
