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