Re: [sqlite] reg:sqlite usage

[A. Pagaltzis]

* sandhya <[EMAIL PROTECTED]> [2006-07-19 14:10]:
> 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.

Not “should” – you *cannot*, because there is no server. SQLite
is just a simple library. It does not connect to a server that
performs the database operations, but instead it manipulates the
file containing the database directly.

That part of the reason why it needs so few resources. It is also
why it is easy to use on embedded devices, and why it does not
require any configuration, user management or any of the other
complex administration that client-server databases require.

Regards,
-- 
Aristotle Pagaltzis // 

Re: [sqlite] reg:sqlite usage

[John Stanton]

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

Re: [sqlite] reg:sqlite usage

[sandhya]

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
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>
> >>>
> >
> >
>

Re: [sqlite] reg:sqlite usage

[John Stanton]

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

Re: [sqlite] reg:sqlite usage

[sandhya]

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
> >>>
> >>>
> >>>
> >>
> >
> >
> >
>

Re: [sqlite] reg:sqlite usage

[John Stanton]

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

Re: [sqlite] reg:sqlite usage

[sandhya]

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
> >
> >
> >
>

Re: [sqlite] reg:sqlite usage

[John Stanton]

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

[sqlite] reg:sqlite usage

[sandhya]

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