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