With the pending 3.0, I think we are at a juncture so to speak. We all like/use SQLite because it is very lightweight, fast, and above all simple. One of the major reasons this is so, is due to the very limited and focused functionality. Once SQLite becomes more "functional" all of these appealing aspects will begin to fade away. There is a very good set of reasons why Oracle, SQL Server, and even MySQL are what they are and SQLite is what it is.
As users we must decide what it is we expect from SQLite and what "other" DB's might offer given our environment. We don't haul several hundred concrete blocks in a sports car (Well, some try to) that's what trucks are for. I'm not saying there is no room for improvement in SQLite's functionality, but I feel things need to be kept in perspective. There truly are times when a hammer simply will not drive a screw, and should not be attempted. Your results may vary... Fred > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 06, 2004 8:26 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [sqlite] vers 3.0 concurrency issues > > > > I would like to use SQLite on a web server or .net remoting and > multi-user/threads may become an issue > as locking is based at the finest granularity of file locking instead of > table/page/row locking. Will this issue be resolved from 3.x > onwards so that > concurrency can be increased when multiple users > are connecting to the db? > SQLite is extremely fast in single process/thread mode and because of this > success, more users would like to access the application. File locking is > too similar to MS Access and we have had all kinds of problems > supporting multiple users on a network drive. Ideally I would > first like to > implement SQLite as part of an ISAPI dll so it could be accessed > using http > to an IIS web server. > Any suggestions or solutions to running SQLite in multi-threaded > environment > with potentially high concurrency??? > B.Thomas > > -----Original Message----- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 04, 2004 1:56 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] release 14 > > > aducom wrote: > > Hi, > > > > Is it possible to do a release 14 of the sqlite.dll with the support of > > real blobs? (It's available in cvs?) Or will I have to wait for the > > full new version? > > > > I don't know what you mean by "support for real blobs". You'll need > to be much more specific. > > Generally speaking, no new features will be added to SQLite 2.8.13. > What you see is what you get. New features go into SQLite 3.0.0. > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > ------------------------------------------------------------ > This e-mail may be privileged and/or confidential, and the sender > does not waive any related rights and obligations. Any > distribution, use or copying of this e-mail or the information it > contains by other than an intended recipient is unauthorized. If > you received this e-mail in error, please advise me (by return > e-mail or otherwise) immediately. > > Ce courrier électronique est confidentiel et protégé. > L'expéditeur ne renonce pas aux droits et obligations qui s'y > rapportent. Toute diffusion, utilisation ou copie de ce message > ou des renseignements qu'il contient par une personne autre que > le (les) destinataire(s) désigné(s) est interdite. Si vous > recevez ce courrier électronique par erreur, veuillez m'en aviser > immédiatement, par retour de courrier électronique ou par un autre moyen. > > ============================================================ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
