Tim, I, like you, am using SQLite as the DB to a web server. But I have to agree with Roger. I do so from the prospective that web client cannot make native calls to SQLite. Thus the web server is the client. Further more I would say that in all web server based solutions, the web server is the DB client.
With fully integrated solutions like ASP.Net and MS SQL Server, a lot of the connection stuff is automatically handled by the vender (Microsoft) so that application developers like you and me don't have to mess with it. But when we move to the world of open source, we have to deal with some plumbing. Not high on my list of things I like to do, but it has to be done:( Sam On Sat, Jul 24, 2010 at 7:42 AM, Tim Romano <[email protected]> wrote: > Roger, > It would be more accurate to say that SQL is a library which *can* live > inside an application. Whether it actually does live inside it will depend > on how one is using SQLite. When it is used as a "back-end" reached via > middleware, such as the ADO.NET driver, SQLite does not live inside the > client application. Quite a few users of SQLite these days are not > wrapping > the SQLite libraries in their own client app but are communicating with the > database via a bridge as if it were a remote server engine. > > The reason I bring this up is that your replies are sometimes colored by > the assumption that one is using SQLite in library-mode, which may not be > the case. Your opposition to my request several months ago for a raw > reverse > function was colored in this way. You did not acknowledge at the time that > a > raw-reversed (and hence possibly malformed) sequence of unicode codepoints > could give middleware the hiccups, and insisted that it this reversal be > done "in the application". > > Regards > Tim Romano > Swarthmore PA > > > > On Fri, Jul 23, 2010 at 11:19 PM, Roger Binns <[email protected]> > wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > > > Remember that SQLite is a library - it lives inside your application - > and > > is not some remote unchangeable component. > > > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
