I second this notion. I think SQLite is uniquely suited to server based applications of all kinds. Its light footprint and the fact that it's a library rather than a full system gives it a flexibility and raw performance that other systems cannot. We use it at the core of each node in a distributed and parallel system.
When using SQLite the architecture of your database system is not preordained by designers who could not foresee novel designs and approaches. SQLite is like a systems programing language: It's lean and mean and a powerful tool that gives full control to the systems designer and programmer. The only thing I'd change about SQLite is the SQL bit. To me it's an anachronism and a mess and needs to be factored further out of the SQLite core, with a more rigorous formalism providing an interface (with an exposed and supported API) to the database engine, but at a higher level than say the virtual machine. On Wed, Feb 18, 2015 at 9:12 AM, Marcus Grimm <mgrimm at medcom-online.de> wrote: > We use sqlite as the db engine inside a server application > with a number of clients that connect to the server. > Sqlite works just beatiful here and I wish these statements > "sqlite shall not be used for client/server things" would be > worded less generally. In fact when we mention sqlite as our > db engine customer point to this restriction and we run into > an excuse sort of arguments. > On the bottom line: Sqlite CAN very well serve as the DB > engine for client/server applications, it just depend how > the api is used. > > Marcus > > Am 2015-02-18 15:34, schrieb Richard Hipp: > >> In a feeble effort to do "marketing", I have revised the "Appropriate >> Uses For SQLite" webpage to move trendy buzzwords like "Internet of >> Things" and "Edge of the Network" above the break. See: >> >> https://www.sqlite.org/whentouse.html >> >> Please be my "focus group", and provide feedback, comments, >> suggestions, and/or criticism about the revised document. Send your >> remarks back to this mailing list, or directly to me at the email in >> the signature. >> >> Thank you for your help. >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
