<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>This is a bit of a soap box, so if your are easily offended or annoyed, just pass by, there is nothing to see here.</div><div><br></div>I see in the OpenSim world the assertion that SQLite is not production worthy often. Most recently here:<div><br></div><div><blockquote type="cite"><a href="http://opensimulator.org/wiki/Upgrading">http://opensimulator.org/wiki/Upgrading</a></blockquote></div><div><span class="Apple-style-span" style="font-family: -webkit-sans-serif; font-size: 13px; line-height: 19px; ">SQLite (default - a lightweight database that comes bundled with OpenSim and can be used without requiring any extra configuration. It is mostly intended to get you up and running quickly, not for production use.)</span></div><div><font class="Apple-style-span" face="-webkit-sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="-webkit-sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 19px;">I prefer to describe SQLite as: </span></font></div><div><font class="Apple-style-span" face="-webkit-sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 19px;">SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.</span></font></div><div><font class="Apple-style-span" face="-webkit-sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="-webkit-sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 19px;">These companies believe SQLite is production worthy/ready: <span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; line-height: normal; "><a href="http://www.sqlite.org/famous.html">http://www.sqlite.org/famous.html</a></span></span></font></div><div><br></div><div>I am a huge fan of SQLite, and for what it does, I believe it does it very well.</div><div><br></div><div>Thanks for letting me get that out, and I hope I can influence more of you to take a better look at SQLite.</div><div><font class="Apple-style-span" face="-webkit-sans-serif" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 19px;"><br></span></font><div><div>On Dec 5, 2008, at 10:58 AM, Justin Clark-Casey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Paul Fishwick wrote:<br><blockquote type="cite"> From one version of opensim to the next, what is the accepted migration<br></blockquote><blockquote type="cite">strategy? In particular, what happens if someone changes an SQLite<br></blockquote><blockquote type="cite">or MySQL schema from one revision to the next? I tried METHOD 2<br></blockquote><blockquote type="cite">last night when going from r7320 to r7605, and it failed. Not sure why<br></blockquote><blockquote type="cite">yet...I ended up just creating new regions from scratch.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">If someone can suggest a more efficient approach, that would<br></blockquote><blockquote type="cite">be great. Once it is down, we can put it in the wiki. It could go<br></blockquote><blockquote type="cite">under:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><a href="http://opensimulator.org/wiki/Configuration">http://opensimulator.org/wiki/Configuration</a><br></blockquote><br>Actually, just a couple of days ago I started a rough wiki page for this.<br><br><a href="http://opensimulator.org/wiki/Upgrading">http://opensimulator.org/wiki/Upgrading</a><br><br>It has the standalone info but not really the grid stuff. Also, your bullet point format is much clearer.<br><br><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">METHOD 1: If Using SQLite in StandAlone Mode<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">1. Build the latest version from source (or download the binaries)<br></blockquote><blockquote type="cite">2. Put this new installation in a new folder<br></blockquote><blockquote type="cite">3. Copy the following files from the old \bin to the new \bin<br></blockquote><blockquote type="cite"> 3a. All *.db files<br></blockquote><blockquote type="cite"> 3b. The opensim.ini file<br></blockquote><blockquote type="cite"> 3c. The \bin\regions XML files<br></blockquote><blockquote type="cite">4. Launch the new opensim.exe<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">METHOD 2: If Using MySQL in StandAlone Mode<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">1. Build the latest version from source (or download the binaries)<br></blockquote><blockquote type="cite">2. Put this new installation in a new folder<br></blockquote><blockquote type="cite">3. Copy the following files from the old \bin to the new \bin<br></blockquote><blockquote type="cite"> 3a. The opensim.ini file<br></blockquote><blockquote type="cite"> 3b. The \bin\regions XML files<br></blockquote><blockquote type="cite">4. Launch the new opensim.exe<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">METHOD 3: If Using MySQL in Grid Mode<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">1. Build the latest version from source (or download the binaries)<br></blockquote><blockquote type="cite">2. Put this new installation in a new folder<br></blockquote><blockquote type="cite">3. Copy the following files from the old \bin to the new \bin<br></blockquote><blockquote type="cite"> 3a. The opensim.ini file<br></blockquote><blockquote type="cite"> 3b. The \bin\regions XML files<br></blockquote><blockquote type="cite"> 3c. The 5 XML config files<br></blockquote><blockquote type="cite">4. Launch services in the following order: UGAIM + R where<br></blockquote><blockquote type="cite"> "R" designates the region server (OpenSim)<br></blockquote><blockquote type="cite"><br></blockquote><br><br>-- <br>justincc<br>Justin Clark-Casey<br>http://justincc.wordpress.com<br>_______________________________________________<br>Opensim-users mailing list<br>Opensim-users@lists.berlios.de<br>https://lists.berlios.de/mailman/listinfo/opensim-users<br></div></blockquote></div><br></div></body></html>