<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Yup, that was a mis-paste.<span class="Apple-style-span" style="color: rgb(84, 0, 0); "></span><div><font class="Apple-style-span" color="#540000"><br></font></div><div><span class="Apple-style-span" style="color: rgb(84, 0, 0); "><a href="http://opensimulator.org/wiki/Configuration">http://opensimulator.org/wiki/Configuration</a></span><div><div><div><br></div><div>I think the key to you statement is "multi-user". SQLite has no concept of user account, but supports multiple access. It the current configuration, no 2 users access the database. One user, the front end application may have multiple access, but never 2 users.</div><div><br></div><div>Anyway, you are right that it is limited in size, only supporting terabyte size databases and gigabyte size strings and blobs ( <a href="http://www.sqlite.org/features.html">http://www.sqlite.org/features.html</a> ) , but I put to you that these limitations may not be draw backs for most opensim admins.</div><div><br></div><div>Thanks so much for the twit link, I really enjoyed listening to it!</div><div><br></div><div>On Dec 5, 2008, at 11:48 AM, Justin Clark-Casey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Generic Email wrote:<br><blockquote type="cite">This is a bit of a soap box, so if your are easily offended or annoyed, <br></blockquote><blockquote type="cite">just pass by, there is nothing to see here.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I see in the OpenSim world the assertion that SQLite is not production <br></blockquote><blockquote type="cite">worthy often. Most recently here:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://opensimulator.org/wiki/Upgrading">http://opensimulator.org/wiki/Upgrading</a><br></blockquote></blockquote><blockquote type="cite">SQLite (default - a lightweight database that comes bundled with OpenSim <br></blockquote><blockquote type="cite">and can be used without requiring any extra configuration. It is mostly <br></blockquote><blockquote type="cite">intended to get you up and running quickly, not for production use.)<br></blockquote><br>Dear Generic,<br><br>I'm a little confused - that text doesn't appear anywhere on that wiki page, and never has. I guess you're probably <br>referring to some other page.<br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">I prefer to describe SQLite as: <br></blockquote><blockquote type="cite">SQLite is a software library that implements <br></blockquote><blockquote type="cite">a self-contained, serverless, zero-configuration, transactional SQL <br></blockquote><blockquote type="cite">database engine. SQLite is the most widely deployed SQL database engine <br></blockquote><blockquote type="cite">in the world. The source code for SQLite is in the public domain.<br></blockquote><br>That's true, although it's best suited to some needs and not others. In particular, I suspect that multi-user access <br>with large data sets is not one of its targets.<br><br>As far as I recall, the creator of SQLite himself pretty much said this on one of Leo Laporte's FLOSS podcasts.<br><br><a href="http://twit.tv/floss26">http://twit.tv/floss26</a><br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">These companies believe SQLite is production <br></blockquote><blockquote type="cite">worthy/ready: http://www.sqlite.org/famous.html<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I am a huge fan of SQLite, and for what it does, I believe it does it <br></blockquote><blockquote type="cite">very well.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thanks for letting me get that out, and I hope I can influence more of <br></blockquote><blockquote type="cite">you to take a better look at SQLite.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote></div></blockquote></div></div></div></body></html>